Accountants · problem and fix
Sales tax liability report does not match the payment? Fixes for Mac accountants
Your sales tax liability report does not match the payment window when the amount on the report differs from the return or the payment you sent. The cause is usually a process gap, not a conflicting deadline, because the states checked here set one due date for both the return and the payment. This page covers what the gap costs, why it happens, and how to close it on a Mac without buying anything.
The short answer
- Filing and payment usually share one due date, so the mismatch comes from your process, not the calendar.
- The usual culprits are journal entries posted after filing, payments dated wrong, and sales edited after the return.
- Compare the liability report, the return and the payment for the same period before you pay.
- Lazur can explain the figures and walk you through the checks, but it does not click buttons or edit your books.
What sales tax report and payment mismatch costs you
Penalties on a short payment
In Alabama, a late payment carries a failure to pay penalty of 10% of the delinquent tax, separate from the failure to file penalty. A return filed on time can still leave a short payment with a penalty attached. Penalties are the cost you can measure most easily, so start there when you size the problem.
A timely discount you can lose
Texas gives a timely filing discount of 0.5% of tax reported and paid on time, and prepaying taxpayers can claim an extra 1.25%. A payment that misses the window or does not match the reported amount can cost that discount. Check the state's own page before each filing, because discount rules can change.
Hours spent hunting the gap
A gap is rarely hard to fix once you find it. Finding it takes the time. The vendor benchmark of 25 to 30 hours a month is one estimate, but its sample and year are not stated. Your own hours matter more, so time one reconciliation and multiply by how often you do it.
Stress and errors near the deadline
A 2026 survey of 438 US tax professionals found that 70% admitted errors or near-misses in the final 48 hours of tax season. The survey covered tax work generally, not sales tax alone. A mismatch found on deadline day is the one that gets rushed and mistyped.
Client trust
When a client asks why the report and the payment differ, a vague answer costs more than the gap itself. A written reconciliation with dates and a cause answers the question on one page. Without one, every difference looks like an error, even when it is not.
Why it happens
Journal entries posted after filing
A journal entry posted to the sales tax payable account after the return is filed changes the balance on the report. QuickBooks Online warns about this exact pattern when a return shows an unexpected balance due. The report then shows a different figure than the one you filed. Nothing in the state calendar moved. Your books did.
Due date treated as the payment date
Many people enter the due date as the payment date, or enter the day they sent the money. The payment date should match the agency's confirmation. A payment dated the wrong day can land in the wrong month, so the period looks open or the amount sits in the wrong place.
Sales edited after the return
A customer invoice or refund changes after the return was prepared. The report reflects today's version of each sale. The return reflects the version you filed. Two versions of the same sale produce two totals, and the gap can look small enough to ignore.
Partial or split payments
You pay part of the balance, or split one payment across two periods. The payment column then covers less than the liability. The two figures never agree on paper. This is correct behavior, but it looks like an error until you write the remaining balance down.
Hand typed return figures
Someone types the return figures from the report and drops a digit or copies the wrong line. The return and the report then differ by a small amount, which is easy to skip. Copy figures from the report whenever you can, and check the total against it before you file.
Several states combined into one total
Each state has its own return, due dates and rules. GAO described a complex patchwork of requirements across states. When you combine states in one total, a difference in one state hides inside the other. Keep each state on its own line.
Zero activity periods skipped
A period with no sales can get skipped. Alabama requires a return even with no activity, so a skipped period leaves a hole in the trail. Log every state and period, including the zero ones, so the sequence stays complete.
How to fix it
These work with or without any app.
Reconcile before you pay
Run the sales tax liability report for the exact period on the return. Compare it with the return you filed and the payment you recorded. Do not pay until every gap has a written cause. If the numbers match on the first pass, that is a good sign, not a reason to skip the check.
Build one reconciliation tab
Create a tab in Excel with one row per state and period. Add columns for the report, the return, the payment and two gap columns. Use formulas like =B2-C2 so each gap updates on its own. Keep the tab with the period's PDFs so the trail stays in one place.
Trace the payable account
Open the sales tax payable account for the agency in QuickBooks Online and list every entry dated after the filing date. Match each entry to a line on the return, or write down why it is there. An entry you cannot explain is the first thing to ask about.
Correct with a new entry, not a delete
Deleting an entry hides the history that explains the gap. Post a correcting entry instead, and write a memo that names the period and the reason. Your firm's rules on changing client records apply, so check them first.
Record the payment on the agency date
Use the date and amount shown in the agency's confirmation, not the date you clicked send. Record the payment with Record payment in QuickBooks Online, then match it to the bank line. A payment that matches the bank but not the return is a partial payment, so note the balance.
Save a PDF of each report at filing
Before you file, save the liability report as a PDF. In Chrome, choose File > Print, then pick Save as PDF from the Destination menu. A dated PDF shows what the report said on filing day, even after the live balance changes.
A mismatch shows up in one of three places. The liability report shows one amount, the return you filed shows another, and the payment you recorded shows a third. Each number can be right on its own. They just do not describe the same period, the same tax, or the same moment. Finding the gap is mostly matching work, and you can do it in Excel or Numbers with the files you already have.
What a sales tax report and payment mismatch costs you
The first cost is time. A 2026 survey of 438 US accountants and tax professionals found that 70% admitted errors or near-misses in the final 48 hours of tax season. That figure covers tax work in general, not sales tax alone, and the survey sponsor is not named. Treat it as a warning sign, not a rate for your own reports. Vendor numbers are weaker still. Anrok, a sales tax automation vendor, cites 25 to 30 hours a month of manual sales tax work, but its sample size and year are not stated.
The second cost is penalties. In Alabama, a late return carries a failure to file penalty of the greater of 10% of the tax due or $50. A late payment carries a separate failure to pay penalty of 10% of the delinquent tax. A return filed on time can still come with a short payment and a penalty. Check the payment on its own, not only the return.
The third cost is a lost discount. Texas gives a timely filing discount of 0.5% of tax reported and paid on time. Prepaying taxpayers can claim an extra 1.25%. If the payment misses the window, or the amount drifts from the return, that money can disappear. Confirm the current rules on the state's own site, because discounts and deadlines can change.
70%
of 438 surveyed US tax professionals admitted errors or near-misses in the final 48 hours of tax season (2026 survey)
Analytix: Tax Season Burnout$30 billion
estimated 2021 nationwide remote sales tax collections, per GAO, which found businesses face substantial compliance costs
GAO-23-105359: Remote Sales Tax (federal legislation could resolve some uncertainties)25 to 30 hours
a month on manual sales tax work, per an Anrok vendor benchmark that is not independently verified
Stacker: The $400K compliance cost (Anrok benchmark)
Why the liability report and the payment drift apart
One pattern is named in QuickBooks Online's own help. If a return shows an unexpected balance due, check for journal entries posted to the sales tax payable account for that agency. Those entries can change the balance so it no longer matches the Sales Tax Liability report. Nothing in the state calendar moved. Your books did.
Other patterns are ordinary bookkeeping. A sale gets edited after the return is prepared. A refund posts in the wrong month. A payment gets dated on the day you sent it, while the agency may record a different day. Each change moves one number. Nobody notices until someone lines the three documents up.
- A journal entry hits the sales tax payable account after you filed.
- A sale or refund is edited after the return was prepared.
- A payment is dated when you sent it, not when the agency shows it.
- A return figure was typed by hand and one line was copied wrong.
- A zero activity period gets skipped, even though Alabama requires a return with no activity.
A worked example: tracing a gap in one period
Say your liability report for March shows a balance higher than the return. The return shows a smaller figure, and the payment matches the return. That pattern usually means something changed after filing. The report pulls the balance as it stands today. The return holds the figures you saved on filing day.
The order of checks matters. Start with the date range, because a range that is one day off can create a gap that looks like a real error. Then move to the entries, and only then to the sales themselves.
- Open the report for the same start and end dates as the return, not the calendar month.
- Filter transactions for the sales tax payable account to the period, then sort by date.
- Compare each entry with the return line it should affect.
- If one entry explains the gap, write it down with its date and memo.
- If no entry explains it, check edited sales and payments dated in another month.
Sales tax due dates by state: return and payment windows
The return and the payment usually share one deadline, but the details differ by state. The table lists the three states this page checked. Use each state's own calendar, and check it again each quarter, because weekend and holiday rules move due dates.
| State | Return and payment due | Electronic or timing rule | Penalty or discount to know |
|---|---|---|---|
| Georgia | 20th of the month after the period | Owing more than $500 on any return means filing and paying electronically | The page checked gives no separate early payment deadline |
| Texas | 20th, with quarterly filers due Jan 20, Apr 20, Jul 20 and Oct 20 | A weekend or legal holiday moves the due date to the next working day | 0.5% timely filing discount, plus an extra 1.25% for prepaying |
| Alabama | On or before the 20th of the month after the month tax accrued | Electronic payment information must be sent by 4 p.m. Central on or before the due date | 10% failure to pay penalty, plus a failure to file penalty of the greater of 10% or $50 |
Two details trip people up. In Texas, a due date that lands on a weekend or legal holiday moves to the next working day. Texas TEXNET payments over $1,000,000 must be initiated by 8 p.m. CT on the banking business day before the due date. A large payment on a deadline day is exactly where a mismatch starts, so schedule it early.
Build a one page reconciliation in Excel for Mac
A single tab is enough. Open Excel for Mac, start a new workbook, and name the first tab Reconciliation. Use one row per state and period. Add these headers in row 1: Period, Liability report, Return filed, Payment, Report gap, and Payment gap. In row 2, type =B2-C2 in the Report gap column and =D2-C2 in the Payment gap column, then drag both down.
Keep payments on a second tab so you do not type them twice. If that tab lists the period label in column A and the amount in column C, the Payment cell in row 2 can use =SUMIFS(Payments!C:C,Payments!A:A,A2). That formula adds every payment with the same label. Test it on one period first, then copy it down.
- Type the period label the same way on both tabs, such as Mar GA, so the formula can match.
- Turn on filters with Data > Filter so you can sort by any gap.
- Sort the gap column from largest to smallest before you start the review.
- Save the workbook with File > Save As, then keep a PDF of each report beside it.
- Leave the payment cell blank until the agency confirmation arrives, so blank means not paid yet.
Trace journal entries that change the payable balance
Journal entries are the hardest part, because they hide inside normal bookkeeping. Start with the account, not the report. Open the sales tax payable account for the agency in QuickBooks Online and list every transaction dated after the filing date. Compare each one with the return line it should affect.
Do not delete an entry to make the numbers match. Deleting hides what happened. If an entry is wrong, post a correcting entry and write a memo that names the period and the reason. If you are unsure, take it to the person who owns the client's books. Your employer's rules for client data and record changes apply here too.
Record the payment so it lines up with the return
In QuickBooks Online, the flow runs in a set order. Review the return under All apps > Sales Tax > Overview > Review sales tax. The return is filed with the agency, either through Intuit's electronic filing service in some states or on the agency's own site. Then record the payment using Record payment. Enter the date the agency shows for the payment, not the date you clicked send.
Watch partial payments. If you pay less than the return shows, the report will not match the payment, and that is correct. Record the amount actually paid, then note the remaining balance in the Payment gap column. A partial payment is a record of what happened, not an error to hide.
Mistakes that keep the mismatch alive
- Filing before the reconciliation is done, then fixing the books afterward.
- Typing return figures by hand instead of copying them from the report.
- Editing old invoices or refunds after the return is filed.
- Recording the payment on the day you sent it, not the day the agency shows.
- Logging a partial payment as a full payment, so the gap disappears on paper.
- Keeping the reconciliation in your head instead of in a saved file.
The most expensive mistake is the quiet one. A gap nobody writes down looks fine until a notice or an audit arrives. Write one line for every gap, even a small one. The line proves you checked, and it saves the next person an afternoon of guessing.
Where Lazur helps, and where it does not
Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ to ask about anything on screen, and it answers out loud. Ask where the Sales Tax Liability report is, and Lazur draws a circle and a label around it. Ask how to record a payment, and Lazur guides you one click at a time, waiting for each click.
Lazur does not click buttons, edit files or operate other apps for you. It cannot file the return or post the payment. It can explain a journal entry you are looking at, read a gap out loud, draft a note to a client, and type text where your cursor sits when you hold fn to dictate. Dictation is unlimited on both plans.
Lazur's research feature runs in its own Chrome tabs and comes back with a summary and a report. Use it to gather the due date pages for each state you file in, then open each official page yourself before you trust it. For more Excel steps, see Excel for accountants on Mac.
Follow your employer's rules on client data before you point Lazur at a client file. Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer and are not stored. Content is never used to train AI models. If your firm has stricter rules, those win. The Pro plan starts with a three-day trial and no credit card, and the trial starts when you first open the app. Details are on the pricing page.
Multistate filers and edge cases
Multistate filers have more chances for drift. GAO found that businesses face substantial compliance costs, and that state thresholds and rules differ, which creates a complex patchwork of requirements. Reconcile each state on its own tab. Do not net one state against another, even when the totals look close.
When you cannot find the cause, stop digging and contact the state agency or the client's tax advisor. Write down the period, both amounts, and what you ruled out. A short note with those facts helps far more than a guess. If a filed return needs correcting, ask the agency how to amend it before you change anything.
Faster with Lazur
Where Lazur helps with sales tax report and payment mismatch
Hold ⌥ ⌘ and say what you want. Lazur sees your Excel window. Lazur guides you one click at a time and waits for each click.
- 1
Hold ⌥⌘ and talk
- 2
Lazur guides you one click at a time and waits for each click.
- 3
You stay in Excel. Nothing to copy into a chat window.
More things to say in Excel
- “Lazur, what does this payable entry actually mean?”
- “Lazur, where is the Sales Tax Liability report?”
- “Lazur, walk me through recording this payment.”
- “Hold fn and dictate the variance note into the cell.”
- “Lazur, draft a short note to my client about this gap.”
- “Lazur, gather the due date pages for these three states.”
Free for 3 days, then $18/month. Download for Mac
You say“Lazur, which cell should I check next?”
Lazur · walks you through itLazur points at the gap that is not zero, says which number to trace next, and waits while you check it.
What accountants say to Lazur for this
Each one is a single hold of ⌥ ⌘.
“Lazur, what does this payable entry actually mean?”
Lazur looks at the screen and explains the entry out loud, so you keep your place in the report.
Explains what's on screen
“Lazur, where is the Sales Tax Liability report?”
Lazur draws a circle and a label around the item in QuickBooks Online, so you find it faster in Chrome.
Points at it
“Lazur, walk me through recording this payment.”
Lazur guides you one click at a time and waits for each click. You do the clicking.
Walks you through it
“Hold fn and dictate the variance note into the cell.”
Dictation types clean text at the cursor in any app, including an Excel cell. It is unlimited on both plans.
Types what you say
“Lazur, draft a short note to my client about this gap.”
Lazur drafts the text and types it where your cursor sits. You check every figure before anything goes out.
Drafts it
“Lazur, gather the due date pages for these three states.”
Research runs in Lazur's own Chrome tabs and returns a summary and report. You still open each official page yourself.
Researches in the background
A plan you can start this week
- Day 1
Pull the three numbers
Run the sales tax liability report for the exact period on the return. Open the return draft and the payment record. Save the report as a PDF in the period folder before anything changes.
- Day 2
Trace the payable account
Open the sales tax payable account for each state. List every entry dated after the filing date. Write one line per entry in the reconciliation tab with its date, memo and amount.
- Day 3
Confirm each due date
Open each state's own due date page. Compare it with your reminder in Outlook or Calendar. Fix any reminder that came from a tracker site rather than the agency.
- Day 4
Record the payment
Enter the payment on the date the agency shows. Attach the confirmation to the period. Note any partial balance in the Payment gap column, not in the total.
- Day 5
Write the variance note
If a gap remains, write what it is and why. Draft the note with Lazur if that helps, then check every figure yourself before it goes to a client.
- Next period
Repeat before the deadline
Run the same steps before the next due date. Keep the reconciliation tab, the PDFs and the note in one folder per period, so the trail survives the next review.
Questions people ask
Why does my sales tax liability report not match the return?
Usually the report pulls today's balance, while the return holds the figures you filed. A journal entry, an edited sale or a late payment can change the report after filing. Compare both for the same period and look at entries posted after the filing date.
Should the return and the payment have the same due date?
In Georgia, Texas and Alabama, the return and the payment share one 20th-of-month due date. Rules differ on weekends, electronic filing and discounts. Check the state's own calendar each time, since rules can change.
Can I change the payable balance so the numbers match?
Avoid it. Deleting or editing history hides the cause. Post a correcting entry with a memo that names the period and reason. If the filed numbers were wrong, ask the agency how to amend the return.
Can I fix this without buying software?
Yes. A reconciliation tab in Excel, a PDF of each report and a dated payment record cover most cases. Sales tax automation tools exist, but the vendor figures we found are not independently verified, so test any tool before you trust it.
Does Lazur file the return or record the payment for me?
No. Lazur does not click buttons, edit files or operate other apps for you. It explains what it sees, points at controls, guides you one click at a time, and drafts or dictates text.
Can I paste client sales tax data into Lazur?
Follow your employer's rules on client data first. Lazur listens and looks only while you hold the shortcut. Audio and the screenshot are sent to AI providers to answer and are not stored, and content is never used to train AI models.
Sources
- Georgia Department of Revenue: File & Pay sales and use tax · Georgia Department of Revenue · checked 2026-11-09
- Texas Comptroller: Sales Tax · Texas Comptroller of Public Accounts · checked 2026-11-09
- Alabama Department of Revenue: Due date calendar for sales and use tax · Alabama Department of Revenue · checked 2026-11-09
- Intuit QuickBooks Help: File your sales tax return and record sales tax payments in QuickBooks Online · Intuit · checked 2026-11-09
- Analytix: Tax Season Burnout · Analytix · checked 2026-11-09
- GAO-23-105359: Remote Sales Tax (federal legislation could resolve some uncertainties) · U.S. Government Accountability Office · checked 2026-11-09
- Stacker: The $400K compliance cost (Anrok benchmark) · Stacker · checked 2026-11-09
Fix sales tax report and payment mismatch with Lazur, free for 3 days
Hold a key and ask. Lazur sees your screen, points at the button and talks you through it, in any Mac app. No credit card.