Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers checkbook register template

Does anyone have a useful checkbook register template to use with Numbers?

MacBook Pro, macOS Sierra (10.12.1)

Posted on Apr 5, 2017 2:47 PM

Reply
Question marked as Top-ranking reply

Posted on Apr 5, 2017 3:27 PM

There is not a checkbook registry built-in but you can make one by entering the column names:


User uploaded file


then make the first row a header row by using the contextual menu for the row:

User uploaded file



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

User uploaded file



if you would rather have a debit and credit column, try something like this:

User uploaded file



use the formula:

F2=IF(OR(D2≠"", E2≠""), SUM($D$2:D2)−SUM($E$2:E2), "")


fill F2 down like before

2 replies
Question marked as Top-ranking reply

Apr 5, 2017 3:27 PM in response to deerc_1948

There is not a checkbook registry built-in but you can make one by entering the column names:


User uploaded file


then make the first row a header row by using the contextual menu for the row:

User uploaded file



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

User uploaded file



if you would rather have a debit and credit column, try something like this:

User uploaded file



use the formula:

F2=IF(OR(D2≠"", E2≠""), SUM($D$2:D2)−SUM($E$2:E2), "")


fill F2 down like before

Numbers checkbook register template

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.