How do I reconcile daily restaurant sales and payments?

Choose one business-day cutoff and compare sales records with expected payments and counted or statement amounts. Record differences and check refunds, fees, payment timing and missing records before deciding the cause.

What is average order value?

In this workbook it is net sales divided by order count. Net sales are gross sales minus discounts and refunds on your chosen consistent basis. When order count is zero, average order value is undefined.

Why can settlement amounts differ from the sales report?

Settlement timing, fees, refunds and adjustments can differ from the business-day sales record. A variance identifies a difference to review; it does not establish the cause.

Does the HTML workbook save or calculate my entries?

The HTML page provides editable fields for manual review and printing. It does not save entries or automatically calculate the formulas. The downloadable PDF is a blank printable workbook.

DineHalo

WORKBOOK / DineHalo resource

Daily Sales & Payment Workbook

Record daily sales by channel and compare expected payment totals with counted or statement figures.

Version 1.0Updated 2 October 2026For restaurant owners and staff who reconcile daily records

This workbook does not verify bank or delivery-platform settlement, choose tax treatment, or provide bookkeeping or accounting advice. It flags arithmetic differences for review.

Read Me

Venue name
Business date
Currency
Prepared by
Version
Chosen gross / net definition
Tax treatment follows venue records
Update date

Daily summary

Sales by channel

Channel	Gross sales entered	Discounts	Refunds	Net sales	Order count	Average order value

Payment summary

Payment method	Expected total	Counted / statement total	Variance	Reference or note	Checked by	Check date

Channel detail

Channel name
Gross sales
Discounts
Refunds
Net sales = gross - discounts - refunds
Order count
Average order value = net sales / order count (when count > 0)

Payment check

Payment method
Expected from sales record
Counted / statement amount
Variance = counted - expected
Reference / note
Checked by
Check date

Definitions and review

Choose one consistent gross / net and tax treatment from your own records
Blank means missing; zero means a recorded zero
Settlement timing, refunds and fees can affect a comparison
Review a variance before deciding what caused it

How to use it

Use a consistent business date and matching sales definition across channels.
Record gross, discounts, refunds and net separately using the venue's chosen accounting basis.
Compare payment figures using clearly stated settlement dates; review a variance before classifying it.

Maintainer: DineHalo Editorial · Format: Printable PDF and HTML preview

Open PDF