What is the difference between the Sage200 format you can find from Pleo and Custom Format?
With our Sage200 format, you cannot include tags in the export, however, this can be done with our custom format, while also creating a template that is compatible with Sage200.
Sage200 however, cannot understand the custom formats negative values, meaning an additional column will need to be created to separate the positive and negative values in the Sage200.
In Sage200 these are:
4 = expense, negative value
5 = refund, positive value
Our Sage200 format in Pleo does this automatically, but unfortunately our custom format does not understand this, so if you choose to go with custom format - every time you export, we would need to double check if there are refunds and then manually change the type from 4 to be 5 on those refunds in the export file.
These instructions how to set up and import transactions from Pleo to Sage200 are more of an example as your company's set up in Sage200 might differ. We recommend contacting your account manager in Sage if you are having issues with importing documents or you can always contact email@example.com if you have any additional questions.
How to set up Custom Format for Sage 200c
These instructions are more of an example that might not work for all versions of Sage200. If you have any questions, please contact our firstname.lastname@example.org
- Click on your profile image in the lower left hand corner and select Settings
- From the menu option, select Accounting
- Choose Custom Format as your accounting system
- Create Tax codes and set up the Settings like below:
3. Set up categories
4. Set up Tags (Cost centres)
5. Make sure you have set up the settings like below
6. Create the columns for your export file. Click "New" below the Columns.
7. Create each column using the image below as a reference
You can always change the column names and add more columns and datapoints if that works with your set up in Sage200.
In Custom Format, you can also use Teams and the department code as another data point. You just need to choose Project ID and the data source to be "Team code". The team code is always fixed for each user.
If employees always need to choose the tag, then we recommend using the Tags in Pleo and choosing "tag name - ID" as a data source. Read more about Tags from here!
Formatting the Sage200 columns
You need to change some of the formatting in a few datapoints so you won't get errors when importing to Sage200
SYSTraderTranType datapoint to be 4
1. Choose Static Value
2. Click the 3 dots inside the green box
3. Write 4 in the empty row in the pop up window
Change the date format
1. Choose Settled date
2. Click the 3 dots on the green box
3. Choose dd/mm/yyyy
Make sure the number format is with 1000.00 and not 1000,00 with Net Amount and Tax Amount.
Read through this article to see how to import transactions to Sage200.