Why Sales, Stock And Accounting Reports Do Not Match
Your sales, stock, and accounting reports may all be right.
They may still show different numbers.
This is why a sales report can be different from an accounting report even when both reports are useful.
Most times, the split comes from three things.
They count different documents.
They use different dates.
They use different formulas.
Do not start by asking which team is wrong.
Start by asking what each number is meant to answer.
One Order Can Show Three Numbers
A customer orders 100 units.
Sales sees 100 units of demand.
The warehouse has 80 units ready today.
So the team picks and sends 80 units.
Accounts sends the invoice later.
That may happen after the delivery document is checked.
So the reports can say:
- sales: 100 units ordered
- warehouse: 80 units delivered
- accounts: no invoice posted yet
No one may be wrong.
They are just looking at different steps.
But the owner sees three different numbers.
Why The AutoCount Flow Can Split
In an AutoCount-style flow, each document has its own job.
| Document | What it often means | Why reports may split |
|---|---|---|
| Sales Order | customer order or demand | it may not reduce stock or post to accounts yet |
| Delivery Order | goods sent or stock movement | it may reduce stock before an invoice is posted |
| Invoice | billing and accounts record | it may come after delivery, or it may be made direct |
This is only a simple example.
Some companies invoice direct.
Some move from Sales Order to Delivery Order to Invoice.
Some combine many deliveries into one bill.
So do not only ask:
Which report is right?
Ask:
Which document is this report counting?
The Formula Can Also Change The Number
Even with the same date, the number can still change.
Sales may show gross sales.
Accounts may show net sales.
One report may include SST or tax.
Another may remove it.
One report may include cancelled orders, changed orders, samples, delivery fees, or free items.
Another may remove credit notes and returns.
So two reports can both say "sales".
But they may not mean the same thing.
Before you compare them, define:
- gross sales or net sales
- order date, delivery date, or invoice date
- before or after credit notes
- with or without tax
- with or without delivery fees
- Sales Order, Delivery Order, or Invoice
Cut-Off Dates Create Quiet Gaps
Dates matter.
Sales may use order date.
Warehouse may use picking date or delivery date.
Accounts may use invoice date, posting date, or month-end close.
So "May sales" can mean different things.
If the problem is late reports, read why month-end reports are too late for owners.
That is a late-report problem.
Here, the problem is different.
The reports are ready.
But the numbers do not match.
Where The Numbers Often Split
The split often happens when work moves from one team to another.
Common cases:
- goods delivered but not billed
- goods billed but not delivered
- part delivery or backorder
- return or credit note after the month closes
- carton and piece count do not match
- stock moving between branches
- cancelled or changed sales orders
- stock adjustment after delivery
Purchase flow can also affect stock value and margin.
For example, PO to GRN to Purchase Invoice can affect stock cost, received quantity, and accounts value.
It may not change the sales count.
But it can change margin and stock-value reports.
If the stock count keeps changing in ways accounts cannot explain, read why stock goes missing even when accounting looks correct.
Why Excel Makes The Split Harder To Trace
Excel is not always the cause.
But it can hide the trail.
One team exports AutoCount data.
Another team copies warehouse updates into a sheet.
Sales adds notes by hand.
Someone filters the file.
Someone else edits last week's file.
Now the owner is not comparing systems.
The owner is comparing changed copies of systems.
How To Trace One Order Or SKU
Do not start by fixing every report.
Pick one order or SKU where the numbers disagree.
Trace these steps:
- Sales Order
- Delivery Order
- Invoice
- stock posting
- return or credit note, if there is one
At each step, ask:
- which document made this number?
- which date is used?
- was the document transferred or typed again?
- what changed if the quantity changed?
- what happened if only part was delivered?
- what happened if the customer returned goods?
This is often enough to find where the split began.
If the trail is too messy to follow, a system audit can help map the documents, dates, and formulas first.
Make A Source-Of-Truth Map Before A Dashboard
A dashboard cannot choose your rules for you.
First, map each number.
| Owner question | Right number | Source document | Date basis | How to handle exceptions |
|---|---|---|---|---|
| What did customers order? | confirmed order demand | Sales Order | order date | remove cancelled orders |
| What stock left the warehouse? | delivered quantity | Delivery Order | delivery date | show part delivery on its own |
| What did we bill? | invoiced sales | Invoice | invoice date or posting date | deduct credit notes by an agreed rule |
| What is free to sell? | available stock | stock balance and reservation | current date | split reserved, in-transit, and damaged stock |
This turns a report fight into a shared rule.
When A Dashboard Helps
A business dashboard helps when the rules are clear.
An AutoCount dashboard can show sales, stock, cash, and margin earlier.
This works best when the Sales Order, Delivery Order, and Invoice trail is kept.
For a more direct service, see dashboards and reporting from AutoCount data.
But if the rules are not clear, the dashboard will only show the mismatch faster.
That is why trustworthy reporting starts with fixing the data.
If the main issue is sales order or delivery flow, review sales order to AutoCount and delivery to AutoCount billing.
FAQ
Why does my sales report not match my accounting report?
Most times, one report counts orders.
The other counts invoices or posted accounts entries.
Should sales be counted by order date, delivery date, or invoice date?
It depends on the question.
Order date shows demand.
Delivery date shows fulfilment.
Invoice date shows billing.
Can stock reduce before the invoice is posted?
Yes, depending on the workflow and setup.
A Delivery Order may record stock movement before the invoice is posted.
What should an owner do when every department says its report is correct?
Pick one transaction.
Trace the document, date, and formula used by each report.
What To Do Next
If your sales, stock, and accounting reports do not match, do not start with another spreadsheet.
Map one order from demand, to delivery, to invoice.
Then decide which number the owner should use for each decision.