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.









Why mark it billable to a customer and select “track returns for customers” box on a bank deposit

This has to do with reflecting accurate direct expenses related to customers on Income by Customer Report.

If you are depositing a vendor/supplier refund for an expense that was previously Billed to a customer, select “Track returns for customers” box and choose that same customer on the deposit and mark it Billable.

For example, if you buy a material for a customer’s job, you would bill the expense to the customer. But if the customer later returns the material to you and you return it to the vendor/supplier for a refund that you are depositing, you need to mark the deposit billable to that same customer and also select “Track returns for customers” box. Otherwise, it will show as customer billed for the material expense, and the vendor credit will not appear on Income by Customer Summary Report.


 





 
Here is an example of what happens when $1,000 billable purchase returned to the supplier for a refund and deposited that money in the bank. The goal is to show zero expense related to that customer.

SHOWING RESULT WITHOUT BILLABLE AND RETURNS FROM CUSTOMERS

deposit without billable-and track returns for customers
deposit without billable-and track returns for customers
income by customer summary without billable track returns from customers
income by customer summary without billable track returns from customers

SHOWING RESULT WITH BILLABLE AND RETURNS FROM CUSTOMERS

deposit with billable and track returns for customers
deposit with billable and track returns for customers
income by customer summary with billable track returns from customers
income by customer summary with billable track returns from customers

 
WATCH VIDEO
QuickBooks Online Plus: Track returns for customers box on Deposit Form


 





 

How do you apply customer payment that has a merchant fee to an invoice in QBO?

You will need to group both your deposit and fee together so your deposit in QBO matches the bank deposit that was made in real life.

Here’s how to handle it in QBO at this time:

RECEIVE PAYMENT

  1. Create an Invoice for your customer as you normally would.
  2. From the home page screen, click the Create icon (+) when you’re ready to receive the payment from your customer.
  3. Choose “Receive Payment” from the dropdown that appears.
  4. Fill out the Receive Payment as you normally would, but ensure the Deposit to field reads “Undeposited Funds” account.
  5. Click Save and close.
receive payment deposit to uf
receive payment deposit to uf

 

BANK DEPOSIT

  1. From the home page screen, click the Create icon (+) when you’re ready to get the deposit, minus the fee, in your bank account.
  2. Choose Bank Deposit (under Other) from the drop-down that appears.
  3. Check off the payment from this customer (and any other payments in the batch).
  4. In the Add New Deposits area, enter in the fee as a negative number, so it reduces the overall deposit total.
  5. Click Save and close.
payment minus fee
payment minus fee

This will then match the deposit made to your bank account and record the proper account.

 

WATCH VIDEO

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.

I have already received payments in QBO from multiple customers. How to make them match with a single deposit I see in my bank feed.

You’ve two ways to match with bank feed deposit.

1) Match it directly from the bank feed downloaded transactions.

Select a row for deposit in question. The row expands to show you “Find other matching transactions” button. Once you click this button, you will see a long list of possible match transactions. To easily locate your deposits, change payment date as you’ve recorded. Select payments (type = payment) to match with bank feed deposit amount. Make sure difference is zero. Save. Done.

find other matching transactions1
find other matching transactions1

2) Manual. This will take few steps, but you will see green MATCH sign once done.
a) Go back to “Receive Payment” (create+ sign > customer > receive payment > upper left corner clock, locate payment) screen for customer payment you’ve already recorded and change Deposit to: “Undeposited Funds” instead of a bank account. Do the same for other customer payments that you want to match to a batch deposit.
b) Bank Deposit (create + sign > other > bank deposit) – check existing payments from the list to match batch bank deposit. Make sure to check correct bank account if you’ve multiple bank accounts. Save. Done. Save and Close.
c) Go back to banking center (bank feed) and now you should see green Match sign for that deposit. Click Match. It should disappear from the list.

Note: #2 is recommended process in QBO if you’ve merchant card payments or use bank deposit slip from depositing checks from various customers.

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





Thank you!






Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA





QuickBooks Canada








#QuickBooks #QBO How do I get separate payments from different customers to show up as one deposit as it does when I deposit it in the bank?

On Receive Payment screen (create + sign > customers > receive payment) > select deposit to: undeposited funds > choose invoice and payment amount > save

Next step > On Bank Deposit screen (create + sign > other > bank deposit) > select customer payments > match total payment to bank deposit > save

If you are downloading bank transactions > banking center (left navigation bar > transactions > banking) > click deposit in question > deposit transaction screen will expand > select “Find Match” > select transactions (payments) to match deposit amount > save

Click on the screenshots below to enlarge them
deposit to undeposited funds1

deposit to undeposited funds2

deposit1 match uf

deposit1

deposit2 find match

deposit3 match transactions

deposit4 posted in quickbooks

 

#QuickBooks Online

 

What do I call making a credit card payment with checking account? Expense Type? Transfer Type?

To transfer fund from bank checking account to credit card account as payment:

  • From the home page screen > Create + sign > Other > Transfer
  • Transfer Funds FROM = Bank Checking Account
  • Transfer Funds TO = Credit Card Account

To enter credit card expenses:

  • From the home page screen > Create + sign > Vendors > Expense
  • Choose a payee
  • Select “Credit Card account” from drop-down list (Importante)

Transfer

Expense 3456

How to print a deposit slip and deposit summary in new QuickBooks Online (QBO)?

In order to print, from the homepage screen

  • Select create (+) sign
  • Select “Bank Deposit” “under “Other” heading
  • Go to small clock icon on top left corner and select “Recent Deposits” slip and summary you want to print
  • Select Print at the bottom middle
  • Select “Print Deposit Slip and Summary” or “Print Deposit Summary Only”
  • Select “Setup and Alignment” feature in order to test

Note: In order to print “Printable Deposit Slips”, you will need to purchase special printed form from Intuit, which is not cheap. Print alignment feature is not available (or do not work) at this time.

Print deposit slip
Print deposit slip

New QuickBooks Online (QBO) – Print Checks help video