cancel
Showing results for 
Search instead for 
Did you mean: 
claudiascafe
Level 2

Enter receipt from seller with GST of 4.08 in spend of 258. Type in 4.08 need QB to work out full cost of GST-payable item, show balance enterable on GST free line. How

 
8 Comments 8
JamesDuanT
Moderator

Enter receipt from seller with GST of 4.08 in spend of 258. Type in 4.08 need QB to work out full cost of GST-payable item, show balance enterable on GST free line. How

How are you doing, Claudia?

 

I want to clarify a few things so I can give you the information you need. Are you trying to enter the taxable amount manually? Is the taxable amount inclusive or exclusive from the total amount?

 

Additional details would be much appreciated.

claudiascafe
Level 2

Enter receipt from seller with GST of 4.08 in spend of 258. Type in 4.08 need QB to work out full cost of GST-payable item, show balance enterable on GST free line. How

Hi, thanks so much for replying.  It's a simple thing, but I can't work out how to do it!  I buy things from say Coles and the total might be $258, but down at the bottom of the receipt is an amount, say $4.08, that is the GST component in the $258.  So I need to put a GST entry into Quickbooks and the remainder would be a GST free entry in the one transaction.  I'd be eternally grateful if you could explain how to do it.  Thanks heaps!

JamesDuanT
Moderator

Enter receipt from seller with GST of 4.08 in spend of 258. Type in 4.08 need QB to work out full cost of GST-payable item, show balance enterable on GST free line. How

Thanks for the detailed information, Claudia.

 

In Quickbooks Online for Australia region users, we cannot create a custom rate for sales tax.

 

As a workaround, we'll need to manually calculate the taxable and non-taxable amounts. Here's how:

  1. Click the Create menu (+) and select Expense.
  2. Enter the Payee and the Payment account.
  3. Enter the Payment date and method.
  4. Select Amounts are Inclusive of Tax.
  5. In the first line, enter the following information:
        • the expense account in the CATEGORY column. 
        • 44.88 in the AMOUNT column.
        • select GST on purchases (10%) in the GST column.
  6. In the second line, enter the following information:
        • the expense account in the CATEGORY column. 
        • 213.12 in the AMOUNT column.
        • select GST free purchases (0%) in the GST column.
  7. Make sure the total amount is 258.00.
  8. Click Save and close.

I added a screenshot as your guide to completely record the expense transaction.

Capture.PNG

Let me know how this goes.

claudiascafe
Level 2

Enter receipt from seller with GST of 4.08 in spend of 258. Type in 4.08 need QB to work out full cost of GST-payable item, show balance enterable on GST free line. How

Hi James, thanks so much for this, but I'm looking for a way not to have to use a separate calculator.  It can be three or four items that equal $44.88 (GST $4.08) and I don't want to add them up myself.  In Quicken 2004 (a really old program, but a good one!) it worked as it's own calculator.  I'd type in $4.08, pop in a code that says GST expense and Quicken would pop in $44.88 - simple!  Does Quickbooks have this feature?  If so, how do I use it?  Thanks for your continued help James and I really appreciate it!

JessT
Moderator

Enter receipt from seller with GST of 4.08 in spend of 258. Type in 4.08 need QB to work out full cost of GST-payable item, show balance enterable on GST free line. How

We're unable to do this reverse process, claudiascafe.

 

An expense item or account has to be entered first to calculate the tax amount, not the other way around.

 

If you have other questions about to your receipt, feel free to reply on this thread.

brad57
Level 1

Enter receipt from seller with GST of 4.08 in spend of 258. Type in 4.08 need QB to work out full cost of GST-payable item, show balance enterable on GST free line. How

Can someone tell me where this "Create" menu is. I have the same problem as Claudia.

Kass_B - Product Champion
Content Creator

Enter receipt from seller with GST of 4.08 in spend of 258. Type in 4.08 need QB to work out full cost of GST-payable item, show balance enterable on GST free line. How

Hi brad57,

 

Thanks for reaching out. The 'Create' menu has been updated since this question was posted. You'll find the option to create an Expense under the '+ New' button at the top of the menus on the left:

 

 

-Kass

 

 

claudiascafe
Level 2

Enter receipt from seller with GST of 4.08 in spend of 258. Type in 4.08 need QB to work out full cost of GST-payable item, show balance enterable on GST free line. How

Hi Brad!  It's Claudia and I'm wondering if it's okay to tell you what I do and then maybe that will help.  It's clunky, but it does work.  I look at my receipt and it says GST included in total is, say $2.28, but I also have many GST free items on the same receipt so the total I've paid is, say, $50.  I type into the amount box

$2.28 x 11 (the times symbol on the right hand side of my keyboard has an asterisk that looks like this * and that multiplies stuff).  The total will come up as $25.08.  Wait for it, I then type in the next line for GST free transactions $50 - $25.08 and that is then the total of GST free sales.  Gosh I hope that makes sense and it is cumbersome, but it's the only way I know how to do it.  I believe if it's a banking transaction that you automatically download and then reconcile, a button does appear that says "split", but I do manual reconciliation as Quickbooks reconciliation is way too clunky to rely on.  Anyway Brad, hopefully this helps and let me know if it's a little confusing!!!