Payment Matching for Freelancers: Reconcile Bank Transfers with Invoices

Why freelancers need payment reconciliation

When you have five clients, each paying different amounts on different dates via bank transfer, things can get messy fast. Without matching payments to invoices, you lose track of:

• Who has actually paid— your invoice says “sent” but has the money arrived? Without checking your bank statement, you don't know.
• Partial payments— a client pays €1,500 of a €2,000 invoice. If you mark it as “paid” by mistake, you lose track of the €500 still owed. (See our partial payments guide.)
• Overdue invoices— if you don't reconcile regularly, you might not notice an invoice is overdue until weeks later. Early follow-up gets you paid faster.
• Tax accuracy— your VAT return and income tax depend on knowing exactly which invoices were paid and when. Mismatches lead to incorrect filings.
• Cash flow clarity — your dashboard is only as accurate as the data behind it. Unreconciled payments mean your reported cash flow is wrong.

The “log first, match later” workflow

The most reliable approach for freelancers is a two-step process:

1. Log the payment— when you see a transfer in your bank account, record it in your payment log immediately. Capture the amount, date, payer name, and reference (if any).
2. Match it to an invoice— find the corresponding invoice and link the payment to it. The invoice status updates automatically.

Why not do it in one step? Because sometimes you can't identify the invoice immediately. The payer name might be different from the client name, the amount might not match exactly, or the client might have combined payments for multiple invoices. Logging first ensures nothing falls through the cracks while you sort out the details.

How to log a bank payment in Bontello

Open the Payment Log and add a new entry:

1. Click Log Payment.
2. Enter the amountexactly as it appears on your bank statement (e.g., €2,380.00).
3. Enter the date the payment was received (the bank statement date, not the date you noticed it).
4. Enter the payer nameas shown on the bank statement (e.g., “ACME GMBH”).
5. Add a referenceif the client included one (e.g., “INV-2026-042” or a project name). This makes matching easier.
6. Save. The payment is now in your log, ready to be matched.

Matching a payment to an invoice

Once the payment is logged, the next step is linking it to the right invoice:

1. Open the unmatched payment from your Payment Log.
2. Click Match to Invoice. Bontello shows your unpaid and partially paid invoices, sorted by amount similarity and client name.
3. Select the matching invoice. If the payment amount equals the invoice total, it's a full match — the invoice moves to Paid.
4. If the payment is less than the invoice total, it's recorded as a partial payment. The invoice moves to Partially Paid and shows the remaining balance.
5. Confirm. The payment is now matched, and the invoice status is updated.

Handling edge cases

Real-world payments are rarely as clean as the textbook. Here are the most common complications and how to handle them:

Different payer name

The bank statement says “ACME HOLDING BV” but your invoice is for “Acme Digital GmbH.” This happens when a parent company or a shared services center processes payments. Match it manually based on the amount and timing, and add a note explaining the discrepancy. Over time, you'll learn which clients pay from different entities.

Combined payment for multiple invoices

A client sends one transfer of €4,200 that covers Invoice #041 (€2,000) and Invoice #043 (€2,200). Log the payment once, then split it across both invoices. In Bontello, you can match a single payment to multiple invoices by allocating the amount across them.

Overpayment

The client accidentally sends €2,500 for a €2,000 invoice. Match €2,000 to the invoice (marking it as Paid) and leave €500 as an unmatched credit. You can apply this credit to the client's next invoice or arrange a refund.

Unmatched payments

Sometimes you receive a payment that doesn't match any invoice. This could be a refund from a supplier, a tax rebate, or an error. Leave it unmatched in your payment log and investigate. Do not force-match it to an invoice just to clear the list.

Spotting unmatched payments at a glance

Your dashboard should make unmatched payments immediately visible. In Bontello, the Payment Log highlights:

• Unmatched payments— bank transfers that haven't been linked to any invoice yet. These need your attention.
• Unpaid invoices— invoices that have no matching payment. Cross-reference with your bank statement to see if the money arrived but wasn't logged.
• Partially matched payments— payments that were applied to an invoice but have a remaining unallocated balance.

Make reconciliation a weekly habit. Set aside 15 minutes every Monday (or Friday) to log new payments from your bank statement and match them to invoices. The longer you wait, the harder it gets to remember which payment belongs to which invoice.

Key takeaways

• Payment matching connects your bank statement to your invoicing records — essential for accurate bookkeeping.
• Use the “log first, match later” workflow: record every bank transfer, then link it to the right invoice.
• Handle edge cases (different payer names, combined payments, overpayments) by matching manually and adding notes.
• Never force-match an unidentified payment — investigate first.
• Make reconciliation a weekly habit: 15 minutes saves hours of confusion at tax time.
• Ask clients to include the invoice number in their bank transfer reference for easy matching.