Setting up the Sage 200 export

We are excited to offer a tailored CSV for Sage 200 to ensure all your transactions end up in the right place in your accounting. If you are interested on bringing cost centres or projects into Sage 200, please read through this article.


IMPORTANT

These instructions how to set up and import transactions from Pleo to Sage 200 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 our Support team if you have any additional questions. 


Choosing Sage 200 export in Pleo

  • Click on Settings

  • Select Accounting

  • Select Sage 200 as your accounting system




Setting up the export

  1. Create a Pleo Bank Account in Sage and use it as Contra Account for Pleo expenses

  2. If you wish to use Reimbursements, you can also set up a account for out-of-pocket expenses and a contra account for reimbursements. More information on this here.

  3. Add your tax codes in the table in the bottom.

  4. You can learn how to export in this article.

How to import Pleo transactions into Sage200

  1. Review expenses in Pleo and Export.

  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 is available here.

AccountNumber

Pleo account number

GoodsValueInAccountCurrency

Settled amount

PostedDate

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


Other important settings


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article