FAQ: Expenses by Category Report

Q: What is the difference between the Expense Summary and Expenses by Category reports?

A: The Expense Summary report shows only the total spent in each main category. The Expenses by Category report provides more detail by breaking down each main category into subcategories, so you can see exactly which types of expenses within a category are highest. Use Expense Summary for a quick overview, and Expenses by Category when you need to analyze specific expense types.

Q: Why are some subcategories empty or showing zero?

A: A subcategory appears empty if no expenses were posted to it during your selected date range. This is normal and not an error. If you want to hide empty subcategories to simplify the view, look for a filter option like "Include Zero-Amount Categories" and uncheck it.

Q: Can I collapse or expand the category tree in the report?

A: Yes, in most report views you can click on a category name to collapse or expand its subcategories. Some systems also offer an "Expand All" or "Collapse All" button at the top of the report. This lets you control the level of detail you see.

Q: How do I compare expenses between two months using this report?

A: Run the Expenses by Category report twice — once for each month — with the same category and filter settings. Export both as Excel files, then place them side by side in a spreadsheet or create a comparison table. Alternatively, export both to Excel and use a spreadsheet to calculate month-over-month changes.

Q: What does the "percentage" column show?

A: If you enable the percentage option, each subcategory shows what percentage of its parent category it represents. For example, if "Office Rent" is 60% and "Supplies" is 40%, it means rent is 60% of total office expenses. This helps you spot which subcategories are the biggest drivers of spending.

Q: Can I filter by multiple departments or cost centers at once?

A: Yes, most report generators allow you to select multiple items in a filter. Click or check the departments or cost centers you want to include, then run the report. The report will combine data from all selected units.

Q: Why does my report include expenses from accounts I didn't expect?

A: Verify your filter settings. Check that you haven't accidentally selected "All Categories" or "All Accounts." Also ensure that the date range doesn't accidentally include unexpected transactions. If you are still unsure which accounts contributed to the total, export the report to Excel to see more detail.

Q: Can I print this report with the hierarchical structure (categories and subcategories) intact?

A: Yes. When you print directly from the browser, the hierarchy will be preserved unless you have collapsed certain categories. Use Print Preview before printing to see how the report will look on paper. If some sections are collapsed, you can expand them first, then print.

Q: Is there a way to see which individual transactions make up a category total?

A: The Expenses by Category report itself shows only totals and counts, not individual transaction details. To see the underlying transactions, you would typically need to click through to a transaction journal or ledger view, or export the report data and review it in a detailed format. Check your Usystems interface for a "Drill Down" or "View Details" option on the report.

Q: How often should I run this report for financial management?

A: Many businesses run this report monthly to monitor spending trends and catch unusual spikes early. Some run it quarterly for high-level reviews. The frequency depends on your business needs and how closely you want to track expenses. More frequent reviews (weekly or bi-weekly) are helpful if you are actively managing a specific project or cost center.