Personal Finance & Money Asked on December 28, 2020
I commonly group purchases or invoices into transactions and then show the individual components as splits in gnucash
. I don’t know if this is the right approach, but suppose I go shopping, I might do something like this:
Transaction: Shopping
Then when I go to the Confectionary account, it would be great to see how much I spent on Nutella, but instead all I see is a bunch of “Shopping” transactions (because I only see the description of the transaction in the ledger).
I see two workarounds, neither of which are very satisfying:
I’m after a technical solution here but also some guidance on how this kind of problem should be solved in gnucash
as well as accounting more generally.
Note that a similar feature request was made 9 years ago. Given that this hasn’t been resolved I assume there’s some good workaround out there. I’d love to hear it!
The amount of detail that you can get in your GnuCash reports depends partly on the amount of effort that you expend in detailed input.
For my own records, I have an expense account called Expenses:Groceries, and when I come home from the supermarket most (sometimes, all) of my spending gets recorded against that single category. It simplifies the input into GnuCash, but it does mean that I can't get any reports on my spending on Bananas, or Corn Flakes, or Toilet Paper.
If you want more detail to be available, you could create subcategories like
Expenses:Confectionery:Chocolates
Expenses:Confectionery:Lollies
Expenses:Confectionery:Nutella
With more work when inputting your purchases, you will be able to get more detailed info out of the system.
Answered by Greg Schmidt on December 28, 2020
Open Confectionary Account
Report->Account Report
Look for Nutella in the Memo Column
Copy and Paste to Excel
Filter on Memo Column if necessary
Answered by base64 on December 28, 2020
I have the same request as quant. I use the Memo field for each split entry. The answer provided by base64 works and provides what I need, but requires a couple of steps, where, with an option, that same information could show up directly in the account register. Currently, all other split entries for this transaction also show up in the selected account register when using auto-split option in View.
Answered by Chris on December 28, 2020
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP