Blog

Home / quickbooks / Entering Meal Receipts with Tips into Quickbooks – CANADA and UK


Entering Meal Receipts with Tips into Quickbooks – CANADA and UK

Quickbooks auto-calculates taxes for you when you enter receipts. This is a cool time-saving feature. Where Quickbooks doesn’t do so well with its auto-calculation is when there are tips added to a receipt, such as with meals purchased at a restaurant.

To enter the proper amounts for that restaurant bill into Quickbooks, you need to do one manual calculation.

Let’s take a restaurant receipt as an example.

Entering a Meal Receipt with Tips into Quickbooks

If you pay with a credit or debit card, you usually receive two documents, the restaurant receipt and the credit or debit card receipt. You need both.

In Quickbooks, you need the following information from both receipts.

  1. For the total amount, use the total amount of the meal’s bill plus any tip (1)
  2. For the tax amount, use the total tax amount (2)
  3. For the subtotal, it is (1) – (2) = (3)

If you look at the Quickbooks screen shot, you’ll see where you enter these numbers.

Entering Meal Receipt with Tip into Quickbooks

I hope you found this quick tip (pun intended) useful!

Need a better way to do bookkeeping?

Our courses teach you how to set up, manage, and understand your business financials. You'll learn bookkeeping basics, a document management system, how to use accounting software, and how to keep your books up to date.

Spend less time worrying about bookkeeping and more time making smarter business decisions.

Become a Small Biz Doer Member for only $15!




4 Comments


Working From Bed Productions
February 18, 2013, 4:17 pm

This does not work if living in manitoba with 2 taxes

smallbizdoer
February 18, 2013, 7:58 pm

It actually does, you just have to change out the H for G when dealing with taxes. To be more clear, the PST is considered part of the cost of the meal, so the only tax you need to worry about is the GST (as you want to separate out the GST so that you can claim an input tax credit).

So, what you do is take the total amount of the bill, subtract the GST, and you will get the before taxes amount to enter into QuickBooks. Make sense?

Maggie
November 26, 2013, 8:27 am

Not sure if I'm missing something, but when I follow all of the steps I get a message that the transaction is not in balance and will not let me proceed. If I hit recalculate then it changes all of the numbers.

    smallbizdoer
    November 27, 2013, 2:53 pm

    Ah, I think I know the issue. Try doing the data entry in this order. 1, 3, 2 (looking at the steps above). You have to enter it in that fashion so that QuickBooks doesn't recalculate automatically and incorrectly.