Back to Blog

Matching Invoices to Deposits: A Month-End Check Without Accounting Software

Short answer: A paid invoice and money in your bank are two different events, often on different days and for different amounts. Once a month, list every paid invoice, list every deposit that hit your bank, and match them line by line. Anything left over on either side is your to-do list.

Most freelancers and small shops find out something is off the same way: the invoices say it was a good month, and the bank balance disagrees.

Usually nothing is wrong. A client paid by card on the 29th and the money landed on the 2nd. Three card payments arrived as one deposit. Processing fees came out before the money reached you. But "usually nothing is wrong" isn't the same as knowing. A short monthly check closes the gap.

Why doesn't "paid" match what's in the bank?

A few ordinary reasons:

  • Timing. A card payment is paid the moment the client pays, but it reaches your bank later, when your processor sends a payout. A check or bank transfer lands on whatever day it clears.
  • Bundling. A processor like Stripe can combine several payments into one payout. Your bank shows one deposit; your invoices show three payments.
  • Fees. Card processing fees are usually taken out before the payout, so the deposit is smaller than the invoice total.
  • Refunds and disputes. These can reduce a later payout, so a deposit can look short for reasons that have nothing to do with that week's invoices.
  • Payments outside your invoices. A client pays by check or bank transfer and nobody updates the invoice to paid.

None of this is a problem on its own. It only becomes one when you can't explain the difference.

What do you need for the check?

Three lists for the month:

  1. Invoices showing as paid, with invoice number, client, amount and the date it was paid.
  2. Payouts from your card processor, if you take cards. In Stripe, the Payouts view lists each payout and the payments inside it.
  3. Deposits on your bank statement for the business account.

If you already keep an unpaid-invoice tracker, list one is mostly done. See How to Track Unpaid Invoices: A Simple Receivables Tracker.

How do you match invoices to deposits?

Add two columns to your tracker: Deposit date and Deposit reference (the payout ID, check number or bank transfer reference). Then work through it in order:

  1. Card payments first. Open each processor payout, see which payments it contains, and write that payout's date and ID next to each matching invoice. Then find that payout's amount on your bank statement and tick it off.
  2. Checks and bank transfers next. Match each remaining bank deposit to an invoice by amount and client name. Write the date and reference next to the invoice.
  3. Fees. For each payout, the difference between the invoices it covers and the deposit should be the processing fees. Note the fee total for the month; your bookkeeper or tax preparer will want it.

Example (amounts are examples only): invoices 1041, 1042 and 1044 were paid by card for $600, $1,250 and $400, a total of $2,250. One payout of a little less than that lands in the bank two days later. The difference is the fees on those three payments, and all three invoices now have the same deposit date and payout ID.

What do the leftovers tell you?

When you're done, look at what didn't match:

  • An invoice showing as paid with no deposit. Either the money hasn't landed yet (check the processor), or the status is wrong. Find out which this week, not next quarter.
  • A deposit with no invoice. Often a client paid by check or transfer and the invoice is still showing as unpaid. Update its status so you don't send a reminder to someone who already paid you.
  • A deposit that's short by more than fees. Look for a refund or dispute in your processor.
  • An unpaid invoice that's now overdue. That's a follow-up, not a reconciliation problem. Your weekly check should catch these sooner.

How often should you do this?

Once a month is enough for most freelancers and small shops, ideally in the first few days of the next month, once the last payouts have landed. If you get a lot of payments, do it every two weeks. Block the time on your calendar so it actually happens.

This isn't a replacement for proper bookkeeping or an accountant. It's a quick way to make sure the money you think you earned is the money you actually have.

How does this work in InvoiceMedley?

In InvoiceMedley you create a professional invoice in minutes and email it with the PDF attached. Clients can pay right away with Pay Now through your own connected Stripe account. You can see which invoices are sent and which are paid, which gives you list one for the month-end check. Card payments then show up in your own Stripe account, where you can see each payout.

QuickBooks and Xero sync is coming soon.

Plans are $19 a month for Starter, $49 for Professional and $99 for Enterprise.

Frequently asked questions

Why is my bank deposit less than my invoice?

Card processing fees are usually taken out before the payout reaches your bank. A refund or dispute can also reduce a later payout.

Why does one deposit cover several invoices?

Card processors such as Stripe can bundle several payments into one payout. Open the payout in your processor to see which payments it includes.

What does it mean to reconcile invoices?

Matching each invoice that shows as paid to the money that actually arrived in your bank, and explaining anything that doesn't match.

How often should a freelancer reconcile?

Once a month works for most. Do it more often if you have a high volume of payments.

Do I need accounting software to do this?

No. A spreadsheet, your processor's payout list and your bank statement are enough for a monthly check. An accountant or bookkeeper is still worth having for taxes and year-end.

Start your 14-day free trial, card required, cancel anytime before it ends. invoicemedley.com

Start your 14-day free trial. Card required, cancel anytime before it ends.

Get started