Check out How To Make a Basic Checkbook Spreadsheet With Numbers On a Mac at YouTube for closed captioning and more options.
Check out How To Make a Basic Checkbook Spreadsheet With Numbers On a Mac at YouTube for closed captioning and more options.
I wrote one of these spreadsheets last year, but I like yours better. Thank you!
Gary, Great video. I have been using a numbers spreadsheet for years. The biggest difference being the first row has the beginning balance in the deposit column with the note stating Starting balance. Works the same. Thanks for all you do.
Gary,
Why go to the effort of creating a starting balance table when it is only used once.
I feel it is simpler to put a starting balance on the very first empty row before any transactions begin to be recored.
Martin: It really isn’t much effort. There are some good reasons to place this unique value into a separate table. For instance, say you want to use COUNT to count the number of transactions. You don’t want that special row counted. Saw you want to double-click on the column heading to select all of the cells in the column to re-paste the formula or do something else — you would get that special unique row also if you did that.
Great one for this Numbers newbie. Thanks Gary.
I am getting an error when I try to copy and paste the formula. It tells me this: The operator “-” expects a number, date, or duration, but cell D4 contains a string. What is my problem?
Arthur: What do you have in cell D4? Is it a number? When you select D4, what does it show as the cell type in the bottom left corner of the window?
In this spreadsheet/checkbook, is there a way to use filters to see what you are spending on a particular type/category? For budgeting purposes?
Randy: Check out Smart Categories https://macmost.com/using-smart-categories-pivot-tables-in-mac-numbers.html