This is simply a few columns I use to help reconcile the checkbook. To the right of the checkbook grid is the reconciliation data. Any other letter won't register properly. It can be upper or lower case, but it must be an x. Important note: When reconciling, only use an "x" in column B. If all is well, your account should reconcile. When you get your bank statement, enter the balance according to the statement in cell H3. You reconcile it much like you would an ordinary checkbook, except it does all the math for you. New in version 2.0 is a reconcile ability. You'll just have to hope that you haven't made a mistake or forgotten to enter a check -) While reconciling your checkbook on a regular (monthly) basis is a wonderful thing, this Simple Checkbook will operate just fine if you never reconcile it. If it is not, go through deposits, credits, check amounts and withdrawls looking for the error. Hopefully everything balances and cell H4 is 0.00. Second, go through your bank statement line by line and enter an "x" in column B for each item accounted for in your bank statement. If that result is zero then all items are accurate and accounted for and the checking account is "reconciled".įirst, enter your account balance according to your bank statement in cell H3. In short, a checkbook is "reconciled" when outstanding checks are subtracted from the bank balance and the result is compared to your checkbook balance. If you've never reconciled a checkbook before then these notes may be useful to you. A recent backup copy will save you grief.
Also, keep in mind that if your computer crashes or the power goes off while you are editing your checkbook, some data may be lost (even if you save frequently).
#FREE CHECKBOOK REGISTER FOR MAC ZIP#
In addition, it is good practice to regularly save copies of your checkbooks to a floppy, CD, zip drive, tape drive or another hard drive. Make sure your spreadsheet program is configured to save a backup copy of your data. You can also use Simple Checkbook for savings accounts.īe sure to back up your data regularly. Rename that copy to say, My Other Account.xls. If you have another account, again copy Checkbook.xls. Rename that copy to whatever you wish, say My Account.xls. Let's suppose you'll use the Excel version (.xls). That's the equivalent of 50 packs of standard checks. This will display a listing of all values previously entered in that column.
With the Excel version you can right click and choose "Pick from list." in the transaction column. As soon as you tab to the next cell, the current year will be filled in automatically. The date column is such that all you need to enter is the month & date (1/22). There are enough wünderprograms out there for all that. It won't make coffee and it won't take out the trash. It won't budget and supposedly solve all your financial woes. It won't remind you to pay the electric bill. It won't go online and retrieve bank statements. Drop me a line if you use it and like it. You'll need Microsoft Excel, Microsoft Works or Star Office to use it.Ĭost: Nothing. Requirements: This is not a standalone program. It's just a simple spreadsheet and I've included an MS Excel version (.xls), an MS Works version (.wks) and a Sun Star Office version (.sdc). It's laid out like a regular checkbook and you fill it in like a regular checkbook. In function it is exactly like your little paper checkbook register - except you don't have to do the math and it makes reconciliation a breeze.
0 kommentar(er)
