AP records a supplier payment on the last day of the month. The bank clears it two days later. The new statement confirms that the payment went through, but the month-end reconciliation still needs to show it as outstanding at cutoff.
Start from the statement and ledger at the same cutoff
Save the account, currency, statement end date, ending bank balance, and book balance. Match transactions within that scope. Use later bank activity to confirm when an outstanding item cleared, and keep its clearance date separate from the close date. In NetSuite, matching or clearing transactions precedes reconciling the account statement, where the reviewer checks the statement end date and balance. Oracle’s bank statement reconciliation documentation.
For example, suppose the statement ends at $20,000 and the books show $18,800. A $1,200 payment recorded before cutoff clears the following month. Subtracting the outstanding payment from the statement balance gives $18,800. The difference is explained without another payment entry.
Give every carried item a reason and an owner
| Item | What to verify next |
|---|---|
| Outstanding payment | Payment reference, recipient, and the date it clears. Investigate if it remains open beyond the expected period |
| Deposit in transit | Deposit detail, amount, and the later bank credit |
| Bank fee missing from the ledger | Statement line and the accounting entry approved to record it |
| Returned customer payment | Bank reversal, original receipt, and the invoice balance after correction |
Start the next reconciliation with the prior list. Mark an item cleared only when the new evidence supports it. If a payment was canceled or a receipt reversed, trace the correction rather than dropping it from the list. Have the reviewer check the adjusted balances and explain any difference before sign-off.
Test automation across two statements
Use one item from each side of cutoff and one fee missing from the books. Check that the proposed matches leave the prior statement intact and that the following statement can clear the carryforward item. Measure the time it takes to explain and clear exceptions, not just how many lines the tool matches.
Try the bank reconciliation tool with sample bank and ledger exports to compare rows. Check the date range and amount signs first. Use the statement balances and carryforward list to finish the reconciliation.