Worksheet Reconciliation: Create and Edit

These steps assume you have already set up and have a good understanding of the following:

• Common Data:

  • Banks

  • Bank Accounts

  • Bank Account Trees

  • User Codes

  • User Code Trees

  • Reference Types

  • Standard Settlement Instructions

• Cash:

  • Worksheets

  • Balance Explorer

• Payments, including how to flag payments to appear in worksheets:

  • Single Transactions

  • Multiple Transactions

• Deal portfolio, including how the estimated transaction is booked:

  • Deal Portfolio

• Reporting, including what reports are available to view reconciliation results:

  • Standard Library

  • Custom reports

Please follow the above links to complete any setup steps that you may have missed before continuing.

Plan for Setup

A Reconciliation worksheet defines which Accounts and User Codes will be included in Reconciliation. Account Trees and User Code Trees can be added or used instead of the actual Accounts and User Codes.

Considerations:

• All accounts you wish to reconcile must be available in Ripple Treasury.

• You must have access to all accounts you wish to reconcile.

• Reconciliation Rules use only User Codes, not User Code Trees. However, you can use ranges of User Codes.

• Any hidden accounts are automatically included in the reconciliation.

• Reconciliation worksheet balance types include:

  • Actual transactions

  • Estimated transaction

  • Payments (funds transfers) from the Payments module; this is an Estimated transaction that only appears in worksheets, not in Balance Explorer

• Forecast transaction types are not reconciled.

• You can create multiple Reconciliation worksheets to address different considerations like:

  • Reconciliation for simple versus complex requirements and rules

  • Reconciliation that would require an unwieldy number of rules

    • More rules slow down the reconciliation process

  • Reconciliation for accounts or User Codes with too large a volume of transactions to be easily managed in a single worksheet

  • Reconciliation for transactions by account tree to apply similar rules

Set Up Reconciliation Worksheet

Refer to Worksheets: Create and Edit for instructions on creating the worksheet.

The following example reconciliation worksheet has a typical reconciliation setup:

• Bank accounts across the top

• User Code Trees and User Codes down the left side

• Actual and Estimated transaction types shown

• Amount column to show the variance between the Actual and Estimated transactions

Copyright 2025 Ripple Labs Inc.