How to export data from QuickBooks Online to Sage Handiledger

DRAFT PENDING AXIS V12 RELEASE

Before exporting your General Ledger data from QuickBooks Online to Handiledger please check the following items:

You have enabled Account Numbers in your QuickBooks Online company file (Company Settings > Advanced > Chart of Accounts and Enable account numbers = On)
You have entered account numbers for all of your Accounts and they have an Account Number that matches the equivalent account in Handiledger (ie Sales = 0500)

If you are an accountant or Intuit Pro Advisor who has clients who use QuickBooks Online and Sage HandiLedger for

Export your General Ledger data from QuickBooks Online in HandiLedger file format

Open Zed Axis and connect to QuickBooks Online
User selects the Export tab
User Selects the Reports data type to export and then the report type as General Ledger
Select the date range filter for the period of data you want to extract the data typically that would be the last financial year
Click Get and the data is shown in the preview form
Select the HandiLedger format for saving then saves the text file.

Import your General Ledger data into Sage HandiLedger

Select Tools and then Import Data from an ASCII File > General
On the Import Entries screen click the File button, and select the file that was exported from QuickBooks Online
If this is the first time you have imported you will need to set the Import Field Mappings to the fields in Handiledger (see the recommend map in the table below), if not you can select Load and the mapping that you previously used.
Click Run to import the data into Handiledger, once complete you will see a summary of the records imported
You can review the imported entries, prior to committing to the client ledger, click Close to post the entries and then Yes

Recommended Map for importing QuickBooks Online General Ledger details into HandiLedger

HandiLedger Field	Map	Description
Account	5	The equivalent HandiLedger Account Number (4 digit max)
Batch	3	Reference number for the transaction
Cash
Closing
CreditAmount	12
Date	1	Date of the transaction
DebitAmount	11
Description	4 or 6	Description or name of the GL Account
DrCr
ExclAmount
Opening
Presented
Quantity
Reference	3	Reference number for the transaction
SignedAmount
Spare
Sub
Tax	10	Tax amount
TaxCode	9	The tax code (translated)
Transaction	3	Transaction type
Type	2	Reference number for the transaction

Article ID: 284, Created: 5/4/2016 at 5:27 AM, Modified: 8/16/2024 at 4:43 AM