Can I download a report that shows all categories and the cost codes related to those categories?

Can I download a report that shows all categories and the cost codes related to those categories?

Answers

  • Sheena TrepanierSheena Trepanier Posts: 1,386 admin
    edited August 2017

    Hi! In your policy you have the ability to build a custom export template that would allow you to export the category applied to each expense, as well as the cost code (GL code section) that is currently assigned to that category in Expensify.

    You could use the two formula below to pull the category and cost code into your custom export template.

    {expense:category}
    {expense:category:glcode}

    You can learn more about our custom export template here and you can customize your export further with our custom formula page.

    I just want to note that the cost codes attached to categories are mapped on the backend. This means they will appear in the export but on the report itself they will not be visible.

    Cheers!

  • K_HalK_Hal Posts: 3

    Sheena, regarding your answer above, is there a way to make the GL account numbers visible on the CSV file? I have to download users' reports on CSV files and then send them to another person for entry into our accounting software. That person wants to see the GL codes. Your answer above makes it sound like we can't get visible GL codes on our CSV downloads. In our workgroup we need to have those visible on the CSV files. Am I understanding this correctly?

  • RachCHopkinsRachCHopkins Posts: 432 admin

    Hi @K_Hal - I think we have some terminology confusion...

    When Sheena is referring to the 'Report' she means the Expensify report, and by 'Export' she means the CSV.

    So if you use the fields suggested above, this should display the GL codes in the exported CSV even if you can't see them in the Report at the Expensify end.

    I hope that helps! :)

Sign In or Register to comment.