Export custom excel or csv file

1. Navigate to Settings
2. Click on Accounting
3. Select Create your own format

1. 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.
     
     
2. Add the account numbers in the Accounting Setup Settings
3. Add all Tax codes in the tax codes table with their Name, Code and Tax rate as set up in your accounting system.

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.

1. Click Format settings
   1. Choose if you want a One Line or Multiple line 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

        
        Good to know:
      • Under preferences you can select check boxes to define how your data is shown.
      • You can see an example of how your data will look as you select and unselect the boxes.
        
        
   2. 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.
   3. Select a File Type - Comma-separated values (CSV) or Excel (XLSX)
   4. Select a Delimiter
   5. Select a Separator
      
      
2. Customise the Columns so your export will be set up for your accounting system
   1. For every Column:
      • Enter a Name
      • Connect a Data source - All available data points
   2. Click Download preview file to see what the export file looks like

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. 

1. Navigate to Export
2. Select the expenses that are ready for export
3. Click Add to Export Queue
4. Go to Export Queue
5. Select the expenses you want to export
6. Click Export
7. Click Download file
8. Upload the export file into your Accounting system