How do I set up a checkbook register?

G

Guest

I would like to set up a checkbook register in excel. I have a basic idea but
the total column fills before I put an entry in the row.
 
B

Biff

Hi!

Change your total formula so that it won't show the total
until/unless there are enties in either the debit or
deposit fields. EG:

D2 = debits
E2 = deposits
H2 = total or balance

formula in H2:

=IF(OR(D2="",E2=""),"",Your Total Formula)

Biff
 
B

Biff

Ooops!

Change that to:

=IF(AND(D2="",E2=""),"",Your Total Formula)

Or, you can just choose which ever field you'd like. I
have mine setup to test the first field which is the date.

Here are some tips that I have incorporated into my
register.

I use dropdown lists in most fields so that I'm just
pointing and clicking. I point and click for the date, the
check number, the transaction description, any bank fees
like atm fees, the reconciliation field, and regular
deposit amounts. Basically, all I enter is a debit amount.
Reconciliation is a piece of cake!

Biff
 

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

Similar Threads

how do I create a checkbook register in excell 1
Checkbook Register template 5
Checkbook Register 5
Another Autocomplete question! 1
Excel checkbook register 2
how do i add a formula to a cell that will add or subrtact from d. 2
how do i create a running balance on checkbook register 5
Checkbook Spreadsheet for Excel 5

Top