Income Statement with Bank CSV Import and Business Dashboard
Full Product Description
Turn monthly figures or an exported bank CSV into a clear Income Statement, KPI dashboard and automatically generated business commentary. Finreportly suggests transaction categories, isolates exceptions for review and keeps loans, transfers and capital items from being blindly treated as profit or loss.
Know what your numbers are telling you
Finreportly is an Excel-based Income Statement and performance dashboard for small-business owners. Choose the input route that suits your business:
1. **Manual monthly input** - enter monthly actuals and budgets in clearly highlighted cells.
2. **Bank CSV import + adjustments** - paste an exported bank statement, map its headers, review exceptions and add accounting adjustments that the bank cannot provide.
Approved figures flow automatically into the Income Statement, monthly and year-to-date KPI cards, management charts and formula-generated commentary.
What Finreportly helps you understand
- Monthly and year-to-date revenue
- Cost of sales and gross margin
- Operating expenses and the largest cost drivers
- EBITDA, operating profit, net profit and net margin
- Actual vs Budget and full-year variances
- Month-on-month performance movement
- Top three revenue and cost drivers, including percentage contribution
- What reported performance may mean for the business
- Risks, opportunities and sensible next actions
What is included
- Blank protected Excel template
- Completed demonstration workbook
- Quick-start PDF guide
- Customer license and usage terms
Key features
- Optional manual or bank-import actuals route
- Flexible bank-column mapper
- Automatic inflow and outflow detection
- Editable keyword categorisation rules
- Exception-only review workflow
- Accounting adjustment schedule
- 12-month Actual and Budget areas
- Custom cost types mapped to standard reporting categories
- Automated Income Statement and full-year variance analysis
- Ten separate monthly and YTD KPI cards
- Four performance visuals
- Automatically generated management commentary
- Built-in reconciliation checks
- Protected formulas and clearly highlighted input cells
Compatibility
Designed for Microsoft Excel desktop. Microsoft Excel is required. Google Sheets, Apple Numbers and mobile spreadsheet applications are not guaranteed to preserve the formulas, charts, data validation, formatting or protection features
Important information
This is a digital download. No physical product will be supplied.
A bank statement records cash movement, not every Income Statement item. The workbook helps organise and review transactions, but it cannot determine every accounting treatment without judgement. Depreciation, accruals, unpaid invoices, stock movements and prepayments may require adjustments.
Finreportly supports internal management reporting and does not replace bookkeeping, accounting, tax or professional financial advice.