Skip to main content

Cash or Accrual? What the Basis filter does to your numbers

The Basis filter in EasyTruckShop reports switches between money you invoiced (Accrual) and money you were paid (Cash). Here is which reports have it, what each default is, and which one to send your accountant.

Written by Vladimir

What the Basis filter does

Several EasyTruckShop reports have a Basis button in the filter row that switches between Cash and Accrual. It is the single biggest reason two people looking at the same report on the same day get two different numbers.

  • Accrual counts money the day you invoiced the job, whether or not the customer has paid.

  • Cash counts money only when the customer's payment arrives.

Neither is wrong. They answer different questions. Accrual answers "what did I sell?". Cash answers "what did I get paid?".

A worked example

Say you finish a $1,000 job on 31 March, invoice it that day, and the customer pays you on 12 April.

Report period

Accrual shows

Cash shows

March

$1,000

$0

April

$0

$1,000

Same job, same money, two different months. That is all the Basis filter is doing.

How big the difference gets in practice

Here are two reports from one shop, one month, switched only by the Basis button:

Report

Accrual

Cash

Fees — total charged

$1,693.91 across 39 fee lines

$722.84 across 16 fee lines

Sales Tax — tax figure

$499.25

$708.89

Notice that the difference does not always go the same direction. Fees were higher on Accrual because many invoices were still unpaid. Sales Tax was higher on Cash because payments received that month included tax on invoices billed in earlier months.

Which reports have a Basis filter, and what each one defaults to

Only three reports have the switch, and their defaults are not the same — which is exactly why it is worth checking the button before you copy a number.

Report

Has a Basis filter?

Opens on

Reports > Sales

Yes

Cash

Reports > Fees

Yes

Accrual

Reports > Sales Tax

Yes

Cash

Reports > Part Revenue

No — its only filters are date, Shop, Customer and Customer Group

—

Reports > Inventory

No — it is a stock value as of a date

—

Reports > Orders

No — counted by order date

—

Reports > Service Types

No

—

Customers > Payments

No — it is payments, so it is cash by definition

—

Customers > Invoices

No — it is invoices, so it is accrual by definition

—

Part Revenue is the one to watch. Because it has no Basis switch and is not labelled either way, its Revenue figure will not tie cleanly to the Sales report's Parts card. Use Part Revenue for margin, and the Sales report for the revenue number you hand your accountant.

How to change the Basis

  1. Open the report you want. Reports is under your profile icon at the top right — your initials in the circle — not in the top menu bar.

  2. Click Basis in the filter row across the top. The current setting is shown in blue next to the word Basis.

  3. Choose Cash or Accrual from the small menu.

  4. The page reloads with the new figures. The setting also carries into the file when you click Export.

The image below shows the Basis menu open on the Sales Tax report: 1 is the menu with Cash and Accrual, with the current choice marked.

The Basis menu open on the EasyTruckShop Sales Tax report showing the Cash and Accrual radio buttons with Cash selected.

Which one should I send my accountant?

Ask them which basis your books are kept on. That is the honest answer, and it takes one message. Most small shops file on cash basis and most larger ones on accrual, but it depends on your size, your country, and choices your accountant made when the books were set up.

Two practical rules that hold either way:

  • Label every figure you send with the basis you used. "August sales, cash basis" is a usable number. "August sales" is not.

  • Never mix. If you send sales on Accrual and sales tax on Cash for the same month, they will not reconcile and someone will spend an afternoon finding out why.

The Sales Tax export helps here — the downloaded file is named with the basis in it, for example Sales Tax Report (Cash).xlsx.

"My number changed and I didn't change anything"

On Cash basis, last month's figure can move after the month has ended. If a customer pays an old invoice today, that payment lands in today's period on a cash-basis report — but it also means a report you ran last week for an earlier period can now show a different number if the payment date fell inside it.

On Accrual, a closed period is much more stable, because the invoice date does not move.

If a number you already sent someone has changed, check the Basis first. It explains most of these.

Accounting words and what they are called in EasyTruckShop

What your accountant says

What EasyTruckShop calls it

Accrual basis / revenue recognition

Basis > Accrual

Cash basis / cash receipts basis

Basis > Cash

Revenue / turnover / sales

The Sales report — set the basis they use

Accounts receivable (A/R)

The gap between the two: invoiced but not yet paid. See the Balance column in Customers > Invoices

Deferred revenue

Not tracked in EasyTruckShop

Period close / cut-off

Set the date range on the report; there is no lock or close in EasyTruckShop

Other ways shops ask this question

  • "Why are my sales different from last time I looked?" — check the Basis button.

  • "Which one is the real number?" — both are real; they answer different questions. Accrual = what you sold. Cash = what you were paid.

  • "My accountant says my sales are wrong" — ask which basis their books use and re-run the report on that setting.

  • "How much am I owed?" — that is the difference between the two, but do not calculate it that way. Use Customers > Invoices and the Balance column instead.

  • "Which reports don't have this setting?" — Part Revenue, Inventory, Orders, Service Types and Payments have no Basis filter.

  • "Why won't Part Revenue match my Sales parts figure?" — because Part Revenue has no Basis switch at all. They are not built to tie out.

What the Basis filter does not do

  • It does not change your books. It only changes how this report counts. Nothing in EasyTruckShop is posted or re-posted when you flip it.

  • It does not exist on every report. Only Sales, Fees and Sales Tax have it. See the table above.

  • It does not remember your choice everywhere. Each report opens on its own default, and Fees opens on Accrual while Sales and Sales Tax open on Cash. Check the button each time.

  • It does not give you a profit and loss statement. EasyTruckShop has no P&L report. For profit you would combine the Part Revenue report's margin with labor revenue from Sales — and EasyTruckShop does not track labor cost at all, so a complete profit figure has to come from your accounting software.

Did this answer your question?