You can make a difference in the Apple Support Community!

When you sign up with your Apple ID, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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