The Cleared Balance cell on top takes into account if the entry has been checked off in the Cleared cell, such as if a check has not been processed by the bank yet. The Balance formula for each line is the sum of Deposits from that line down to the bottom minus the sum of the Debits from that line down to the bottom. I have my entries in reverse chronological order, with the newest entries on the top so they are always easy to see. The solution for me was to create my own checkbook spreadsheet in Apple Numbers.Īs shown below, I set up the spreadsheet similar to what you might see in a checkbook register. However, these 3rd party apps always seemed to have syncing issues. The apps I tried had Mac and iOS versions that work together so that I could look at the register from any device I was working on. I mainly just want to have a running list of deposits and debits so I know what my balances will be at any point. For years, I tried different checkbook apps to keep track of my bank checking and saving accounts.

Check register templates for mac