AAATEX’s TransImporter2012©


Import Transactions from Excel files into QuickBooks Desktop (Pro, Premier or Enterprise) or QuickBooks Online

This product is no longer available and replaced by our TransImporter4

Versions and Pricing (in US dollars)

 STANDARD
Common to All Editions
  • Works with QuickBooks Pro, Premier and Enterprise Editions
  • Creates Invoices, Sales Receipts, Sales Orders1 or Estimates1
  • Supports Customer Payments
  • From an Excel xls, csv or tab delimited text file
  • Easy and flexible mapping of columns
  • No IIF files
  • No need for Admin or single user mode
  • Can mark transactions that are pending1
  • Can create customers
  • Log of added transactions, customers, etc.
  • Can create items
  • Can have up to 10 description fields grouped together but separated with a character.
  • Supports custom fields for weight, location (i.e Bin #), etc.
  • Can use columns A-AZ
  • 1 License supports 1 QuickBooks Company (Diamond Edition supports Multiple QuickBooks Company).
For QuickBooks For QuickBooks Online Edition
$189+ $65/yr annual maintenance required after the 1st year $199+ $65/yr annual maintenance required after the 1st year

 SILVER

  • Standard Edition functions plus
  • Can check inventory quantity on hand and reject line or order.
  • Can lookup customer via account number.
  • Customer Payments by Invoice number, amount, etc.
  • Can update customer’s information
  • Creates Purchase Orders
  • Creates Bills
  • Create Time Tracking
  • Supports multiple Journal Entries formats
  • Can specify the Sheet Name or number
  • Can use columns A-AZ
  • Can do Sales Transactions and Purchase Transactions in the same run (same rows)
For QuickBooks year
$249
 + $100/yr annual maintenance required after the 1st

For QuickBooks Online Edition
$299 
+ $100/yr annual maintenance required after the 1st

 GOLD

  • Silver Edition functions plus
  • Match QuickBooks sub-items to QuickBooks full item name
  • Duplicate Order # checking
  • Customer Payments via multiple matching amounts
  • Dynamic Transaction types on a row by row basis
  • Folder monitoring – automatic importing if a file of a certain pattern has bee added to a specified folde.
  • FTP (File Transfer Protocol) so files can be downloaded from an FTP site
  • FTP Monitoring every nn minutes for files that match a pattern to be downloaded and imported
  • Profile (each profile is a separate set of settings).
  • Special processing (i.e Reversal or charge via journal entry), etc
  • Simple Parsing of cell data to extract parts of the data i.e from ‘Name:Customer Name’ only ‘Customer Name’

 

For QuickBooks
$399
 + $149/yr annual maintenance required after the 1st

For QuickBooks Online Edition
$399
+ $149/yr annual maintenance required after the 1st

 Platinum

  • Gold Edition functions plus
  • Group Expand (Expands the group to allow changing of prices, etc.). Not for QuickBooks Online
  • Assembly Expand (Expands the group to allow changing of prices, etc.) Not for QuickBooks Online
  • More to come
For QuickBooks
$699
 + $189/yr annual maintenance required after the 1st

For QuickBooks Online Edition
Not Available

Excel to QuickBooks DIAMOND

  • Gold Edition functions plus
  • Support for up to 5 QuickBooks companies (licensing). Need more contact us.
For QuickBooks
$999
 + $249/yr annual maintenance required after the 1st

For QuickBooks Online Edition
$999
+ $249/yr annual maintenance required after the 1st

Cloud Ready

but you must check with your Cloud provider for what they support or use ours.

Download trial or production version 

Click here for instructions to download a trial or production version.

(Trial limited to 30 transactions, apx 40 rows per execution)

 

1Not available on QuickBooks Online Edition

Non-Enterprised Editions are currently licensed by QuickBooks company name (unless otherwise stated). Therefore 1 license can be used for all users for a given QuickBooks Company.

Need a custom solution- we can customize our programs work for you.

 

Visa Mastercard Discover eCheck PayPal

Major Credit cards and e-Checks via PayPal. We also accept M/C, Visa, and Discover directly. Email/call us.

 

To View our return policies – Click here

 

Email us

 

Currently licensed by QuickBooks company name (unless otherwise stated). Therefore 1 license can be used for all users for a given QuickBooks Company.

If you are using Firefox the dropdowns and links may not work. If this occurs please use another browser. We have found that some anti-virus addons can be are causing the problem.