8/6/2023 0 Comments Checkbook calculator excel![]() Notice the formula is automatically filled in. This allows me to enter in new data by simply going over here to the check number, hitting Return, and then entering in the check number and the other data. I'm going to grab the bottom handle here and shrink it all the way up there so there are no extra rows. So here we can see it added $400 and subtracted $67. ![]() Now it will pull the balance from the row above and subtract the withdrawal of the current row and add the deposit of the current row. Now that I've done that I can Copy this cell and paste it in the remaining rows. Then I'm going to subtract the withdrawal. For the second row here I'm going to do a similar formula but I'm going to start with the balance in the row above. Now this first row is the only time we're going to refer to the Starting Balance. ![]() Then I hit Return and I'll get the balance after this check has been written out. I'm going to start with the Starting Balance and we're going to then subtract any withdrawal in this row and add any deposits. To do the first balance calculation I'll hit the equals key here to start entering in a formula. So now I've got a starting balance of $2000. You can adjust these tables and move them around as you want. Let's say we're starting with $2000 in this account at the time that we're starting to keep track of this. We'll move that over here, kind of above the balance column and we'll enter in the starting balance. We're going to call that table Starting Balance. Move it up here above Bank Account and let's shrink it down so it's one by one because there's only going to be one number in this table. We're going to insert another table and just use a blank table like that. First we'll name this one Bank Account and I'll move it down somewhat to make room for another table up here. To do that we're going to need a starting balance. Now it's time to calculate the balance based on that. You could see here I've added a few more checks and another deposit as well. Let's say here there's no withdrawal but there is a deposit of $400. Now there may be a deposit number or something you have and you could enter that here or you could leave that blank. Then let's say on the next day there's a deposit. Let's say there's another check and that's on the next day and that's for $45. I won't worry about filling out Recipients here. Then we'll have a column here for Miscellaneous Notes which is always important. To be able to keep track of how much money is in the account at any time according to the amounts deposited or withdrawn. The next column is going to be the running balance which is the whole point of the spreadsheet. You would never have a row where there's something in both of these cells. If it's a deposit, money going into the account, the number would go here. The idea would be that if this row represents a withdrawal, a check written out, the number would go here. So instead of calling it an amount we'll call it Withdrawal and then the next column we'll call the Deposit. Now here we can put the amount of the check.īut a checkbook should also record any deposits. Now we're not always going to use a check number but it's going to be common enough that we can use that as the header column. Now you have the Header column here and we can keep that because there is a unique identifier for each item here. So let's start off with a standard blank template here in Numbers. This is actually a good example to use to start learning how to use formulas in Numbers. But the tricky part is calculating the current balance based on each row of the checkbook. So a checkbook is basically a running record of deposits and withdrawals from you checking account. So I've been asked a few times recently about doing a basic checkbook in Mac Numbers. Join us and get exclusive content and course discounts. There you can read more about the Patreon Campaign. MacMost is brought to you thanks to a great group of more than 600 supporters. Today let me show you how to do a basic checkbook in Mac Numbers. Check out How To Make a Basic Checkbook Spreadsheet With Numbers On a Mac at YouTube for closed captioning and more options.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |