Simple cash book (UK style), help

[Jon1954]

Hi
My first post so hope it's in the right forum.
I can fly basic Excel and am familiar with spread sheets but not to a great depth.
I'd like a simple cash book setup with (and I'm not sure of the correct terminology here) a continual new line function !
Basically if I fill in the first line, I'd like a new one to appear below once it's completed so it expands naturally while retaining the totals and balances on the bottom line.
I prefer to enter expenses and dates on the left with relevant sections such as Electric, motor exp, R&R on the top line.
In addition it would be very useful to have a monthly report facility.

Possibly there's already something here which might do this and if so could someone point me at it please.
Many thanks

[Russell Dawson]

Hi Jon

Welcome to the forum.

There are lots of templates out there but if you have something in mind then why not try it yourself. The way you describe it I understand, but instead of increasing the depth of your worksheet so that your total is always one step ahead of you (as it were) - why not have the total always at the top.

Regards

Russell

[Jon1954]

Hi
Possibly I'm locked in to a rather old fashioned visual format.
I just wanted to get 1 step ahead of doing a manual "insert line"
I've found most accountancy packages too cluttered with features so was going back to basics.
Might be better to not spend much time on this one

[Russell Dawson]

Jon

Don't be discouraged. Why not create your own and if you get into difficulties then post here again. Try your "old fashioned" ideas - the main thing is that you have a visualisation of what you want to achieve. You have Excel knowledge so give it go. Nothing to lose!

Having a project and something in mind is a great way to improve.

Regards

Russell

[Jon1954]

Ok so I'm managing now with manual insert line which keeps the bottom line totals intact.
I'm now trying to figure out how to extract monthly totals to a second report sheet without chopping up the running figures on sheet 1.
I assume there will be a =sum function that will add sheet 1 (e1:f7) and place a result where I want it on sheet 2. How do I point the sheet 2 function at sheet 1 to get a result?

[Russell Dawson]

In sheet2 commence your calc in the appropriate cell

=sum( then select sheet1 and the range e1:e7 and then close brackets.

Help is just down the A64 !

[Jon1954]

Thank you both for the information and being overall helpful with what to many must appear to be a basic level query.
I think this will do for the moment, till I get sheet 1 populated with some meaningful data.
I love the pure logic of spread sheets, but lack an understanding of appropriate terminology which would enable me to ask precise questions.