Your A/R aging is showing customers with negative balances, and some of them are people who paid you weeks ago. Nothing errored. The integration is working. The payment simply arrived in QuickBooks before its invoice did, so it applied to nothing and sat there as a credit.
Accounts receivable is an asset. It is the money customers owe you. A negative balance in an asset account is a credit balance, and in plain terms it means QuickBooks is holding money from a customer that it cannot connect to anything they owe you. It is not a rounding error and it is not cosmetic. It is an unapplied credit, sitting in the wrong place on your balance sheet.
The practical damage shows up fast. Your A/R aging is now unreliable, so you cannot tell who genuinely owes you money. Statements go out to customers who paid you three weeks ago. Whoever runs collections chases people who are square. And your balance sheet understates a liability, because money you are holding without an invoice behind it is closer to a customer deposit than a receivable.
The reassuring part, if there is one, is that the money is real. Negative A/R almost never means cash is missing. It means the cash arrived in your books before the paperwork that explains it. Fixing it is mostly a matter of connecting the two ends back together and then stopping the gap that separated them.
Here is the sequence that creates nearly all of it. Follow the clock, because the timing is the entire story.
That is the whole cause. The card processor runs on its own clock and it does not wait for your office. Your invoicing runs on your clock. Any gap between them turns into unapplied credits, and the size of the problem is a direct function of the size of the gap.
If invoices reach QuickBooks the same day the payments do, a negative balance lasts a few hours and resolves itself. If your office reviews invoices weekly, or exports invoice batches monthly while the processor batches nightly, then every card payment you take spends weeks in QuickBooks with nothing to apply to. Negative A/R stops being an anomaly and becomes the permanent state of your aging report. That is the situation most shops calling us are actually in, and it is why the fix is as much about cadence as it is about cleanup.
This is the part that surprises people. When the invoice does eventually export, QuickBooks does not go back and match the credit to it. The customer now shows an open $2,850 invoice and a $2,850 unapplied credit, netting to zero. Their balance looks fine. The aging report is still wrong, because it shows a receivable that has already been paid. Somebody has to apply the credit to the invoice, deliberately, and if nobody does, it stays broken.
The tempting workaround is to switch on automatic credit application in QuickBooks. Resist it. QuickBooks will apply the credit to the oldest open invoice for that customer, which on a repeat-service customer is frequently a completely different job. Your total A/R comes back to zero and your job-level receivables become fiction, which is a harder problem to unwind than the one you started with.
Trusted by 25+ Contracting Businesses
The timing gap is the big one, but these four produce credits that will never clear on their own, even when your export cadence is perfect.
The payment posts under one customer record and the invoice under another, because a name was entered differently at some point, or a job was set up as a new customer instead of a new job. Now the credit and the invoice sit on separate records and can never meet, no matter how long you wait. This one hides well, because the company-wide A/R total looks close to right while two customer records are equal and opposite.
A customer puts $5,000 down on a $20,000 system replacement three weeks before install. There is no invoice yet, and there should not be. That money is a customer deposit, which is a liability, not a payment against a receivable. Recorded as a payment it drives A/R negative until the install invoice appears, and if the job cancels, it stays negative permanently while a liability you genuinely owe is nowhere on the balance sheet.
A batch fails partway through, someone re-exports it, and payments that already landed post a second time. The duplicate has no invoice to apply to, because the real one already consumed it. That credit is phantom money. It will sit in A/R forever and it will also strand a matching phantom payment in Undeposited Funds, which is why these two problems almost always show up together.
A credit memo issued and never applied. A refund processed on the card but recorded as a standalone bank withdrawal instead of against the original payment. A financing payout from GreenSky or Wisetack that exceeds the invoice it relates to. Each one leaves a credit balance on a customer that no future invoice will ever clear, and each one has to be found and closed out by hand.
Run the A/R Aging Summary and the Customer Balance Detail, then match what you see against this. The shape of the problem tells you what caused it.
| What you see | What it means | What to do |
|---|---|---|
| Many customers with small recent negative balances | The routine timing gap. Card payments are exporting ahead of their invoices, and your export cadence is slower than your processor's batching. | Apply the credits to the invoices as they arrive, then close the cadence gap so it stops. This is a process fix, not a cleanup. |
| A customer with both an open invoice and a matching credit, netting to zero | The invoice caught up, but nobody applied the credit to it. The customer balance looks fine and the aging is still wrong. | Apply the credit to that specific invoice. Do not turn on automatic credit application, or it will apply to the oldest invoice instead of the right one. |
| Two customer records with equal and opposite balances | A duplicate customer. The payment landed on one record and the invoice on the other, so they can never meet. | Merge the records in QuickBooks, then apply the credit. Merges cannot be undone, so confirm they are genuinely the same customer first. |
| A large old negative on a customer with no invoices at all | Usually a deposit taken on an install that was never invoiced, or a duplicate payment from a re-exported batch. | If it is a deposit, reclassify it to a customer deposits liability account. If it is a duplicate, trace it against the bank before you touch it. |
| Negative A/R that grows every month and never comes down | The gap is structural. Invoices are being exported on a slower cycle than payments, so the problem regenerates faster than anyone can clear it. | Stop cleaning and fix the export order and cadence first. See how to sync ServiceTitan to QuickBooks properly. |
Work customer by customer. It is slower than a journal entry and it is the only approach that leaves your bank reconciliation and your cash trail intact.
Run the A/R Aging Summary and sort so the negatives come to the top. Then run the Customer Balance Detail for those customers so you can see the individual transactions, not just the net. Write down the total. You need a number to work against, and you need it before you start, because the first thing an owner asks halfway through a cleanup is whether it is working.
This single question splits the whole population. If the invoice is there, this is an application problem and it is quick. If the invoice is not there, this is an export problem and the credit is a symptom, not the disease. Do not start applying anything until you have sorted every negative into one of those two piles.
Open the customer, find the unapplied payment, and link it to the invoice it actually belongs to. The invoice it belongs to, not the oldest one on the account. On a repeat-service customer with several jobs, applying a credit to the wrong invoice fixes the balance sheet and quietly destroys your job-level receivables, which is a worse problem and a much harder one to see.
The invoice is sitting in an unexported batch, or an export failed and was never retried, or it was voided in ServiceTitan after the payment had already gone out. Each of those is a different fix and each one has consequences beyond this customer, because if an invoice never reached QuickBooks then your revenue is short by that amount too. If exports have been failing, work through the ServiceTitan to QuickBooks export errors before you go any further.
Money taken before there is an invoice is not a receivable and it should not be sitting in A/R. Set up a customer deposits liability account and move those amounts into it. When the install invoice is finally raised, apply the deposit against it. This is the correct accounting and it also makes the balance sheet honest about money you are holding that you have not yet earned.
It is the fastest-looking fix and it is the most destructive one available to you. That payment is tied to a real deposit and a real bank line. Delete it and the negative A/R goes away, your bank reconciliation breaks, and your revenue or cash is now wrong somewhere you will not find for months. If a payment is genuinely a duplicate, trace it against the bank first and confirm the money only arrived once before you remove anything.
When you are done, the A/R aging should contain no negatives older than a few days. Make reviewing it a weekly job, and treat any negative balance as an alarm rather than background noise. A negative that is more than a week old means an invoice never arrived, and that is always worth knowing this week instead of at year end.
Trusted by 25+ Contracting Businesses
Cleaning up negative A/R without closing the timing gap is pure maintenance. Close the gap and the problem mostly stops existing.
Negative A/R is rarely the actual problem. It is the most visible symptom of a payment pipeline that is running ahead of an invoicing pipeline, and the same root cause is almost certainly producing other damage you have not looked at yet. If payments are arriving without invoices, then some of those invoices never arrived at all, which means your revenue is understated. And every one of those payments also landed in Undeposited Funds, where it is probably still sitting. These three problems travel together, and fixing one while ignoring the others is how a cleanup gets undone within a quarter.
So the honest answer, if your aging is full of negatives, is that a spreadsheet of credits to apply is not the deliverable you need. You need the export order and cadence fixed, the stranded invoices found and exported, the Undeposited Funds balance aged and cleared, and the credits applied to the right invoices, in that order. Any of it done out of sequence gets partially undone by the next week of transactions.
What is quick and worth doing regardless: move to daily exports, in the right order, and put someone on a weekly aging review. That alone stops new negatives from forming. The rest is our ServiceTitan and QuickBooks cleanup, and if the connection was never configured properly to begin with, the ServiceTitan and QuickBooks integration page is where to start. The ServiceTitan resource hub has the rest of the cluster.
FinTruction is a bookkeeping and accounting firm in Coppell, Texas, working remotely with HVAC, plumbing, electrical, and roofing companies running ServiceTitan across the United States. We are not a software reseller. We fix the books underneath the software.
We will tell you how many of those credits are simply waiting on an invoice, how many are duplicate customers, how many are deposits sitting in the wrong account, and how many are payments for invoices that never made it into QuickBooks at all. That last number is usually the one that gets people's attention.
The Audit is free, it takes a few days, and you keep the findings whether or not you hire us.
Get a Free AR AuditThe card processor auto-batches on its own schedule, usually nightly, and exports the payment to QuickBooks before the invoice has been reviewed and exported. QuickBooks receives a payment for a customer with no open invoice, so it records a payment on account, which credits Accounts Receivable and pushes that customer negative. The bigger the gap between when payments export and when invoices export, the more chronic it gets.
No. QuickBooks does not retroactively match an existing credit to a new invoice. Once the invoice exports, the customer shows both an open invoice and an unapplied credit that net to zero. Their balance looks correct while your aging report still shows a receivable that has already been paid. Somebody has to apply the credit to the invoice deliberately.
No. QuickBooks will apply the credit to the oldest open invoice for that customer, which on a repeat-service customer is frequently a different job entirely. Your total A/R comes back to zero and your job-level receivables become fiction, which is harder to unwind than the negative balance you started with. Apply credits to the specific invoice they belong to.
Almost never. The cash is real and it is in your bank. What is missing is the invoice that explains it. That said, a large or growing negative A/R balance often means invoices genuinely never reached QuickBooks, which does mean your revenue is understated. So the balance itself is not the loss, but it is frequently pointing at one.
Because you cleared the symptom and left the cause. If your processor batches nightly and your office exports invoices weekly or monthly, every card payment taken in between arrives in QuickBooks with nothing to apply to. The problem regenerates faster than anyone can clear it. Move to daily exports in the correct order, bills then invoices then payments, and it mostly stops forming.
Do not. That payment is tied to a real deposit and a real bank line. Deleting it removes the negative from your aging and breaks your bank reconciliation at the same time, and the resulting error will be far harder to find than the one you were trying to fix. If you believe a payment is a genuine duplicate, trace it against the bank and confirm the money only arrived once before you remove anything.
As a liability, in a customer deposits account, not as a payment against Accounts Receivable. Money collected before an invoice exists is not a receivable, it is money you owe the customer work for. Recorded as a payment it drives A/R negative until the install invoice appears, and if the job cancels it stays negative permanently. Apply the deposit against the invoice once the job is invoiced.
You have the same customer in QuickBooks twice, usually because a name was entered differently or a job was set up as a new customer. The payment landed on one record and the invoice on the other, so the credit and the invoice can never meet. Merge the records, then apply the credit. QuickBooks merges cannot be undone, so confirm they are genuinely the same customer first.
Directly. The same payments that landed in A/R without an invoice also landed in Undeposited Funds, where they are very likely still sitting. Duplicate payments from a re-exported batch produce a phantom credit in A/R and a phantom balance in Undeposited Funds at the same time. These problems travel together, and cleaning up one while ignoring the other is how a cleanup gets undone within a quarter.
Real results from contractors we have helped untangle their books and systems.
They didn’t just record transactions and call it a day. They built a custom chart of accounts around how a remodeling company actually runs, did a full catch-up on years of bookkeeping inside QuickBooks Online, and now stay on top of my monthly bookkeeping and payroll. Every step, they broke it down in simple terms instead of burying me in accountant talk.
FinTruction rebuilt the whole thing from the ground up, with real job costing, work in progress, and retainage. They didn’t just hand me reports and disappear; they walked me through my numbers until I understood them.
Sahil and his team handle the bookkeeping and job costing for my painting business. They cleaned up my books and set up integrations that give me accurate, timely job costing with solid weekly data. Reliable, detailed, and genuinely invested in getting the numbers right.
FinTruction is the only bookkeeping team we’ve found that truly understands construction accounting and WIP reporting. They aligned our income and costs across 21 jobs and gave us full, monthly transparency. Fast, accurate, and an indispensable partner.
When I came to FinTruction I had no financial structure. No job costing, no WIP tracking, books behind. They did a full cleanup and rebuilt job costing and WIP tracking in QuickBooks. Now I know what’s billed, what’s owed, and where every job stands.
A couple of minutes from a contractor we support, sharing what working with FinTruction has been like and what changed once their numbers finally made sense.
We will apply the credits to the right invoices, find the invoices that never made it into QuickBooks, and fix the export cadence so the negatives stop forming. No obligation.
Tell us what is broken between ServiceTitan and your books. We will look at your actual data and show you exactly where the numbers diverge, at no cost.
