Bank Statement Analyzer
Who this is forThis template is built for SME owners and founders who need to understand their cash position beyond a closing balance, bookkeepers who reconcile bank statements monthly, and finance teams who need to produce a cash flow summary fast. If you have a bank export and no clear view of burn rate, runway, or where the money is going — this is for you.How it worksOne input point: the BANK STATEMENT tab. Paste your bank export into columns A–F. Column G auto-fills the transaction type. Every other tab — Dashboard, Analytics, and Risk Monitor — calculates automatically. Nothing else to update.Compatible with any bank export in standard 6-column format: DBS, OCBC, HSBC, UOB, and others.What it shows you Opening balance, closing balance, total receipts, total payments, net cash flow Daily burn rate — true payment outflow divided by business days Cash runway in days — auto-flagged against a 90-day benchmark Cash flow bridge — step-by-step balance movement from opening to closing Weekly timing profile — Week 1–4 breakdown of receipts and payments Top depositors ranked by value and share % of total receipts Top vendors ranked by payment value and share % of total outflows Bank charges and TT fees isolated and compared against receipts Six risk factors auto-assessed in the Risk Monitor: runway, net flow, bank charges %, debit concentration, deposit count, and payment run risk RequirementsExcel 2016 or above. Works on Mac and PC. No macros. No plugins.What you receiveInstant download. Single .xlsx file. Lifetime access. Free updates.
Get it → singleinputcfo.gumroad.com