Numbers checkbook register template
Does anyone have a useful checkbook register template to use with Numbers?
MacBook Pro, macOS Sierra (10.12.1)
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Does anyone have a useful checkbook register template to use with Numbers?
MacBook Pro, macOS Sierra (10.12.1)
There is not a checkbook registry built-in but you can make one by entering the column names:
then make the first row a header row by using the contextual menu for the row:
Then add the formula in the column for "Balance"
E2=IF(D2<>"", SUM($D$2:D2), "")
this is shorthand for... select cell E2 then type (or copy and paste from here) the formula:
=IF(D2<>"", SUM($D$2:D2), "")
to fill down, select cell E2, copy
now select cells E2 thru the end of column E, paste
if you would rather have a debit and credit column, try something like this:
use the formula:
F2=IF(OR(D2≠"", E2≠""), SUM($D$2:D2)−SUM($E$2:E2), "")
fill F2 down like before
There is not a checkbook registry built-in but you can make one by entering the column names:
then make the first row a header row by using the contextual menu for the row:
Then add the formula in the column for "Balance"
E2=IF(D2<>"", SUM($D$2:D2), "")
this is shorthand for... select cell E2 then type (or copy and paste from here) the formula:
=IF(D2<>"", SUM($D$2:D2), "")
to fill down, select cell E2, copy
now select cells E2 thru the end of column E, paste
if you would rather have a debit and credit column, try something like this:
use the formula:
F2=IF(OR(D2≠"", E2≠""), SUM($D$2:D2)−SUM($E$2:E2), "")
fill F2 down like before
Thank you.
Numbers checkbook register template