How to show Other Expenses subaccounts in Budgeted vs Actual reports

Ceawlin · ‎12-25-2018

I track my business and personal income and expense by classifying my personal expenses this way:

I created this account:

Account Type: Other Expense

Detail Type: Other Miscellaneous Expense

Name: PERSONAL - EXPENSES

I then created accounts for each category of personal expense as a subcategory of the above account.

The problem - when I run Budgeted vs Actual report, the Personal Expense categories are collapsed into Other Expenses. I cannot compare, for instance, budgeted personal travel vs. actual personal travel.

I've tried multiple ways of fixing this. I don't want to run two separate sets of books because I have a simple small consulting business. I keep separate bank accounts and credit cards but like being able to see everything on one report.

Ideas, anyone? Thanks!

Anonymous · ‎12-25-2018

Good day, @Ceawlin,

Thanks for getting this to our attention and for allowing us to help you with your Budget vs. Actual report.

Technically, you should be able to see both parent and sub-expense account in the report. You'll only need to make sure you're using the correct Budget template, Report Period and the Accounting method. Here's how it should look like:

Also, you must review each transaction you have created and make sure it uses the correct expense item. This way, the amount will be broken down on the report based on the expense account used. Please see screenshot below:

That should do the trick for you, @Ceawlin. Please let me know how this goes for you. I'm here if you need further assistance with your budget report. Have a great day!

Ceawlin · ‎12-25-2018

Thank you for the quick response and good advice. Previously, it showed subs and parents on all 'Expenses' but grouped 'Other Expenses together'. Strangely, I rebooted and it now breaks out both categories. I'm good - thanks so much.

Topics

Training

Community

Resources

How to show Other Expenses subaccounts in Budgeted vs Actual reports