All Collections
Account Admin
Standard expenses export formats
Standard expenses export formats

This article will help you identify which export format is most suitable by illustrating how these export formats look when exported.

J
Written by Jack
Updated over a week ago

There are several export formats available on ExpenseIn as standard - you'll find these in the Admin area under the heading Export Formats.

Before adding any additional export formats to your accounts, you'll have seven standard export formats available:

  • Basic Export

  • Card Statement Status Report

  • Detailed PDF Report

  • Mileage PDF Report

  • Summary PDF Report

  • User Expenses PDF Report

  • User Summary

Basic Export

Your basic export format will detail the: Expense number, submission number, user's first name, user's surname, user's reference, department, category and category reference, expense description, expense date, submission date, VAT amount, net amount and gross amount.

Here you'll find a link to our example file for the basic export format.

Card Statement Status Report

The card statement status report is a CSV file highlighting company card expenses and their current status. The report will show you the expense status (e.g. Draft or Approved), the expense, submission, approved, reconciled and completed date along with the User's full name and Statement Identifier.

Here you'll find a link to our example file for the card statement status report format.

Detailed PDF Report

The detailed PDF report will initially provide you with a cost breakdown (e.g. gross amount, VAT amount, net amount) summary of your categories, departments, projects and users. The report will then provide you a detailed account of each expense.

Here you'll find a link to our example file for the detailed PDF report format.

Mileage PDF Report

The mileage PDF report will initially provide you with a summary of total business miles for departments and users, before then presenting a detailed account of each mileage expense - including highlighting any policy issues associated with the expense.

Here you'll find a link to our example file for the mileage PDF report format.

Summary PDF Report

The summary pdf report will provide you with some great illustrative insights into how your categories, departments, purchase methods and expense types are split. You'll find out which users have incurred the highest expense amounts and those who travelled the furthest. The PDF report also gives a fantastic insight into what policy rules have been present for your users' expenses.

Here you'll find a link to our example file for the summary PDF report format.

User Expenses PDF Report

The user expenses PDF report will initially provide you with a cost breakdown (e.g. gross amount, VAT amount, net amount) of your users' expenses. The report will then breakdown each user's expenses, detailing aspects of each expense and providing insight into the categories used.

Here you'll find a link to our example file for the user expenses PDF report format.

User Summary

The user summary export format is a very basic overview of your users' expenses. You'll be provided with your users' first and last names, any user references on the system as well as the total amount of the expenses for the date range you've exported.

Here you'll find a link to our example file for the user summary format.

Related Articles

Did this answer your question?