Restaurant Daily Sales Report Template Bangladesh: Reconcile Every Channel
A copyable day-end report that separates sales from collections and exposes missing orders, payment gaps, delivery receivables and unexplained cash variance.
Last verified: 2026-08-30
A restaurant daily sales report should answer five questions before the manager leaves: what was ordered, what was recognized as sales, what was discounted or reversed, how customers paid, and where each collection now sits. Mixing these questions creates false shortages—for example, a delivery-platform sale may be valid today even though the restaurant receives the net settlement later.
The template below is designed for Bangladesh restaurants that accept cash, bank cards, mobile financial services such as bKash or Nagad, own online orders and marketplace orders. It is a management reconciliation template, not an NBR form. Keep official VAT invoices and records in the format and manner currently required for the restaurant, then link their references to the daily control report.
Copyable restaurant daily sales summary
Define every line in a short data dictionary. Decide whether gross sales include VAT, service charge, delivery charge, packaging and tips, and state that decision. Do not compare two days unless the definition is identical. Keep tax collected or payable separate from sales performance when the restaurant's accounting treatment requires it.
Do not use the average-order formula blindly. Exclude test, fully voided or zero-value records according to one documented rule. If the outlet has dine-in tables and delivery orders with different commercial models, show channel-level averages before making operational decisions.
| Line | Amount or count | Source |
|---|---|---|
| Opening order count | ____ | POS opening status |
| Gross item sales | ৳ ____ | All completed orders before adjustments |
| Discounts | (৳ ____) | Approved discount report |
| Voids/cancellations | (৳ ____) | Void and cancellation report |
| Refunds/returns | (৳ ____) | Refund record |
| Other defined adjustment | +/− ৳ ____ | Named supporting record |
| Net sales | ৳ ____ | Calculated and clearly defined |
| Completed order count | ____ | Order report |
| Average order value | ৳ ____ | Net sales ÷ eligible completed orders |
| VAT/tax fields | As applicable | Official records and adviser mapping |
Break sales down by order channel
Channel classification must happen when the order is created. Reconstructing it from memory after close causes marketplace sales to appear as counter sales and makes commission analysis unreliable. If staff manually enter a marketplace order into the POS, require the correct marketplace tag and its external order reference.
A channel total should tie to a list of orders. When it does not, check reopened orders, duplicate entries, time-zone or cut-off differences, cancelled marketplace tickets, and orders accepted near midnight. Record the cut-off used by the restaurant and do not silently move a difficult order to the next day.
| Channel | Orders | Gross sales | Adjustments | Net sales | Settlement owner |
|---|---|---|---|---|---|
| Dine-in | ____ | ৳ ____ | ৳ ____ | ৳ ____ | Cashier/branch |
| Takeaway | ____ | ৳ ____ | ৳ ____ | ৳ ____ | Cashier/branch |
| Own website/QR | ____ | ৳ ____ | ৳ ____ | ৳ ____ | Payment/order owner |
| Foodpanda | ____ | ৳ ____ | ৳ ____ | ৳ ____ | Marketplace receivable |
| Pathao Food | ____ | ৳ ____ | ৳ ____ | ৳ ____ | Marketplace receivable |
| Other marketplace | ____ | ৳ ____ | ৳ ____ | ৳ ____ | Named account |
Reconcile payment and collection separately
Payment totals and sales totals can differ for legitimate reasons: receivables, refunds processed on another day, split tender, prior-period settlement and tips. Explain every bridge item. Do not force the cash drawer to balance against total sales when a large part of the day was paid digitally or remains due from a platform.
Reconciliation must use merchant or terminal records, not customer screenshots. Record settlement timing and fees only when supported by the restaurant's agreement or statement. Never copy a commission or settlement assumption from another restaurant into the daily report.
| Payment/receivable | System amount | Verified amount | Variance | Evidence |
|---|---|---|---|---|
| Cash | ৳ ____ | ৳ ____ | ৳ ____ | Signed cash count |
| Bank card terminal | ৳ ____ | ৳ ____ | ৳ ____ | Terminal batch/merchant record |
| bKash merchant | ৳ ____ | ৳ ____ | ৳ ____ | Merchant transaction record |
| Nagad merchant | ৳ ____ | ৳ ____ | ৳ ____ | Merchant transaction record |
| Own online gateway | ৳ ____ | ৳ ____ | ৳ ____ | Gateway report |
| Marketplace receivable | ৳ ____ | ৳ ____ | ৳ ____ | Order/payout ledger |
| Other/tender | ৳ ____ | ৳ ____ | ৳ ____ | Named source |
Sources for this section: Bangladesh Bank Payment Systems Report 2025
Discount, void and refund control
List each discount and reversal by order, amount, reason, staff user and approver. Separate a promotional discount from a service-recovery discount, staff meal, complimentary item, duplicate order, kitchen cancellation and actual refund. These have different operational causes and should not be hidden inside one adjustment number.
Review unusual patterns rather than assuming every variance is fraud. Repeated voids can come from menu-button errors, staff training, printer delays, unavailable ingredients or deliberate misuse. The manager should check supporting tickets and fix the process that created the pattern.
- No blank reason
- No shared cashier login
- Manager approval for defined thresholds
- Original order and changed record preserved
- Refund payment route identified
- Customer complaint or incident linked where relevant
VAT document and record bridge
The daily sales report is not a substitute for a required VAT invoice, Mushak form, register or return. Use NBR's current pages and qualified advice to identify which documents apply to the restaurant. Add fields in the management report for invoice sequence, missing or cancelled document references and the person who investigated any gap.
When POS totals and VAT-document totals differ, do not overwrite one to match the other. Reconcile order cut-off, inclusive or exclusive treatment, cancellation, return, rounding and document status. Preserve the explanation and correction trail so the monthly preparation does not depend on memory.
Sources for this section: National Board of Revenue VAT FAQ · National Board of Revenue VAT forms
Manager day-end sign-off
A signature should mean the manager reviewed exceptions, not that the sheet has numbers. Require cashier and manager names, report run time, business-date cut-off and the version of any exported file. If a value is pending, assign an owner and deadline rather than entering zero.
Lock the final report or preserve a read-only export. Corrections should create a new version with reason and approver. Silent editing after cash has been deposited or a marketplace report has arrived removes the audit trail.
| Check | Result | Exception/action |
|---|---|---|
| All open orders resolved | Pass/Fail | ____ |
| Channel totals tie to order detail | Pass/Fail | ____ |
| Cash counted and witnessed | Pass/Fail | ____ |
| Digital payment records checked | Pass/Fail | ____ |
| Marketplace receivables posted | Pass/Fail | ____ |
| Discounts, voids and refunds approved | Pass/Fail | ____ |
| VAT sequence exception reviewed | Pass/Fail/N/A | ____ |
| Report locked/exported and handed over | Pass/Fail | ____ |
Turn the report into next-day decisions
Use the report to identify a small number of actions: prepare more of a high-demand item, correct an unavailable menu listing, investigate a recurring discount, train one cashier, follow up a missing settlement or update a supplier order. Assign the action at the morning meeting and link it to the source line.
Compare like with like: same branch, weekday, hours, campaign and channel definition. A festival, rain disruption, stockout or temporary closure can explain a large difference. Record the event instead of treating every deviation as performance failure.
Spreadsheet-to-POS migration rule
A spreadsheet can work while order volume and channels are controlled, but manual re-entry creates delay and version risk. Move to a system report when staff copy POS totals into multiple sheets, channel names change between users, marketplace receivables are forgotten or management cannot trace an adjustment to an order.
Before migration, freeze the definitions in the template. Configure the POS channel, payment method, discount reason and report cut-off to match them. Run both reports for a controlled period and explain differences before retiring the old sheet.
How we calculated and verified this
The template is a control model, not a claim about statutory format. It starts with the accounting identity that gross sales must be reduced by recorded discounts, voids, refunds and other defined adjustments to reach a clearly labelled net-sales figure. Collections are reconciled separately because cash received, card settlement, mobile financial service settlement and marketplace receivables can occur on different dates.
NBR pages are linked for the current VAT document and record context, while Bangladesh Bank is linked for regulated payment-channel context. The example contains formulas and blank fields but no invented benchmark, VAT rate, commission rate or expected daily revenue. A qualified accountant or VAT adviser should map the restaurant's final report to its legal and tax obligations.
The strongest daily report keeps sales, adjustments, payment collections and receivables separate, then reconnects them through documented bridge items. That makes cash variance visible without treating every unsettled delivery order as missing money.
Copy the tables, replace blank fields with the restaurant's controlled categories and have the accountant or VAT adviser approve the final tax mapping. Never hard-code a VAT, commission or settlement assumption without the restaurant's current source document.
Related guides
- Restaurant Sales Forecast Guide
- Restaurant Cash Flow Management
- Foodpanda Payout Reconciliation
- Mushak 6.3 VAT Challan for Restaurants
See this workflow in Rosuii: Review restaurant sales, orders and branch reports in Rosuii
Sources checked
Frequently asked questions
What should a restaurant daily sales report include?
Why do daily sales and cash not match?
Should Foodpanda sales be recorded on order date or payout date?
Is this template an NBR VAT form?
Can the report be created from a POS?
Run your restaurant on Rosuii
POS, menu, inventory, payroll and more — built for Bangladeshi restaurants.
Start free
