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

Hail_1986

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

Sheena Trepanier

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.

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_Hal

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?

Rachael Hopkins

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!

Shannon_Lee

I tried adding the {expense:category:glcode} to my custom report and the codes still do not appear on the export. I do have the GL codes in the system. Has anyone found the solution?