[GNC] Tax Accounting for Trust Income Received in Following Fiscal Year

flywire flywire0 at gmail.com
Thu Aug 19 04:05:49 EDT 2021


I've finally figured it out, one of those John Ralls comments that leaves
you scratching your head.

Anyway, with covid and all, I'm starting to understand a bit more about the
accounting side of shares. Apparently, dividends and distributions are
different https://blog.stockspot.com.au/dividend-vs-distribution/
explaining why despite using cash accounting my accountant always insists
on including certain receipts in the previous tax financial year (and don't
worry about putting it in your books, just give me the reports showing the
$100/yr income).

So I posted about Tax Accounting for Trust Income Received in Following
Fiscal Year (
https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097173.html) and
contra accounts, and I've worked out how to show it on an Income and
Expense reports for tax purposes.

Distribution workflow:
* Transaction in Bank Account From ETF Distribution first quarter of new fy
* Import Bank Statement Bank Account <- Income:Distribution
* Duplicate Transaction
* Change transaction to Liability:Contra:Distribution <- Income:Distribution
* Change Duplicate date to end-of-previous-fy
* Change Duplicate to Bank Account <- Liability:Contra:Distribution

Dividend workflow:
* Import Bank Statement Bank Account <- Income:Dividend
* Add Franking [Tax] credit split from Liability:Contra:Franking
* Zero Liability:Contra:Franking at eofy

That distribution workflow is pretty fiddly and error-prone for a clueless
bookkeeper and I'm wondering if there is a simple way of doing it. I'd like
to go through and mark a contra-tax action against the bank account split
then run a process to fix it up.

Do you use a better workflow? Is there a simple way to flip accounts with
respect to Income/Expenditure? If not I'm inclined to do a piecash script.
Could the python bindings do it better?

Now, that comment about 30 years' worth of books (flaming expected if
number's wrong). He's probably not anal about expenditure, more likely
keeping account of asset expenditure.


More information about the gnucash-user mailing list