Bank Reconciliation Made Easy: Step-by-Step Guide

Bank reconciliation (bankavstamning) is the process of matching your accounting records against your actual bank transactions. It is essential for catching errors, preventing fraud, and maintaining accurate books. This guide walks you through the entire process.

What is Bank Reconciliation?

Bank reconciliation compares two sets of records:

1. Your accounting records -- what you have booked in Fortnox, Visma, Bokio, or your spreadsheet
2. Your bank statement -- the actual transactions recorded by your bank

The goal is simple: make sure every transaction in your books matches a real bank transaction, and vice versa. Any discrepancies need investigation.

Why Reconciliation Matters

• Catch errors early: A mistyped amount or duplicate entry is easy to fix when caught quickly
• Detect fraud: Unauthorized transactions show up during reconciliation
• Tax compliance: Skatteverket requires accurate books. Reconciliation proves your records match reality
• Cash flow visibility: Know your exact bank balance vs. booked balance at any time
• Audit readiness: Regular reconciliation makes audits painless

Step-by-Step: Bank Reconciliation

Step 1: Get Your Bank Statement in a Workable Format

Most banks provide statements as PDFs. To reconcile efficiently, you need the data in Excel or CSV format.

Step 2: Export Your Accounting Records

From your accounting software, export the same period's transactions:

• Fortnox: Go to Bookkeeping > Bank Reconciliation > Import bank file
• Visma: Reports > Account statement > Export
• Bokio: Bank > Reconciliation > Import transactions
• Excel: Open your bookkeeping spreadsheet and filter by the relevant account and date range

Step 3: Match Transactions

Go through each bank transaction and find the corresponding entry in your books. Match on:

1. Date: Should match within 1-2 business days
2. Amount: Must match exactly (ore/cent level)
3. Description: Bank descriptions may differ from your booked descriptions -- use amounts and dates to confirm

Step 4: Investigate Discrepancies

Common reasons for mismatches:

• Timing differences: You booked a payment on Friday but the bank processed it Monday
• Missing bookings: A bank fee or interest payment you forgot to book
• Duplicate entries: The same transaction booked twice
• Wrong amounts: Typos in manual bookkeeping entries
• Unrecognized transactions: Card purchases or automatic payments you need to identify

Step 5: Adjust and Document

For each discrepancy, create the appropriate journal entry in your accounting software. Document the reason for the adjustment. Save the reconciliation report for your records.

Reconciliation in Fortnox

Fortnox makes reconciliation straightforward with its bank import feature:

1. Convert your PDF statement using BankStatementConverter with the Fortnox CSV export format
2. In Fortnox, go to Bookkeeping > Bank reconciliation
3. Click Import bank file and select your Fortnox CSV
4. Fortnox will automatically match transactions with your booked entries
5. Review unmatched transactions and create bookings for any missing entries
6. Confirm the reconciliation when the balance matches

How Often Should You Reconcile?

The short answer: as often as practical.

• Monthly: Minimum recommended frequency. Reconcile at the end of each month.
• Weekly: Recommended for businesses with high transaction volume.
• Daily: For businesses handling cash or with fraud risk.

In Sweden, Bokforingsnamnden (BFN) recommends reconciliation at least monthly. For businesses using Fortnox or Visma, the process takes only minutes when your bank statements are already in the right format.

Tips for Faster Reconciliation

1. Convert statements immediately: Do not let PDFs pile up. Convert as soon as your bank issues the statement.
2. Use the right export format: Fortnox CSV for Fortnox, standard CSV for other tools.
3. Reconcile regularly: Monthly reconciliation takes minutes. Quarterly takes hours.
4. Automate what you can: Recurring transactions (rent, salary, subscriptions) can be pre-booked.
5. Keep records: Save both the original PDF and the converted file for audit trails.