How do I set up a checkbook register?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
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
 
Back
Top