Accounts Payable & Receivable
Reconciliations
Reconciliation tools auto-match transactions, roll forward balances, flag exceptions, enforce standardized templates and sign-offs, and track reconciling-item aging. They cut manual effort, standardize quality, provide an audit trail, and let staff focus on genuine exceptions—shortening close and reducing errors and risk.
Real-world example
Automated matching clears 90% of bank and AR items instantly, so the team only reviews true exceptions at close.
Cash Application
Reconciliations
Aging Analysis
A control account is a GL account whose balance summarizes a sub-ledger—e.g., the AP control account equals the total of all supplier balances. Reconciliations confirm the control account agrees with its sub-ledger detail. Postings should flow through the sub-ledger, not directly to the control account, to keep them in agreement.
Real-world example
The AR control account in the GL should always equal the sum of every customer's balance in the AR sub-ledger.
Aging Analysis
Invoice Processing
Reconciliations
How do you reconcile cash across the bank statement, cash book, AR receipts, and AP payments?
AdvancedTie the movements together: AP payment runs and AR receipts recorded in the ledgers should match cash out/in on the bank statement, with the bank reconciliation explaining timing (outstanding checks, deposits in transit) and bank-only items (fees, interest, returns). This end-to-end tie confirms both sub-ledgers and the GL agree with actual cash.
Real-world example
A payment run total, customer receipts, and the day's bank movement all reconcile once outstanding checks and a deposit in transit are accounted for.
Payment Runs
Cash Application
Reconciliations
A two-column (or T-format) reconciliation lists the two balances being compared and the adjustments that bridge them. A running/continuous reconciliation is maintained on an ongoing basis rather than only at period-end, catching differences earlier. Both aim to prove agreement; continuous reconciliation reduces month-end workload.
Real-world example
Moving key accounts to continuous reconciliation spreads the work across the month and shortens the close.
Cash Application
Aging Analysis
Reconciliations
Tie the movement in AR to sales and cash: opening AR + credit sales - cash collected - credits/write-offs = closing AR. Differences point to unposted sales, misapplied cash, or unrecorded credits. This cross-checks that receivables reflect actual billed revenue and collections, supporting revenue assurance.
Opening AR 200k + Credit sales 500k - Collections 480k
- Write-offs 5k = Closing AR 215k (should equal the ledger).
Real-world example
The AR-to-revenue roll-forward flags an unposted batch of sales when closing AR doesn't tie to the ledger.
Aging Analysis
Cash Application
Reconciliations
A three-way reconciliation ties three records together—for trust accounts, the bank balance, the book/cash balance, and the total of individual client ledgers must all agree. It's a stringent control used where funds are held on behalf of others (law firms, escrow), ensuring no client money is misallocated.
Real-world example
A law firm's monthly three-way reconciliation confirms bank, book, and client-ledger totals all match to the cent.
Cash Application
Reconciliations
Aging Analysis
Identify items recorded in one place but not yet the other due to cut-off (deposits in transit, outstanding checks, receipts not yet banked, invoices in transit). List them as reconciling items that will clear next period—no adjusting entry is needed for pure timing, only documentation—while genuine errors get corrected.
Real-world example
Outstanding checks and a deposit in transit explain the bank-book gap and are carried as timing items to clear next month.
Cash Application
Payment Runs
Reconciliations
It should show both balances, the source of each, all reconciling items with descriptions/ages/owners, supporting documentation, and evidence of independent review and sign-off with dates. No unexplained differences should remain. This lets a reviewer or auditor verify completeness and accuracy quickly.
Real-world example
An auditor accepts the bank reconciliation because every reconciling item is documented, aged, owned, and signed off independently.
Reconciliations
Aging Analysis
Invoice Processing
Reconciliations compare independent records, so misappropriations (skimmed receipts, fake payments, altered records) create differences that surface during reconciliation—especially when performed by someone independent of processing. Regular, reviewed reconciliations deter and detect fraud that would otherwise stay hidden.
Real-world example
An independent bank reconciliation catches an unauthorized withdrawal that the person handling payments had concealed.
Payment Runs
Cash Application
Reconciliations
How do you reconcile accounts payable to the trial balance and supporting sub-ledgers at consolidation?
AdvancedAt group level, each entity's AP sub-ledger must tie to its AP control account and trial balance, intercompany payables must match counterparties, and currencies must translate consistently. Reconciling before consolidation ensures the group AP is complete, intercompany eliminates cleanly, and no entity's control account diverges from its detail.
Real-world example
Pre-consolidation checks confirm every entity's AP ties to its trial balance and intercompany balances mirror, so the group AP is reliable.
Aging Analysis
Vendor Management
Reconciliations