Problems with cash balance on investment transactions report

[tjhughes72]

Hello Mark,

I'm a newbie to your software and the forums - I'm evaluating it to see if it can help me keep track of my investments.

I am trying to reconcile my default cash account with my own Excel spreadsheet and the "balance" column doesn't seem accurate. It does not seem to keep the correct running total. The balance seems to just stay the same despite a number of transactions over more than one day (I had initially thought it was a just showing an end of day balance).

I have copied and pasted my cash balance report below. If you look at the individual transactions and the values listed in "amount" you can see that these don't tally with the values in "balance". Could you help?

Many thanks,

Tom

++++++++++++++++++++++++++++++++++++++++++++++



Date Transaction Price Shares Fee Amount (GBP) Memo Shr Blnc Balance (GBP)
23/01/2009 TxIn 3,000,000 3,000,000.00 Initial cash injection of £3MM 3,000,000 3,000,000.00
29/01/2009 TxOut -1,000,000 -1,000,000.00 Cash withdrawl of £1MM 2,000,000 2,000,000.00
13/02/2009 Sell 1 -250,000 -250,000.00 Bought 250,000 BGI Sterling Liquidity Fund 1,383,872 1,383,872.26
13/02/2009 Sell 1 -250,000 -250,000.00 Bought 250,000 JP Morgan Sterling Liquidity Fund 1,383,872 1,383,872.26
13/02/2009 Sell 1 -28,958 -28,957.50 Bought 55,000 Threadneedle UK Equity Income Retail 1,383,872 1,383,872.26
13/02/2009 Buy 1 715 715 Distributed Return of Capital from Threadneedle UK Equity In 1,383,872 1,383,872.26
13/02/2009 Sell 1 -29,034 -29,034.00 Bought 45,000 Martin Currie Asia Pacific A 1,383,872 1,383,872.26
13/02/2009 Sell 1 -29,184 -29,184.00 Bought 24,000 Martin Currie Nth American A 1,383,872 1,383,872.26
13/02/2009 Sell 1 -29,667 -29,667.24 Bought 9,200 Cazenove European B 1,383,872 1,383,872.26
12/03/2009 Acct Fee -2,512.37 Fees 27 Jan to 11 March 09 1,383,872 1,383,872.26
13/03/2009 Int Inc 1,660.83 Interest on UBS GBP cash AC 1,383,872 1,383,872.26
18/03/2009 Int Inc 454.11 Interest on UBS GBP cash AC 1,383,872 1,383,872.26
24/03/2009 Sell 1 -397 -397.26 Accrued Interest for Heineken 7.25% bond 2015 1,251,632 1,251,631.87
24/03/2009 Sell 1 -100,637 -100,637.26 Bought 100,000 Heineken 7.25% bond 2015 1,251,632 1,251,631.87
24/03/2009 Sell 1 -31,206 -31,205.87 Bought 3,000 GlaxoSmithKline 1,251,632 1,251,631.87

[tjhughes72]

I tried ticking the "reinvested" box and that seemed to do the trick...

Sorry,

Tom

[Mark]

Hi Tom,

Glad you got it working. Just a couple hints... The "Balance" column is showing the end of day balance, not the end of that transaction balance. Also, only transactions that have shares, will change the share balance (and thus value balance). For example, distribution distributions is money paid out, and not put back in. By checking "reinvested" you are buying more shares with that distribution.