Summarising bank balances

[Colin Law]

On 4 March 2012 16:50, John Bibby <johnbibbyjohnbibby at gmail.com> wrote:
> Dear Colin
>
> Thanks for your suggestion.
>
> I started with a spreadsheet. But the problem was that each time you update
> the balance in any account, it over-writes the previous balance. (Unless you
> have some spreadsheet wheeze that I have not thought of.)

Have a column for the date and a column for each account balance.
Each month (or quarter or whatever) add a new row at the bottom with
the date and the account values, so that the history is not lost.
Then you can get a report for a particular date, the report will find
the correct row to use based on the requested date.

Colin

>
> JOHN
>
>
>
> On 4 March 2012 16:44, Colin Law <clanlaw at googlemail.com> wrote:
>>
>> On 4 March 2012 16:40, John Bibby <johnbibbyjohnbibby at gmail.com> wrote:
>> > Hullo. I am new to Gnucash and I hope this is an easy question.
>> >
>> > 1. I want to use Gnucash to track my bank balances every so often - I do
>> > not need or want to have to enter the individual transactions. I simply
>> > want e.g. when at the end of the Quarter I get my statement for Account
>> > X,
>> > I want to be able to put the date and balance into Gnucash. (If it sets
>> > up
>> > a dummy transfer that is OK.)
>> >
>> > 2. Then I will want to print a report  listing the account names and
>> > some
>> > details, along with the latest balance - and some totals.
>> >
>> > 3. I want to be able to record some details too for each account - e.g.
>> > owner (self, wife or joint), type of account (fixed, ISA or whatever),
>> > rate
>> > of interest and any time-periods, etc etc.
>> >
>> > I'd welcome your advice please on how to do 1, 2 and 3.
>>
>> I am not sure that GC is the best tool for the job if that is all you
>> want.  I think maybe just a spreadsheet would be better.
>>
>> Colin
>
>



-- 
gplus.to/clanlaw