Once your data and transactions have been finalized in Sage Business Cloud Accounting, you are ready to export to HandiLedger and HandiTax for reporting and BAS submission respectively. At this stage, the integration with HandiLedger & HandiTax is one way only. The data flows from Sage Accounting to Handisoft, but not the other way around.

Please ensure that all transactions and any additional journal entries have been entered and finalized before exporting to HandiLedger/Tax.

*The latest version of HandiLedger and HandiTax must be installed.

1.                 Linking Sage Accounting to HandiLedger

We will first need to link your Sage Accounting account to HandiLedger. This is a one-time process, unless you have changed your Sage Accounting login credentials.

1. Open HandiLedger
2. From the Options menu, choose Sage Accounting
3. Enter your Sage Accounting login username (email address) and password. Click OK.

 

2.                 Linking HandiLedger Entity to corresponding company in Sage Accounting

Note	If the company/entity does not already exist in HandiLedger, create the company. To view a list of linked entities, go to Reports  Sage Accounting Clients in HandiLedger.

In the Entity Details screen, click on the ellipsis button for the Sage One field then select the appropriate company.

With the entity selected in HandiLedger with the correct financial year, you may now import from Sage Accounting.

3.                 Mapping Sage Accounting GL with HandiLedger GL

Before importing data from Sage Accounting into HandiLedger, you need to map its chart of account with the HandiLedger general ledger first.

1. Click in the middle menu bar to select the client
2. To view and edit the mapping, go to View  Sage Accounting Accounts

1. Review all mapping rules and ensure all GL accounts (on the left) are correctly matched with the HandiLedger accounts (on the right).  Please scroll down to the bottom to ensure all accounts are correctly mapped.

 

1. Click Save.

4.                 Exporting to HandiLedger for Financial Reporting

With the use of Sage Business Cloud Accounting, HandiLedger could be used for your reporting purposes. No additional data entry or processing will be needed in HandiLedger.

1. To import the data, go to Tools, then select Import from Sage One. 

1. Select the Import Range Selection you would like.

1. The Import Entries screen will open. Click Post if the button is available, otherwise click Errors to make necessary corrections.

Note	There will most likely be “Errors” during your first import due to unmapped accounts between Sage Accounting and HandiLedger. In HandiLedger, please go to View  Sage Accounting Accounts to view or edit your list of linked accounts.

Once you click Errors, you may see a list of errors that exist due to unmatched accounts

 

Click the Accounts button, scroll down, and select relevant HL Num for the unmatched accounts in red. Create new HandiLedger accounts if necessary.

Once you are happy with your coding above, click Save and Close. 

 

The Errors button will be deactivated once all errors have been resolved. You could then click Post to post Sage One transactions into the HandiLedger.

You could also click on Transactions to see the imported information .

 

5.                 Exporting to HandiTax for BAS Lodgement

Your client's Business Activity Statements can be easily transferred from Sage Business Cloud Accounting into HandiTax for lodgement, saving you from re-keying the information manually.  The below is a general process diagram.

Before transferring the data into HandiTax, you must set up the connection with Sage Accounting if not already configured for HandiLedger

1. Open HandiTax
2. From the Options menu, choose Sage Accounting…
3. Enter your Sage Accounting login credentials

 

 

1. Select the client, and then click Edit in the middle menu bar.

1. In the Entity Details screen - by selecting the entity and clicking “edit” – click on the ellipsis button for the Sage Accounting field then select the appropriate company to link. Then click Save.

 

1. Click in the middle menu bar to select the client
2. From the Tools menu, select Import BAS from Sage Accounting

 

1. Select the date range you would like to import and click OK

1. The BAS information from Sage Accounting will then populate into your HandiTax BAS for the selected period

 

Note	If this is the second import or if you BAS had pre-fills from the ATO you will be asked if you would like to merge the data.

You will now be able to view the BAS on HandiTax