Tax Liability Report showing no amount or 0.00 when there should be an amount

Legacy KB ID: 4930

Question

Why is the Tax Liability Report showing blank or 0.00 when there should be an amount?  The Cash Detail and Tax Summary Reports are reporting correctly.  This problem appears on both Cash and Accrual Reports.

Answer

This problem suggests that the Tax Item List suffered corruption on a recent upgrade and that the accompanying “sales tax reference numbers” that the Tax Liability Report depends on, are no longer correct.

Solution

1. Backup your company file
2. Rebuild the company file:
   1. Resort all Lists
   2. Rebuild the company file
   3. Verify the company file - ensure no errors detected
   4. View the Tax Liability Report - if the problem persists, then continue with the next steps.
3.  Export the Item List to an IIF file
   1. File > Utility > Export > Lists to IIF
   2. Tick Item List > OK
   3. Select a Location and Name the file (for example, Desktop > TaxItems)
   4. Click Save.
4. Open the IIF file in Excel
   1. Go to the location of the IIF file >, right click it > Open With > select Excel
   2. For usability, freeze panes on show Columns A and B
   3. In Column B, scroll down to the block of Tax Items in the INVITEM section
   4. Scroll across to Column BA – SALESTAXRETURNLINE
   5. Add or modify any missing or incorrect numbers for each Tax Item:

      1. TAX ITEM	NUMBER
         ADJ-P	8000
         ADJ-S	8000
         CAF	8005
         CAG	8000
         CAI	8003
         CDG	8000
         CDS	8004
         EXP	8005
         FRE	8005
         GST	8000
         INP	8005
         NCF	8005
         NCG	8000
         NCI	8003
         WET	8004
         WGST	8000

   6. f you have custom tax items (please note these are) then you will need to add the appropriate reference number for that type:
      1. 8000   10% GST applied
      2. 8003   Input Taxed
      3. 8004   Wine Tax
      4. 8005   other GST Free – EXP and FRE/NCF/CAF types
   7. Save and Close this IIF file, being careful to maintain the current file type (text file .IIF)
5. Import the modified IIF file into your company file
   1. File > Utilities > Import > IIF files
   2. Select your modified IIF file
6.  Check the Tax Liability Report.  It should show numbers in all fields. 
7. Create a new backup.

Need more help?

Ask the Reckon Community at: https://community.reckon.com/categories/reckonaccounts

Or Log a Support Ticket: https://www.reckon.com/au/support/