Pantry

Run your books

Reconcile a bank statement

Import a CSV or OFX statement, match each line to your books, and finish when the difference is $0.00.

Your bank statement is the bank's record. Reconciling proves that your books agree with it, line by line, before you close the month.

Import the statement

  1. Download the statement from your bank as OFX (also called Web Connect or QFX) or CSV.
  2. In Bank, under Import a statement, choose the bank account and the file.
  3. For a CSV file, enter the opening and closing balances printed on the statement, its start and end dates, and the account's last four digits, because a CSV file does not name the account. An OFX file carries its own account and closing balance.
  4. Choose Import statement.

Importing the same file again adds nothing, and an overlapping download adds only the lines Pantry does not already have. Statement lines never post anything by themselves.

Match each line

Choose Reconcile beside the statement. Pantry shows Statement lines beside Ledger postings, with the statement's balances and the Difference above them.

  1. Select one or more statement lines and the postings they correspond to.
  2. If the books are missing something, such as a bank fee, interest, a transfer between your accounts, a customer receipt or a vendor payment, add it in Match review with + Fee, + Bank income, + Transfer, + Receipt or + Payment.
  3. When the statement and ledger totals agree, choose Approve match.

A payment you already recorded is cleared by its bank line without being posted twice. A line or posting is matched only once.

Finish the reconciliation

Finish reconciliation stays unavailable until every line is matched and the ledger's bank balance, less items not yet on a statement, equals the closing balance. Until then Before you can finish lists each remaining difference. Once finished, the reconciliation keeps its proof and its matches are frozen.

If you typed a balance from the statement wrongly, correct it with a reason before you finish.

When your agent proposes a match

Lines your agent has matched show Proposed by agent. Review the proposal under the tables and choose Approve match or Reject. Approving re-checks every line and posting it used. See Agent work.