We are excited to offer a custom CSV export that you can use for Sage One to ensure all your transactions end up in the right place in your accounting.
Connect Sage One and Pleo
Click on your name in the bottom left and select Settings
Select Create your own format from the available options
Setting up the export
In Pleo you can set up the export the way you want it. You can find more information about how it works here.
Once you have all the data points you need, it is time to finalise the setup in Sage One:
Create a new bank account in your Sage One account. This account will be used for Pleo expenses only (go to Banking -> Create new bank account Pleo. Make sure it's a current account). The account number you choose can then be put in as the Contra Account for Pleo card expenses
Create a Pleo Pocket account which will serve as your out-of-pocket expenses account. More information on how Pocket works here.
Create a Pocket Reimbursement Account to account for all the reimbursements to your employees. More information on how Pocket works here.
How to import transactions from Pleo?
Download the Sage One csv from Pleo and upload it in Sage under the previously created Bank Account (make sure you have set up 'Sage Accounting' as your accounting system under 'Accounting' in Settings). Now go to Pleo Bank Account in Sage One -> Connect to Bank -> Import Statement.
Add a suitable account number to each expense (the VAT code will be allocated automatically).
Once the account is selected, click on 'Create' which will move the expense to the bank account.
After you have created all the transactions (look above), go back to your Pleo bank account in Sage. Then go over the list of expenses and check for the same reference number in your downloaded folder from Pleo and attach each receipt.
Click on Reconcile in the main Pleo bank view.
Select all applicable expenses and click on “Reconcile all entries”.