Intuit has sent out a final reminder that all services and support for QuickBooks 2006 (United Kingdom Edition) will be discontinued as of September 30, 2010.
If you are a current user of Transaction Pro Importer from Baystate Consulting, you may benefit from these upgrade tips:
Transaction Pro Importer 4.0 Required
- Be sure you are running the latest release of Transaction Pro Importer 4.0. You can do this by clicking About/Check for Updates. If you are on an earlier major version of Transaction Pro Importer such as 2.0 or 3.0 you need to go to our upgrade page here: http://www.baystateconsulting.com/register/upgrade.asp. Also note that if you plan to run QuickBooks UK 2010 under Windows 7 you will need to upgrade to TPI 4.0 as that is the only version that will work with Windows 7.
- VAT Considerations: With UK 2005/2006 there was the ability to set the total VAT via the TPI field “Tax1Total” With the release of UK 2008 Intuit removed this field from the QBSDK and TPI lost the ability to set VAT directly.Note: This only impacts users that have the total VAT appearing in a column rather than a separate line item row in the data in their data file. If you are currently importing VAT from a separate line item row than you can ignore this section.Workaround 1 (Preferred): Use the “Sales Tax Code” field in TPI to set the VAT code for each line and let QuickBooks calculate the VAT for you.Workaround 2: Use the eCommerce option and map the VAT column to the “Sales Tax” field in TPI. Be sure to set your VAT item account and name to match on the eCommerce settings screen that appears in TPI. TPI will create a new line item with the VAT.
Workaround 3: Check the options “Do not add new Customers” and “Do not add new Items” on the TPI basic options screen. Then make sure your customers and items are setup with the VAT codes you want to use in your import file. This option is for users that want to let QuickBooks calculate the VAT but currently do not know or have VAT codes on each line of their import file. When importing the file with existing customers and items, QuickBooks will correctly calculate the VAT based on the settings for those entities.
- Multi-currency considerations: When importing transactions that contain multiple currencies, QuickBooks will determine the currency to use based on the currency set on the Customer or Vendor record, it is not necessary to specify the currency however it is possible to specify the currency if the Customer or Vendor record does not exist. You can also specify the Exchange Rate that should be used for that particular transaction. The exchange rate is the market price for which this currency can be exchanged for the currency used by the QuickBooks company file as the “home” currency