Increasing / Adjusting the Tax Amount in the tax column in QuickBooks QBi 2008/09

Legacy KB ID: 309

Question

How do I Increase / Adjust the Tax Amount in the tax column in QuickBooks QBi 2008/09?

Answer

*Note: If your Tax reporting is Cash basis, bills will need to be entered in at the time of payment.

In this scenario, the Bill is for $378.90 including GST.
The net amount originally entered is $344.44 and the tax is $34.46 as shown on the bill received from the supplier.
When you enter the transaction in QuickBooks, the net amount displays $344.44 but the tax amount displays $34.44 Fig.1

Fig.1


Create a Tax item for 100% tax amount for purchases and link it to the tax code. Fig.2

• From the List menu, select Tax Item List
• Click on Item and select New
• Choose Tax Item in the Type drop down list
• Enter a name for the Tax Item
• Enter a description if required
• Enter 100% in the Tax Rate (%) or Amt and select Australian Taxation Office in the Tax Agency
• Select Use this item in purchase transactions
• Select Goods and Services Tax in the Tax Return Line drop down
• Click OK

Fig.2


Create a Tax Code to link it with the Tax item. Fig.3

• From the List menu, select Tax Code List
• Click on Item and select New
• Enter a Tax Code
• From the Taxable Information, select the Tax Item you just created in the Purchase Tax Item drop down list
• Click OK

Fig.3


Create a Tax Item for a 0% tax amount for purchases and link it to the tax code. Fig.4

• From the List menu, select Tax Item List
• Click on Item and select New
• Choose Tax Item in the Type drop down list
• Enter a name for the Tax Item
• Enter a description if required
• Enter 0% in the Tax Rate (%) or Amt and select Australian Taxation Office in the Tax Agency
• Select Use this item in purchase transactions
• Select Goods and Services Tax in the Tax Return Line drop down
• Click OK

Fig.4


Create a Tax Code to link it with the Tax item. Fig.5


• From the List menu, select Tax Code List
• Click on Item and select New
• Enter a Tax Code
• From the Taxable Information, select the Tax Item you just created in the Purchase Tax Item drop down list
• Click OK

Fig.5


Now we need to increase the tax amount by 2 cents, therefore you need to enter 2 cents in the net amount on the second line using the 100% Tax Code.
On the third line, enter -0.02 in the net amount column and using the 0% Tax Code to reduce the net amount from the previous line. Fig.6

Fig.6


The Tax Summary report will show both tax codes as shown below. Fig.7

Fig.7


When configuring the BAS Report, you will need to select the three Tax Codes used on the transaction (NCG, 100% and 0%) in order for the figures to be correct. Fig.8

Fig.8


Once you have configured the BAS Report, the following figures will be displayed:

Supplies and Acquisitions – G11 = $378 Fig.9

Debits and Credits – 1B = $34 Fig.10

Fig.9 Fig.10


How did we do?


Powered by HelpDocs