Can I configure a report such that Amount reported = balance in account A + 50% of balance in account B?
Background: Like most couples, some of our income and expenditure is joint (e.g. interest from joint bank accounts) and some is separate (e.g. salaries). Once a year, we have to prepare two tax reports (one each). For this purpose we divide the joint income and expenses 50:50 between us, and add it to our separate income and expenditure. That is, each of us reports 100% of our separate income and expenditure, plus 50% of the joint. To do this in GnuCash, I have set up three accounts for each category of income or expenses that we have to report in the tax report form: two sole accounts and one joint account. So now I need each GnuCash tax report to show 100% of the balance in one sole account + 50% of the balance in the joint account. How do I do this? I thought of splitting all transactions for joint accounts into two, 50% to each of the corresponding sole accounts. However, this seems way too complicated. I also thought of doing a virtual transaction on the last day of the tax year, transferring 50% of the balance of each joint account into each corresponding sole account. It’s not as complicated, but is still a very awkward workaround. There must be a more logical and intuitive way to report. Apologies if this has already been answered. I’ve tried searching for previous questions & answers on this topic, but without success. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.