Borrow/Invest Statement: Run Report

  • Published on Oct 6, 2026
  • 8 minute(s) read
  • Migration Team
  • RJ
 Prev Next

Purpose

The Borrow/Invest Statement shows the principal and interest movements over a nominated period for all Cash Account, Intercompany Loan, and Loan/Deposit deals selected.

It's the primary report for a month-end interest position. A single row returns the principal movement and all four interest figures for the period: opening accrual, period accrual, interest settled, and closing accrual.

Run Reports

  1. Go to Risk > Reports > Accounting > Borrow/Invest Statement.

  2. The Borrow/Invest Statement screen opens.

  3. Enter your report parameters:

2026-09-22_12-51-58.png

  • For a single calendar month:

    1. Set Reporting Period to Accounting Period.

    2. Use the arrows to move the Period Start and Period End fields to the month being reported.

      • For the accrual default settings, your Period Start date is the end of the month prior to your period.

      • The dates to capture your period may differ based on your Application Settings for Accruals.

    3. Set Report Type to Summary.

2026-09-22_13-41-10.png

  • For multiple calendar months:

    1. Set Reporting Period to Multiple Accounting Period.

    2. Use Period Start, Term, and Period End to establish the accounting periods for your report.

      • The accrual default dates is to set the Period Start to the last day of the month prior to the period, and to set Period End to the last day of the period. For example, March 31 to May 31 captures April and May.

      • The dates to capture your period may differ based on your Application Settings for Accruals.

    3. Set Report Type to Summary.

    4. Set Frequency to Monthly.

    5. Set Stub to Front.

    6. Mark Force Month Ends.

2026-09-22_13-38-31.png

  1. Select Generate Report.

  2. A list of all deals meeting the report parameters is displayed.

  3. As needed, group the report by ID to keep each deal’s periods together.

2026-09-22_13-33-28.png

Read Report Results

Principal

2026-09-22_15-26-45.png

Review your principal. Borrowings display as negative amounts, so the figures on screen carry a minus sign.

  • Opening Balance

  • Movement

  • Closing Balance

The relationship between these figures are:

  • Opening Balance + Movement = Closing Balance

  • Each period's closing balance is the next period's opening balance.

  • Days is the difference between the Period Start and Period End. For example, 30-Apr-26 to 31-May-26 is 31 days, and this is number of days that accrue.

The principal information shows you what was outstanding at the start of the period, the drawdowns and repayments during it, and what is outstanding at the end.

Interest

2026-09-22_10-02-27.png

Review your interest. Borrowings display as negative amounts, so the figures on screen carry a minus sign.

  • Opening Accrual

  • Period Accrual

  • Interest/Fees Paid

  • Closing Accrual

The relationship between these figures are:

  • Opening Accrual + Period Accrual − Interest/Fees Paid = Closing Accrual

  • Each period's closing accrual is the next period's opening accrual, and across the life of the deal total accrued equals total settled.

  • Days is the difference between the Period Start and Period End. For example, 30-Apr-26 to 31-May-26 is 31 days, and this is number of days that accrue.

Reconcile Interest Against Second Report

You can confirm each of the interest figures against a second report. If a period boundary is drawn a day or later, the interest moves between months but the actual to-date total doesn't change. If a total changes, something is wrong rather than merely presented differently.

Opening Accrual

  • Definition: Earned but unsettled at the start of the period

  • Confirm Against: Accruals Report, Accrued Interest column with Accrual Since Last Roll marked and the Report Date set to one month before the Borrow/Invest Statement’s Period End

2026-09-22_10-03-07.png

Period Accrual

  • Definition: Earned during the period

  • Confirm Against: Accruals Report, Accrued Interest column with Accrual For Period marked and the Period Start and Period End dates the same as the Borrow/Invest Statement

2026-09-22_10-20-09.png

Interest/Fees Paid

  • Definition: Settled in cash during the period

  • Confirm Against: Event Diary, Amount column with Start Date the first day of the month and the End Date the same as the Borrow/Invest Statement’s Period End.

    • The Amount column shows both the interest payment and the principal drawdown. Use to the interest amount.

2026-09-22_10-37-22.png

Closing Accrual

  • Definition: Earned but unsettled at the end of the period

  • Confirm Against: Accruals Report, Accrued Interest column with Accrual Since Last Roll marked and the Report Date date the same as the Borrow/Invest Statement’s Period End

2026-09-22_10-26-50.png

Report Parameters

2026-09-22_12-58-47.png

Asterisks (*) indicate that a field is mandatory.

Fields:

  • *Reporting Period: Determines how the statement's start and end dates are set:

    • Accounting Period: Dates come from the selected fiscal calendar. Arrows next to the end date move you between periods. The term is fixed at 1 month.

    • Custom Period: Enter any start and end dates. No fiscal calendar is involved.

    • Multiple Accounting Periods: Fiscal-calendar driven, but you set a start date and the term or end date to span multiple accounting periods.

  • Fiscal Calendar: (Only visible when Reporting Period is Accounting Period or Multiple Accounting Periods) Sets the calendar to define the reporting dates. It defaults to your default fiscal calendar.

  • Period Start: Sets the start date for the report. Works in conjunction with Term and Period End to set period.

  • Term: Sets the time covered in the report. Works in conjunction with Period Start and Period End to set period.

    • d: Days

    • w: Weeks

    • m: Months

    • y: Years

  • Period End: Sets the end date for the report. Works in conjunction with Period Start and Term to set period.

  • *Report Type: Sets the report content.

    • Details: Deal-level rows with the underlying accrual and cash detail.

    • Summary: Aggregated rows per generated period and reveals the three schedule fields below.

  • *Frequency: (Only visible when Report Type is Summary) Sets the length of each period the summary is broken into across the reporting range.

  • *Stub: (Only visible when Report Type is Summary) Controls where the short period falls when the range doesn't divide evenly into the frequency.

    • Back: Short period falls at the end of the period.

    • Front: Short period is at the start of the next period.

  • Force Month Ends: (Only visible when Report Type is Summary) Snaps the generated period boundaries to month ends rather than to anniversaries of the start date.

  • Portfolio and Analysis radio buttons: Choose which selection list is used. Only the active list is used in the report.

    • Portfolio: Select deals from the deal portfolios.

    • Analysis: Select deals from the saved exposure management analyses.

  • Portfolio: (Only visible when Portfolio radio button is selected) Select one or more portfolios to be reported.

  • Currency: (Only visible when Portfolio radio button is selected) Select one or more currencies to be reported.

  • Business Unit: (Only visible when Portfolio radio button is selected) Select one or more business units to be reported.

  • Deal Type: (Only visible when Portfolio radio button is selected) Select one or more deal types to be reported.

  • Analysis: (Only visible when Analysis radio button is selected) Select one or more analyses to be reported.

  • Include Inactive Deals: (Only visible when Analysis radio button is selected) Mark to include deals that are no longer active in the selection.

Default Reporting Period Convention

New balances accrue from the date onward but movements always take effect from the movement date.

  • Period Start: Balances on this date accrue to the previous period (not the one you are reporting). Principal movements on this date affect the current period in your report.

  • Period End: Balances on this date accrue in the current period you are reporting. Principal movements on this date affect the next period (not the one you are reporting).

This difference in how balances and movements are captured is why you use different report dates between reports to capture information for the same month.

Date Boundaries

You can change your accrual method setting per instrument type and product in gear Platform icon > Administration > System Configuration > Application Settings.

Changing your accrual method moves interest between accounting periods for every deal in that product. Treat this change as an accounting policy change, not a reporting fix, and confirm the convention with the accounting department.

Report

Dates to Capture May 2026

Date Boundaries

Borrow/Invest Statement

Period Start: 30-Apr-26

Period End: 31-May-26

Default: Start date excluded, end date included.

Editable in Application Settings for Accruals. Your setting applies consistently to Borrow/Invest Statement, Accruals Report, and GL Processing in the same way.

Manage Report Grid

Column Management

Resize:

  1. Hover your cursor over the column break on the header line.

  2. The cursor changes to a double headed arrow.

  3. Click and move the cursor left or right to change the size of the column.

  4. Double-click to return the column to its original size.

2026-09-22_14-47-29.png

Reorder: Select, drag, and drop the column header to reorder the columns.

2026-09-22_14-48-58.png

Show and Hide:

  1. Select the More icon for any column header.

  2. Select Columns to expand.

  3. Mark columns to show them or unmark columns to hide them.

2026-09-22_14-49-56.png

Sort:

  1. Select a column header to sort by that column.

  2. An arrow appears to show the sort order (ascending or descending).

  3. Select the same column again to reverse the sort order, and a third time to remove sort.

  4. Select any additional columns to sort by.

  5. If you select multiple columns, a number appears next to the arrow to indicate the sort order.

2026-09-22_14-58-57.png

Filter:

  1. Select the More icon for the column header you want to filter.

  2. Select Filter to expand.

  3. Use the filter parameters to set up one to two more filters.

  4. Select Filter.

  5. The filter appears in the top right corner above the grid.

  6. Select Remove to remove all filters.

2026-09-22_15-06-21.png

2026-09-22_15-08-18.png

Grouping

You can group your data by one or more columns. For detail reports, it’s common to group by the ID to keep each deal’s periods together.

Group by Column:

  1. Drag and drop the required column header into the group row above the grid.

  2. The view refreshes to be grouped in the new format and automatically sorts by group in ascending order.

    • Select the arrow to reverse the sort order.

  3. Repeat the above steps to group by more than one column.

    • Select, drag, and drop the groups to change the order of the group headers.

  4. Select the X icon for any group to remove the group.

2026-09-22_15-43-23.png

2026-09-22_15-45-27.png

2026-09-22_15-46-40.png

Add, Edit, and Remove Column Totals:

  1. Right-click in any column.

  2. Select Column Totals to expand.

  3. Select the type of total to include.

    • Depending on the data type in column you clicked, not all total options may be available.

  4. Mark Include Label to show a column label that indicates the type of total for the column or unmark to hide the label.

2026-09-22_16-02-11.png

Views

Manage Views:

  1. Select the grid icon in the upper right corner to expand the View options.

    • Save, delete, or undo changes in your view.

  2. Use the View drop-down list to switch between saved views.

2026-09-22_16-08-12.png

Print:

  1. Right-click anywhere in the grid.

  2. Select Print.

  3. Confirm the print preview.

  4. Select Print.

  5. Select whether to save the pages as a PDF or send to your local printer.

2026-09-22_16-13-20.png

2026-09-22_16-16-21.png

2026-09-22_16-15-59.png

Copy:

  1. Right-click anywhere in the grid.

  2. Select Copy Grid.

    • If the data is grouped, the grouped headers won’t copy but the data will copy in the same grouped order.

  3. Paste the grid into your Excel spreadsheet.

2026-09-22_16-13-20.png

Copyright 2025 Ripple Labs Inc.

Related articles