Automated Cashflow & Bank Categorisation
Downloads bank and QuickBooks data, classifies every transaction into a ledger using a keyword table and produces a monthly cashflow statement with payroll summary. New vendors are handled by simply adding a keyword.
- Industry
- Accounting
- Deliverable
- Cashflow 2026.xlsm
- Built with
- Excel VBA, Selenium, Bookkeeping
Before
Bank and QuickBooks transactions were categorised line by line every month.
After
Transactions are classified by a keyword table and the monthly cashflow with payroll summary is built automatically.
More like this
Related projects
Baseball Roster & Lineup Generator
Sports
Creates fair fielding lineups for a youth baseball team. Positions are randomised inning by inning while the equalizer rules make sure every player sits, catches and…
View project
Multi-Language Expense Report Form
Manufacturing (Baltics)
An employee expense claim form used in several countries. The form switches between eight languages, converts currencies, validates accounts and cost centres and emails the finished…
View project
Product Analysis Report Generator
FMCG / Retail Analytics
An automated sales analysis tool for a beverage brand. Raw point-of-sale data is imported, a pivot master is built and the macro produces Pareto, NIS and…
View project