Common Ledger

Have a look at this quick video which will show you how to import data into Sage HandiLedger.

For a step by step guide, follow the instructions below:

Login to Common Ledger, then choose your client from the Connected Companies List

Go the Mapping Page and select the chart of accounts you would like to use the chart drop down box

Check that the client chart has been fully mapped

Go to the Common Ledger Status page and select the financial year that you would like the data for

Select Download under Sage HandiLedger. A CSV file will download and can be found in the downloads folder on your device

1. Login to Common Ledger, then choose your client from the Connected Companies List 
2. Go the Mapping Page and select the chart of accounts you would like to use the chart drop down box 
3. Check that the client chart has been fully mapped 
4. Go to the Common Ledger Status page and select the financial year that you would like the data for 
5. Select Download under Sage HandiLedger. A CSV file will download and can be found in the downloads folder on your device

The next step is to import the data into Sage HandiLedger by following these steps:

Select the entity which you want to import the transaction details

Press F3, or from the View Menu, click Entity Details

On the ‘Entities’ window, Highlight the required entity, then click Select

From the Tools menu, hover over Import Data and then click General

The ‘Import Entries’ window will open. The rows are blank because the data has not yet been imported

The ‘Import ASCII Data’ window will open. This allows you to view the information contained in the file, and to map it to the correct fields

Click File, and then select the Import File Name from the ‘Open’ window

Load and select a mapping scheme from the ‘ASCII Import/Export Mapping Schemes’ window. Select the Common Ledger scheme. Click here to create a mapping scheme if you don't already have one

On the ‘Import ASCII data’ window, click Run. The ‘Import Entries’ window lists the imported records

Click Close to exit the window and post the imported entries to the ledger. On the ‘Attention’ window, click Yes to post the entries

The Data has now been posted to your ledger

1. Select the entity which you want to import the transaction details 
2. Press F3, or from the View Menu, click Entity Details 
3. On the ‘Entities’ window, Highlight the required entity, then click Select 
4. From the Tools menu, hover over Import Data and then click General 
5. The ‘Import Entries’ window will open. The rows are blank because the data has not yet been imported 
6. Click Import 
7. The ‘Import ASCII Data’ window will open. This allows you to view the information contained in the file, and to map it to the correct fields 
8. Click File, and then select the Import File Name from the ‘Open’ window 
9. Load and select a mapping scheme from the ‘ASCII Import/Export Mapping Schemes’ window. Select the Common Ledger scheme. Click here to create a mapping scheme if you don't already have one 
10. On the ‘Import ASCII data’ window, click Run. The ‘Import Entries’ window lists the imported records 
11. Click Close to exit the window and post the imported entries to the ledger. On the ‘Attention’ window, click Yes to post the entries 
12. The Data has now been posted to your ledger