{"product_id":"bankavstamning-kontoavstamning-2026-2027-matchkontroll-differenser-protokoll-excel-word-pdf","title":"Bank Reconciliation \u0026 Account Reconciliation 2026\/2027 – Matching Control, Discrepancies \u0026 Protocols | Excel, Word \u0026 PDF","description":"\u003csection class=\"mb-product\" lang=\"en\"\u003e\n\u003ch2\u003eBank Reconciliation \u0026amp; Account Reconciliation 2026\/2027 – professional template in Excel, Word, and PDF\u003c\/h2\u003e\n\n\u003cp\u003eCompare \u003cstrong\u003ebank statements with bookkeeping\u003c\/strong\u003e, identify discrepancies, and document checks with a practical package for Swedish small businesses, associations, and financial administration. The product combines an editable \u003cstrong\u003ebank reconciliation in Excel\u003c\/strong\u003e with forms for reconciliation protocols, correction supporting documents, reconciliation routines, and a separate user guide.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eYou receive:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\n\u003cnav aria-label=\"About the document template\"\u003e\u003cstrong\u003eAbout the document template:\u003c\/strong\u003e \u003ca href=\"#mb-innehall\"\u003eWhat is included\u003c\/a\u003e · \u003ca href=\"#mb-excel\"\u003eExcel features\u003c\/a\u003e · \u003ca href=\"#mb-sa-gor-du\"\u003eStep-by-step\u003c\/a\u003e · \u003ca href=\"#mb-juridik\"\u003eRules and risks\u003c\/a\u003e · \u003ca href=\"#mb-faq\"\u003eFAQ\u003c\/a\u003e\u003c\/nav\u003e\n\u003caside style=\"border-left:4px solid #2f7758;background:#EDF8F0;padding:16px;margin:16px 0\"\u003e\u003cstrong\u003eSource-verified October 13, 2026.\u003c\/strong\u003e Legal information has been compared with the Swedish Bookkeeping Act, the Swedish Accounting Standards Board's rules, and the Swedish Tax Agency's current bookkeeping guidance. This is an editorial and technical check, not government approval, certification, or proof of external legal review.\u003c\/aside\u003e\n\u003ch2 id=\"mb-innehall\"\u003eWhat is included in the package\u003c\/h2\u003e\n\n\u003ctable\u003e\n\n\u003cthead\u003e\u003ctr\u003e\n\n\u003cth\u003eDocument\u003c\/th\u003e\n\n\u003cth\u003eContent and function\u003c\/th\u003e\n\n\u003cth\u003eFormat\u003c\/th\u003e\n\n\n\u003c\/tr\u003e\u003c\/thead\u003e\n\n\u003ctbody\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eBank Reconciliation \u0026amp; Account Reconciliation\u003c\/td\u003e\n\n\u003ctd\u003eEight Excel sheets for balance control, bank entries, bookkeeping entries, match control, monthly overview, discrepancies, and settings.\u003c\/td\u003e\n\n\u003ctd\u003eXLSX\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eBank Reconciliation Routine\u003c\/td\u003e\n\n\u003ctd\u003eResponsibilities, workflow, manual matching, follow-up, corrections, and internal control.\u003c\/td\u003e\n\n\u003ctd\u003eDOCX + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eBank Reconciliation – Protocol\u003c\/td\u003e\n\n\u003ctd\u003eCheck of opening and closing balances, open items, checklist, and approval.\u003c\/td\u003e\n\n\u003ctd\u003eDOCX + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eDiscrepancy \u0026amp; Correction Supporting Document\u003c\/td\u003e\n\n\u003ctd\u003eCase details, investigation, amounts, cause, action, correction reference, and authorization.\u003c\/td\u003e\n\n\u003ctd\u003eDOCX + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eBank Reconciliation – English\u003c\/td\u003e\n\n\u003ctd\u003eEnglish work form with account balance, control points, and authorization for Swedish companies.\u003c\/td\u003e\n\n\u003ctd\u003eDOCX + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eDetailed User Guide\u003c\/td\u003e\n\n\u003ctd\u003eInstructions, calculation examples, common errors, legal limitations, sources, and English quick guide.\u003c\/td\u003e\n\n\u003ctd\u003eDOCX + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\n\n\n\u003c\/table\u003e\n\n\u003cp\u003e\u003cstrong\u003eDelivery:\u003c\/strong\u003e 11 files in a ZIP – five editable Word, five searchable PDF, and one Excel (XLSX). The files work offline with compatible software.\u003c\/p\u003e\n\n\u003ch2 id=\"mb-excel\"\u003eThe Excel tool – bank reconciliation with dashboard\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e bank and bookkeeping opening balance, transaction sum, calculated closing balances, and total discrepancy.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eSettings:\u003c\/strong\u003e company, account, period, and opening balances.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eBank entries:\u003c\/strong\u003e up to 200 entries from the bank statement with references and manual match ID.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eBookkeeping:\u003c\/strong\u003e up to 200 general ledger entries for the same BAS account, with date and voucher reference.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eMatch control:\u003c\/strong\u003e up to 200 manually selected match IDs that are summed per group and flagged as RECONCILED, DISCREPANCY, or MISSING COUNTER-ENTRY.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eMonthly overview:\u003c\/strong\u003e bank and bookkeeping changes month by month for the selected year.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eDiscrepancies:\u003c\/strong\u003e 100 case rows for investigation, action, responsible person, and status.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eGuide:\u003c\/strong\u003e short instructions and source references.\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003caside style=\"padding:16px;background:#FFF2D7;margin:16px 0\"\u003e\u003cstrong\u003eImportant limitation:\u003c\/strong\u003e The Excel template does not connect to the bank, does not import SIE automatically, and does not perform automatic transaction matching. A person must check each business transaction and assign a match ID; match status only applies to the groups the user has registered for control. A total discrepancy of zero does not prove that all transactions have been booked correctly. The Excel template is not a bookkeeping system.\u003c\/aside\u003e\n\u003ch2 id=\"mb-sa-gor-du\"\u003eHow to use the bank reconciliation template\u003c\/h2\u003e\n\n\u003col\u003e\n\n\u003cli\u003eRetrieve original bank statements and general ledger for the same company, bank account, currency, and period.\u003c\/li\u003e\n\n\u003cli\u003eEnter company details, BAS account, period, and opening balances in Excel.\u003c\/li\u003e\n\n\u003cli\u003eRegister bank transactions and corresponding bookkeeping entries in separate sheets. Payments received should increase and payments made should decrease the bank account in both lists.\u003c\/li\u003e\n\n\u003cli\u003eCheck date, counterparty, amount, and voucher reference, then assign a match ID manually.\u003c\/li\u003e\n\n\u003cli\u003eCompile each verified match ID once in Match Control and review discrepancies, open items, and items not yet matched.\u003c\/li\u003e\n\n\u003cli\u003eDocument actual errors or timing differences in the discrepancy supporting document. Make any accounting corrections in the regular bookkeeping system with correct supporting documentation.\u003c\/li\u003e\n\n\u003cli\u003eSign the reconciliation protocol and archive the bank statement, general ledger, workbook, and vouchers together.\u003c\/li\u003e\n\n\u003cli\u003e\n\u003c\/ol\u003e\n\n\u003ch2 id=\"mb-juridik\"\u003eBank reconciliation, Bookkeeping Act, and vouchers\u003c\/h2\u003e\n\n\u003cp\u003eThe 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 \u003cem\u003eBookkeeping, Annual Accounts, and Tax Return\u003c\/em\u003e (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.\u003c\/p\u003e\n\n\u003cp\u003eOfficial sources: \u003ca href=\"https:\/\/www.riksdagen.se\/sv\/dokument-och-lagar\/dokument\/svensk-forfattningssamling\/bokforingslag-19991078_sfs-1999-1078\/\"\u003eThe Riksdag – Bookkeeping Act\u003c\/a\u003e · \u003ca href=\"https:\/\/www.bfn.se\/redovisningsregler\/beslutade-redovisningsregler\/\"\u003eAccounting Standards Board – accounting rules\u003c\/a\u003e · \u003ca href=\"https:\/\/www.skatteverket.se\/download\/18.9567cda19bf6c0027216f6\/1770379535285\/bokforing-bokslut-och-deklaration-skv282utgava09.pdf\"\u003eSwedish Tax Agency – SKV 282 (2026)\u003c\/a\u003e.\u003c\/p\u003e\n\n\u003ch2 id=\"mb-faq\"\u003eFrequently asked questions\u003c\/h2\u003e\n\n\u003ch3\u003eWhat is a bank reconciliation?\u003c\/h3\u003e\n\n\u003cp\u003eA check that the booked balance and relevant transactions match the bank statement, with explanations of remaining items.\u003c\/p\u003e\n\n\u003ch3\u003eIs account reconciliation the same as bank reconciliation?\u003c\/h3\u003e\n\n\u003cp\u003eBank 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.\u003c\/p\u003e\n\n\u003ch3\u003eCan the template import bank statements or Fortnox automatically?\u003c\/h3\u003e\n\n\u003cp\u003eNo. Data is registered manually and no direct integration is included.\u003c\/p\u003e\n\n\u003ch3\u003eIs transaction matching automatic?\u003c\/h3\u003e\n\n\u003cp\u003eNo. The user manually assigns an ID after actual review. Excel sums and compares the ID groups that have been registered.\u003c\/p\u003e\n\n\u003ch3\u003eCan I use it for year-end closing?\u003c\/h3\u003e\n\n\u003cp\u003eYes, as a supplementary reconciliation document. It does not replace regular bookkeeping or a qualified annual account.\u003c\/p\u003e\n\n\u003ch3\u003eAre English documents included?\u003c\/h3\u003e\n\n\u003cp\u003eYes. A separate English work form and an English quick guide are included. Other master templates are Swedish and based on Swedish conditions.\u003c\/p\u003e\n\n\u003ch3\u003eIs this a duplicate of Cash Book or Accounts Payable?\u003c\/h3\u003e\n\n\u003cp\u003eNo. \u003ca href=\"\/en\/products\/kassabok-dagskassa-2026-2027-kontantjournal-dagsavslut-kassadifferens-excel-word-pdf\"\u003eCash Book \u0026amp; Daily Cash\u003c\/a\u003e focuses on physical petty cash and \u003ca href=\"\/en\/products\/leverantorsreskontra-betalningsbevakning-2026-2027-fakturor-delbetalningar-forfallolista-excel-word-pdf\"\u003eAccounts Payable\u003c\/a\u003e on supplier debts. This product concerns bank accounts against the general ledger.\u003c\/p\u003e\n\n\u003ch2\u003eDigital delivery and terms of use\u003c\/h2\u003e\n\n\u003cp\u003eDigital 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.\u003c\/p\u003e\n\n\n\u003cdiv class=\"mb-related-guide\" style=\"padding:16px 20px;margin:20px 0;border:1px solid #dbe6ea;border-radius:10px;background:#f6fafb\"\u003e\u003cp\u003e\u003cstrong\u003eRead our in-depth guide:\u003c\/strong\u003e \u003ca href=\"\/en\/blogs\/foretag\/bankavstamning-steg-for-steg-konto-1930-differenser\"\u003ebank reconciliation step-by-step with account 1930 and discrepancies\u003c\/a\u003e – practical work steps, checklist, and common questions.\u003c\/p\u003e\u003c\/div\u003e\n\n\u003c\/section\u003e","brand":"Svenska Dokumentmallar","offers":[{"title":"Default Title","offer_id":55731503923542,"sku":"BANKAVSTAMNING-2027-SVEN","price":79.0,"currency_code":"SEK","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0827\/2373\/3846\/files\/bankavstamning_2027_hero.png?v=1791904929","url":"https:\/\/mallbutiken.se\/en\/products\/bankavstamning-kontoavstamning-2026-2027-matchkontroll-differenser-protokoll-excel-word-pdf","provider":"Mallbutiken","version":"1.0","type":"link"}