About this template
Bank Reconciliation & Account Reconciliation 2026/2027 – professional template in Excel, Word, and PDF
Compare bank statements with bookkeeping, identify discrepancies, and document checks with a practical package for Swedish small businesses, associations, and financial administration. The product combines an editable bank reconciliation in Excel with forms for reconciliation protocols, correction supporting documents, reconciliation routines, and a separate user guide.
You receive: 1 Excel tool with eight worksheets, 5 Word documents (DOCX), and 5 corresponding searchable PDF files. Swedish master templates plus a separate English work form adapted to Swedish conditions.
What is included in the package
| Document | Content and function | Format |
|---|---|---|
| Bank Reconciliation & Account Reconciliation | Eight Excel sheets for balance control, bank entries, bookkeeping entries, match control, monthly overview, discrepancies, and settings. | XLSX |
| Bank Reconciliation Routine | Responsibilities, workflow, manual matching, follow-up, corrections, and internal control. | DOCX + PDF |
| Bank Reconciliation – Protocol | Check of opening and closing balances, open items, checklist, and approval. | DOCX + PDF |
| Discrepancy & Correction Supporting Document | Case details, investigation, amounts, cause, action, correction reference, and authorization. | DOCX + PDF |
| Bank Reconciliation – English | English work form with account balance, control points, and authorization for Swedish companies. | DOCX + PDF |
| Detailed User Guide | Instructions, calculation examples, common errors, legal limitations, sources, and English quick guide. | DOCX + PDF |
Delivery: 11 files in a ZIP – five editable Word, five searchable PDF, and one Excel (XLSX). The files work offline with compatible software.
The Excel tool – bank reconciliation with dashboard
- Dashboard: bank and bookkeeping opening balance, transaction sum, calculated closing balances, and total discrepancy.
- Settings: company, account, period, and opening balances.
- Bank entries: up to 200 entries from the bank statement with references and manual match ID.
- Bookkeeping: up to 200 general ledger entries for the same BAS account, with date and voucher reference.
- Match control: up to 200 manually selected match IDs that are summed per group and flagged as RECONCILED, DISCREPANCY, or MISSING COUNTER-ENTRY.
- Monthly overview: bank and bookkeeping changes month by month for the selected year.
- Discrepancies: 100 case rows for investigation, action, responsible person, and status.
- Guide: short instructions and source references.
How to use the bank reconciliation template
- Retrieve original bank statements and general ledger for the same company, bank account, currency, and period.
- Enter company details, BAS account, period, and opening balances in Excel.
- Register bank transactions and corresponding bookkeeping entries in separate sheets. Payments received should increase and payments made should decrease the bank account in both lists.
- Check date, counterparty, amount, and voucher reference, then assign a match ID manually.
- Compile each verified match ID once in Match Control and review discrepancies, open items, and items not yet matched.
- Document actual errors or timing differences in the discrepancy supporting document. Make any accounting corrections in the regular bookkeeping system with correct supporting documentation.
- Sign the reconciliation protocol and archive the bank statement, general ledger, workbook, and vouchers together.
Bank reconciliation, Bookkeeping Act, and vouchers
The Bookkeeping Act (1999:1078) requires current bookkeeping, traceable corrections, and vouchers, among other things in Chapter 5. The Accounting Standards Board's BFNAR 2013:2 Bookkeeping provides further guidance. The Swedish Tax Agency describes the reconciliation of bank statements against the booked bank account in the brochure Bookkeeping, Annual Accounts, and Tax Return (SKV 282, 2026), where monthly reconciliation is specified as the working method. This standard template does not replace the accounting corrections, attachments, vouchers, or security routines that the business may need.
Official sources: The Riksdag – Bookkeeping Act · Accounting Standards Board – accounting rules · Swedish Tax Agency – SKV 282 (2026).
Frequently asked questions
What is a bank reconciliation?
A check that the booked balance and relevant transactions match the bank statement, with explanations of remaining items.
Is account reconciliation the same as bank reconciliation?
Bank reconciliation is a specific account reconciliation of bank accounts. This product focuses on the bank account and its general ledger account, not all balance sheet accounts.
Can the template import bank statements or Fortnox automatically?
No. Data is registered manually and no direct integration is included.
Is transaction matching automatic?
No. The user manually assigns an ID after actual review. Excel sums and compares the ID groups that have been registered.
Can I use it for year-end closing?
Yes, as a supplementary reconciliation document. It does not replace regular bookkeeping or a qualified annual account.
Are English documents included?
Yes. A separate English work form and an English quick guide are included. Other master templates are Swedish and based on Swedish conditions.
Is this a duplicate of Cash Book or Accounts Payable?
No. Cash Book & Daily Cash focuses on physical petty cash and Accounts Payable on supplier debts. This product concerns bank accounts against the general ledger.
Digital delivery and terms of use
Digital document product without physical delivery. The ZIP file contains editable local documents and guides. The automatic download in Shopify must be checked separately via Digital Products. Special cases such as foreign currencies, pool/group accounts, and complex bank agreements may require customization with an accounting specialist.
