How to import payment items into QuickBooks desktop

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

QuickBooks fieldTypeDescription
NameStr 31Mandatory: Name of the payment item
Bar Code ValueStr 50Bar Code to use for the payment item
Is ActiveBoolWhether the item is active or not (True or False)
Class Ref Full NameStr 159Full Name of the class or category
Item DescStr 4095Description for the payment item
Deposit To Account Full NameStr 159Bank account to deposit the payment too
Payment Method Full NameStr 31The payment method used

Add Feedback