Income division in fund based accounting
David G. Pickett
DavidGPickett at comcast.net
Sat Dec 10 14:15:43 EST 2016
A major complication in fund accounting for non-profits is the division
of income. The various funds in a category can share in a bank account
or investment vehicle like a mutual fund or account holding multiple
mutual funds. Depending on the nature of the fund and associated
policy, the income may be diverted to administrative costs (gotta pay
the overhead of having the money managed), but in some cases that is not
appropriate or desirable, or even legal. The income, loss or change in
cash value of the account needs to be divided between the funds
participating in the account pro-rata, and the accounting software needs
to adjust ownership proportions every time a fund makes a transaction on
the funds.
For instance, suppose Fund A is established with $10,000 and Fund B with
$20,000, and the money is put in a Vanguard account in a mutual fund:
1. Fund A owns 1/3 or 33.3333% of value at Vanguard.
2. When a dividend of say $387.29 is received, either as cash in the
trading account or reinvested, now Fund A has $10,129.10 at
Vanguard, still 1/3 or 33.3333%.
3. If the underlying funds rise in value by 11%, now it has $11,243.30
at Vanguard, still 1/3 or 33.3333%.
4. If Fund A transfers $2,000.00 to a bank account for distribution ash
checks, now it has $9,243.30 at Vanguard, or 27.4039%.
The desire is to have software that juggles the ownership gracefully,
precisely, without excess transactions and with accurate reporting. If
all the fund values add up to more than the account value due to
rounding up, what do you do (even with biased rounding, there might be
ties for amount or age of value owned by each fund, so this might have
to a bit random, like last guy loses a penny, as with going down the
owner list alphanumerically and pulling their value from the whole, and
dividing the remainder among the rest, recursively)? Fund accounting is
almost like running a bank! Banks have to round loan interest down, so
they do not charge over their promised rate, but they do not seem to be
so constrained with savings interest.
Can GNUCash deal with this somehow?
More information about the gnucash-user
mailing list