You can import data into QuickBooks from files that are in a number of different formats using Zed Axis. This article is a detailed description of the different formats and best layout for importing transactions. Included with the Zed Axis software is a folder of sample file for all the transactions types that Zed Axis can import into QuickBooks, these files are included in the Zed Axis program files located at C:\ProgramData\Zed\Axis 15.0\Sample filesFile format
The file needs to be in a Microsoft Excel spreadsheet or a flat text file that separates the data fields with a comma, tab, or pipe. Text files generally have a file extension of .txt, .csv (comma separated value), or .tab.
Data in rows
The data needs to be in rows so each row will import into QuickBooks as a line item. For example in the file shown below this is shows two invoices reference numbers 1005 and 1006. Invoice 1005 has only one line whilst invoice 1006 contains two lines. When importing transaction data into QuickBooks, Zed Axis will group lines together on the same transaction as long as they have the same reference number, this allows you to import multiple transactions in one file. If the transaction reference number is not provided then each line will import as a separate transaction and QuickBooks will automatically assign a reference number.
Headers and columns
The columns represent the data that you want to import into QuickBooks, we recommend that the first row of the file is a header row that contains a description of what is contained in that column. If the file contains a header row it makes the mapping process much easier, if there is no header row then default field headers will be shown such as Field1, Field2, Field3,. The order that the columns in does not matter since the mapping process you can map in any particular order. For more about mapping read this article.Data issues to avoid
Trouble logging in? Simply enter your email address OR username in order to reset your password.
For faster and more reliable delivery, add email@example.com to your trusted senders list in your email software.