Summarising bank balances
Colin Law
clanlaw at googlemail.com
Sun Mar 4 12:21:25 EST 2012
John, don't forget to use reply to all or reply to list when replying,
your replies have been coming to me rather than the list.
On 4 March 2012 17:05, John Bibby <johnbibbyjohnbibby at gmail.com> wrote:
> Hi Colin
>
> My problem with that is that different columns will have different lengths.
> Also, where would I put the tags relating to each account? (I suppose that
> could go at the top: the key thing that GC seems to be lacking is the
> ability to put in a balance and then it calculates the transaction)
In GC you can specify a calculation when you enter a transaction. So
if the old balance is, say, 135.25 and the new balance is 760.33 then
just enter a transaction by typing 760.33 - 135.25 in the appropriate
column and it will work out the calculation for you.
Colin
>
> Your suggestion may be the best available and thanks
>
> JOHN
>
>
> On 4 March 2012 16:58, Colin Law <clanlaw at googlemail.com> wrote:
>>
>> 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
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>
--
gplus.to/clanlaw
More information about the gnucash-user
mailing list