Reconcile a bank account

Bring in each bank's statements, say what every line was, and complete each statement once it balances.

  1. 1

    Open Reconcile from the sidebar. Each bank account is listed with its balance. Click a bank to open its page, where the lines of all its statements sit together.

  2. 2

    On a bank with no statement yet, drop the statement file on its page. Celerp reads PDF, CSV, Excel, OFX and QFX files and photos of a statement, then shows every line before anything is imported. If it doesn't recognise a CSV's columns, it asks which column holds the date, the description and the amount.

  3. 3

    In the preview, check the opening balance, the closing balance and the period; click a figure to correct it. The preview says whether the statement ties. Lines already imported, or probably already in your books, are marked and left unticked. Click Import to add the statement to the bank. On a bank that already has lines, Import another statement opens the same drop.

  4. 4

    Lines are grouped by who the money went to or came from, the largest group first, with its total and the suggestion its lines share. Switch between Open, Suggested, Questions, Posted and All, or search descriptions and references.

  5. 5

    Tick the groups whose suggestion is right and click Post ticked. The button shows how many lines and what total you are posting. Each posted line keeps an Undo until its statement is complete. Suggest looks again for an answer to every open line.

  6. 6

    To answer one line, click Answer separately beside it. Choose an account, a transfer to another bank, a cash withdrawal, no entry, or Suspense to decide later, and who it was paid to or from, then click Post. Split divides a line across accounts; the parts must add up to the line's amount.

  7. 7

    When you don't know what a line was, click Ask the client and write your question. The client answers on their questions page, with a receipt if they have one, and their answer becomes the line's suggestion. Lines asked about show under Questions.

  8. 8

    When the statement's difference is zero, click Complete statements. Celerp completes each open statement that balances, oldest first, and says where it stopped and why. Lines still in Suspense wait there until you say where they belong. A completed statement can be opened again from the statements strip.

  9. 9

    A rule posts every line that matches its pattern to the same account. Add rules on the Reconciliation Rules tab of accounting settings, each for one bank or for every bank.

  10. 10

    Reconciliation history beside a bank on the list shows its completed statements.

  11. 11

    The assistant can read a statement, suggest answers and settle lines for you. It shows what it proposes on one card, and nothing is posted until you confirm. The card links to the bank page, where you can change what is ticked.

You can open this guide inside Celerp too: choose Help on any screen.

What to do next

Related guides

All guides for this module: Accounting

Features

Download Free