Transfer data from Brightpearl to IRIS

It's quite likely that your accountant will be using software called IRIS to produce your Year end results. This page is for the accountant.

Your IRIS system will have it's own code structure, which is different from Brightpearl. We have an extra field in the Chart of Accounts to support your IRIS "Map code", which allows a number of really handy features:

Display the IRIS map code in place of the Brightpearl nominal code for data entry screens, drop down menus and reports, if you are using Brightpearl purely for internal-only accounting.

Export a Trial balance already mapped to your IRIS system, or display the existring Trial Balance including the IRIS codes:

 

Setting up

To display the IRIS Mapping Codes in place of the Brightpearl codes:

1. Visit Setup:Options:Finance
2. Choose "Mask Nominals" = yes
3. Choose "Show map codes" = "yes"
4. Save

To add a Map code to a Brightpearl nominal code:

1. Visit Accounts:Setup:Chart of accounts
2. Click the pencil icon to edit a code
3. Add the Map code
4. Save

 

 

Creating the Chart of Accounts

If you're setting up a new client, then you can import the Chart of Accounts from Excel, including your IRIS Map code. This means that you can have a default set for your practice, and load this each time you create a new client account.

Read more about importing accounts from a spreadsheet.

You can export your full Chart of Accounts at any time using the Trial balance report, or the link at the bottom of the Chart of Accounts screen.

 

Exporting a Trial Balance for IRIS

Just visit the Reports : Trial Balance screen, open the Advanced options, tick the "show map codes" box, then click "GO". You can export this to Excel using the drop down to the left of the GO button.

 

Importing a Trial Balance from IRIS

We've built an import tool that will take your Trial Balance, using IRIS map codes, and import directly into Brightpearl as an opening Trial Balance.

1. Ensure you have your map codes set up as above.
2. Prepare a CSV file, with the amount in Col A, and IRIS Map code in Col B. Brightpearl ignores other columns.
3. Visit Setup:Import data from the Brightpearl main menu.
4. Click to import IRIS TB
5. Choose the Opening Balances date.
6. Import. Simple!

The following image is the first few rows of the IRIS CSV file. Note that each code should only contain ONE value, so if rows 3 AND 4 in the file (both with map code 735) were to contain a value in Col A, the import would fail. You'd need to consolidate rows. Make sure that each of your Brightpearl nominal codes only maps to one IRIS code.

 

 

The following images show the accounts after the import: