Checkbook Register

Need a simple checkbook register that works using numbers.The examples I found do not deduct or add amounts ,just keeps repeating the original starting balance.



Thank You

Posted on May 15, 2023 5:30 AM

Reply
3 replies

May 15, 2023 7:16 AM in response to runner1330

The joy is you can design whatever you want to fit how you want to do it. Here is one I made for my use:


Row 10 in the screenshot is a footer row.

Column A is formatted as text, justified to the right. You could format it as Numeral System with 4 places if you don't want to type leading zeros.


Formula in cell F2 is =SUM(OFFSET(E$1,1,0,ROW()−1,1))−SUM(OFFSET(D$1,1,0,ROW()−1,1))

Fill down to complete the column other than the footer row.


F10 =SUMIF(G,TRUE,E)−SUMIF(G,TRUE,D)


With these formulas you can rearrange, add, or delete rows without having to redo any formulas. The footer has the balance of the reconciled items.

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.

Checkbook Register

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