Articles on: Exporte

How to Export Expenses

The Expenses CSV Export provides a detailed overview of your expense and Petty Cash data in DPO. The exported file can be opened in Excel, where you can filter and analyze the data by criteria such as department and supplier. This is useful for reporting, cost analysis, and reviewing expenses across departments.


Good to Know
  • Export your Expenses and Petty Cash data into a single CSV file.
  • Use Excel to filter and analyze the exported data, for example by department or supplier.
  • A new export should be requested whenever you need the latest available data.
  • You can assign a user role with export permissions, allowing selected users to create exports based on their access and permissions.


Create an Expenses CSV Export


  1. Go to Settings → Export Expenses.







  1. Enable “pettycash-export.csv” by checking the box.
  2. Click “Create Export”. This step is required for every export to ensure the most up-to-date data is included.
  3. Refresh the page and verify that today’s date appears above the download button.
  4. Click “DOWNLOAD”.





Open the CSV File in Excel


  1. Open Excel and create a new workbook. Go to Data → Get Data → From Text (Legacy).





  1. Select the downloaded CSV file and click “Import Data”.
  2. Choose Delimited, make sure UTF-8 is selected as the file origin, and click “Next”.



  1. Select Comma and Tab as delimiters, then click “Finish”.

(Check the preview to ensure the columns are displayed correctly.)






  1. Click “Import” to load the data into Excel.




Filter Data by Department


  1. Select the first row and enable Filters using the toolbar.






  1. Open the filter of the column you want to use (e.g. “Department”), uncheck “Select All”, and choose the desired department.
  2. Click “Apply Filter” to display the filtered results.







Questions or need help?
Our customer support is always available to help with any questions or setup assistance


Contact us
Email: support@digitalpurchaseorder.com
Support: +1 888 DPO 7254
Support Int'l: +44 20 331 88 338
Berlin Office: +49 (0)30 55 572 5956


Or book a personalized support call
We look forward to hearing from you.

Updated on: 01/09/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!