Skip to content
Degresh Finance

Reconcile a bank statement

Import a bank statement from Excel, match its lines to the books, turn bank charges into entries, then finish the reconciliation.

7 min read

Before you start

A bank account in Degresh Finance is an asset account that isn’t a group. Open Bank reconciliation and choose the bank account. Importing a statement needs Write access or higher.

1. Import the statement

  1. Get the template

    Choose Import a bank statement, then Download the template and copy the bank’s lines into it.
  2. Choose the account and the file

    Fill in the Opening balance or Closing balance if the file has no Balance column. Left empty, the period runs from the first line’s day to the last line’s day.
  3. Check the file, then import

    Choose Check the file. Lines imported before are skipped; fix any errors marked in the file, then Import.

2. Match the lines

Choose Match the lines. On one side are the Statement lines, on the other the Journal lines for that account.

  • Suggestions — same amount and direction, at most 3 days apart. Nothing is matched until you choose Accept or Accept all suggestions.
  • By hand — pick lines on both sides until The two sides are equal, then Match.

3. Record bank-only lines

Bank charges, interest and tax usually aren’t in the books yet. On that line, choose Create an entry from this line, pick the other account (such as bank charges expense), then Create entry. The entry is posted and matched at once — or waits for approval when approvals are on.

4. Finish the reconciliation

Choose Start a reconciliation with the statement date and balance. The reconciliation page shows the Balance per bank and Balance per books with their adjustments: deposits in transit, outstanding payments, and items in the bank that aren’t in the books yet.

When the Difference reaches zero, choose Finish.

A finished reconciliation is frozen

Lines and matches up to the statement date can’t change, and matched entries can’t be reversed or voided. An admin can choose Reopen reconciliation for the latest one; this is recorded in Activity.

Questions about this flow?

Our team is happy to help, including during early access.

Talk to us