On Wed, Jul 2, 2014 at 3:55 PM, Martin Blais <[email protected]> wrote:
> But if you mean "continuously", e.g., given some unrealized gain against
> positions, how much of it can be considered due to the tax-man, always
> calculated based on current ledger, I think you would need a custom script
> to report that. You do have the cost basis of all assets in the Ledger, so
> it would be possible to use this to estimate your taxes.
Thanks, I think I do mean more of the continuously
updating scenario. Basically using the cost basis
calculation and adding that to a virtual account
that calculates the expected taxes.
Say I have a ledger consisting of a salary paycheck:
$ cat X
2014-01-01 * MyCo Paycheck
Assets:401k:MyCo $100.00 ; 401k: employer
basic
Assets:401k:MyCo $100.00 ; 401k: employer
match
Assets:401k:MyCo $100.00 ; 401k: pre-tax
Assets:401k:MyCo $100.00 ; 401k: post-tax
Assets:Prepaid Tax:Income:Federal $400.00
Liabilities:Tax:Income:Federal $-400.00
Expenses:Tax:Income:Federal $400.00
Expenses:Tax:Federal:MED/EE $60.00
Expenses:Tax:Federal:OASDI/EE $100.00
Expenses:Tax:Ca:Dis/EE $20.00
Assets:Prepaid Tax:Income:Ca $300.00
Liabilities:Tax:Income:Ca $-300.00
Expenses:Tax:Income:Ca $300.00
Expenses:Insurance:Medical $50.00
Expenses:Insurance:Vision $6.00
Income:MyCo:Salary $-2,000.00
Income:MyCo:MyCo:Basic $-100.00
Income:MyCo:MyCo:Match $-100.00
Assets:MyBank:Checking
I can use exact values to calculate the expected tax
liability and prepaid tax (exactly equal in this case):
$ ledger -f X balance Assets:Prepaid
$700.00 Assets:Prepaid Tax:Income
$300.00 Ca
$400.00 Federal
--------------------
$700.00
$ ledger -f X balance Liabilities
$-700.00 Liabilities:Tax:Income
$-300.00 Ca
$-400.00 Federal
--------------------
$-700.00
and I can pivot report on the 401k balance:
$ ledger -f X balance 401k --pivot=401k
$400.00 401k
$100.00 employer basic:Assets:401k:MyCo
$100.00 employer match:Assets:401k:MyCo
$100.00 post-tax:Assets:401k:MyCo
$100.00 pre-tax:Assets:401k:MyCo
--------------------
$400.00
Later on I'll be taking those dollars and buying
stocks or something:
2014-02-02 * 401K Investment
Assets:401k:VIPSX 29.607 VIPSX @@ $400.00
Assets:401k:MyCo
The pivot report show that I'd have a $100.00
cost basis in the 401k, and that everything else
(employer basic, employer match, pre-tax), plus
whatever gains made in excess of $400.00 due
to changes in the stocks, have a liability equal
to some appropriate tax rate.
So I'd like to figure out a way to get a running
approximation of taxes due, so that I can have
a more accurate net worth report, similar to the
Liabilities:Income:Tax accounts I maintain as
part of the salary entry.
Thanks for the feedback, I'll think about this and
will post back anything useful I come up with.
Jim
--
---
You received this message because you are subscribed to the Google Groups
"Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
