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/

How did we do?

Accounts receivable aging reports show invoices as overdue when they are current, or as more overdue than they should be, according to terms set up.

Printer not activated -20 error when emailing or Save as PDF after upgrading to Windows 7 and later.

Related Articles

Incorrect total and tax amount when using timesheets with a bill and Amounts inc tax ticked.
No PAYE tax amount is being calculated.
Tax appears on Bill created from Foreign Purchase Order when there should be no tax
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)