A customer paid several invoices in one payment: how to apply it

A Direct, Useful Answer

To apply a lump sum payment, start by matching the payment amount to the sum of outstanding invoices. Check the date the payment was received and compare it to the dates of recent invoices. Look at the payer's name and any reference numbers, even if they don't match exactly. Once you've identified which invoices the payment covers, apply the payment to those invoices in your accounting software. If you're unsure, apply the payment to the oldest invoices first or divide it proportionally.

What Most Owners Try First

Most owners manually go through each invoice and payment, hoping to match them up. This often involves spreadsheets, printed invoices, and a lot of guesswork. While this method might work when business is small, it quickly becomes unmanageable as the number of transactions grows. Errors creep in, and payments can end up being misapplied or missed altogether.

What to Do Instead

If you're doing this manually, start by listing all outstanding invoices and their amounts. When a payment comes in, see if its total matches any combination of invoice amounts. If the payer's name is slightly different, consider any known aliases or trading names. Use the payment date to help confirm the match, and double-check any references provided. Once matched, apply the payment in your system and update each invoice status.

How This Gets Easier With Scheduled Follow-Up

When follow-up is automated and scheduled, you just need to approve actions instead of chasing every payment yourself. Payments are matched against invoices automatically, considering all the factors you would check manually. Confident matches are applied directly, while others are flagged for your review. This means you get to focus on growing your business rather than tracking down payments.

FAQ

What if the payment doesn't match any invoices?

If the payment doesn't match, contact the customer for clarification. They might have intended it for future invoices or made a mistake with the amount.

How do I handle overpayments or underpayments?

For overpayments, apply the extra amount as a credit towards future invoices. For underpayments, note the shortfall and follow up with the customer to settle the remaining balance.

Can QuickBooks handle multiple invoice payments automatically?

Yes, QuickBooks can help match payments to invoices, but you need to approve any automated suggestions to ensure they're correct.

What should I do if the payment reference is unclear?

First, try matching the payment with known invoices using the amount and date. If still unclear, reach out to the customer for more information.

Is there a way to prevent future payment mismatches?

Encourage customers to use invoice numbers as payment references and ensure their account details are up-to-date. Automated systems can also reduce mismatches by learning from past transactions.