Yes. An AI agent connected to QuickBooks can compare the sales tax you collected with what each state actually took from your bank, explain every difference, and draft the adjusting entry that clears it, but a person still has to approve that entry and own the books. Reconciling Daily Grace's 45 monthly sales tax reports used to take me about 2 hours every month, and an elf I built (an elf is an AI agent that does one back-office job) now does it in about 2 minutes.
Two hours a month doesn't sound like much. It's 24 hours a year of matching numbers. And the cost of skipping it is worse than the two hours: a sales tax payable account that never quite reaches zero, and nobody who can tell you whether the leftover balance is a discount you earned or a penalty you paid.
What Does Reconciling a Sales Tax Payment Actually Mean?
Reconciling a sales tax payment means proving that, for each state and each filing period, the sales tax you collected from customers, minus what you paid the state, equals zero once you account for every known difference.
Start with the account. Sales tax payable is the liability account that holds sales tax you collected from customers and still owe the state. Every taxable order adds to it. Every payment to a state takes away from it. If those two were always equal, there would be nothing to reconcile.
They're almost never equal. The state might let you keep a small discount for filing on time. It might charge a penalty. A return can round differently than your orders did. So each month you have three numbers per state: what your books say you collected, what the return said you owed, and what actually left your bank. Reconciling is lining those three up and booking an entry for whatever's left.
If Your Filing Service Files and Pays, Why Do You Still Reconcile?
Because the filing service's job ends at the return and the payment. The reconciliation, and the adjusting entry once a month, are still yours.
At Daily Grace we use a company like Numeral or TaxJar to do the actual filings. Both file returns and send the money. Numeral's Shopify app listing promises: "Automate all filings and remittance." TaxJar's AutoFile help article says TaxJar will "prepare and submit returns to the state, along with payments," and it's clear about where the money comes from: "the state will debit your bank account for the tax payment due." You get an email showing the amount paid, and the filed return sits in your filing history.
That's a real service. But look at what you end up with: a bank debit from a state, an email, and a PDF. None of that is a journal entry. Your bank feed will post the debit somewhere, usually against sales tax payable, and whatever didn't match stays behind in the account.
If you count on Shopify itself, read the fine print first. Its US taxes overview says "Shopify doesn't remit sales tax for you, unless your US sales tax is managed by Shopify or your store is already enrolled in automated filing with Shopify Tax." Even when someone else remits, the books are still yours to close.
Where Do the Differences Come From?
Most of what's left in sales tax payable after the payments post comes from a short list:
- Timely filing discounts. Some states let you keep part of the tax you collected if you file and pay on time. TaxJar's guide to state sales tax discounts puts it this way: "certain states will actually let you keep some of the sales tax you've collected if you pay early or on time". Texas, for example, allows a 0.5 percent timely filing discount, plus a separate 1.25 percent discount for prepaying a reasonable estimate, per the Texas Comptroller's sales tax FAQ as it reads in November 2026.
- Penalties and interest. If the state charges you, the payment is bigger than the tax.
- Rounding. Small differences between the return's math and your orders' math.
- Prior credits and prepayments. A credit from an earlier period, or a prepayment, applied against this one.
Notice what isn't on the list: the filing service's own fee. That's a bill from a software vendor, an expense like any other subscription. It never touches sales tax payable.
QuickBooks recognizes the same kinds of differences. When you record a sales tax payment in QuickBooks Online, its manage sales tax payments page says the Make Adjustment option is for "credits, discounts, fines, interest, penalties, and corrections for rounding adjustments." Its guidance on where they go is plain: never the sales tax payable account itself. A credit or discount goes to an income account, "such as Other Income." A fine, penalty, or interest goes to an expense account. Rounding goes to income or expense depending on which way it fell.
A Worked Example: One Month, Three States
Here's an example with made-up numbers. A Shopify brand files in three states for October. Its filing service filed all three returns, and its bank feed posted each state's debit against sales tax payable.
| State | Tax collected (books) | Tax on the return | What the state took | Left in sales tax payable | Why |
|---|---|---|---|---|---|
| State A | $4,800.00 | $4,800.00 | $4,776.00 | $24.00 credit | 0.5% timely filing discount |
| State B | $1,250.00 | $1,250.12 | $1,250.12 | $0.12 debit | Rounding |
| State C | $932.50 | $932.50 | $957.50 | $25.00 debit | $25.00 late payment penalty |
| Total | $6,982.50 | $6,982.62 | $6,983.62 | $1.12 debit |
State A first. The return showed $4,800.00 of tax, and the state allows 0.5 percent for filing on time, so the discount is $4,800.00 times 0.005, which is $24.00. The state took $4,776.00. That leaves $24.00 of credit in sales tax payable that you don't owe anybody. You earned it.
State C is the one that hurts. The return was right and on time, but the bank account was short on the day the state tried to debit it, so the debit failed. TaxJar's help article covers this case: if the funds aren't there, "you will receive a nonpayment notice from the state." In this example the brand paid the tax plus a $25.00 penalty after the notice came, $957.50 in all, and that payment gets matched back to the October return.
Net, sales tax payable for October sits at a $1.12 debit balance, which looks like nothing. That's the trap. A $24.00 credit and $25.12 of debits are hiding inside $1.12, and if you write off the $1.12 as "rounding," you've buried a penalty in the wrong account and missed income you earned.
The adjusting entry that clears it:
| Account | Debit | Credit |
|---|---|---|
| Penalties expense | $25.00 | |
| Sales tax rounding expense | $0.12 | |
| Sales tax payable | $1.12 | |
| Other income: sales tax discounts | $24.00 | |
| Total | $25.12 | $25.12 |
After this entry, sales tax payable for October is zero, the penalty sits where you can see it (and ask why it happened), and the discount is recorded as income.
Three states is easy. Do it for every return you file, every month, and you get to 45 reports, which is where Daily Grace is.
How Would an AI Agent Reconcile Your Sales Tax?
An AI agent reconciles sales tax the same way a careful bookkeeper does, one state and one period at a time, except it doesn't get tired at report number 38. Here's the job, step by step, so you can do it by hand tomorrow or hand it to an agent:
- Pull what you collected. For each state and period, the sales tax you collected, from your sales tax payable account or your sales tax report. Use the same date range and the same basis (cash or accrual) everywhere.
- Pull what was filed. The tax due on each return, from your filing service's filing history or the filed return itself.
- Pull what was paid. Each state's debit from your bank feed, matched to its return.
- Compare the three. Collected against filed, filed against paid. Any state where all three match is done.
- Explain every difference. Discount, penalty, interest, rounding, credit, or prepayment. A difference that fits none of those gets flagged, not forced.
- Draft the adjusting entry. Discounts and credits to income. Penalties, interest, and rounding to expense. Nothing booked to sales tax payable except the offset that clears it.
- Send it to a person. The entry, the support, and the list of anything it couldn't explain.
Steps 1 through 6 are exactly the kind of work AI is good at: lots of rows, a fixed set of rules, and a clear test of being done. Step 7 is the one that stays human.
That's the kind of job my elf does on Daily Grace's 45 monthly reports, in about 2 minutes instead of about 2 hours. It's also one of the jobs Eleven Elves is built to do on its own, right inside the books, with nothing to export first (it isn't open yet).
What Does QuickBooks' Own Sales Tax AI Do?
QuickBooks Online has its own Sales Tax AI, and it does something different: it checks your sales before you file, not your payment after.
Intuit's Sales Tax AI help page says it "helps automate your sales tax workflow by tracking tax rules and identifying potential issues before you file." It suggests sales tax categories for your products, which you confirm or deny, and it runs a pre-file check for "differences between your Profit and loss report and your Sales tax liability report." Intuit's page on the pre-file check says it runs automatically on QuickBooks Online Plus, Advanced, and Intuit Enterprise Suite, and the manual steps work on every plan.
That's useful, and Intuit deserves credit for putting it inside the product. It catches the case where your income and your taxable sales don't agree, which is a real problem. One detail from that page is worth knowing on its own: if service or processing fees show up on a sales transaction, "they can reduce your total sales for sales tax purposes," so Intuit tells you to record those fees on an expense transaction instead.
But comparing your sales to your liability report is a different job from proving that what each state took matches what you owed. The first happens before the return. The second happens after the money moves, and that's where the discounts, penalties, and leftover balances live.
Where Does AI Still Need You?
AI still needs a person to approve the entry, to deal with the state, and to own the books.
Approving the entry is the obvious one. An agent can classify a $25.00 difference as a penalty. You're the one who decides it's right and posts it.
Dealing with the state is the second. A nonpayment notice, a request for information, or an amended return goes to a human. The agent can spot a failed debit or a payment that doesn't match its return. It can't call the state.
The third is judgment about the unusual. If State B's difference is a few cents, that's rounding. If it jumps to $412.00, or if the return comes in higher than what you collected by the same amount month after month, that's not rounding, and the right move is to stop and find out why, not to book it. A good agent flags it. You decide.
Here's my position, and the trade-off that comes with it. Let the agent do the matching and draft the entry, and keep a person on the approval. That costs a few minutes of review every month that full automation would skip. It's worth it, because a wrong entry in sales tax payable can sit there for months before anybody notices, and by then it's a much longer afternoon.
That's how the elves are built, too: to draft the entry above and hand it to you to approve, with the support attached.
What Do GAAP and the IRS Say About Sales Tax You Collect?
Under US GAAP, sales tax you collect from a customer is generally a liability you owe the government, not revenue. The revenue standard, ASC 606, lets a company make an accounting policy election to exclude sales taxes collected from customers from the transaction price. In the words of ASC 606-10-32-2A, as quoted in PwC's revenue guide, that covers taxes "imposed on and concurrent with a specific revenue-producing transaction and collected by the entity from a customer." Taxes assessed on a company's total gross receipts are outside that election, and PwC notes that companies without the election evaluate each tax on its own.
The federal tax return mostly follows the same idea, with one difference worth knowing. IRS Publication 334 (2025) says that state and local sales taxes "imposed on the buyer, which you were required to collect and pay over to state or local governments, are not income," and that you don't deduct them either. But if a state's sales tax is imposed on you as the seller and you collect it from the buyer, Publication 334 says "you must include the amount collected in gross receipts." Which one you have depends on how each state writes its tax. Ask your CPA which applies to you.
If you're still sorting out what is and isn't revenue in the first place, start with Is a Shopify Payout the Same as Revenue? And if you want more on running the business behind the books, sign up for our strategy newsletter.
JJ
This article is general information, not tax or accounting advice. Check with your accountant about how it applies to your business.