Free Template

POS Sales Reconciliation Template for Restaurants

Match sales, payments and payment methods at the end of each day without chasing stray receipts. Free download.

The problem

When POS sales, cash, card payments, delivery platforms and tips are not checked together, discrepancies surface late and nobody knows where they came from.

This template helps you solve it simply and professionally, without any complicated software.

What's in this template?

Everything you need to start working in an organised way from today.

Daily reconciliation between POS sales and money actually received

Separate tracking of cash, card, bank transfer, vouchers and delivery

Record of tips, comps, voids and discounts

Follow-up of discrepancies with owner, cause and corrective action

Preview

Free basic version

Daily reconciliation between POS sales and money actually received
Separate tracking of cash, card, bank transfer, vouchers and delivery
Record of tips, comps, voids and discounts
Follow-up of discrepancies with owner, cause and corrective action
FormatExcel (.xlsx)
PriceFree
Versions by type of business

Adapted to your type of venue

Every hospitality business is different. The template includes versions adapted to different types of venue.

Restaurant with several till shifts and a closing manager

Café with lots of cash, small tickets and shift changes

Hotel with restaurant, bar, room service and room charges

Business with delivery, prepaid bookings and sales through third-party platforms

Download your template

Fill in your details and download the template instantly.

Frequently asked questions

Answers to the most common questions about this template.

What is sales reconciliation in a restaurant?

It is the daily check that compares what the POS recorded as sold with what was actually received through each payment method: cash, card, bank transfer, vouchers, delivery platforms, prepaid bookings or room charges. It helps you catch discrepancies, payment mistakes, badly recorded voids and differences between the till, the bank and your reports.

How is this template different from a cash-up sheet?

A cash-up focuses mainly on counting cash and accounting for the physical till. Sales reconciliation is broader: it cross-checks POS sales, payments by channel, tips, comps, discounts, voids, delivery commissions and outstanding differences. The two templates work together, but they cover different controls.

What should I check every day?

Record the date, shift, person in charge, gross sales, discounts, voids, net sales, payments by method, tips, expenses paid from the till, cash counted, expected amount, difference and cause of the discrepancy. If you do delivery, add sales and commissions per platform so you don't confuse turnover with net receipts.

Does it work for cafés and hotels?

Yes. In cafés it helps you keep on top of small tickets, cash and shift changes. In hotels it lets you separate the restaurant, bar, room service and room charges. The template is editable, so you can add columns for outlets, departments, waiters, platforms or separate tills.

How often should I reconcile?

Ideally at the end of every day and, if you are busy, per shift as well. The sooner you check, the easier it is to find the receipt, card terminal, void or change error behind the discrepancy. Leaving it until the end of the week tends to turn a small adjustment into a slow investigation.

Tired of updating templates by hand?

Try Zindra for free and automate the running of your restaurant. Rotas, inventory, costs and much more — all in one place.