We are currently experiencing higher than normal support inquiries and response times. The Community is here to support you as well so please help each other out when you can. Please visit our status page to subscribe to updates.

Custom Report

CocoCoco Expensify NewcomerPosts: 6Expensify Customer Expensify Newcomer

I've created a custom report format to output the user's email address, report title, report start date, GL code and expense amount. Instead of getting individual line item amount, is there any way to get the TOTAL amount by category (or GL code) AND by user? Basically, I want to be able to select all reports processed in any time frame and be able to create an excel report to show the TOTAL amount BY CATEGORY BY USERS.

Answers

  • Sheena TrepanierSheena Trepanier Expensify Success Coach Posts: 1,992Expensify Success Coach - Admin Expensify Success Coach

    @Coco the best option here would be to use the Category export template that comes standard with all accounts. From the Reports page, select all the reports you want to export and then the Category export in the Export to drop down. (below)

    This template should give you the breakdown by category and allow you to sort by employee. If that isn't the case, then using a custom export template and exporting from the Expenses page, by employee, should be a good option.

  • CocoCoco Expensify Newcomer Posts: 6Expensify Customer Expensify Newcomer

    @Sheena Trepanier I did try the Category Export that come standard with the account. However that only spit out ONE total for each category for ALL users. Is there a way to customize that Category Export function?

  • Sheena TrepanierSheena Trepanier Expensify Success Coach Posts: 1,992Expensify Success Coach - Admin Expensify Success Coach

    @coco -- Unfortunately, the Category Export template is not customizable at this time. In this scenario, it may be better to export from the Expenses page after filtering expenses to be for a single employee. An example of that is below.

Sign In or Register to comment.