a checkbook register for actual and bank balance current

S

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.
 
P

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
 
S

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
 
P

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
 
B

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
 
S

shezageek

It has been sent!


Paul B said:
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
 
S

shezageek

It has been sent!


Barbara Wiseman said:
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
 
P

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
 
S

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.
 
D

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"
 
S

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.
 
S

shezageek

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top