Template: Checking Account Register for Apple iWorks Numbers ‘08
August 23rd, 2007 | by Michael |
By request. This is a simple spreadsheet to keep a record of your checking account transactions
Usage:
- Enter a beginning balance, and date, in the upper right hand corner of the sheet.
- Enter transactions as they occur, the running balance will be calculated for you.
- Check the check box for the transactions as they clear the bank.
You may want to keep a different sheet for each month. Otherwise, when you reach the bottom, add more rows, and copy the formulas down.
Download Check Account Register Template
10 Responses to “Template: Checking Account Register for Apple iWorks Numbers ‘08”
By Jared on Aug 24, 2007 | Reply
Cool, thanks for this!
Do you know if there’s a relatively easy way to build on this? I keep a very basic ledger of business income and expenses in separate tables, it would be handy to have that information automatically flow into a check register like this one.
By Michael on Aug 24, 2007 | Reply
Jared,
I think you could do something like that fairly easily, but you may consider going at it from the other direction.
If I were going to tackle it, I would add an extra column in the register for income/expense type. Then, in my income statement I would use the SUMIF() function, along with the OFFSET() function to total my stuff automatically by category.
Good luck!
- Michael
By loki on Sep 4, 2007 | Reply
I’m fairly new to spreadsheet use. But I really like the idea of being able to track my expenses like this. How difficult would it be for me to create a drop down column (eg., Food, Entertainment, Gas, Bills, etc…) for this register and have a second table add up all of the expenses for a given type of expense?
By Michael on Sep 6, 2007 | Reply
Loki,
I think your idea would be fairly easy to implement. You add a column for expense type. Then, in another table, use the sumif() function to total your expenses by type.
- Michael
By Not So Good with Numbers on Sep 7, 2007 | Reply
Could you post a solution for tracking mileage for business reimbursement? I’ve seen the gas mileage sheets, but they don’t include (miles) * (IRS allowed rate for mileage) = total.
Sorry I’m an extreme novice with calculations, and even Numbers, simple as it is, is a bit overwhelming.
Thanks.
By Darrin on Nov 8, 2007 | Reply
Thank you for taking the time to create this. Very nice. Im new to spreadsheets and wondering where I would go to learnhow to do something like this myself. As of right now there arent a whole lot of tutorials on numbers.app.
By Michael on Nov 11, 2007 | Reply
Darrin,
Check out our forums, and of course keep reading this site!
- Michael
By JeremyC on Mar 8, 2008 | Reply
Does anyone know of a way to add split transactions to a register like this to account for multiple categories?