FAQSearchEmail

Baystate Consulting 

QuickBooks Import/Export Utilities  
 

HomeProducts | Contact Us | Support   

01 Transaction Pro Import Wizard 2.0
Import Transactions into QuickBooks from any Excel or Text File

Transfer Transaction Data to QuickBooks from any Text File:
 
Rating: 5/5 stars Rated 5 Stars by QuickBooks Users - Read Reviews

Click Here to Purchase for only $199.95

See a movie of Transaction Pro Importer in action! Movie Demo

From within the Transaction Pro Wizard, you can automatically import QuickBooks bills, checks, credit card charges, credit memos, deposits, estimates, invoices, journal entries, purchase orders, receive payments, sales orders, sales receipts, and time tracking from any Excel or text file (such as a CSV or tab delimited file - More information about the type of file you need to use can be found here). Easy configurable field level mapping gives you complete flexibility and control in importing your data. Transaction Pro will even enable you to edit your data prior to sending it into QuickBooks.

Save Time By Entering Data Once:

Save time by eliminating duplicate data entry from orders gathered from web sites or other sources.

Want an easy way to import your transactions into QuickBooks? The Transaction Pro is the solution you’ve been looking for. Wizard interface provides simple step-by-step instructions and field-level mapping of your data. Quickly import an Excel or text file as a QuickBooks bill, check, credit card charge, credit memo, deposit, estimate, invoice, journal entry, purchase order, receive payment, sales order, sales receipt, time tracking, or vendor credit. Automatically adds new accounts, customers, jobs, items, and classes. Supports comma, tab, and pipe delimited text formats. Edit existing data before exporting to QuickBooks in program grid. Supports sales tax codes for each line item.

eCommerce Features Integrated into TPI 2.0: Map shipping, handling, discounts, and sales tax to QuickBooks fields to be added as transaction lines.

Supports the Following Transaction Types:

Bills
Checks
Credit Card Charges
Credit Card Credits
Credit Memos
Deposits
Estimates (Quotes)
Invoices
Journal Entries
Purchase Orders
Receive Payments
Sales Orders
Sales Receipts
Time Trackings
Vendor Credits

Version 2.0 adds these additional features:

Support for Excel files as well as text delimited files
Stronger validation before import: TPI now sets all import data field lengths to the maximum allowed by QuickBooks. TPI also checks for fields to be in the proper format. This almost completely eliminates all data validation errors when importing the file into QuickBooks.
Exception File for failed Transactions: Ability to output unsaved transactions to an exception file. This exception file can be used to re-import the failed transactions.
Load and save unlimited map files for each transaction type
Ability to skip transactions with reference numbers that already exist in QuickBooks
Ability to send a default value to a QuickBooks field instead of mapping to a field in import file
Ability to set record terminators (CR/LF, CR, or LF)
Integration with e-Commerce Edition features. Now one version of TPI
Options screen to set all program options in place of command line options

Click one or more of the images below to see actual screens from the program

Step 1 - Select Your File Step 2 - Set Options Step 3 - Review Input File
Step 4 - Map Fields Step 5 - Review Mapped Data Step 6 - Item Settings

Free installation support. Customizations available - please request a quote. We can customize a turn-key solution for your organization.

Designed for use with QuickBooks®

Includes: Installation and setup assistance. Single user license.


Download working demo -
Limited to working only with QuickBooks sample product based company
(Rock Castle Construction)

Requirements: QuickBooks 2003 (US, CA), 2005 (UK, AU) or newer installed on the machine.
Yes, it works with QuickBooks 2008!

A valid email address is required to download the demo. Enter your email address then click submit. A link to download the software will be sent to this email address.


Click Here to Purchase for $199.95

Questions?
Baystate Consul
ting: 781-932-1133
sales@baystateconsulting.com

 

Contact us today for a free consultation: info@BaystateConsulting.com or 781.932.1133