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
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
Health Plan Quote Builder (Excel to Word)
Insurance
Builds self-funded health plan quotes. Premiums, claims forecasts and fees are calculated in Excel and a single click exports the finished quote into a formatted Word…
View project
Economic Data Web Scraper
Finance / Research
Collects treasury yield curves, consumer price index series, personal consumption data and wage indices from public government websites straight into Excel, ready for analysis.
View project