{"product_id":"small-business-bookkeeping-excel-template","title":"Bookkeeping Excel Template","description":"\u003cp\u003eTurn bank transactions into organised bookkeeping, a monthly Profit \u0026amp; Loss, an indicative VAT summary and a clear business dashboard - all in Microsoft Excel.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eFull product description\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eKeep your bookkeeping organised without starting from a blank spreadsheet.\u003c\/p\u003e\n\u003cp\u003eThe 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.\u003c\/p\u003e\n\u003cp\u003eApproved bank transactions and manual entries feed a structured transaction ledger, bank reconciliation, monthly Profit \u0026amp; Loss, indicative VAT Summary and visual Dashboard. Built-in checks highlight incomplete records before you rely on the reports.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWhat the workbook helps you do\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003ePaste up to 500 bank transactions from a CSV export\u003c\/p\u003e\n\u003cp\u003eMap common bank layouts with separate debit and credit columns or one signed Amount column\u003c\/p\u003e\n\u003cp\u003eSuggest categories, VAT rates and reporting treatment from editable description rules\u003c\/p\u003e\n\u003cp\u003eOverride any suggestion without changing the original bank data\u003c\/p\u003e\n\u003cp\u003eReview exceptions, possible duplicates and incomplete entries in one place\u003c\/p\u003e\n\u003cp\u003eAdd cash, accruals, corrections and other non-bank entries manually\u003c\/p\u003e\n\u003cp\u003eMaintain a calculated transaction ledger\u003c\/p\u003e\n\u003cp\u003eReconcile one business bank account by month\u003c\/p\u003e\n\u003cp\u003eProduce a monthly and full-year Profit \u0026amp; Loss\u003c\/p\u003e\n\u003cp\u003eReview an indicative monthly VAT position\u003c\/p\u003e\n\u003cp\u003eMonitor cash, sales, costs, net profit and VAT on a visual dashboard\u003c\/p\u003e\n\u003cp\u003eRead automatically generated plain-English bookkeeping commentary\u003c\/p\u003e\n\u003cp\u003eConfirm internal consistency with a clear MODEL STATUS: PASS control\u003c\/p\u003e\n\u003cp\u003eA simple monthly workflow\u003c\/p\u003e\n\u003cp\u003eComplete the guided Setup sheet.\u003c\/p\u003e\n\u003cp\u003ePaste one bank CSV export into Bank Import.\u003c\/p\u003e\n\u003cp\u003eMap the bank's date, description and amount columns.\u003c\/p\u003e\n\u003cp\u003eResolve any REVIEW items and confirm the READY transactions are sensible.\u003c\/p\u003e\n\u003cp\u003eAdd any non-bank activity in Manual Entries.\u003c\/p\u003e\n\u003cp\u003eEnter the statement closing balance in Bank Reconciliation.\u003c\/p\u003e\n\u003cp\u003eConfirm Checks shows PASS, then read the Dashboard, Profit \u0026amp; Loss and VAT Summary.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWhat is included?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eBlank Bookkeeping workbook v1.0\u003c\/p\u003e\n\u003cp\u003eCompleted three-month demonstration workbook v1.0\u003c\/p\u003e\n\u003cp\u003eSix-page Quick Start Guide\u003c\/p\u003e\n\u003cp\u003eFinreportly Customer License\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWho it is for?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eSole traders and owner-managed businesses\u003c\/p\u003e\n\u003cp\u003eFreelancers, consultants and service businesses\u003c\/p\u003e\n\u003cp\u003eSmall product businesses with straightforward bank-led bookkeeping\u003c\/p\u003e\n\u003cp\u003eNew business owners building a consistent monthly finance routine\u003c\/p\u003e\n\u003cp\u003eBookkeepers supporting one licensed client business\u003c\/p\u003e\n\u003cp\u003eDesigned for bookkeeping beginners\u003c\/p\u003e\n\u003cp\u003eThe 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eImportant information\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eDesigned for Microsoft Excel 365 or Excel 2021 and later; desktop Excel is recommended.\u003c\/p\u003e\n\u003cp\u003eNo macros, subscriptions or external connections are required.\u003c\/p\u003e\n\u003cp\u003eVersion 1.0 is presented in GBP and supports one bank account per working copy.\u003c\/p\u003e\n\u003cp\u003eEach working copy supports up to 500 bank rows and 150 manual entries.\u003c\/p\u003e\n\u003cp\u003eCompatibility with Google Sheets, Apple Numbers, mobile apps and older Excel versions is not guaranteed.\u003c\/p\u003e\n\u003cp\u003eThe VAT Summary is indicative and may not cover VAT schemes, partial exemption, reverse charge, imports or other special treatments.\u003c\/p\u003e\n\u003cp\u003eThis is a management bookkeeping template, not statutory accounts, payroll, inventory, invoicing, tax-return or VAT-filing software.\u003c\/p\u003e\n\u003cp\u003eBuyers are responsible for the accuracy, completeness and accounting or tax treatment of their entries.\u003c\/p\u003e\n\u003cp\u003eThis is a digital product; no physical item will be shipped.\u003c\/p\u003e\n\u003cp\u003ePurchase provides a single-business license. A separate license is required for each additional business or client.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eKey selling points\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eBank CSV import with flexible column mapping\u003c\/p\u003e\n\u003cp\u003eReusable automatic categorisation rules\u003c\/p\u003e\n\u003cp\u003eFocused exception and duplicate review\u003c\/p\u003e\n\u003cp\u003eManual adjustments and calculated transaction ledger\u003c\/p\u003e\n\u003cp\u003eMonthly bank reconciliation\u003c\/p\u003e\n\u003cp\u003eProfit \u0026amp; Loss and indicative VAT Summary\u003c\/p\u003e\n\u003cp\u003eVisual dashboard with plain-English commentary\u003c\/p\u003e\n\u003cp\u003eBuilt-in model checks\u003c\/p\u003e\n\u003cp\u003eBlank and completed demonstration workbooks\u003c\/p\u003e\n\u003cp\u003eQuick Start Guide and Customer License included\u003c\/p\u003e","brand":"Finreportly","offers":[{"title":"Default Title","offer_id":62407988937091,"sku":null,"price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1027\/7902\/7843\/files\/Finreportly_Bookkeeping_Template_Cover_8368e3ec-59c4-4d32-beee-b2e43ea68322.png?v=1786996905","url":"https:\/\/finreportly.com\/products\/small-business-bookkeeping-excel-template","provider":"Finreportly","version":"1.0","type":"link"}