A few months ago I posted about my switch from FileMaker Pro to Numbers for my client invoice tracking. It’s worked out very well. Recently upon opening the iFinance app where I track my banking I was greeted to a message that there was a new version available. The amount is not too much but my current version works fine and browsing through the changes I didn’t see anything new that I needed. But it brought to mind that it would mean that the current version wouldn’t be seeing any more updates. Not a problem for now but perhaps in the future with OS updates. So, I had a similar thought, why not try to move my banking to a Numbers spreadsheet?
My needs are pretty basic. I wanted to mimic iFinance. I exported each account to a CSV and imported into Numbers. Then I created a master account file and set-up multiple sheets, one each for the various accounts. So, for example, Cash, Apple Cash, bank, PayPal, credit card, etc. Each is a simple line-item ledger that keeps a balance along with the usual: date, description, payee, category and note if needed.
The table for cash on hand. Different accounts are visible in the top row of sheet tabs.
The first sheet, Account Overview, consists of a series of simple 1 row, 2 column tables each showing the balance of each account. At the top is a table that calculates the total balance of all the accounts. Last, I added a simple bar graph showing the total amount in each accounts.
The Account Overview shows the current balance of each account as well as a bar graph.
It’s fairly simple but works exactly as I hoped and only took a couple hours to create. I can open with any of my devices and I know that because it’s based on Apple’s own Numbers app, it’s likely to be supported for years to come.