Tax Detail Reports - Cash Net and Cash Tax - don

Legacy KB ID: 3610

Question

Why doesn’t the Tax Detail Report (Cash Tax) show all the transactions that are listed in the Tax Detail Report (Cash Net)?

Answer

QuickBooks is configured to record GST taxes into Tax Payable and reports are configured to access this account for tax collection/paid details.  You will encounter the above problem if your GST taxes are assigned to an account other than Tax Payable or to sub-accounts of Tax Payable.

Cash Net Reports will display correctly, but Cash Tax reports will not display any transactions.

 

Solution

The only way to have a correctly reporting Cash Tax Report is to have all tax amounts assigned to the Tax Payable account:

1.    Ensure that the Australian Taxation Office supplier’s tax agency tab is assigned to collect tax to Tax Payable:

a.    Supplier Centre > right click on Australian Taxation Office and select Edit

b.    Click on Tax Agency Info tab

c.    Ensure the two boxes at the bottom Track Tax on..... have Tax Payable

d.    Click on OK to save.

2.    Reassign transactions with tax assigned to the sub-accounts to Tax Payable by deleting each line in the transaction and re-inputting them.  When they are re-input the tax will be assigned to Tax Payable. 

 

Workaround

If there are too many transactions to reassign, then follow this interim measure until all existing transactions assigned to the sub-account are reported.

 

To display transactions in the Cash Tax Report (cash basis):

1.    Click on Modify Report and in the Columns box select Tax Amount;

2.    Select Filters tab;

3.    Under Account dropdown menu, select the all income/expense accounts;

4.    Click OK and you will see all sales transactions and item/expenses purchases.

5.    Print this report or export to Excel.

 

This report may not list all relevant transactions – balance sheet items that included tax are not listed.  You can filter again for all balance sheet items to capture other tax transactions.  (You will need to manipulate this report to get the relevant transactions).  These items need to be added to your first report.

 

Note:  part-payments of invoices and bills will be either fully reported or not reported at all:

·         Invoices and bills will be fully reported in the period the final payment is made. 

·         If payments span reporting periods, the first period(s) will not report the part-payment.

·         If the report is run after the end of the reporting period and after a final payment has been made in the next period, then the full amount will be reported in the first reporting period and not in later periods. 

You will need to identify part-payments and make the necessary adjustments to your totals. 


Additional Information

If you find that you have more than one supplier with a name relating to the Australian Taxation Office, like:

  • ATO
  • Aust Tax Office
  • Deputy Commissioner of Taxation

Then click here for KB329 for instructions to merge multiple tax agencies.

 


How did we do?

Sales transactions do not appear when generating the Tax Agency QuickReport

Unrealized (Exchange Rate) Gain & Loss Report does not refresh in Reckon Accounts 2023

Related Articles

Tax Detail Report shows only Cash Tax and not Cash Net on EasyStart
Tax Detail Report (Cash Net) not match The Tax Liability and Tax Summary Reports.
Tax Invoices appear under Purchases on a Tax Detail – Cash Net Report
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)