Accruals Report: Run Reports

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

Purpose

The Accruals Report lists deals with the interest accrual for each deal, either as at a nominated date or for an accounting period, and provides the supporting detail for interest accrual accounting entries.

The report runs two distinct jobs, selected by the first parameter:

Mode

Dates in the Mode

Job Use

Accrual Since Last Roll

The report runs from the deal's last roll to the report date, and the report date itself accrues.

The accrual balance at a point in time. The opening and closing accrual.

Accrual for Period

Both a start and end date are used. The start date is excluded and the end date is included, so 30-Apr-2026 to 31-May-2026 is the calendar month of May.

The accrual movement across a period, and the support for general ledger accrual postings.

After running the Borrow/Invest Statement, use the Accruals Report to confirm the Opening Accrual, Period Accrual, and Closing Accrual figures.

Run Report for Accrual Since Last Roll

Use this report to obtain an opening or closing accrual, which is the interest earned but unsettled at the end of the month.

  1. Go to Risk > Reports > Accounting > Accruals Report.

2026-09-22_17-03-18.png

  1. The Accruals Report screen opens.

  2. Enter your report parameters:

    1. Select Accrual Since Last Roll.

    2. Set Accrue To to Accounting Period.

    3. Use the arrows to move the Report Date field to the month being reported.

      • The default closing accrual is the last day of the month.

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

  3. Select Queue Report.

  4. A list of all deals with their accruals is displayed.

2026-09-22_17-16-15.png

Run Report for Accrual for Period

Use this report to obtain the interest accrued during one or more months, and for the figures behind general ledger accrual postings.

  1. Go to Risk > Reports > Accounting > Accruals Report.

2026-09-22_17-03-18.png

  1. The Accrual For Period screen opens.

  2. Enter your report parameters:

    1. Select Accrual For Period.

    2. Set Accrual Period to Accounting Period or Multiple Accounting Periods.

    3. Set the Period Start and Period End dates to reflect the months being reported.

      • The default opening accrual is the last day of the month prior to the month being captured. For example, 31-Mar to 31-Jul captures April to July.

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

    4. Set the Frequency to Monthly for multi-month periods.

    5. Select Force Month Ends for multi-month periods.

  3. Select Queue Report.

  4. A list of all deals with their accruals is displayed.

2026-09-23_10-02-57.png

Read Report Results

2026-09-23_10-02-57.png

Your Accruals Report is a list of all deals meeting the report parameters. Each deal shows:

  • Deal Details: The largest portion of the report columns contains your deal details. Among these details are:

    • Period Start:

      • For Accrual Since Last Roll, this is the last interest date or the start of the deal.

      • For Accrual For Period, this is the start date of the accounting period or the start of the deal.

    • Period End: This is the end date of the period or the maturity date of the deal.

    • Days: Number of days between the Period Start and Period End.

    • Day Basis: The day basis for the deal fee.

  • Accrued Interest: This is the last set of columns in the report. These columns are:

    • Total:

      • For interest rate deals, the accrued interest for the deal

      • For financial instruments, the accrued coupon interest and the accreted discount or amortized premium for the deal

    • Accrued interest by date: When viewing multiple accounting periods, each accrued interest column is headed by the period end date of its bucket. If a rateset has occurred in the period but hasn’t been actioned, this field has a notification that shows it is pending.

      • For example, 30-Apr is April and 31-May is May.

    • Posted: The amount already transferred to General Ledger.

Report Parameters

2026-09-23_10-42-42.png

Fields:

  • Available Reports: Lists your previously queued Accruals Reports, newest first.

    • Selecting one reloads both its results and the parameters it ran with.

    • Leaving it on new starts a fresh report. If your most recent report hasn't been viewed yet, the screen loads it automatically.

  • Name: Defaults to Accruals Report - <today's date> and identifies the run in the reports queue.

  • Auto Retry: Mark to have Ripple Treasury automatically retry running the report if it fails.

  • Accrual Since Last Roll and Accrual For Period radio buttons: Select whether to view the accrual balance at a point in time or the movement across a period.

    • Accrual Since Last Roll: Reports interest accrued from each deal's last coupon roll up to a single date. The only date you select is Report Date.

    • Accrual For Period: Reports interest accrued within a date range you define.

  • Accrue To: (Only visible when Accrual Since Last Roll is selected) Period to use when determining the last coupon roll to a new date.

    • Accounting Period: Use a fiscal calendar. Arrows next to the date move you between periods.

    • Custom Period: Enter any date. No fiscal calendar is involved.

  • Accrual Period: (Only visible when Accrual For Period is selected) Period to use to evaluate interest accrued.

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

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

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

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

  • Report Date: (Only visible when Accrual Since Last Roll is selected) The single date interest accrued is reported to. The reporting period is from each deal’s last coupon roll to this date.

  • 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.

  • Forecast Events: Mark to include forecast (not yet fixed) events, so accruals can be projected past known rate sets.

  • Market Data Date: (Only visible only when Forecast Events is marked) The date whose rates are used to forecast events; defaults to the earlier of the report's end date and today.

  • Reporting Currency: Converts the reported amounts into a single currency. If you select none, amounts stay in each deal's own currency. Defaults to your tenant's default reporting currency.

  • Frequency: (Only visible when Accrual For Period and either Custom Period or Multiple Accounting Periods are selected) Sets the length of each period the report is broken into across the reporting range.

  • Stub: (Only visible when Accrual For Period and Custom Period are selected) 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 Accrual For Period and either Custom Period or Multiple Accounting Periods are selected) 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.

  • Business Unit: (Only visible when Portfolio radio button is selected) Select one or more business units 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 by Report

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

Accruals Report,

Accrual For Period

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.

Accruals Report,

Accrual Since Last Roll

Report Date: 31-May-26

Report date accrues

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-23_12-35-18.png

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

2026-09-23_12-37-21.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-23_12-38-18.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-23_12-39-53.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-23_12-41-26.png

2026-09-23_12-42-44.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-23_12-44-00.png

2026-09-23_12-44-19.png

2026-09-23_12-46-22.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-23_12-48-44.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-23_12-51-34.png

Export, Print, and Copy

Export:

  1. Select the export icon in in the upper right corner.

  2. Select your export definition from the drop-down list.

    • Export definitions are managed in gear Platform icon > Connectivity > Job Management > Import/Export Definitions.

  3. Select Export.

  4. Select Continue.

  5. An Excel document of your grid downloads to your computer.

2026-09-23_13-07-04.png

2026-09-23_13-09-42.png

2026-09-23_13-11-20.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-23_12-53-21.png

2026-09-23_12-53-47.png

2026-09-23_12-54-11.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-23_12-53-21.png

Copyright 2025 Ripple Labs Inc.

Related articles