N
Njardine
The following is a sample excel worksheet from the month
end investment entries. It is fairly simple, 45% of the
total gain is deferred for tax purposes and the remainder
is the increase in unrealized gain for investments.
Debit Credit
Tax Rate
19,483.73
8,684.90
45.00% 19,483.73 8,767.68
45.00% 8,684.90 3,908.21
10,716.05
4,776.70
Proof Totals 28,168.63 28,168.63
What is interesting is that if you look at the numbers,
they do not add:
Column one is correct, but column is realli 28,168.64.
There is a 0.01 cent difference, due I suspect to
rounding. The debits do not equal the credits.
This is causing DATA ENTRY troubles, as when I produced
the entry, they clearly do not total. I suspect it has to
do with roundings, but can not find the answer. This also
happens when she does the payroll. This was a problem for
2 times this year.
When I researched the answer, there appears to be no feed
back free line for excel. There is only a paid service.
Can you help me?
Many thanks
NJ
end investment entries. It is fairly simple, 45% of the
total gain is deferred for tax purposes and the remainder
is the increase in unrealized gain for investments.
Debit Credit
Tax Rate
19,483.73
8,684.90
45.00% 19,483.73 8,767.68
45.00% 8,684.90 3,908.21
10,716.05
4,776.70
Proof Totals 28,168.63 28,168.63
What is interesting is that if you look at the numbers,
they do not add:
Column one is correct, but column is realli 28,168.64.
There is a 0.01 cent difference, due I suspect to
rounding. The debits do not equal the credits.
This is causing DATA ENTRY troubles, as when I produced
the entry, they clearly do not total. I suspect it has to
do with roundings, but can not find the answer. This also
happens when she does the payroll. This was a problem for
2 times this year.
When I researched the answer, there appears to be no feed
back free line for excel. There is only a paid service.
Can you help me?
Many thanks
NJ