Short Answer: Each summary card shows totals and counts—including bank totals, book totals, matched totals with counts, unmatched totals by side, and skipped record counts.
Answer
PreRequisites
-
The reconciliation report is loaded.
-
The summary cards are visible beneath the action bar.
Steps
-
Open the reconciliation report and look at the summary cards under the action bar.
You will see cards such as:
• Total bank amount
• Total book amount
• Matched
• Unmatched – Bank
• Unmatched – Books
• Skipped records -
Each card displays:
• A total amount (e.g., $125,450.75)
• A transaction count in parentheses (e.g., (48 transactions))
This helps you understand how many transactions contribute to each total. -
Use the cards as a summary overview:
• Total bank amount → Sum of all bank transactions
• Total book amount → Sum of all book transactions
• Matched → Amount and count of successfully matched transactions
• Unmatched – Bank → Transactions present in bank but not matched
• Unmatched – Books → Transactions present in books but not matched
• Skipped records → Count of records ignored due to errors or missing data -
Click or switch to the corresponding tabs (Matched, Unmatched, Skipped) to drill down into details behind each card.
This allows you to verify and investigate the totals.
Troubleshooting
-
Card totals don’t add up as expected.
Likely Cause:
• Some records are skipped due to missing or invalid data.
• Transactions may be grouped into multi-transaction matches.Action:
• Check the Skipped records section to identify ignored entries.
• Expand grouped matches in the Matched tab to view individual transactions and subtotals.
• If needed, correct the source data and run a new reconciliation.
Note: The Matched card may include additional context such as '(X bank transactions matched with Y book transactions)' to explain how the totals were derived.