How to set up the Sage 50 Desktop export

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 Reimbursements, you can also set up an 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.

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

• How to set up your categories ✈️
• How to set up your tax codes ?
• How to set up your tags (cost centers and projects) ?️
• Download and export expenses
• How to use Reimbursements with your accounting
• How to use Mileage