Overview
When adopting reconciliation statements in SoftLedger, you may need to account for historical transactions from previous months or years to align with your current bank statement periods. A "catch-up" reconciliation statement allows you to include older journal lines and reconcile them in bulk, helping you establish a steady cadence for future statements. This article explains how to create a catch-up statement to bring your reconciliations up to date. For general guidance on reconciliations in SoftLedger, refer to our Cash Management: Reconcile article -->
A catch-up reconciliation statement compares an external statement balance (e.g., from a bank) with the cleared balances of journal lines in SoftLedger. By creating a large statement that includes historical transactions, you can reconcile past activity in bulk and transition to regular monthly reconciliations. The goal is to select a specific end date from your external statement that you are confident aligns with the journal lines in SoftLedger, then reconcile all relevant transactions up to that date.
High level overview video:
Steps to Create a Catch-Up Reconciliation Statement
Determine the Statement End Date - Identify a specific end date from your external source (e.g., bank statement) that you are confident is reconciled with the journal lines in SoftLedger. This date will be used for your catch-up statement.
Create the Statement - Navigate to the Cash Management>Reconcile module and create a new statement. Specify the Location, Ledger Account, Currency, and an initial Statement Balance (this can be edited later). See Reconcile Article-->
Review and Adjust the Statement Balance - After creating the statement, review the unbooked balance from journal lines in SoftLedger. Edit the statement to ensure the Statement Balance matches the unbooked balance displayed.
Increase the Row Limit - In the statement table, change the row limit to 1,000 rows to display all relevant journal lines (you can save this as default view going forward too).
Mark Transactions as Reconciled - Select all journal lines by checking the checkbox for each row (or use the "Select All" option). Mark them as reconciled by confirming with a checkmark (up to 1,000 at a time).
Repeat as Needed - If additional journal lines remain, repeat the process to include all transactions for the statement period.
Verify Zero Variance - Confirm that the variance is zero, meaning the cleared balance equals the statement balance.
Lock the Statement - (Optional) Once reconciled, you may choose to lock the statement to prevent further changes.
Proceed to Standard Reconciliations - With the catch-up statement complete, you can move on to standard monthly reconciliations. See our Cash Management: Reconcile article for details -->
Note: Ensure all journal lines are accurately reflected in SoftLedger before creating the catch-up statement to avoid discrepancies.