# Report expense claims by type of expenses

**URL:** <https://forum.manager.io/t/report-expense-claims-by-type-of-expenses/13208>\
**Category:** Uncategorized\
**Created:** [December 15, 2017, 9:30pm UTC](https://forum.manager.io/t/report-expense-claims-by-type-of-expenses/13208 "2017-12-15T21:30:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![novica](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/novica/32/7414_2.png) [@novica](https://forum.manager.io/u/novica)\
**Post date:** [December 15, 2017, 9:30pm UTC](https://forum.manager.io/t/report-expense-claims-by-type-of-expenses/13208/1 "2017-12-15T21:30:20Z")

</div>

A typical expense claim that I have has gas, food, and office supplies expense paid by employees’ personal funds.

Is there any way that I can get a report showing totals for all employees in each group of expenses?

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [December 15, 2017, 9:53pm UTC](https://forum.manager.io/t/report-expense-claims-by-type-of-expenses/13208/2 "2017-12-15T21:53:18Z")

</div>

Use a combination of Search and column sorting under the Expense Claims tab. For example, Search for Roberto’s name. Then sort by clicking the `Account` column heading. You will have all of Roberto’s expense claims, with _Food_ expenses, then _Gas_ expenses, then _Office supplies_. Export to a spreadsheet for further manipulation.

Or search for _Office supplies_, then sort by Payer name. You will have a list by employee of expense claims for office supplies.

Or search for the year and sort the result.

Or export the entire expense claims list and do all your searching and sorting in the spreadsheet.

---

<div class="post-metadata">

**Author:** ![novica](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/novica/32/7414_2.png) [@novica](https://forum.manager.io/u/novica)\
**Post date:** [December 15, 2017, 10:14pm UTC](https://forum.manager.io/t/report-expense-claims-by-type-of-expenses/13208/3 "2017-12-15T22:14:35Z")

</div>

This means that I should create an expense claim for every individual item. But if I have Roberto’s expenses on a single claim, I can only see the total amount of the claim.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [December 16, 2017, 12:06am UTC](https://forum.manager.io/t/report-expense-claims-by-type-of-expenses/13208/4 "2017-12-16T00:06:25Z")

</div>

Well, all accounts represented on an expense claim (for multiple line items) will show. But no, you can’t produce a report that just shows how much Roberto spent on gas via expense claims. But you can drill down on the _Gas_ account to see which purchases of gas were via expense claim. However, in that case, you can’t see that Roberto bought the gas instead of Maria.

The bottom line is that someone can always think up a report they’d like to see organized in some particular fashion with specific content. Until Custom Reports get fleshed out and documented, you may have to work harder than you want to obtain these non-standard reports. Meanwhile, there are almost 40 reports meeting most standard accounting needs.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 3:23pm UTC](https://forum.manager.io/t/report-expense-claims-by-type-of-expenses/13208/5 "2023-01-18T15:23:01Z")

</div>

Closed on January 18, 2023, 3:23pm UTC


