How To Record Total Daily Sales in QuickBooks Online

We will discuss here, how to record total daily sales in QuickBooks Online only by using a single sales receipt.

If you are using a different point of sale system, you can file a single sales receipt to report total daily sales in QuickBooks. Or if in case you are not invoice customers then saves your time, when keeping your income reports correct.

So, let’s proceed further and learn step by steps methods to record total daily sales in QuickBooks Online.

Steps To Record Total Daily Sales In QuickBooks Online

Check out the below steps and perform sequentially as described:

Step 1: Create a customer for daily sales

You will only use the customer account on your “end of the day” sales receipt.

  • Go to the Sales on the left menu, and later click on Customers.
  • Now click on New customer.
  • Insert the “Daily Sales.”
  • Click on Save.

Step 2: Set up accounts for daily sales

Be sure that daily sales accounts are set up directly. Doing this can benefit you a lot in correct reporting income. Check out the steps to set up daily sales accounts:

  • On the Toolbar, click on the gear icon.
  • Click on the Chart of Accounts below your Company
  • Click on the New on the top right.
  • Now, set up the accounts
NameCategory TypeDetail TypeDescription
Daily Sales IncomeIncomeOther Primary Income/Sales of Product IncomeFor tracking daily sales
Clearing AccountBankCash on handZero balance account for daily sales
Overage/Underage ExpenseExpenseOther Business ExpensesFor drawer shortages

Step 3: Set up items for daily sales

Go with these steps to set up a “Daily Sales” category to run your items arranged:

  • On the Toolbar, click on the gear icon.
  • Go to the Lists, and click on the All Lists.
  • Click on the Product Categories.
  • On the top right, click on the New Category.
  • Now give a name to the new category “Daily Sales.”
  • Click on Save.

Later, after fixing up the category, the following are the items:

  • On the Toolbar, click on the gear icon.
  • Go to the list, and click on the Products and Services.
  • On the top right, click on the New.
  • Now, set up the items.
  • Note: Always remember to choose the Daily Sales as Category for every item.
NameAccountDescription (will appear on forms)
Daily Sales IncomeDaily Sales IncomeDaily Sales Income
Overage/underageOverage/Underage ExpenseOverage/Underage
Visa/MasterCardUndeposited FundsVisa/MasterCard
American ExpressUndeposited FundsAmerican Express
CashUndeposited FundsCash
DiscoverUndeposited FundsDiscover

Step 4: Create a daily sales template

Every time you have to use this template to record total daily sales. Check out below steps:

  • On the Toolbar, click on the gear icon.
  • Go to the list, and click on the Recurring Transactions.
  • On the top right, click on New.
  • Later, go to the Transaction Type drop-down, and look for the Sales Receipt and click on it.
  • Now, give a name to your template “Daily Sales” and be sure that Type is Unscheduled.
  • Click on Daily Sales as the Customer.
  • Choose the items:
    • Daily Sales: Daily Sales Income
    • Daily Sales: Cash
    • Daily Sales: Check
    • Daily Sales: Visa/Mastercard
    • Daily Sales: American Express
    • Daily Sales: Overage/Underage
    • Daily Sales: Discover
  • Click on Save.

Important points to remember:

  • If you collect sales tax, mark the “Daily Sales Income” item taxable.
  • Be sure your sales tax rate is accurate.

Step 5: Record your total daily sales

Have your sales receipt template set up? Now you are able to record your “end of day” sales.

  • On the Toolbar, click on the gear icon.
  • Click on the Recurring Transactions, under the lists option. 
  • Now, look for your template, then select Use from the Action drop-down.

Step 6: Deposit your total daily sales

To record the exact amount of money deposited to the bank. This step is important to ensure that your deposit appears on your bank statement.

Points to Remember

  • As soon as you receive money from your merchant service provider, record the deposit for Visa, AMEX, or MasterCard.
  • Also, you have to record the bank deposit as soon as possible to deposit the check payment.

Steps to record the deposit:

  • Go to the + New option.
  • Click on the Bank Deposit below the other option.
  • Click on the bank account under the Account drop-down.
  • Insert the deposit date under the Date field.
  • Click on the payments group involved in the deposit.
  • Click on the Save.

Hope, after reading this article you can easily record total daily sales in QuickBooks Online only by using a single sales receipt. But if need any kind of help while performing the above steps then feel free to contact us by dialing our toll-free +1-855-441-4417 and get quick help from our expert team of ProAdvisors.

Connect With QuickBooks ProAdvisor Experts

Author: Editor Team
Wizxpert Authors & Editor team is blessed with the most qualified and experienced experts that support you with one of the best solutions for your queries related to Accounting and Bookkeeping. We are here from last 3 years in the assistance of our customers. Our main goal is to happy and satisfied viewers with our service. We are a team of 10+ members. Every member research on the unique issue and try to fetch out the relevant solutions of that particular problem. Our team always tries to get the update with every new release of Accounting and Bookkeeping solution, and also try our level best to convey that information in the very moderate form to our viewers.

Live QB Support:

Content is protected !!
Call Now