{"product_id":"finreportly-excel-cash-flow-statement-bank-csv-dashboard","title":"Cash Flow Statement with Bank CSV Import and Business Dashboard","description":"\u003cp\u003e\u003cstrong\u003eFull product description\u003c\/strong\u003e\u003cbr\u003e\u003c\/p\u003e\n\u003cp\u003eTurn monthly figures or an exported bank CSV into a clear Cash Flow Statement, monthly and year-to-date dashboard, automated exception review and business commentary. Finreportly identifies inflows and outflows, applies editable keyword rules and shows what the cash movements may mean for the business.\u003c\/p\u003e\n\u003cp\u003eKnow where your cash came from, where it went and what it means - without building a financial model from scratch.\u003c\/p\u003e\n\u003cp\u003eFinreportly is an Excel-based Cash Flow Statement and management dashboard designed for small-business owners. Choose the input route that suits your business:\u003c\/p\u003e\n\u003cp\u003e1. **Manual monthly input** - enter monthly Actual and Budget amounts in clearly highlighted cells.\u003cbr\u003e2. **Bank CSV import** - paste an exported bank statement, map its headers once and review only the transactions that need attention.\u003c\/p\u003e\n\u003cp\u003eApproved figures flow automatically into the Cash Flow Statement, monthly and year-to-date KPI cards, four management charts and formula-generated commentary.\u003cbr\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eStraightforward monthly bank workflow\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e- Paste the full bank CSV, including its header row.\u003cbr\u003e- Map Date, Description and the bank amount columns once for that export format.\u003cbr\u003e- Use either separate Money In \/ Money Out columns or one signed Amount column.\u003cbr\u003e- Tell the workbook whether positive signed amounts represent money in or money out.\u003cbr\u003e- Append later monthly CSVs at the displayed Next paste row.\u003cbr\u003e- Repeated bank header rows are ignored automatically.\u003cbr\u003e- Editable description keywords suggest the cash-flow category.\u003cbr\u003e- Normal recognised transactions become Ready automatically.\u003cbr\u003e- Unmatched, duplicated or conflicting transactions are isolated for review.\u003cbr\u003e- Optional Transaction ID and Account mapping improves duplicate detection.\u003cbr\u003e- Internal transfers and genuine duplicates can be excluded from reported cash flow.\u003cbr\u003e- Budgets remain separately editable in Monthly Inputs.\u003c\/p\u003e\n\u003cp\u003eThe paste area supports up to **20 source columns and 2,000 annual transaction rows**. It is designed for common bank-export structures, but the buyer must confirm the column mapping, category rules and final treatment.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWhat Finreportly helps you understand\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e- Monthly and year-to-date cash inflows\u003cbr\u003e- Monthly and year-to-date cash outflows\u003cbr\u003e- Cash generated or consumed by normal operations\u003cbr\u003e- Investing cash movement, including asset purchases and proceeds\u003cbr\u003e- Financing cash movement, including loans and owner funding\u003cbr\u003e- Net increase or decrease in cash\u003cbr\u003e- Opening and closing cash balances\u003cbr\u003e- Actual versus Budget and full-year variances\u003cbr\u003e- Whether the cash buffer is strengthening or weakening\u003cbr\u003e- Whether cash receipts are covering cash payments\u003cbr\u003e- Which months created or used the most cash\u003cbr\u003e- Whether cash movement is driven by operations, investing or financing\u003cbr\u003e- What reported performance may mean for liquidity, spending and funding decisions\u003cbr\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eKey features\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e- Optional Manual Entry or Bank Import actuals route\u003cbr\u003e- Flexible one-time bank-header mapper\u003cbr\u003e- Automatic inflow and outflow detection\u003cbr\u003e- Support for signed amounts and separate Money In \/ Money Out columns\u003cbr\u003e- Up to 20 CSV columns and 2,000 annual transaction rows\u003cbr\u003e- Monthly append workflow with repeated-header handling\u003cbr\u003e- Editable contains-keyword categorisation rules\u003cbr\u003e- First-match rule priority for specific and broad keywords\u003cbr\u003e- Exception-only review workflow\u003cbr\u003e- Transaction-ID and fallback duplicate checks\u003cbr\u003e- Manual category override for one-off activities\u003cbr\u003e- Internal-transfer and duplicate exclusion option\u003cbr\u003e- Financial-year-aware month ordering, including April to March\u003cbr\u003e- 12-month Actual and Budget input areas\u003cbr\u003e- Custom cash-flow activities that can be renamed\u003cbr\u003e- Automated Cash Flow Statement and full-year variance analysis\u003cbr\u003e- Ten separate monthly and year-to-date KPI cards\u003cbr\u003e- Four management visuals with explanatory headings\u003cbr\u003e- Automatically generated management commentary\u003cbr\u003e- Four prompts for drivers, timing, risks and management actions\u003cbr\u003e- Built-in reconciliation and import controls\u003cbr\u003e- Clearly highlighted input cells and formula-driven reports\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWhat is included?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e- Blank ready-to-use Excel template\u003cbr\u003e- Completed demonstration workbook\u003cbr\u003e- Five-page quick-start PDF guide\u003cbr\u003e- Customer license and usage terms\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eCompatibility\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eDesigned for **Microsoft Excel desktop**. Microsoft Excel is required. Google Sheets, Apple Numbers, mobile spreadsheet applications and older Excel versions are not guaranteed to preserve the formulas, charts, data validation, formatting or workbook behaviour.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eImportant Cash Flow note\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eA bank statement records cash movement. It does not replace bookkeeping records or determine every business treatment automatically. Users must review transfers, refunds, reversals, loan payments, credit-card settlements and other judgement items. Finreportly supports internal management reporting and cash planning. It does not provide bookkeeping, accounting, tax, legal, investment or other professional advice.\u003c\/p\u003e\n\u003cp\u003e \u003c\/p\u003e","brand":"Finreportly","offers":[{"title":"Default Title","offer_id":62012673130883,"sku":null,"price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1027\/7902\/7843\/files\/ChatGPT_Image_Aug_8_2026_01_04_31_AM.png?v=1786147605","url":"https:\/\/finreportly.com\/products\/finreportly-excel-cash-flow-statement-bank-csv-dashboard","provider":"Finreportly","version":"1.0","type":"link"}