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.

IMPORTANT

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 support@pleo.io if you have any additional questions.

How to set up your Accounting System with Pleo

  1. Go to the Settings page in Pleo
  2. Select Sage 200 as your accounting system
  3. Create a Pleo Account in Sage200
  4. Input your Pleo Bank account number in Pleo Accounting -page
  5. Add the Tax codes you use in Sage in the Settings page
  6. 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

  1. Review expenses in Pleo and Export. See how to review and Export from here!
  2. Download the export file and Save to your computer
  3. Open Sage200
  4. Go to "Utilities" and "Import transactions"
  5. Always choose “Validate records only”, because that is where you can test the data. Then click OK and choose the .csv file.
  6. 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

Did this answer your question?