Import your Excel (xls, xlsx, xlsb, xlsm), CSV and tab delimited text files into QuickBooks using our TransImporter4^© for QuickBooks Windows Desktop
or our TransImporterQO^© for QuickBooks Online.

---

What's new in the new TransImporters^©

• Sub-account Lookup
• Assign Account types when the Account must be added
• Assign Master Account
• Lookup Replace for Expense Accounts
• Profile by Company Name (Diamond Edition)

 

See details for the TransImporterQO for QuickBooks Online click here but they are extremely similar.

No need to delete rows above the header row. Just adjust the settings to the Row for the header line and data start line.

Mapping can be to a Header Value i.e. Name, Date, Column i.e. A, B, E, etc. or a literal (must be enclosed in pipe characters |) i.e. |True| or |NET 30|.

See an image of it.

Cloud Ready

See the editions, pricing/purchase information

Features (our Edition have different features depending on your needs):

• No need for admin or single user mode for QuickBooks Desktop.
• Uses Excel file formats xls, xlsx, xlsb, xlsm, csv, tab delimited text or any Excel supported files types.
• Startup samples files of common transactions included
• With Excel Files you can use formulas, table lookups, etc.
• No IIF files or conversions to IIF files
• Imports Invoices, Sales Receipts, Estimates or Sales Orders¹ and more
• Can import Bills, Vendor Credits, BillPayments¹, Purchase Orders², Journal Entries, Time Tracking, Checks, etc. etc.
• Can create Customers, Items, Vendors, Classes, etc. if not in QuickBooks
• Mixing transaction types can be in the file identified via a column i.e. INVOICE, RECEIVE PAYEMNT, BILL, VENDOR CREDIT, etc.
• Can import Invoices and Invoice line items from Sales Orders¹
• Location/Department for QuickBooks Online.
• No Web Connector
• Can check Quantity on Hand and reject order or line item.²
• We can help you set it up
• Can use customer's account number as a lookup instead of using name.
• Flexible definitions of columns
• Map to column letters, column header values or literals so much less need to add columns to the file.
• Fast and Easy
• Can select Template¹
• Top unused file rows need not be deleted.
• Can select Class
• File Header is optional
• Can have a default customer if name or account number¹ not defined in QuickBooks.
• FTP Download of file (manual or automatic)
• Auto Deposit of Customer Payments¹
• Folder Monitoring
• Group and Assembly Expand to components¹

We can customize it for you to solve your Business Requirements.

See some screen images.

See the editions, pricing/purchase information

Download a trial or production version;

TransImporter4 for QuickBooks Windows Desktop 
TransImporterQO for QuickBooks Online

(trial limited to 20 transactions and 200 rows per program startup)

Requirements:

• QuickBooks USA 2004 Pro or better (2008 for AU, Canadian, NZ, or UK) for QuickBooks Desktop
• Windows 7, 8, 10, 2008, 2012, 2016
• Microsoft Office 2007 (Excel) or later for XLS types of files.
• Same machine requirements as QuickBooks^® for QuickBooks Windows Desktop versions
• For QuickBooks Online Internet Explorer 11
• Recommended Windows screen images set as smaller.
• QuickBooks License

¹Not available in QuickBooks Online

²Not currently available in the TransImporterQO but may be added upon request