Cash or accrual: QuickBooks Online users puzzled by shifting report totals
QuickBooks Online users see income and sales tax totals move when reports switch between cash and accrual basis; here is what fixes the view.
QuickBooks Online users keep running into the same puzzle: two reports that refuse to agree. Income appears on one statement and not on another, and sales tax liabilities land in different months depending on where the report was run. We have seen the pattern before, and the cause is almost never damaged data. It is the accounting method behind the report, cash or accrual, and the fix is knowing where that choice lives.
The symptoms users run into
The pattern is consistent. A profit and loss figure looks solid one day and different the next, even though no transactions were added. A sales tax summary shows two payments in two months where the user expected one. An invoice everyone remembers sending leaves no trace in income until the money arrives. None of this signals a bug. Each symptom is a faithful rendering of whichever basis the report happened to use.
Cash or accrual?
The accepted answer draws the line at money movement. Cash basis counts income only when a payment lands, and it counts expenses only when a bill is paid. Send an invoice in one month and collect in the next, and the cash view ignores it until the cash arrives. Accrual basis counts income and expenses the moment an invoice or bill exists, paid or not. Money never needs to change hands for a transaction to hit the report.
The sales tax example that clarifies it
The thread includes a worked example worth retelling in plain terms. A business invoices a customer in August, and the invoice carries $60 of sales tax. The customer pays part of the bill in August and the rest in September, which splits the tax into $24 and $36 pieces.
On the cash basis, two payments come due: $24 for August and $36 for September, because payments landed in both months. On the accrual basis, one payment of $60 comes due in August, because the invoice date sits in August. Same customer, same invoice, two different tax calendars.
Which method should you choose?
That depends on when you want income and expenses to register. Businesses that think in terms of bank activity tend to prefer the cash view, since it mirrors the account statement. Those who want reports to reflect every invoice and bill the moment it is issued lean accrual. The software supports both, and you are not locked into one lens. The per-report control described below lets you see either view without committing.
How do you change the method for the whole file?
The company-level setting lives in the account settings area. Open Settings, then Account and settings, and switch to the Advanced tab. In the Accounting section, select the edit icon, choose the accounting method, then save and confirm. One caution from the accepted answer: after the switch, accounts and balances across your reports may display differently. That is expected behavior, not corruption.
Can a single report use the other basis?
Yes, and many users miss this. The per-report control sits inside the reports area itself. Go to Reports, open Standard reports, and select any report. Under the Accounting method header, pick Cash or Accrual, then run the report. The Customize button offers the same choice in its General section. This changes the view for that report only, and the company default stays untouched.
The tax rule to know before switching
One caution belongs here, and it comes from the tax authority rather than the software. The IRS expects a business to keep the same accounting method from year to year, and a permanent change requires the agency’s approval first. Flipping the basis inside QuickBooks Online for a temporary view is one thing. Committing your books to a different method is a step to take only after that approval exists.
The resolution, in short
Users who hit this problem walk away with two takeaways. A mismatch between reports is usually a basis mismatch, not a data error. And the basis can be set once for the company, then set again for any individual report, which makes both views available without changing anything permanent. Run a suspect report on each basis before assuming a number is wrong. Most of the time both numbers are right, and the setting explains the gap.