Bookkeeping Excel Template
£39.99
Skip to product information
Turn bank transactions into organised bookkeeping, a monthly Profit & Loss, an indicative VAT summary and a clear business dashboard - all in Microsoft Excel.
Full product description
Keep your bookkeeping organised without starting from a blank spreadsheet.
The Finreportly Bookkeeping Template is a guided Excel system for small-business owners who want a simpler monthly process. Paste a bank CSV export, map the bank's columns, let reusable rules suggest categories and VAT treatment, then review only the transactions that need attention.
Approved bank transactions and manual entries feed a structured transaction ledger, bank reconciliation, monthly Profit & Loss, indicative VAT Summary and visual Dashboard. Built-in checks highlight incomplete records before you rely on the reports.
What the workbook helps you do
Paste up to 500 bank transactions from a CSV export
Map common bank layouts with separate debit and credit columns or one signed Amount column
Suggest categories, VAT rates and reporting treatment from editable description rules
Override any suggestion without changing the original bank data
Review exceptions, possible duplicates and incomplete entries in one place
Add cash, accruals, corrections and other non-bank entries manually
Maintain a calculated transaction ledger
Reconcile one business bank account by month
Produce a monthly and full-year Profit & Loss
Review an indicative monthly VAT position
Monitor cash, sales, costs, net profit and VAT on a visual dashboard
Read automatically generated plain-English bookkeeping commentary
Confirm internal consistency with a clear MODEL STATUS: PASS control
A simple monthly workflow
Complete the guided Setup sheet.
Paste one bank CSV export into Bank Import.
Map the bank's date, description and amount columns.
Resolve any REVIEW items and confirm the READY transactions are sensible.
Add any non-bank activity in Manual Entries.
Enter the statement closing balance in Bank Reconciliation.
Confirm Checks shows PASS, then read the Dashboard, Profit & Loss and VAT Summary.
What is included?
Blank Bookkeeping workbook v1.0
Completed three-month demonstration workbook v1.0
Six-page Quick Start Guide
Finreportly Customer License
Who it is for?
Sole traders and owner-managed businesses
Freelancers, consultants and service businesses
Small product businesses with straightforward bank-led bookkeeping
New business owners building a consistent monthly finance routine
Bookkeepers supporting one licensed client business
Designed for bookkeeping beginners
The workbook uses a guided, colour-coded structure. Yellow cells are for user entries or choices, light-blue areas contain calculations or reference data, and READY / REVIEW / PASS statuses show where attention is needed. The included demo workbook shows the complete process before you start with the blank copy.
Important information
Designed for Microsoft Excel 365 or Excel 2021 and later; desktop Excel is recommended.
No macros, subscriptions or external connections are required.
Version 1.0 is presented in GBP and supports one bank account per working copy.
Each working copy supports up to 500 bank rows and 150 manual entries.
Compatibility with Google Sheets, Apple Numbers, mobile apps and older Excel versions is not guaranteed.
The VAT Summary is indicative and may not cover VAT schemes, partial exemption, reverse charge, imports or other special treatments.
This is a management bookkeeping template, not statutory accounts, payroll, inventory, invoicing, tax-return or VAT-filing software.
Buyers are responsible for the accuracy, completeness and accounting or tax treatment of their entries.
This is a digital product; no physical item will be shipped.
Purchase provides a single-business license. A separate license is required for each additional business or client.
Key selling points
Bank CSV import with flexible column mapping
Reusable automatic categorisation rules
Focused exception and duplicate review
Manual adjustments and calculated transaction ledger
Monthly bank reconciliation
Profit & Loss and indicative VAT Summary
Visual dashboard with plain-English commentary
Built-in model checks
Blank and completed demonstration workbooks
Quick Start Guide and Customer License included