Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am using Quickbooks 2010 UK Version and Excel 2010. I am trying to create and import IIF files using Big Red Consulting IIF Transaction Creator Pro. How can we create an IIF file for a bill that has VAT? VAT should appear in the Total VAT box and VAT code should be shown in the Split section. I managed to get the VAT amount shown but VAT code is not appearing. Please see the attachment.
Solved! Go to Solution.
Hello User04032022,
Welcome to the Community page,
We dont support iif files in Quickbook desktop, you can look at this article here that tells you more and status that we dont support iif files.
Hello User04032022,
Welcome to the Community page,
We dont support iif files in Quickbook desktop, you can look at this article here that tells you more and status that we dont support iif files.
I am not familiar with the app you are using. Afaik, as of 2008, Intuit dropped support for setting Tax1Total and Tax2Total via the QBSDK. Users that have been using these fields to set GST/PST (Canada) or VAT (UK) will not longer have access to these fields once they upgrade to QuickBooks 2008 or later. Our clients have been using another importer tool and prepare their data in XLS format. The workaround is using the Sales Tax Code field to set the VAT code on each line.
Customer | Transaction Date | RefNumber | PO Number | Terms | Class | Template Name | To Be Printed | Ship Date | BillTo Line1 | BillTo Line2 | BillTo Line3 | BillTo Line4 | BillTo City | BillTo State | BillTo PostalCode | BillTo Country | ShipTo Line1 | ShipTo Line2 | ShipTo Line3 | ShipTo Line4 | ShipTo City | ShipTo State | ShipTo PostalCode | ShipTo Country | Phone | Fax | Contact Name | First Name | Last Name | Rep | Due Date | Ship Method | Customer Message | Memo | Cust. Tax Code | Item | Quantity | Description | Price | Is Pending | Item Line Class | Service Date | FOB | Customer Acct No | Sales Tax Item | To Be E-Mailed | Other | Other1 | Other2 | Unit of Measure | AR Account | Currency | Exchange Rate | Sales Tax Code | |
Anne's Bakery | 01/09/2020 | 100 | Y | 15/09/2020 | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | (123) 456-7890 | Non | Cabinets | 10 | Cabinets | 1000 | Non | ||||||||||||||||||||||||||||||||
Anne's Bakery | 01/09/2020 | 100 | Y | 15/09/2020 | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | (123) 456-7890 | Non | Hardware | 10 | Hardware | 50 | Non | ||||||||||||||||||||||||||||||||
John's Barber Shope | 02/09/2020 | 101 | Y | 15/09/2020 | John's Barber Shope | 1 Main Street | Anytown | NY | 12345 | USA | John's Barber Shope | 1 Main Street | Anytown | NY | 12345 | USA | (999) 888-8888 | Non | Blueprints | 1 | Blueprints | 500 | Non | ||||||||||||||||||||||||||||||||
Main St Bank | 03/09/2020 | 102 | N | 16/09/2020 | Main St Bank | 1 State Street | Anytown | NY | 12345 | USA | Main St Bank | 1 State Street | Anytown | NY | 12345 | USA | (888) 888-8888 | Non | Door | 1 | Door | 300 | Non |
Explore this importer tool. If you need other clarifications, you may contact their Support.
https://transactionpro.grsm.io/qbd
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.