With a tailored CSV file specifically for Sage 200, it's easy to import and map your transactions that you have in Pleo into your Sage accounting system. If you want to create your own format for Sage 200, read through this article.
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 firstname.lastname@example.org if you have any additional questions.
How to set up your Accounting System with Pleo
- Go to the Settings page in Pleo
- Select Sage 200 as your accounting system
- Create a Pleo Account in Sage200
- Input your Pleo Bank account number in Pleo Accounting -page
- Add the Tax codes you use in Sage in the Settings page
- Add categories. If you want to bring cost centres to Sage from Pleo transactions, you need to read this article.
How to import Pleo transactions into Sage200
- Review expenses in Pleo and Export. See how to review and Export from here!
- Download the export file and Save to your computer
- Open Sage200
- Go to "Utilities" and "Import transactions"
- Always choose “Validate records only”, because that is where you can test the data. Then click OK and choose the .csv file.
- Choose to import records after the validation
Datapoints in the Sage200 format file
Here are the datapoints that will be exported with the Sage 200 format from Pleo. If you'd like to get more data into your import file to Sage 200, you need to create a Custom Format. More information on custom format with Sage200 you can find here.
AccountNumber: Pleo account number in Sage
GoodsValueInAccountCurrency: Settled amount of the expense
PostedDate: The date of export
TransactionReference: Receipt Number
SYSTraderTranType: 4 or 5, (4=Expense, 5=Refund)
TransactionDate: Settled date
TaxValue: Amount of Tax
NominalAnalysisTransactionValue/1: Settled amount of the expense
NominalAnalysisNominalAccountNumber/1: Nominal Code
TaxAnalysisTaxRate/1: Tax Code
TaxAnalysisGoodsValueBeforeDiscount/1: Settled Amount