Import or export transactions from Excel or text files into QuickBooks

Import Module - Saves you hours in entering transactions into QuickBooks

Supports a wide range of import file formats - your import data can be Microsoft Excel (2007 or earlier) format, or a text file (CSV and Tab).

Supports the full range of transaction types - if you need to import transaction data into QuickBooks then you can choose from the extensive list of transaction types including: Invoices, Sales Receipts, Sales Orders, Estimates, Credit Memo/Adjustment Notes, Receive Payments, Deposits, Purchase orders, Inventory adjustments, Bills, Vendor credits, Bill Payment - cheque, Bill Payment - credit card, Time Entries , Supplier Credits, Cheques, Credit Card Charges, Credit Card Credits, Journal Entries and Price Level lists.

Supports a wide range of fields - we have access to the full set of fields available when importing transaction data into QuickBooks. If you can't find the field you need then let us know and we will add it.

Intelligently creates items, customers, or jobs if they are not in QuickBooks - if Axis finds that a customer, vendor or item is not yet setup in QuickBooks it will create it for you during the import saving you even more time.

Set up a constant – you have the option to select a constant value like a date or a class that can be applied to all transactions. Just specify the constant in the mapping and it will be added for all the transactions that are included in that import. You can even save the constant as part of the saved mappings options.

Preview your data before you import it into QuickBooks - before you commit your import to QuickBooks you can preview the transactions and edit those if you need to.

Powerful data validation - finally Axis will check your data before importing into QuickBooks to ensure that it is in the format that QuickBooks can accept, if it finds an error it gives you the chance to correct it and reattempt the import.

Clear and concise error reporting and handling - with the error reporting feature you open a log file to examine the issue that is causing the problem and the data row that was rejected so that you can reattempt the import using only the data that was rejected.

Convert amounts from including tax to excluding tax – if you have QuickBooks and have been using the Australian or UK versions of QuickBooks and been unable to import data where amounts are including tax now Axis will automatically convert those to excluding tax before import.

Import transactions into MYOB – If you use MYOB Accounting software you can now import, orders, quotes and invoices from text files or spreadsheets into MYOB. Create customer records if they don’t already exist in MYOB

Export Module - Makes exporting transactions from QuickBooks easier

Export transactions from QuickBooks – now with a few click you can export transactions from QuickBooks into spreadsheets or text files

Export only transactions with an open balance – You can select to export only those transactions with and open balance by selecting the export and filtering by paid or unpaid

Select only the transactions you want - Choose from Filter for date ranges or references numbers to extract only the transactions you want.

Supports a range of export transactions types - if you need to export transactions from invoices, sales receipts, credit memos, receive payments, bills, bill payment - check, bill payment - credit card, check, credit card charges, journal entries, time entries, and price levels lists.

EDI Module - Adds Powerful advanced eCommerce Features

Automatically monitor a folder for new messages - you can set up Axis to automatically watch a folder for new import files according to your specific criteria. Matching files are then retrieved and added into the Axis inbox ready for processing saving you time

Automatically process import files in the background - as new files arrive in the inbox Axis can be set up to automatically process those in the background and import into QuickBooks or MYOB using a predefined mapping.

Send and Receive Transactions - When you need to send or receive business transactions such as purchase orders, sales order or invoices electronically from QuickBooks or MYOB then the new EDI module in Zed Axis can help. The new module allows you to setup trading parnters (supported Partners only, for addition partner support please contact support), send and receive messages into a familiar inbox and outbox.

Watch the movie

Try it out free for 30 days, then all you need to do pay online to continue using it

Online support

Free access to our Support Portal, search our knowledge base of hundreds of support articles, raise a support ticket or chat live with one of our support team.

Annual support and Maintenance Package

Subscribe to the annual maintenance and support plan and get 4 free live support incidents and any upgrades or updates during the year.

Telephone Support

For you initial 10 day period we provide free telephone support to assist you to set up and configure your new software. After that you can purchase a support incident

System Requirements

QuickBooks 2007 - upwards,  Pro to Enterprise Country editions US, Canada, UK

QuickBooks 2008/09 - Upwards,  Pro to Enterprise Country editions , Australia, New Zealand, Singapore and South African versions

Windows XP, Vista.