If you're migrating from Sage to Brightpearl you'll need to extract all your data and import it into Brightpearl. This will allow you to stop using Sage and carry on using Brightpearl where you left off with Sage.
When to switch from Sage to Brightpearl
You don't have to switch accounting systems at the end of a financial year, or even a VAT quarter.
Once you have imported your accounting into Brightpearl you should immediately start using Brightpearl and stop using Sage.
What you will need to export
- Customers
- Suppliers
- Trial balance
- Debtors report
- Creditors report
Each of these will be imported to Brightpearl.
What can't be imported
- Historical transactions other than outstanding invoices.
Export your data from Sage
You will need to export customers, suppliers, the trial balance, your debtors and creditors from Sage.
How to export the trial balance from Sage
- Go to Modules > Financials .
- Click the Trial icon.
- Select File and click Run .
- Save the file as a comma separated value (CSV) file, name it "Trial Balance" and save it in a location where you can find it later.
- Set your criteria values to export all transactions and click OK .
You'll need to get your nominals column to accept leading zeros for nominals less than 1000. Select column A, right-click and select format cells . Choose Custom , and type '0000' in the Type field.
How to export customers & suppliers from Sage
Export your Customer Record CSV (Extended) file. Not all fields used in Sage are available in Brightpearl so will need to be removed from the spreadsheet, try adding a customer in Brightpearl to see what's available. Other fields that are not included in the Sage file as default, such as price list, delivery address details and currency so you'll need to customise your report in Sage. Some data will also need to be set up in Brightpearl before you can import it, including price lists, currencies and custom fields (Analysis fields in Sage).
- Go to Modules > Customers . or Suppliers .
- Click the Reports icon.
- Select the Customer Details Report folder, or the Suppliers Detail Report .
- Highlight the Customer Record CSV (Extended) report , or the Supplier Record CSV (Extended) report and click the File button.
- Save the file as "Customers" somewhere you can find it later.
- Select the criteria values to export all customers and click OK .
Once you have exported the file to CSV, add the column headings, remove unwanted columns and save as XLS (Excel 97-2003) type file.
How to export debtor & creditor data from Sage
Export your Aged Debtors Analysis (Detailed) file and Aged Creditors Analysis (Detailed) file. Not all the exported fields provided in the file from Sage can be imported to Brightpearl so they will need to be removed from the spreadsheet. In Brightpearl go to Settings > Data/Import > Import Accounts and download the sample file for debtors and creditors to see what columns you can import.
- Go to Modules > Customers or Suppliers .
- Click the Reports icon.
- Select the Aged Debtors Reports folder, the Aged Creditors Reports folder.
- Highlight the Aged Debtors Analysis (Detailed) , or choose Aged Creditors Analysis (Detailed) , and click the File button.
- Choose to generate the file as a comma separated value (CSV) file, name it "Debtors" or "Creditors" and save it in a location where you can find it later.
- In the criteria values box leave everything as default to export all debtors/creditors and click OK .