Bank reconciliation in the accounting firm: closing the quarter without surprises

· 3 min read

Bank reconciliationQuarter closeInvoicesAccounting firms

Reconciling is matching what the bank says with what the invoices say. A method to do it every quarter and ask only for what is missing.

In this article
  1. What gets matched
  2. Cases that do not match at first
  3. A quarterly routine
  4. What to keep
  5. Deadlines rule
  6. In Guilda Work

Closing a quarter is largely about answering one question: does everything that moved in the bank have its supporting document, and does every invoice have its receipt or payment? Bank reconciliation answers both halves, and doing it before calculating the return avoids reopening a quarter that is already filed.

What gets matched

Two lists for the same period are compared:

  • Bank movements, as they come out of the CSV or Excel statement: date, description and amount.
  • The client's invoices, issued and received, with their totals.

The most reliable match is by exact amount, with date and description as support. That produces three groups:

  1. Movements with an invoice. Reconciled; no action needed.
  2. Movements without an invoice. What needs a supporting document: expenses without a receipt, receipts without an issued invoice, transfers between own accounts.
  3. Invoices without a movement. Pending receipt or payment, or paid another way (cash, personal card, another account).

Cases that do not match at first

  • Grouped payments. One transfer that settles several invoices from the same supplier. Try sums of two to four invoices from the same counterparty before calling it "no invoice".
  • Bank fees and charges. Small movements that usually have their own monthly statement from the bank.
  • Transfers between own accounts. Neither income nor expense; flag them and set them aside.
  • Card or gateway receipts. The bank receives the net amount, not the gross sales.
  • Advances and credit notes. A credit note subtracts; it must not be counted as a repeated invoice.

A quarterly routine

  1. Ask for the full statement for the period, not only the movements the client remembers.
  2. Reconcile before calculating VAT. Invoices that appear in the bank but not in the ledger are input or output VAT that is missing.
  3. Ask once. A single request with the list of unsupported movements, not three scattered emails.
  4. Ask closed questions. "Business or personal?" is answered with one tap; "what is this?" needs an explanation.
  5. Review invoices without payment before closing. It may be a late payment to watch or an invoice that never existed.

What to keep

The bank statement contains third-party data that is not needed for the close. A prudent practice is to keep only what the work requires: date, amount and description of each movement, not the whole file. That lets you flag invoices without receipt or payment at quarter close without holding more data than necessary.

Deadlines rule

Quarterly VAT and instalment returns are filed in the first twenty calendar days of the month after the quarter (up to 30 January for the fourth quarter of model 303 and model 130). If the last day falls on a non-working day, it moves to the next working day. Reconcile with a margin: the Tax Agency's taxpayer calendar is the reference.

In Guilda Work

Guilda Work matches the statement with invoices by amount, proposes grouped payments, lets you request supporting documents from the client in their portal with one-tap questions and, at quarter close, flags invoices without receipt or payment. The bank file is not stored; only what you flag.

Informational content. Confirm deadlines and obligations with the Tax Agency and the BOE.

Informational content based on the official sources cited. It does not replace tax or legal advice for a specific case; check the data at the source before applying it.