Retail Shop Daily Cash-Up and Stock Take Pack

At closing time you need three answers: how much cash should be in the till, how much is there, and what to bank. This workbook gives them from the figures on your POS shift report (often called a Z report) and your count.

What is inside:

• Count Calculator: notes and coins by denomination into a counted total, 400 lines
• Cash-Up: one line per till per day with opening float, cash sales, cash refunds, paid in and paid out. It works out expected cash, counted cash, variance and the amount to bank, and compares your gross sales with the Z report figure you type
• Stock Take: 300 lines comparing the system quantity with your count and valuing the difference at cost
• Month Review: takings, shortages and overages by till and by cashier, and the days with differences
• Two Excel files (blank and a filled-in week), a Worked Example sheet and a README

Expected cash is opening float plus cash sales minus cash refunds plus paid in minus paid out. This is how the Zeyto Academy POS lesson describes the Zeyto POS Z report, where card and on-account sales never enter it. Other POS systems can define it differently, so compare with your own report first.

Who it is for: owners and managers of shops, minimarts and kiosks with a till and a POS shift report.

What it is not: it does not read from any POS, including Zeyto POS, and it is not an audit. You type the figures. They are working tools and templates, not tax, accounting, legal or regulatory advice, and UAE rules change: check with your accountant, lawyer or the relevant authority for your case.

Requirements: Microsoft Excel 2016 or later (not tested in Google Sheets or LibreOffice Calc).