Import statement charges into QuickBooks

You can import statement charges from text files or from Excel spreadsheets directly into QuickBooks using the Zed Axis software. 
  1. Download and install the Zed Axis software on your computer
  2. Open your QuickBooks company file as Administrator and open Zed Axis
  3. Select your text file or spreadsheet which contains the statement charges that you want to import.
  4. Set up the a Mapping of the columns in your statement charges import file to the corresponding fields in QuickBooks, as shown below.
  5. Click Import and your statement charges will be directly added to your QuickBooks company file.

For more information about importing statement charges into QuickBooks, search the Knowledge Base, watch the movies in the Learning Centre, or raise a ticket with Zed Support.

Sample statement charge import file

The following fields are the principal fields when importing statement charges into QuickBooks.

QuickBooks field  Type  Description 
 CustomerFullName  Str209 MANDATORY FIELD - Customer Full Name as appears in QuickBooks ie ACME Inc:Project 101:Job A ,colons are used as a separators. If Axis cannot find a Customer then it will create a new customer record.
 TxnDate  Date The date of the statement charge.
 RefNumber  Str11  Reference number for the statement charge
 ItemFullName  Str159  Item being sold
 InventorySite  Bool  Location of the item being sold
 Quantity  Quan  Number of items sold
 UnitOfMeasure  Str31 The name of the unit of measure selected from within the items available units more on importing units of measure
 Rate  Price The rate or price of the item. If not mapped QuickBooks will use the default rate for the item.Decimal values include amounts, quantities, and percents. can be positive or negative
 Amount  Float The monetary amount
 Desc  Str4095  The description on the charge
 ARAccount  Str159  The accounts receivable account in QuickBooks, if not mapped will default to QuickBooks default AR account
 ClassFullName  Str159  Full name of the class
 BilledDate Date The date when the customer was billed
DueDate Date The date payment is due
 OverrideItemAccount  Str50  Item linked account to use


Add Feedback