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

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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.