All Collections
How to set up the Sage 50 Desktop export
How to set up the Sage 50 Desktop export

Learn how to set up and administrate the Sage 50 desktop format for a seamless exporting experience

Angela avatar
Written by Angela
Updated over a week ago

We are excited to offer a tailored CSV for Sage 50 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 Sage50, please read through this article.

Choosing Sage 50 export in Pleo

  1. Click on Settings

  2. Select Accounting

  3. Select Sage 50 Desktop

Setting up the export

  1. You need to first create bank account in Sage, selecting Cheque Account as type to use it as Contra Account for Pleo expenses.

  2. If you wish to use Pocket, you can also set up a Contra Account for Pocket expenses and a Reimbursement account. 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.

Importing into Sage 50

We have a format fitted for Sage 50 that is fitted only to the CSV format and is fitted specifically to be entered into Audit Trail transactions.  

  1. Open Sage 50 and click on File in the top left corner. 

  2. Now select Import.

  3. This will open the Data Import window and click Next. 

  4. Select Audit Trail Transactions and click Next

  5. Select Comma-separated (*.csv), 'tick' First row contains headings and click on Browse. Select the CSV file and click Next. 

  6. You will now be taken to Field mappings overview. Make sure to match the columns of the import field to the mandatory Sage Field 1:1 within the dropdown available. 

  7. We also recommend selecting Save Map for future imports.

  8. Here is the final ' Import' window detailing the successful imported expenses.

  9. Click on Bank accounts and select the Pleo account. From here once you click on the Activity button you will be able to see all the transaction details.

Other important settings

Did this answer your question?