Shiftmate
Daily sales, POS and cash reconciliation Excel
Compare cash, card, food platform, refund and cash register count and see the daily cash difference.
Prepared by:Shiftmate Product and Operations Team · Son kontrol:
Actual file previews
The images below are the actual data entry and executive summary pages of the workbook to be downloaded.
Step by step usage
Prepare the file according to your business
Cash, card, food platform and other channel sales in the POS report; Enter the return, cash entry-exit and physical cash count for the same business day.
Run formulas and checks
Expected cash is cash sales plus documented cash receipts minus returns and cash issues. Cash difference is calculated as counted cash minus expected cash.
Turn results into action
Review the indicators on the summary page. Match the channel total to the POS report. Add explanation and responsible for the difference. Close the action that carries over to the next day.
What does this Excel file solve?
Compare cash, card, food platform, refund and cash register count and see the daily cash difference. Cash, card, food platform and other channel sales in the POS report; Enter the return, cash entry-exit and physical cash count for the same business day.
What's inside the file?
Channel based sales, Expected cash, Counted cash, Cash difference alert. The file contains sample rows, canned formulas, data validation fields, risk colorings, and executive summary.
Calculation and control logic
Expected cash is cash sales plus documented cash receipts minus returns and cash issues. Cash difference is calculated as counted cash minus expected cash.
Worked example: Closing cash control
Cash sale: 18,400 TL. Refund: 650 TL. Cash out: 1.200 TL. Counted: 16,430 TL. Result: Expected 16,550 TL, difference is -120 TL; The shift manager checks registration, change and documents.
Decisions that can be taken as a result of this
Match the channel total to the POS report. Add explanation and responsible for the difference. Close the action that rolls over to the next day
Common usage mistakes
Adding card sales to physical cash. Deducting the refund twice. Saving cash issue with undocumented free text
Limits and proper use
The file is not an official accounting book. Periodic reconciliation with bank, POS, platform and accounting records is required.
Compatibility and quality control
All 67 workbooks underwent formula error scanning, recalculation checking, and page-by-page visual inspection. Standard .xlsx file; Does not contain macros or external links. Formulas and data validation fields run inside the file. It is recommended that you keep the original file and work on a separate copy for your business.
Transitioning from Excel to automation
Use the file to solve restaurant operation needs immediately. When registration and approval traffic grows, move the same process to the Shiftmate workspace.
Frequently asked questions
Is the tip included in the cash register?
Keep it in a separate account according to your business policy; Do not mix sales revenue and employee tips in the same item.
How should petty cash differences be handled?
Save even if the amount is small. Frequency of recurrence may indicate the need for process or training.