cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
For support running your business during COVID-19 visit quickbooks.com.au/COVID19businesssupport.
Highlighted
Level 1

How do I enter a GST inclusive journal entry so that I don't have to manually calculate the exclusive amount for each line?

 
6 Comments
Highlighted
Level 5

How do I enter a GST inclusive journal entry so that I don't have to manually calculate the exclusive amount for each line?

Hi, cjfranke 

For Purchases/Expenses under the Debits column enter the amount and under the GST column select the relevant GST rate on purchases this will automatically calculate the Credits column with the GST amount ( inclusive of GST/ Gross amount ).

For Sales  under the Credits column enter the amount and under the GST column select the relevant GST rate on sales this will automatically calculate the Debits column with the GST amount ( inclusive of GST/ Gross amount ).

Check the attached screenshot 

Comment back for further clarifications.

Highlighted
Level 1

How do I enter a GST inclusive journal entry so that I don't have to manually calculate the exclusive amount for each line?

It's the exact same thing I am trying to do/find for Journal Entries.
Highlighted
Level 5

How do I enter a GST inclusive journal entry so that I don't have to manually calculate the exclusive amount for each line?

For daily transactions best practice is to use standard workflow such as Invoices,Sales Receipts,Bills,Deposit screen etc which will ensure accurate reports and you have the options of selecting Inclusive of Tax OR Exclusive of Tax under the Amounts are field dropdown menu for the Journal entries this option is not available.
Highlighted
Level 5

How do I enter a GST inclusive journal entry so that I don't have to manually calculate the exclusive amount for each line?

Another available option to find the net amount / exclusive of tax amount is in the amount field enter the Gross amount / inclusive of tax amount and divide by 1.10 ( tax rate is 10% ) to get the net amount, this calculation can be performed in the amount field itself.
Highlighted
Level 1

How do I enter a GST inclusive journal entry so that I don't have to manually calculate the exclusive amount for each line?

Thanks - I didn't know the calc could be done in the amount field.
Highlighted
Level 1

How do I enter a GST inclusive journal entry so that I don't have to manually calculate the exclusive amount for each line?

Hi, but I still find it very time consuming considering if have have several lines for journal entries.. Would be great to have option to choose tax exclusive and inclusive optin.