Credit Notes and Customer Credits: Keeping Them Straight Between Two Systems

A credit note is a document. A customer credit is a balance sitting on an account waiting to be applied. Confusing the 2 produces an aging report showing overdue invoices for a customer who is actually in credit, and it is the most common reconciliation problem between a field system and the books.

The short version

You credit a customer for an invoice that was wrong. That creates a document reversing the charge. What happens next decides whether your books stay legible.

If the credit is applied to the specific invoice, the two cancel and both disappear from the aging report. If it is not, the invoice sits as overdue and the credit sits separately as a balance, and both appear in reports that then describe a situation that does not exist.

The second outcome is the default in most systems. Nothing applies a credit automatically, and nobody notices the difference until somebody chases an invoice that was already credited.

The 3 things being confused

Thing	What it is	What it needs
Credit note	A document reversing all or part of an invoice	To be issued and sent
Credit allocation	The act of applying it to a specific invoice	To be done, deliberately
Customer credit balance	Money owed to the customer, unapplied	To be used or refunded, not left

The middle row is the step that goes missing. Issuing the note feels like the job is done, because the customer has been told and the paperwork exists.

Roopairs syncs credit notes, credit-note journal entries and credit allocations to QuickBooks, which is what keeps the allocation from being a manual step performed in one system and forgotten in the other.

The 4 places credits come from

Each behaves slightly differently, and the last one is the awkward one.

1. A billing correction. Hours or parts were wrong, and the credit relates to a specific invoice. Straightforward, and it should always be allocated
2. A goodwill gesture. Something went wrong and you credited part of the work. Also invoice-specific, and also allocatable
3. An overpayment. The customer paid more than the invoice, deliberately or not, and now holds a balance with no document behind it
4. A deposit or advance. Money received before work, which sits as a credit until there is an invoice to apply it against

The fourth is the one that lingers longest. A deposit taken for an installation in March, applied to nothing, is still sitting there in September while the customer's aging shows overdue invoices from the same project.

Allocate at the moment you issue

One habit, and it removes almost the entire problem.

When a credit note is issued against an invoice, apply it to that invoice in the same action. Not later, not at month end. The person issuing it is the person who knows what it relates to, and they are the only one who will know without investigation.

Where the credit is not invoice-specific, such as an overpayment or a deposit, record what it is for on the record itself. "Deposit, kitchen installation, purchase order 4471" is a credit somebody can use. An unexplained balance is a credit that will sit until an audit.

Then check for unallocated credits monthly. It is a short report in most systems and it is one of the few reconciliation checks that reliably finds money in both directions.

What unallocated credits do to your numbers

Four distortions, and the third causes actual damage.

The aging report overstates what is owed, because credited invoices still appear. Your total receivables figure is wrong by the amount of unapplied credit. Statements sent to customers show invoices they have already been credited for, which invites a query and delays other payments.

And collections activity is aimed at the wrong things. Chasing a customer for an invoice you credited two months ago is a call that damages the relationship and costs you the credibility of the next chase.

That third one is worth taking seriously. A customer who receives an incorrect statement stops trusting the ones that follow, and slow payment frequently starts with a document that was wrong.

When two systems both hold credits

The specific failure mode of a field system plus an accounting system.

A credit issued in the field system syncs to the books as a document. If somebody then allocates it in the books, does the field system know? If somebody allocates it in the field system, does the ledger reflect it?

Where the answer to either is no, the two systems will disagree about what a customer owes, and both will be internally consistent, which makes the discrepancy hard to find.

Two questions to settle: which system is where credits are issued, and which system is where they are allocated. The answer should be the same system for both, and the other one receives the result.

Then reconcile customer balances between the two periodically. Not every invoice, just the balances, and any customer where they differ is a specific thing to look at.

Clearing an accumulated pile

Most service companies looking at this for the first time find several years of unapplied credits.

Work by value and by age. Large credits and old credits, in that order, and leave the small recent ones to be handled by the new habit rather than by a project.

For each one: find what it relates to, allocate it if there is an open invoice, and if there is nothing to apply it to, decide explicitly whether it is refunded or written off. Leaving it is the option that produced the pile.

Do that with whoever maintains your books, because refunds and write-offs have accounting consequences and old credits can relate to closed periods.

Roopairs runs a product tour where you can see invoices, credit notes and their allocations reaching QuickBooks.

What service companies in the trade say

“The customer service with Roopairs is bar none. I've never made a request that wasn't addressed. Friendly service, they remember my name. I am very, very picky about customer service and I have to say that Roopairs has never dropped the ball.” — ProTemp Solutions (NC)

Also worth reading

• Technician Notes Worth Reading Next Time
• Returns, Cores and Restocking Fees in Service
• The future of IoT for commercial kitchen repair companies

Frequently asked questions

What is the difference between a credit note and a customer credit?

A credit note is a document reversing all or part of an invoice. A customer credit is an unapplied balance sitting on the account. The step between them is allocation, which has to be done deliberately and is where the process usually breaks.

When should a credit be allocated?

At the moment it is issued, by the person issuing it, because they are the only one who knows what it relates to without investigating. Doing it at month end means somebody reconstructing intent from a document.

What do unallocated credits do to your reports?

The aging report overstates what is owed, total receivables are wrong, customer statements show invoices already credited, and collections chase the wrong things. The statements are the damaging part, since a customer who gets one wrong document distrusts the next.

Where do credits come from besides corrections?

Goodwill gestures, overpayments, and deposits or advances. Deposits linger longest, because money taken in March for an installation can still be sitting unapplied in September alongside overdue invoices from the same project.

What goes wrong between two systems?

A credit issued in one and allocated in the other leaves the two disagreeing about what a customer owes, with each internally consistent. Decide which system issues credits and which allocates them, and make it the same system for both.

How do you clear an accumulated pile of credits?

By value and age, largest and oldest first, leaving small recent ones to the new habit. For each, allocate against an open invoice or decide explicitly between refund and write-off. Do it with whoever maintains your books, since old credits touch closed periods.