Daily Sales Report

What Is a Daily Sales Report?

A Daily Sales Report is a financial record that summarises every transaction a business completes within a 24-hour trading period. It acts as a snapshot of your business performance, showing exactly how much money came in, where it came from, and what tax obligations are attached to those figures.

For Australian business owners, this document is more than just a way to track progress. It is the foundation of your bookkeeping system. It provides the raw data needed to calculate your Business Activity Statement (BAS), reconcile your bank accounts, and pay your staff correctly.

In modern operations, this report often takes the form of a digital "Z-Read" or end-of-day tally from a Point of Sale (POS) system. However, for tradespeople, market stall holders, and small cafes, a manual log or spreadsheet remains a vital tool. Regardless of the format, the goal is the same: to create an accurate paper trail that explains your daily financial position.

Using a standardised Daily Sales Report template ensures you capture the necessary details consistently, making it easier for your accountant to verify your income at tax time.

When to Use This Document

You should complete a Daily Sales Report at the end of every business day. This habit applies whether you run a busy retail store in Melbourne, a mobile coffee van in Brisbane, or a consultancy in Perth.

The most common time to use this document is immediately after closing the doors or finishing the last job for the day. It allows you to balance the till, count the cash float, and check that EFTPOS totals match your merchant terminal receipts.

This report is also essential whenever you need to verify income or investigate a discrepancy. If a customer claims they were overcharged, or if your bank deposit does not match your records, the Daily Sales Report is the first place you look. It provides the audit trail required to resolve disputes quickly.

For businesses with employees, it is useful to run this report at shift changes. This helps managers track performance across different teams and ensures accountability for the cash handled during specific hours.

Key Sections and Required Elements

A robust Daily Sales Report must contain specific data fields to be compliant with Australian record-keeping standards. If you are building your own template or selecting one from our library, ensure it includes these core sections.

Business Metadata and Date

You must clearly identify the business and the specific reporting period. This section prevents confusion when archiving records.

• Business Name: Use the exact legal name registered with ASIC.
• ABN: Include your Australian Business Number on every document.
• Date: Record the specific date of trading (e.g., 15 October 2023).
• Responsible Person: Note the name of the employee or manager who balanced the till.

Payment Method Breakdown

To reconcile your bank account effectively, you need to know how the money was received. You should record totals for:

• Cash Sales: Total physical currency notes and coins received.
• EFTPOS/Debit: Transactions made via debit cards.
• Credit Cards: Separate totals for Visa, Mastercard, and Amex, as merchant fees often vary.
• Account Sales: Sales made on credit or invoice that have not yet been paid.
• Mobile Payments: Totals from digital wallets like Apple Pay or Google Pay.

Tax Analysis (GST)

The Australian Taxation Office (ATO) requires you to distinguish between taxable and GST-free sales. Your report must categorise sales to simplify your BAS lodgement.

• GST-inclusive Sales: Total sales including the 10% Goods and Services Tax.
• GST-free Sales: Items like basic food, medical supplies, or educational courses.
• Input Taxed: Sales where GST is not charged and cannot be claimed (e.g., some financial services).

Till and Cash Reconciliation

This is the most critical section for preventing theft and identifying errors. It calculates the variance between what the system says you should have and what is actually in the drawer.

• Opening Float: The amount of cash left in the till from the previous day.
• Plus Cash Sales: The total cash revenue for the day.
• Less Cash Out: Money removed from the till for petty cash or small expenses.
• Expected Cash: The calculated total that should be present.
• Actual Cash Count: The physical count of notes and coins.
• Variance: The difference between the expected and actual count.

Void and Refund Log

Cancelled transactions and refunds are high-risk areas for fraud. You need a dedicated space to record these events.

• Time: When the transaction was voided.
• Amount: The value of the refund.
• Reason: A brief explanation (e.g., "Customer changed mind", "Item returned").
• Authorisation: A signature or code from a manager approving the void.

How to Write a Daily Sales Report (Step by Step)

Creating a useful report requires a consistent process. Follow these steps to ensure your records are accurate and compliant.

Step 1: Gather Your Data

Before you start writing, collect all relevant source documents. This includes EFTPOS machine printouts, cash register tapes, handwritten dockets, and invoices. If you use a digital POS system, run the "X-Read" or "Z-Report" to get the system's view of the day's trading.

Step 2: Record Sales Totals by Category

Enter the total sales figures into your report. Break them down by payment method first, then by tax status. For example, if you run a bakery, you might separate your "GST-Free Fresh Bread" sales from your "Taxable Coffee and Cake" sales. This separation is vital for completing your BAS correctly.

Step 3: Calculate Expected Cash

Add your opening float to your total cash sales for the day. Then, subtract any "cash outs" that occurred during the shift. Cash outs are expenses paid directly from the till, such as buying milk for the staff room or paying a window cleaner. The result is your "Expected Cash on Hand".

Step 4: Count the Physical Cash

Open the till and count every note and coin. Do not rely on the drawer's assumed total. Compare this "Actual Cash Count" against your "Expected Cash" figure.

Step 5: Identify and Investigate Variances

If the actual cash does not match the expected figure, you have a variance.

• Overage: You have more money than expected. This might mean a customer was overcharged or a transaction was entered incorrectly.
• Shortage: You have less money than expected. This could indicate theft, giving the wrong change, or a misplaced receipt.

Record the variance amount clearly. If the variance is significant, investigate it immediately before finishing the report.

Step 6: Log Refunds and Voids

Review the receipt tape for any cancelled transactions. Enter these into the refund log section of your report. Ensure you have a valid reason and authorisation for each one. This transparency is crucial if the ATO audits your records.

Step 7: Finalise and File

Once all sections are complete and the totals balance, sign the document. If you are using a paper system, file the report in a binder with the attached cash register tapes. If you are using a digital system, save the file to a secure cloud server or local drive. Remember, under Australian law, these records must be accessible for review.

Common Mistakes to Avoid

Many Australian business owners lose money or face compliance issues because of simple errors in their daily reporting. Being aware of these pitfalls can save you time and stress.

Mixing Personal and Business Expenses

One of the most frequent mistakes is taking money out of the till for personal use and recording it as a business expense or a sale refund. This makes it very difficult to determine the true profit of the business. The ATO requires clear distinctions between business trading stock and personal drawings. Always record personal withdrawals separately, not as a reduction in sales.

Recording Net Instead of Gross

Some business owners only record the amount they bank at the end of the day. This is the "net" figure. For example, if you took $1,000 in sales but spent $200 cash on supplies, you might only deposit $800. Recording $800 as your total sales is incorrect. You must record the gross sales of $1,000 and record the $200 spending as an expense. Underreporting income can lead to heavy penalties.

Forgetting to Track Cash Out

Failing to document money taken from the till for petty cash is a common error. If you remove $50 from the register to buy stationery and do not write it down, your cash balance will be $50 short at the end of the day. This makes it look like money is missing or was stolen. Always use a Petty Cash Voucher to track these movements and record them in the "Cash Out" section of your Daily Sales Report.

Ignoring Small Variances

It is easy to dismiss a missing $2 or $3 as a minor counting error. However, consistent small shortages can indicate a larger problem, such as systematic theft or a faulty cash drawer. Even small variances should be noted and reviewed monthly to identify trends.

Legal Considerations (AU)

Operating a business in Australia comes with strict legal obligations regarding financial records. Your Daily Sales Report is a key part of meeting these obligations.

Record Retention Requirements

You cannot throw your reports away at the end of the financial year. The Income Tax Assessment Act 1936 and 1997 mandates that businesses must retain records that explain all transactions for 5 years after they are prepared or the transactions completed, whichever is later.

If your business is incorporated (a Pty Ltd company), the Corporations Act 2001 increases this requirement. Companies must keep their financial records for 7 years.

Currency and Storage

According to Taxation Ruling TR 96/7, your records must be in English or in a format that can be easily converted into English. Furthermore, the records must be kept in Australia or be accessible electronically from an Australian server. If you use cloud-based accounting software hosted overseas, you must ensure you can access the data instantly from within Australia to remain compliant.

Evidence of Income

The ATO uses the Daily Sales Report as primary evidence of assessable income. If your business is selected for an audit, the ATO will compare your reported sales against your bank deposits and POS data. If your daily reports are missing, incomplete, or cannot be verified against other sources, you may face penalties or additional tax assessments.

Employee Entitlements and Record Keeping

If your business receives tips or service charges that are distributed to staff, the Daily Sales Report helps track these amounts. Under the Fair Work Act 2009, employers must keep accurate records of employee payments. If tips are pooled or distributed through the payroll, you must keep records of these calculations for 7 years. Employees have the right to request access to these records.

Privacy and Personal Data

If your Daily Sales Report includes customer details for lay-bys or credit accounts, you must handle this information carefully. The Privacy Act 1988 applies to businesses with an annual turnover of more than $3 million, as well as certain health service providers. You are required to store this data securely and dispose of it appropriately when it is no longer needed. Leaving a stack of reports with visible customer names and addresses on a counter overnight is a breach of privacy standards.

Director Responsibilities

For directors of Pty Ltd companies, the Corporations Act 2001 (s 286) imposes a duty to keep financial records that correctly record and explain the company's transactions. The Daily Sales Report is a fundamental component of this internal control framework. Failing to maintain these records can result in personal liability for directors and significant fines from ASIC.

Frequently Asked Questions (preview)

Do I need a physical paper report if I use a digital POS? While a purely digital system is acceptable, it is best practice to keep a PDF backup or a printed copy. Digital records can be lost due to technical failures. A PDF copy saved to a secure cloud server satisfies the ATO's requirement for readable and accessible records.

What if I lose a day's report? You should attempt to reconstruct the record using other evidence, such as bank deposit slips, EFTPOS settlement summaries, and supplier invoices. A reconstructed record is better than no record. Note the reconstruction process in your file for transparency.

How detailed does the "Void" log need to be? It needs to be detailed enough to satisfy an auditor that the void was legitimate. Simply writing "Error" is often insufficient. A better entry would be "Wrong item scanned – Manager override".

Can I keep my records in a spreadsheet? Yes, a spreadsheet is a perfectly acceptable way to maintain a Daily Sales Report, provided it is accurate and backed up regularly. If you use a spreadsheet, ensure it is password-protected if it contains sensitive customer data.

Who is responsible for the report? Ultimately, the business owner or director is responsible for ensuring the records are kept. However, you can delegate the task of writing and balancing the report to a trusted employee or bookkeeper.