Step-by-Step Guidance: create sales receipt template with bundle and enter daily sales summary

In this free video tutorial, you will learn step-by-step instructions on how to create sales receipt template using bundle feature and also how to enter daily sales summary using that template. This video tutorial is specifically designed for retail, service and restaurant businesses. If you’re a bookkeeper or office staff whose job tasks include entering daily sales summary into QuickBooks, this is the video you must watch. Watch this video in its entirety and you will know how to handle daily sales summary the right away.









QuickBooks Online QBO Tutorial for Beginners – August 2016

How would you like to learn QuickBooks in 90 minutes? This FREE video tutorial is specifically designed for beginners in mind. You will learn QuickBooks Online the right way from the start. It covers all the basics you need to learn and offers some helpful tips. If you are looking for step-by-step educational guidance and ready to learn QBO, this is the one. And this video is produced by Top International QuickBooks Trainer, VPController.

How does one print a memo line on a check

When you enter a check (create + sign > check), there is a memo section on the bottom left the side of the check (see attachment below). If you have text entered in that memo area, it will print on a check.

check memo line
check memo line

However if you enter a bill (create + sign > bill), even if you’ve entered text entered in that memo area, it will not print on the check when select pay bills (create + sign > pay bills).

If you need to print a fixed memo line like the account number or a specific memo line message on a check print, you can select “account number” field on vendor information page (see attachment below). That way it will print the same memo line on specific vendor checks all the time.

vendor info acct no
vendor info acct no
check print with memo
check print with memo

If you found our answers useful then please contribute few bucks to support this forum. Thank you!





Thank you!






Sign up QuickBooks USA

#QuickBooks #QBO What is the maximum digits you can use for a check number

A check number can be of up to 21 digits.

To sign up QuickBooks for a free trial from US Canada UK and Australia, bookmark this URL link > www.newqbo.com/sign/

check number digits

 

Weekly Price Check US CA UK AU (Plus Plan)

USACanadaUKAustralia
us120x90ca120x90uk120x90au120x90
USD 23.97 per monthCAD 14.50 per monthGBP 15.00 per monthAUD 21.00 per month
USD 23.97 per monthUSD 12.01 per month
(Conversion)
USD 23.30 per month
(Conversion)
USD 16.60 per month
(Conversion)
LOWEST PRICE!

 

#QuickBooks Online

 

Recording Daily Sales

In QBO Essentials and Plus, you can create a Recurring Sales Transaction to be used at the end of each day to record your daily sales transactions.

This YouTube video will show step by step instructions on how to record daily sales in QBO. We highly encourage you to watch the entire video. You do not want to miss a step!

 

You will need to create a few new accounts in the Chart of Accounts:

Clearing Account (Category Type = Banking)
Income Account (Category Type = Income)
Overage/Underage Expense Account (Category Type = Expense)

To create new accounts (left blue navigation bar > transactions > chart of accounts > new)
bank clearing

 

You will need to create Products/Services associated with the following account types:

Sales categories = Sales Income account (make it taxable if your charge sales tax)
Cash= Undeposited funds
Checks= Undeposited funds
Visa/MasterCard = Undeposited funds
American Express = Undeposited funds
Discover = Undeposited funds
Overage/underage (for drawer shortages) = Expense account

To create products/services list (from the home page screen > company gear (upper right corner) > lists > products/services > new (upper right corner)

products services

 

You will also need to enable sales tax settings (if needed).
Sales tax = (left blue navigation bar > sales tax > add/edit tax rates and agencies). QBO will automatically create a Sales Tax Liability account. You do not need to create sales tax account in the Chart of Accounts separately.
sales tax

 

Now you need to create recurring Sales Receipt template (from the home page screen > company gear (upper right corner) > lists > recurring transactions > new (upper right corner).
recurring sales receipt

 

Now you are ready to create a Sales Receipt for each day based on end of the day Cash Register run (from the home page screen > company gear (upper right corner) > lists > recurring transactions > use under action column).
use recurring sales receipt
Note: By recording all of the Sales as positives and all of the Payments (Expenses & Cash Shortage) as negatives, the net amount of the Sales Receipt should be Zero.

In this example, at the end of the day, you have $1,000.00 in Sales, $80.00 in Sales Tax. The cash register count for Cash is $200.00, ‘Checks’ is 300.00, Visa/MasterCard is $390.00, American Express is $80.00, Discover is $80.00 and Cash Shortage is $10.00. The sales report that day shows $1,080.00 in Sales ($1,000 sales income plus $80 sales tax).
use sales receipt from recurring

 

In case of additional expense payments from the cash register, create new products/services mapped to appropriate expense category of Chart of Accounts.
additional expense payments

 

Finally, go to Undeposited Funds and record the deposit for the amounts actually deposited in the bank.
deposits

To do this (from the home page screen > create + sign > other > bank deposit). Select deposit date in QBO based on bank posting date.
 
Note to Simple Start users: since there is no “Recurring Transactions” feature available in Simple Start, you will need to follow all the setup instructions and create a Sales Receipt for daily sales. Transactions will be recorded the same way in QBO.
 

If you found our answers useful then please contribute few bucks to support this forum. Thank you!





Thank you!







300x250 logo on bottom and organge

How do I void an outstanding check from a previous period and re-issue a replacement in the current period without having to re-state financial statements?

I understand you are not asking just how to void and re-issue check. Your accounting question which involves few steps in QuickBooks online plus or desktop version for that matter.

For this example, let us say you wrote a check, void original check and reissue on 12/16/2013.

Vendor: AT&T
Date: 9/15/2013
Amount: $100.00
GL Account: Telephone Expense
It takes four steps process in order not restate your financials.

Step # 1

Write a Journal Entry (click “plus” icon > select journal entry from other menu)
Write a journal entry dated 9/15/2013
Telephone Expense (debit) — $100.00 (Name = AT&T)
Bank account (credit) — $100.00 (Name = AT&T)

Step # 2

Reverse journal entry on 12/16/2013 (that’s the day you are reissuing you new check)
Telephone Expense (credit) — $100.00 (Name = AT&T)
Bank account (debit) — $100.00 (Name = AT&T)

Step # 3

VOID (not delete) original check issued on 9/15/2013
Navigate the Check > click “More” button (located at the bottom) > enter replacement check number under description > select “VOID” > Save and close

Step # 4

Issue new check on 12/16/2013.
Make sure you use same GL account. In this example, its telephone expense account.
That should do it. Your telephone expense for September will not change. You will not see additional expense in December month.

NOTE:

When you do the bank reconciliation next time, in the Reconcile window, locate the entries that you created in steps 1 and 2 (one will appear on the Checks and Payments side, the other on the Deposits and Other Credits side). Click next to each entry to mark it with a check-mark.

What is the different between Expense form and Check form under Vendors heading in new Quickbooks Online?

Vendors - Enter expenses paid by debit card, card card, ATM, enter bill, pay bill
Vendors – Enter expenses paid by debit card, card card, ATM, enter bill, pay bill

Check form is to record written manual checks or to enter computer checks to be printed. This entry will reduce bank balance.
Expense form is to record all banking withdrawal type transactions except Check.

New QuickBooks Online Plus – How to enter various expenses in new QBO?

QuickBooks Online (QBO) Tutorial – Customer Invoice, Sales Receipt, Receive Payment, Bank Deposit