I recently started using GnuCash as a tool for tracking my expenses. It has lovely built in reports on expense, but it seems to limit the categories/accounts displayed to a fairly low number (I think 8 for the bar chart, and 6 for the pie chart) lumping several of the smaller items into the "other" category. However I'm more immediately concerned about controlling my smaller expenses (dining, entertainment, etc).

How can I configure the reports to show me the detail about all expenses, or a limited set of expenses?

| improve this question | | | | |

I'm going to take the “Expense Piechart” report in GnuCash 2.6.7 as my primary example; other reports may have slightly different options.

  1. Open the report you want to use.
  2. Click “Options" in the toolbar or “Report Options” in the Edit menu.
  3. In the “Accounts” tab, the “Show Accounts until level” option (or “Account Display Depth” in some other reports) cuts off subaccounts, and you may wish to increase it. For example, I keep expense accounts like “Expenses:Entertainment:Games”, and if I want to see that specific account I have to set this option to 3, instead of the default 2.
  4. In the Display tab, the “Maximum Slices” (“Maximum Bars” for bar charts) controls how many accounts are shown before the rest are grouped as an “Other” entry. However, it only goes up to 24.

If you want to keep this configuration for future use, you can either leave the report tab open indefinitely, or save a custom report using the “Save Report Configuration As…” command in the toolbar or Reports menu.

Since you asked about expenses in particular: if you are looking for a complete list with more than 24 items, you can use the Income & Expense → Cash Flow report. This report will list out every expense account (and income account, separately) with nonzero transactions. However, it does not have a pie at all and does not display percentages.

| improve this answer | | | | |
  • Is there another report that does not lump anything under "Other"? – Petrus Theron May 23 '17 at 14:42
  • @PetrusTheron There is! I've updated my answer for that and also some changes in the UI. – Kevin Reid May 23 '17 at 15:43
  • 1
    Additionally, if you just want to look at the sub accounts that make up the 'other' category, you can deselect the larger balance expense accounts (e.g. mortgage, groceries, utilities, etc) from the 'account list' in the options. – Andy May 23 '17 at 15:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.