PalletAudits
Three numbers · one gap · every pallet explained

How the audit works

The pallet company’s balance, your own records and a physical count. The audit lines them up, matches every load, and gives each pallet of the difference a reason and a next step.

1. The three numbers

From the sample audit
Pallet company says
1,060
their closing balance
+100
paperwork: on their books, not in your records
Your records say
960
from your WMS
+23
not in the building
You counted
937
by area
Their statement

The pallet company’s balance

Opening balance, plus empties issued to you and transfers suppliers declared to you, minus transfers you declared to customers and returns.

Your WMS

Your book balance

The same opening balance, plus receipts on pooled pallets and empties issued, minus shipments on pooled pallets and returns.

The count

The physical count

What you counted on the floor, by area and pallet size, on a printable sheet.

2. Every load is matched

Shipments to declarations, receipts to credits
01

By a shared reference

BOL, order or PO number on both sides.

02

By customer, date and quantity

Customer names don’t have to be spelled the same. Store numbers have to agree.

03

As part of a roll-up

One declaration that covers several loads to the same customer.

3. What each mismatch means

And what you do about it
A shipment with no declaration
Undeclared: the pallets are still on your account
Declare
A credit with no receipt
You were credited for pallets you never received
Dispute
Different quantities on the same load
Declared more or fewer than you shipped
Correct
A receipt with no credit
The sender never declared the transfer to you
Ask sender
A declaration with no shipment
Over-declared, or a load your WMS file left out
Check
A declaration made days after the load shipped
Rent you paid on pallets you no longer had
Declare on time
Whatever is left between your records and the count
Physically missing from the building
Recount

4. Your files

Read, then discarded

Files are read in memory to build the report. They’re never written to disk.

Only what the report needs

The report keeps the totals and the lines it flags: date, customer, reference, pallets.

Yours to delete

Delete any audit from its report page, any time.

See a full sample audit.

The sample audit uses made-up data for one site and one month.

See the sample auditRun your first audit free