A Vending Report Is Missing Several Days: Check the Data Gap Before Judging Sales
A vending report with several missing days can make sales look lower even when the machine continued trading. Before reducing stock or judging a site’s performance, establish whether the gap represents no purchases, a closed site or missing data. A blank row is an observation about the report, not an explanation of what happened.
Begin by preserving the original export and recording the period you expected it to cover. Note the machines, payment types and filters selected. The aim is to identify the gap precisely and recover or explain the missing information without inventing transactions or filling the space with an unsupported average.
Confirm the report's coverage
Check the start and end dates, time zone and any filters that exclude particular machines or transaction types. Compare the selected period with the visible rows. Some reports show only days containing records, while others include zero-value days; ask the provider how this report behaves rather than assuming that every absent date means zero sales.
Check whether the machine identity changed in the system or whether a site transfer created a separate record. A report for one identifier may stop while activity continues elsewhere in the same system. Keep the equipment and reporting identities connected so the gap can be investigated without merging unrelated machines.
Compare independent operational evidence
Review the site opening record, service notes and any relevant payment summaries for the same period. These can help frame the question, but one source should not be treated as a complete replacement for another. A bank receipt dated during the gap may relate to earlier sales, and a refill visit does not establish the exact number of purchases.
Ask the site contact whether the service was available and record the answer with its date. Distinguish a confirmed closure from a recollection that the room was ‘probably quiet’. Keep uncertainty visible. When assessing a vending business plan, incomplete trading evidence should be identified before it becomes an assumption in the next forecast.
Request a targeted data check
Send the provider the report name, selected period, affected machine identities and the missing dates. Explain whether another report shows activity for those dates. Avoid sending unrelated customer details or full payment credentials. A focused request is easier to investigate than a general claim that the entire reporting system is wrong.
If a replacement export is supplied, compare its scope and totals before substituting it in the analysis. Keep the original and the correction reference so the change is traceable. Do not append the complete replacement beneath the old file, which could duplicate days that were already present and create a second reporting problem.
Report the limitation until resolved
Where the data cannot yet be recovered, mark the affected period as incomplete and explain which conclusions remain uncertain. Do not silently convert missing days to zero or estimate sales and present the estimate as measured performance. If an estimate is needed for internal planning, label its assumptions and keep it separate from the verified report.
Once the gap is resolved, update any decisions or summaries that relied on the incomplete figures. Add a simple coverage check to future exports: expected dates, machine scope and unexplained absences. This helps catch missing information before it influences purchasing or service plans, while preserving an honest distinction between what the business measured and what it still needs to establish.
Related guidance: Vending Revenue Reports: Understand the Period Before Comparing Totals.
For help assessing your site, contact Vending-Machines.ie.
