Viewing Money Reports Differently than Set in YNAB
Does anyone else struggle with, at times, wanting to view reports about their money in ways other than how your categories are organized? I pretty much stick to the YNAB standard of fixed expenses, day-to-day living, true expenses, etc. which is fine, but some things are spread over different category groups, which makes it difficult to group and report on. Take my car; I have fuel in day-to-day living, but I have insurance and maintenance in true expenses. Thankfully, my car is paid off (2012 Civic), but if I had a payment, it would be in fixed expenses. If I wanted to run a report just for my car stuff, I'd have to rearrange it into a category group, run the report, and then put it back afterwards. (I understand that in that example I could tick off just those categories but not if I want to see multiple areas. It's just an example of wanting to view things differently than they are set.)
The basic question is, what do you do or use when you want to view your money in ways other than the way you have your category groups organized? I have been looking into exporting my transactions and then using Excel or even Microsoft's PowerBI as ways to have "alternate views" of my money but it's not easy to set up.
It would be great if YNAB offered alternate report "views".
ukimagic209 After moving my categories to make a report (like you are interested in) a few times, I just permanently moved them into functional categories, some of mine being called: Housing, Garage, Food, Freedom, etc. So only things that are vehicle related are in the garage group.
I personally like how the reports look now and they make sense, to me. It's nice to see exactly how much it cost to run x number of vehicles or how much it cost to keep the lights on and the wifi working.
I'm not that good with Excel, I wish I was.
ukimagic209 I think B's Gambit 's approach is probably the way to go. I do have another idea, although it's clunky: you could put a keyword in all of your car-related categories, search All Accounts for that keyword, and then total up the retrieved transactions.
You can also deselect the non-car categories when you run a report, but there's no way to get back to that view without doing the same thing every time.
Export to Excel is the "anything you want" option if you have the skills.
The default organization is great when you're still budgeting checks to both this and next month, as it somewhat indicates the temporal aspect of your expenses. (Immediate vs accumulate. If funds are tight, the grouping are a gross indication of priority.) After I was able to push all income into next month and budget in month-sized chunks, the temporal consideration went away. There was no "which do I fund first" quandary, since everything was funded at the same time. At that time, I switched to functional groups for the better reporting.
TBH, I hardly use reports at all now. The budget itself is the "report" I typically rely on, possibly with the addition of the average quick-budget information.
ukimagic209 Why don't you just consider moving petrol to "True Expenses"? Or anything to do with your car (sans tinting the windows, adding track lights, fuzzy dice... etc).
Having simple categories that are clearly defined will allow your sub-categories to accomplish what you want them to. Who needs to know how much you spent on a daily-expense when you only ver report on a monthly basis? They're all averaged out in the report.