NetCash Reconciliation Detail Report
Overview
The Reconciliation Detail report is a transaction-level view of a single bank or credit card account's activity for a period. It presents the account as a roll-forward: a beginning GL balance, every GL line dated in the period grouped by whether it has matched to bank activity, the bank activity that has no GL match yet, and an ending GL balance.
Where the Reconciliations Report summarizes each account on one line, the Reconciliation Detail report itemizes the underlying transactions, so it is the report used to see exactly which items make up a period's movement and to hand an auditor the supporting workpaper behind a completed reconciliation.
Accessing the report
Go to NetCash > Reports > All Reports and select Reconciliation Detail. Then set the filters:
- Bank Account - the account to report on.
- Accounting Period, or a From and To date range.
- Include Offset Account - adds the Offset Account column, showing the other side of each GL line.
- As of - the match-visibility basis (As of Today or As of Period End).
Use Expand All and Collapse All to open or close the activity groups.
How to read the report
The report reads in three parts: a roll-forward of the account's general ledger (book) balance for the period, a comparison of that balance to the bank statement, and the outstanding items that explain any gap between the two. Any row group with a count in parentheses can be expanded to see the underlying transactions.
| Row | What it shows |
|---|---|
| Beginning Balance | The account's GL balance carried into the period - all activity dated before the From date. |
| Inflow Matched / Outflow Matched | GL lines dated in the period that are matched to bank activity as of the selected basis, split by direction. Expand to see the transactions. |
| Total Matched | The sum of the matched GL lines. |
| Unmatched This Period | The net of GL lines dated in the period that have no visible match. This is a summary - the individual transactions are listed further down under Deposit In Transit and Outstanding Check. |
| Total Period Activity | All GL activity dated in the period (matched plus unmatched). This equals Ending Balance minus Beginning Balance, and is the same under either As of basis. |
| Ending Balance | The account's GL balance through the period end - all activity dated on or before the To date. Beginning Balance plus Total Period Activity equals Ending Balance. |
| Statement Balance | The bank statement's ending balance recorded on the reconciliation record. Shows 0.00 when none has been entered. |
| Difference | Statement Balance minus Ending Balance - the gap the outstanding items below account for. |
| Deposit In Transit | Deposits recorded in the GL that have not yet appeared on the bank statement. They raise the book balance above the bank balance. |
| Outstanding Check | Checks or payments recorded in the GL that have not yet cleared the bank. They lower the book balance below the bank balance. |
| Cleared | Prior-period outstanding items that cleared during this period. Present under As of Today - under As of Period End an item that cleared after the period end stays in its outstanding section instead. |
| Open Bank Activity | Bank transactions dated in the period that have not been matched to a GL transaction. |
| Total | The sum of the Difference plus outstanding-item sections (Deposit In Transit, Outstanding Check, Cleared, and Open Bank Activity). |
On credit card accounts the outstanding sections are labeled Outstanding Charge, Outstanding Payment, and Open Credit Card Activity.
As of Today vs. As of Period End
The As of control switches the basis the report uses to decide whether a GL line counts as matched. Both views cover the same period and the same set of transactions - only the match visibility changes, so the total period activity is identical between them. What moves is which group each line lands in.
- As of Today (the default) - match visibility is not capped. A GL line that was matched to bank activity in a later period reads as matched here. This is the "did this ever clear" view, used to confirm that everything in the period has since been matched.
- As of Period End - match visibility is capped at the period end date. A line whose match happened after the period end reads as unmatched, exactly as it stood on the reconciliation date. This is the view an auditor expects, and it agrees with what the Reconcile page showed when the reconciliation was completed.
Which basis to use
Use As of Today to verify that a closed period's activity has all been matched since. Use As of Period End when producing a workpaper for audit, so the report reflects the account's state on the reconciliation date rather than its state today. The report header records the basis used on every export, so the two exports of the same account and period are distinguishable.
Exporting the report
The download menu offers three formats:
- Export as PDF - a formatted PDF with the report's column set.
- Export as Excel - the original raw data export, unchanged.
- Export as Excel (Formatted) - a styled workbook built for use as an audit workpaper.
Use Formatted Excel for calculating totals
The original Export as Excel exports Balance as text, which causes =SUM() to return 0; use the Export as Excel (Formatted) when calculating totals.
Troubleshooting
- A matched item appears as unmatched. Check the As of basis. Under As of Period End, an item whose match occurred after the period end date reads as unmatched by design. Switch to As of Today to see its current match state.
- The PDF and Excel exports show different rows. The formatted Excel export and the PDF share the same ordered column set and should agree. The original Export as Excel uses a different column layout; compare against the formatted export or the PDF.
