Payment reconciliation

Reconciliation confirms that recorded payments match bank activity and invoice balances. It catches missing deposits, duplicates, and timing errors.

Without reconciliation, you can feel profitable and organized while your records drift from reality.

Think of it as a scheduled truth check—not a once-a-year panic before taxes.

1) List invoices marked paid in the period. 2) List bank deposits and processor payouts. 3) Match them. 4) Investigate exceptions. 5) Adjust records. 6) Lock the period when clean.

Exceptions include: paid in books but not in bank, in bank but not applied, partial payments, fees withheld by processors, and currency differences.

Work from the bank outward if you get stuck—cash that arrived is hard to argue with.

Card processors often deposit net amounts after fees. Your invoice may be $1,000 while the deposit is $971. Record the fee so reconciliation still ties out.

Batch payouts that combine several invoices need line-by-line application even if the bank shows one lump sum.

Document your fee handling once so you do not reinvent it every Friday.

Weekly is ideal for active freelancers. Monthly is a minimum if volume is low. Daily may help during high-volume seasons.

Reconcile before you send aggressive collection notices. Chasing a client for an invoice you already received is embarrassing and damaging.

Pair reconciliation with your AR aging review for a complete money picture.

Pick last week’s deposits and match them to invoices today.

Create a recurring calendar event for reconciliation—short and non-negotiable.

If exceptions are chronic, fix the upstream cause: missing payment references, slow cash application, or unclear fees.