Bank Reconciliation with Matching Flags: COUNTIFS on Reference and Amount
This lesson is part of the course
In this lesson
You match the cash book against the bank statement line by line, let Excel list the unmatched items and reconcile both balances to the cent.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Trial Balance from a GL Export: SUMIFS & the Debits = Credits Check Locked
- Mapping Accounts to Financial Statement Lines with XLOOKUP Locked
- Bank Reconciliation with Matching Flags: COUNTIFS on Reference and Amount Locked
- Accounts Receivable Ageing: Days Past Due, Buckets with IFS & a Chart Locked
- Prepayments & Accruals: a Monthly Release Schedule Locked
- Fixed Asset Register: SLN, Accumulated Depreciation, NBV & DB Locked
- Budget vs Actual: Variance %, Favourable / Unfavourable & Materiality Flags Locked
- Month-End Close: Checklist Deadlines with WORKDAY & the Intercompany Check Locked