Import statement charges into QuickBooks

Overview of importing statement charges

In QuickBooks Desktop a statement charge is You can import statement charges from text files or from Excel spreadsheets directly into QuickBooks using the Zed Axis software.

Follow these steps:

  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.

More help

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

QuickBooks field Type Description 
 CustomerFullName Str209MANDATORY 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 DateThe 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 Str31The name of the unit of measure selected from within the items available units more on importing units of measure
 Rate PriceThe 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 FloatThe 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
 BilledDateDateThe date when the customer was billed
DueDateDateThe date payment is due
 OverrideItemAccount Str50 Item linked account to use