Tutorvo

The Bank Export: Dates, Descriptions, Signed Amounts & Reference Codes

Lesson 1 of 814 minLab

This lesson is part of the course

In this lesson

You read a raw bank export like a bookkeeper: label every line as money in or out, pull the type code and the reference out of the description text, and prove that the export is complete by rebuilding the closing balance.

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

  1. The Bank Export: Dates, Descriptions, Signed Amounts & Reference CodesLab14 min Locked
  2. Keyword Rules: FIND a Keyword, Return a CategoryLab15 min Locked
  3. Rule Priority & Conflicts: When Several Rules MatchLab16 min Locked
  4. The Vendor Map: Known Vendors First, Keyword Rules as FallbackLab15 min Locked
  5. Amount & Direction Rules: Transfers, Refunds, Income and Small FeesLab16 min Locked
  6. Split Transactions: One Bank Line, Several CategoriesLab15 min Locked
  7. Recurring Payments, Coverage & the Exceptions QueueLab16 min Locked
  8. The Month Summary: Totals by Category, Uncategorised Remainder & a ChartLab17 min Locked