Updated
9 min read

If you run a retail business or regularly handle multiple customer payments each day, manually recording each transaction can quickly become tedious and time-consuming. That’s where learning how to record total daily sales in QuickBooks Online can make a real difference. Instead of logging every individual sale, QuickBooks Online allows you to enter a single daily sales summary. This not only streamlines your bookkeeping but also provides a clear, organized snapshot of your daily income.
For businesses that handle multiple sales transactions throughout the day, it’s important to stay on top of your bookkeeping. Instead of entering each individual sale, you can record daily sales in QBO by summarizing your total sales, including different payment methods, discounts, and taxes. This approach not only saves time but also ensures your financial records remain accurate and easy to manage. To keep your books up to date, make it a daily habit to record daily sales in QuickBooks Online at the end of each business day.
In this blog, we will explain how to record your daily sales in QuickBooks Online, helping you maintain consistent and reliable bookkeeping while focusing on running your business. So, let’s begin!
Businesses that deal with multiple transactions every day can benefit from recording their total daily sales in QuickBooks Online. Rather than entering each sale individually, summarizing your daily activity allows you to keep clean, accurate, and streamlined financial records. Here are some of the key benefits of this approach.
You can improve productivity, reduce errors, and maintain more organized books by recording daily sales summaries. This method ensures that your accounting stays efficient, accurate, and integrated with your day-to-day operations, regardless of whether you run a busy retail store or a small cafe.
Need help recording total daily sales in QuickBooks Online?
Contact us today for expert support and step-by-step guidance—our team is here to help you get it right!
Once you understand the benefits, the next step is to record daily sales in QBO by creating a summary of your total sales, payments, and other key details. Follow these steps to enter daily sales in QuickBooks Online and ensure your books stay accurate and up-to-date.
The customer account will be used exclusively for your end-of-day sales receipts.
Setting up your daily sales accounts properly ensures accurate income tracking and smoother financial reporting. Creating these accounts is as follows:
| Name | Category Type / Account Type | Detail Type | Description |
| Daily Sales Income | Income | Other Primary Income / Sales of Product Income | For tracking daily sales |
| Clearing Account | Cash and cash equivalents | Bank / Cash on hand | Zero balance account for daily sales |
| Overage and Underage Expense | Expense | Other Business Expenses | For drawer shortages |
Set up a dedicated “Daily Sales” category to organize your sales items:
Create your Daily Sales category and then set up your items:
| Name | Account | Description (will appear on forms) |
| Daily Sales Income | Daily Sales Income | Daily Sales Income |
| Overage/Underage | Overage/Underage | Overage/underage |
| Check | Check | Check |
| Visa/MasterCard | Undeposited Funds | Visa/MasterCard |
| American Express | Undeposited Funds | American Express |
| Cash | Undeposited Funds | Cash |
| Discover | Undeposited Funds | Discover |
Record your daily totals more easily by creating a reusable sales receipt template.
Note:
– Identify “Daily Sales Income” as taxable if your business collects sales tax.
– Check the accuracy of your sales tax rate.
The end-of-day totals can be logged once your template is set up:
A sample daily sales receipt looks like this:
The structure helps you maintain neat, easy-to-reconcile books while accurately recording every day’s income.
To ensure your records match your bank statements, enter the amount you actually deposited into your account.
Tips to Keep in Mind:
To record the bank deposit:
Do you need a visual? Below is a sample deposit breakdown.
By following these steps, you can ensure your daily sales are accurately recorded and your financial records are clean and organized. It simplifies reconciliation and provides a clearer picture of your business’s performance when you track and deposit sales consistently.
In a nutshell, entering and recording daily sales in QuickBooks Online is more than just a good practice. It helps businesses stay organized, track income accurately, and match deposits to bank statements without confusion when you use this method consistently. Summarizing your daily sales into one clean entry simplifies your accounting workflow, minimizes errors, and saves you time. This approach also ensures that all types of payments are accounted for, including cash, checks, and credit cards. Any business with a high volume of sales can benefit from using this system, whether it’s a retail store, a restaurant, or any other business.
By choosing to record daily sales manually in QuickBooks Online, you gain valuable insights into sales trends, peak business hours, and customer behavior, helping you make smarter business decisions. Plus, maintaining accurate daily records ensures you’re always prepared for tax season and audit reviews. With QuickBooks Online’s powerful tools and features, you can build consistent, reliable financial records that support the long-term growth of your business.
Follow these steps to find your total sales in QuickBooks Online:
1. From the left menu, select Reports.
2. Type “Sales by Product/Service Summary” or “Sales by Customer Summary.”
3. Set the desired date range for the report.
4. To view total sales, click Run Report.
The Profit and Loss report gives you an overview of income, including total sales during a given period. Making informed business decisions is made easier with these reports.
Follow these steps to get a sales report in QuickBooks Online:
1. Access your QuickBooks Online account.
2. Click on Reports in the left-hand menu.
3. Type and select a report such as:
– Sales by Customer Summary
– Sales by Product/Service Summary
– Sales by Day
4. Choose the date range you prefer.
5. To generate the report, click Run Report.
The report can also be customized by filtering columns, grouping data, and exporting it to Excel or PDF.
When using a point-of-sale system or tracking sales elsewhere, you can enter a daily sales summary instead of recording each transaction separately.
Businesses can summarize all transactions for a day into one sales receipt by recording daily sales. In addition to reducing data entry, this method keeps financial records organized and simplifies reconciliation. Financial reporting and tax preparation are made easier by accurate tracking of income and providing a clear picture of daily business performance.
Use a Sales Receipt or Journal Entry in QuickBooks Online to manually record daily sales. Enter the total sales, payments, and taxes for the day. In this way, you can maintain accurate records without having to create individual sales transactions. Summary reporting is ideal for retail or POS systems.
On this page
Have a QuickBooks® question? Our ProAdvisors can help. QAsolved is not affiliated with Intuit.