About this template
Accurately reconciling daily takings is crucial for maintaining healthy financial records in retail, hospitality, and food service businesses. This Nightly Cashup Sheet template provides a structured, foolproof way for shift managers and supervisors to record register totals, credit card settlements, tip distributions, and cash drawer counts at the close of business. By standardizing the end-of-shift reporting process, management can instantly spot cash variances, track promotional discounts or returns, and maintain an audit-ready log of daily financial activity.
Designed to handle complex multi-terminal setups and shift breakdowns, this form collects everything from coin and bill denominations to service notes and incident reports. Whether you operate a bustling restaurant, a busy bar, or a retail storefront, utilizing a consistent digital cashup sheet eliminates lost paper logs and helps finance teams reconcile daily revenue with minimal friction.
Key features
- Standardize end-of-shift financial reporting across multiple terminals.
- Quickly calculate cash drawers, tips, and register variances.
- Record daily covers, walk-ins, VIPs, and operational incidents.
- Export daily totals directly into spreadsheets for accounting review.
Use cases
Closing out register drawers at restaurants and cafes after dinner se…
Closing out register drawers at restaurants and cafes after dinner service.
Reconciling daily retail sales and EFTPOS terminal settlements.
Tracking nightly tips, cash drops, and register variances for auditing.
Logging shift notes, staff attendance issues, and customer incidents.
What this form collects
- Date of Shift (Date)Select the calendar date for this reporting period.
- Which Shift? (Multiple choice)Choose the operational shift you are closing out.
- Manager's Name (Short answer)Enter the full name of the manager completing this cashup.
- Closing Time / Shift End (Short answer)Enter the approximate time the shift officially ended.
- Total Covers (Short answer)Enter the total number of customers or guests served.
- Walk-ins Count (Short answer)Number of walk-in customers accommodated.
- Names of No-Shows (Paragraph)List any reservation no-shows, or enter 'None'.
- Names of Regulars or VIPs (Paragraph)Note any notable regular customers or VIP guests served.
- Staff Sick / Absent (Paragraph)List any scheduled staff members who called in sick or missed their shift.
- Total Terminal 1 Settlement (Short answer)Enter the total settlement amount for Terminal 1.
- Total Terminal 2 Settlement (Short answer)Enter the total settlement amount for Terminal 2.
- Total Recorded Takings (Short answer)Enter the total gross sales recorded by the POS system.
- Enter Recorded Cash Takings (Short answer)Total cash sales logged by the register.
- Enter Total Return Value (Short answer)Total monetary value of processed customer returns.
- Returns Count & Explanation (Paragraph)Detail the number of returns and reasons for each.
- Enter Total Discount Value (Short answer)Total value of promotional or manager discounts applied.
- Discount Breakdown Details (Paragraph)Explain the breakdown of discounts given during the shift.
- $0.05 Coins (Short answer)Total dollar value or count of $0.05 coins.
- $0.10 Coins (Short answer)Total dollar value or count of $0.10 coins.
- $0.25 / $0.50 Coins (Short answer)Total dollar value or count of half-dollar/quarter coins.
- $1 Bills / Coins (Short answer)Total dollar value of $1 denominations.
- $5 Bills (Short answer)Total dollar value of $5 bills.
- $10 Bills (Short answer)Total dollar value of $10 bills.
- $20 Bills (Short answer)Total dollar value of $20 bills.
- $50 Bills (Short answer)Total dollar value of $50 bills.
- $100 Bills (Short answer)Total dollar value of $100 bills.
- Total Cash Counted (Short answer)Enter the final calculated sum of all physical cash in the drawer.
- Credit Card Tip Total (Short answer)Total tips collected via credit card terminals.
- Cash Tip Total (Short answer)Total cash tips collected.
- Cash Variance (Short answer)Difference between expected cash takings and actual cash counted (positive or negative).
- EFTPOS Variance (Short answer)Any discrepancy between POS system records and terminal settlement reports.
- Explanation of Variance (Paragraph)Provide context or reasoning for any cash or terminal variances observed.
- Incident Status (Multiple choice)Were there any notable maintenance, security, or customer incidents during the shift?
- Service Report & Notes (Paragraph)Describe any equipment issues, customer feedback, or operational highlights.
- Finalize Takings Confirmation (Multiple choice)Confirm that all counts have been double-checked and verified.
- Manager Electronic Signature (Name) (Short answer)Type your full legal name as confirmation of report accuracy.
FAQ
How does Doc2Form help with daily cashup reporting?
Doc2Form instantly converts documents and templates into fully functioning Google Forms, letting your shift managers submit nightly reports directly from any mobile device or tablet.
Can I customize the currency denominations and terminal fields?
Yes! Once the template is in your Google Forms account, you can freely add, remove, or edit fields to match your specific POS setup, terminal count, and currency needs.
Is this cashup sheet mobile-friendly for staff use?
Google Forms work seamlessly on smartphones and tablets, allowing managers to complete their nightly reconciliation right from the counter or back office.
Where is the submitted cashup data stored?
All form submissions are securely saved in a connected Google Sheets spreadsheet, giving your finance or accounting team immediate access to historical daily reports.
Get this form in your Google Drive
Save a copy to your Google Drive with one click (uses 1 credit). Or build from a PDF or description in the app.