Summarising bank balances
clanlaw at googlemail.com
Sun Mar 4 11:58:24 EST 2012
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.
> 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.
More information about the gnucash-user