Select custom format
Settings & Tax codes
Format your files
Complete your first Pleo export
Step 1: Select custom format
- Navigate to Settings
- Click on Accounting
- Select Create your own format
Step 2: Settings & Tax codes
- Create the following accounts in your accounting system:
- Contra Account for Pleo Wallet - for any card expenses or invoices.
Note: We recommend creating a new account in your chart of accounts as you would for a bank account. - Optional - Account for out-of-pocket expenses - to keep track of out-of-pocket expenses until they have been reimbursed
- Optional - Default Supplier account for invoices - to send all invoices without a supplier account to a single place in your accounting system, making it easier to add a supplier later on.
- Contra Account for Pleo Wallet - for any card expenses or invoices.
- Add the account numbers in the Accounting Setup Settings
- Add all Tax codes in the tax codes table with their Name, Code and Tax rate as set up in your accounting system.
Step 3: Format your files
You can customise your export file, so you can seamlessly import it into your accounting system. We recommend involving your bookkeeper to understand the data point that should be added.
- Click Format settings
- Choose if you want a One Line or Multiple lines export. Not all accounting systems will accept a one line set up, so make sure to double check how you can import data for your accounting system.
- One line- Expenses will be represented with the from and to accounts in the same line
Contra Account Amount 1800 (Pleo Wallet) 4200 (Food & Drinks) 20 - Multiple lines- Expenses will be split a debit and a credit line
Account Debit Credit 4200 (Food & Drinks 20 1800 (Pleo Wallet) 20
- One line- Expenses will be represented with the from and to accounts in the same line
- Select your Preferences
- List expenses as positive - By default expenses are shown as negative and refunds as positive. Select this preference if your accounting system expects positive values.
- Include wallet transfers in export files - Select this preference for your Wallet top-ups to show on the export page.
- Select a File Type - Comma-separated values (CSV) or Excel (XLSX)
- Select a Delimiter
- Select a Separator
- Choose if you want a One Line or Multiple lines export. Not all accounting systems will accept a one line set up, so make sure to double check how you can import data for your accounting system.
- Customise the Columns so your export will be set up for your accounting system
- For every Column:
- Enter a Name
- Connect a Data source - All available data points
- Click Download preview file to see what the export file looks like
- For every Column:
Step 4: Complete your first Pleo export
It's important to complete your first export after setting up your custom file to make sure your accounting set-up works with your accounting system.
- Navigate to Export
- Select the expenses that are ready for export
- Click Add to Export Queue
- Go to Export Queue
- Select the expenses you want to export
- Click Export
- Click Download file
- Upload the export file into your Accounting system
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article