Prepare a snapshot at the cutover date
Choose a date you can reconcile, such as the last day of a closed month. Identify which transactions have already been included. Create a working copy of your workbook and keep the original history accessible for review.
- Give every borrower and agreement a consistent reference and identify the legal lender.
- Reconcile principal, unpaid interest and unapplied cash separately for each currency.
- Record the source of each figure and resolve ambiguous entries before importing.
Preview a small batch and compare it to the source
Use the supported opening-balance template. Begin with a small batch covering a simple loan, a borrower with more than one agreement, and a case where the dates need checking. Compare row counts, loan-level figures and currency totals with the spreadsheet.
After approval and import, reopen the saved balances and review the first new transaction. Use the cutover cutoff to ensure an earlier movement is counted once.
What to reconcile before approving the batch
| Check | Expected evidence |
|---|---|
| Loan count | Each intended agreement appears once |
| Balance by currency | Totals match the workbook at cutover |
| Traceability | Each opening entry points to a source reference |