Bank Transaction Categorisation: Keyword Rules, Vendor Maps, Amount Rules, Split Transactions & an Exceptions Queue
Turn a raw bank export into categorised bookkeeping lines: keyword rules with priorities, vendor mappings, amount-based rules, split lines, recurring payments and a queue for whatever the rules miss, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you turn a raw bank export of a fictional pottery studio into categorised bookkeeping lines. You split each description into type code, reference and vendor text with LEFT and MID and prove the export is complete against the statement balance. You build a keyword rule table with IFERROR(FIND(…)), resolve lines that match several rules with priorities and MINIFS, and put a vendor map with XLOOKUP and IFNA in front of the rules. IFS rules sort transfers, refunds, income and small fees, ROUND splits one payment into several categories with a remainder line, COUNTIFS and EOMONTH find recurring payments, and SUMIFS builds the month summary with a chart.
Lessons
- The Bank Export: Dates, Descriptions, Signed Amounts & Reference Codes Pro
- Keyword Rules: FIND a Keyword, Return a Category Pro
- Rule Priority & Conflicts: When Several Rules Match Pro
- The Vendor Map: Known Vendors First, Keyword Rules as Fallback Pro
- Amount & Direction Rules: Transfers, Refunds, Income and Small Fees Pro
- Split Transactions: One Bank Line, Several Categories Pro
- Recurring Payments, Coverage & the Exceptions Queue Pro
- The Month Summary: Totals by Category, Uncategorised Remainder & a Chart Pro