Recording Total Daily Sales in QuickBooks Online With a Single Sales Receipt

Retailers and small-business owners using QuickBooks Online frequently ask how to record total daily sales without entering every individual transaction. The accepted community solution walks through a setup that captures the day’s gross sales, allocates the revenue across payment methods, and handles cash overages or shortages — all on a single sales receipt generated from a recurring template.

Why a Single Sales Receipt Works

Rather than creating dozens of individual invoices or receipts throughout the day, businesses can post one summary sales receipt at close of register. The receipt credits a daily sales income account for the gross amount, applies the correct sales tax, and then balances against payment-type line items that represent how money was actually collected — cash, checks, and each card brand accepted.

Setting Up the Supporting Records

The method requires a few one-time setup steps. First, create a customer named “Daily Sales.” This dummy customer serves as the recipient on every summary receipt and keeps daily totals segregated from real customer records.

Next, create a product category called “Daily Sales” to keep the associated service items grouped together. Under that category, set up individual product or service items for each component of the daily total:

• Daily Sales Income — the gross sales figure before tax
• Cash — the physical currency counted from the register
• Check — the total of paper check payments
• Visa/Mastercard — card payments processed through those networks
• American Express — Amex card payments
• Discover — Discover card payments
• Overage/Underage — a balancing line for cash shortages or excesses

Each item should be assigned to the “Daily Sales” category during creation.

Building the Recurring Template

The core of the workflow is a recurring sales receipt template. From the recurring transactions list, create a new template with the transaction type set to Sales Receipt and the scheduling type set to Unscheduled. Name it “Daily Sales” and select the “Daily Sales” customer.

Add each of the product and service items created above as line entries on the template. Mark the “Daily Sales Income” line as taxable if the business collects sales tax, and verify that the correct sales tax rate is applied. Save the template once everything is in place.

Because the template is unscheduled, it does not fire automatically. The user opens it manually at the end of each business day, selects “Use” from the action menu, and enters that day’s actual figures.

A Worked Example

The community solution includes a concrete illustration. Suppose a business reports $1,177.20 in total daily sales, comprising $1,080 in sales income and $97.20 in sales tax. The register count breaks down as follows:

• Cash counted: $327.00
• Check payments: $316.10
• Visa/Mastercard: $343.35
• American Express: $87.20
• Discover: $87.20

The cash register reading, however, is $16.35 short against what the system expected. That variance is entered on the Overage/Underage line. The payment-type lines — cash, check, and each card brand — are entered as positive amounts representing money collected. The overage or underage line is entered as a positive amount when the register is over or a negative amount when the register is short, which adjusts the total of the payment lines so they equal the gross sales income plus tax on the receipt.

When all lines are entered correctly, the sales receipt balances: the income and tax on the top portion equal the sum of the payment-method lines on the bottom portion, and the receipt can be saved.

Handling Bank Deposits

Card payments and check payments do not land in the checking account the moment the sale is rung up. The solution advises recording a bank deposit as soon as the merchant processor transfers funds for card transactions, and again when check payments are physically taken to the bank.

From the bank deposit screen, the user selects the appropriate bank account, enters the deposit date, and chooses the group of payments included in that particular deposit. This step reconciles the undeposited funds held from the sales receipt against what actually clears the bank, keeping the ledger accurate.

Practical Considerations

This approach is designed for QuickBooks Online and relies on features native to that platform — recurring transactions, product categories, and the bank deposit workflow. Businesses processing a high volume of small transactions, such as restaurants, convenience stores, and salons, tend to benefit most from a summary method like this. The trade-off is that individual customer detail is not captured on each sale; the receipt represents an aggregate daily total rather than customer-specific invoices.

For broader guidance on QuickBooks Online workflows, including sales receipt configuration and deposit matching, additional resources are available.