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
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
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.
An old version of Numbers used to include a checking register template.
Here is a document that includes it and two modernized versions. One of these may work for you.
Checking Register (Dropbox download).
SG
You can post dropbox links???? Any links I post, including to Dropbox or iCloud last a few moments then get deleted. Maybe I'm not covering them like you are; I post the URL directly.
Checkbook Register