'transaction out of balance' when using a CDC tax code

Legacy KB ID: 3598

Question

Why do I get a “transaction out of balance” error when posting POS transactions to QuickBooks?  These transactions use the CDC tax code.

Answer


This error can occur where a transaction has the following combinations of items:

·         The CDC tax code is used (a combination of CDG and WET);

·         A percentage discount has been involved

·         An item with GST tax code has a price override

The error occurs because the tax amount is different to what QuickBooks calculates.


This issue has been resolved in QuickBooks 2010/11.


Workaround for earlier versions

Before starting this workaround we recommend that you make a backup of your QuickBooks company file. 

Change the CDC tax code in the import file;

Import the file into QuickBooks

Change the tax code back to CDC

 

Detailed Instructions

 

1.    Open the error file for the failed post:

a.    The error file is titled QBErroryyyymmdd_hhmmss.iif

b.    It is located in the ImportErrors folder of the QuickBooks installation directory.  The default location is C:\Program Files\QuickBooks 2010-11\ImportErrors\;

 

2.    Right click it and select Open With;

 

3.    Select Microsoft Office Excel (or any Spreadsheet application);

 

4.    Go to the TAX column – column Q and change CDC tax code to another like WET;

 

5.    Close the file and select YES to “Do you want to keep the file in this format”;

 

6.    Open QuickBooks and import the modified error file:

a.    Click on File then Utilities, Import, IIF files and browse to the location of your error file;

b.    The default file and location is C:\Program Files\QuickBooks 2010-11\ImportErrors\ QBErroryyyymmdd_hhmmss.iif;

c.    Your data should import without error.

 

7.    On the top menu line click on Reports, Tax and select Tax Detail;

a.    Modify the date range for the date range of the imported POS transactions;

b.    Filter for the changed tax code (eg WET);

c.    Open each transactions with the changed tax code and change the tax code back to CDC; Save & Close.

 

How did we do?

Related Articles

Out of Balance error when changing the Tax Amount on a General Journal
Out of Balance warning when adjusting a previous Adjust QTY/Value on hand transaction
ADJ tax code appearing when not used under current tax transactions
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)