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
{ 2 trackbacks }
{ 12 comments… read them below or add one }
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.
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
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?
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
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.
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.
Darrin,
Check out our forums, and of course keep reading this site!
- Michael
Does anyone know of a way to add split transactions to a register like this to account for multiple categories?
Can you please explain how to extend the functionality of the spreasdheet beyond the rows that are already part of the template? In other words, I have reached the end of the template and I don’t seem to be able to add additional working rows. i tried to poush “add additional row”, but this does not carry with it the calculating formulas.
Thank you for your help!
I dl your check registry and works great. How can I make a pie chart at the bottom of this template that gives per cent of different bills? Thanks
I’m new with “numbers” and find “register” very helpful, I have same question with Gio…how do I continue on with the spreadsheet and still keep the function of the register?
thanks…….i figured it out