Sales Tax and IIF trns import has been changed


K

klunk

We have an application that has been running perfectly
for 5 years which creates an IIF file of INVOICE transactions
which is then imported to QB. We had used it with QB99
and QB2001.

With the recent end of Payroll updates for QB2001, we
upgraded to QB2004 at the end of February. Everything
"seemed" to go smoothly, but we just started doing
our Calif. Sales Tax report and the Tax Collected amount
on the Sales Tax liability seemed short by a significant
amount. Digging into things, I found that it is caused by
the Taxable and Non-Taxable sales totals being wrong
in QB.

It used to be you could use Taxable Invoice Line Items
but set the overall invoice to Non-Taxable and it was
tracked correctly.

Now, even with the Invoice set to Non-Taxable, and the
Invoice not having any tax, any Invoice Line Items that
are taxable get included in the Taxable sales total.
Brilliant! What is the point in that?

Now to go through 2 months worth of Invoices in QB
and flip each line item on a non-tax invoice to non. bleh.
 
Ad

Advertisements

K

Karl Irvin

Intuit just released an update to QuickBooks (R5). It fixes the IIF problem
with blank descriptions. I don't know if it fixed your problem or not.
 
Ad

Advertisements

K

klunk

Thanks for the heads-up on the QB2004 patch, Karl.

After more investigation, this problem isn't really
caused by the IIF import -- it is a complete behavioral
change on the part of QB when Tax Codes were
introduced in QB2002.

The "customer tax code" on an Invoice no longer has
any meaning other than to set the default for the
customer. It does not set the whole invoice to non-tax
as the behavior in QB2001 and prior.

When a data file is upgraded from the earlier version,
all the existing invoice transactions are changed to
the new behavior (line items are set to NON if the
invoice is taxable field for the trns is true). However
the IIF import process does not make this correction.

Thankfully we still have the source code to the IIF
producing application and made the change there.

I guess we'll have to move to the SDK to get access
to the Tax Codes anyway...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top