a checkbook register for actual and bank balance current

[shezageek]

Hi all,

Can anyone point me in the direction of a simple checkbook register that can
also show actual as well as current bank balances? I found a nice one on the
ms templete in personal finance and love it but I do not know how to insert
a colum to calculate current bank balance before items clear.

 

[Paul B]

shezageek, I have one, if you would like to take a look at it let me know an
I will send you a copy

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[shezageek]

Paul,

I would be grateful. I use my current one to sync with my pocket pc so I
didn't want something that would get too too complicated, but would really
like to have that bank balance line added so I could stay ontop of what is
running through the bank when. Thanks again and look forward to trying it
out. Can you attach it to your next post?

Best Regards,

shezageek

 

[Paul B]

shezageek, send me and e-mail and I will send it to you, remove the nospam
from the address
(e-mail address removed) there is an underscore between l_b
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Barbara Wiseman]

shezageek,
I also have an excel template I use, I put all the entries in to give a
balance in one column, then when they are cleared though the bank I put the
clearance date in another column to give me the cleared balance in a 'bank
balance' column automatically by formula.
I would be happy to send a copy.
Do send me your email address to
(e-mail address removed)
remove the NOSPAM
Barbara

 

[shezageek]

It has been sent!

shezageek, send me and e-mail and I will send it to you, remove the nospam
from the address
(e-mail address removed) there is an underscore between l_b
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[shezageek]

It has been sent!

shezageek,
I also have an excel template I use, I put all the entries in to give a
balance in one column, then when they are cleared though the bank I put
the
clearance date in another column to give me the cleared balance in a 'bank
balance' column automatically by formula.
I would be happy to send a copy.
Do send me your email address to
(e-mail address removed)
remove the NOSPAM
Barbara

 

[Paul B]

I have sent you the file

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Barbara Wiseman]

The template has been sent to your email address, enjoy.
Barbara

 

[shezageek]

Hi Paul,

When you get to the end of the check book you have instructions to drag
down. Can you please explain what this means exactly and how to extend the
register? Thanks so much.

 

[Don Guillett]

drag down means to select the cell(s) you want>grab the fill handle on the
lower right of the rightmost cell and "drag down"

 

[shezageek]

ok Don,

didn't realize there was a fill handle.

next question it gives me the options to copy or fill formatting or without.
However nothing happens when I select any of those options...the sheet
remains unchanged. I am extending the check book so I would assume that is
the option I want but I must be missing something previous to this. Please
advise.

 

[Don Guillett]

If you use the options, as I recall, it's AFTER the drag is complete

 

[shezageek]

Got it. Started playing around with it and by accident discover this as
well. Thanks again.

 

[Don Guillett]

glad to help