Quickbooky

Accounting News

Accounting & Reports

Cash versus accrual: the QuickBooks Online setting behind shifting totals

QuickBooks Online reports can show different income totals for the same period. The accounting method setting explains the gap.

COMMUNITY ISSUESQUICKBOOKY

QuickBooks Online keeps two honest sets of numbers inside one file, and that design regularly sends users hunting for a bug that is not there. The culprit is the accounting method setting, which decides whether a sale counts as income when it is invoiced or when it is actually paid. Reports that disagree with each other are usually both correct. They are answering the same question on different terms.

The symptom: totals that refuse to match

The pattern is consistent across community threads. A Profit and Loss shows income the user does not remember collecting. A sales tax summary puts a liability in a month with no deposits. Sometimes the numbers simply change one day, after someone with access flipped a setting during setup. The data is intact in every case. The reporting lens moved.

The reply marked as the solution in these threads does not diagnose an error at all. It explains what each method counts, then points to the two places where the choice is made.

How does each method count the same sale?

Cash basis is patient. Income appears only when a payment lands, and expenses appear only when a bill is actually paid. Send an invoice in March and collect in May, and March stays quiet under cash reporting.

Accrual is less patient. Income counts the moment the invoice goes out, and expenses count the moment a bill arrives, whether or not money has moved. Under accrual, unpaid invoices and unpaid bills are already part of the picture. That single difference explains most of the mismatched totals people report.

A sales tax example shows the gap

Consider a plain illustration. A business invoices a customer for $60 in August, collects $24 that month, and collects the remaining $36 in September. On the cash method, two sales tax payments come due: $24 for August and $36 for September, because deposits landed in both months. On the accrual method, a single $60 liability lands in August, because the invoice date drives the count. Same customer, same sale, two different tax months.

Where does the default method live?

The company-wide choice sits behind the gear icon. Open Settings, select Account and settings, and go to the Advanced tab. In the Accounting section, select the small Edit icon, pick the accounting method, then choose Save and Done. That selection becomes the default every report follows.

New users often meet this setting during initial setup and pick one without much thought. Revisiting it later is normal, and nothing about the change damages the underlying records.

Can a single report use the other method?

A per-report override exists, and it answers the compare-the-two question without touching the company default. Open the Reports area and select a standard report. Under the Accounting method heading, choose Cash or Accrual, then select Run report. The Customize button opens a panel where the same option sits in the General section. This is the cleanest way to view both lenses side by side before committing to a switch.

Does the change rewrite the books?

No. The transactions, customers, payments, and bills stay exactly as recorded. Only the totals move, because reports now count activity on the other side of the invoice. Balances that looked one way yesterday can legitimately look different today. That is why these threads so often begin with suspicion of data loss and end at a settings menu.

One tax rule to keep in mind

A caution appears alongside the steps in the community answers. The IRS generally expects a business to keep the same accounting method from year to year, and its approval comes before a change, not after. Viewing reports both ways for comparison is a bookkeeping exercise. Changing the method used on a filing is a separate matter with its own requirements.

The short version

If two QuickBooks Online reports refuse to agree, the file is probably fine. The product reports the same activity through either a cash or an accrual lens, the default lives under Settings in the Advanced tab, and any single report can borrow the other lens on demand. The disagreement between reports is rarely corruption. It is usually two correct answers to two slightly different questions, and knowing which lens is active settles the matter.

← Back to Community Issues