![]() To add more clarity, when balancing your checkbook, the register displays a message to notify you that THE CHECKBOOK IS BALANCED when everything is balanced. The overview also reflects the amount to reconcile, your current checkbook balance and the final balance difference, if any. The summary displays the beginning balance, total of your deposits and withdrawals, and the end balance. Your transactions will reside in the "outstanding" column of the "Reconciliation Data" area for the time being until you are ready to reconcile.Īt the top of the worksheet you will find a summary overview of your checkbook. For that reason you may have to wait until transactions are reflected and only then reconcile each of your entries by entering "r" or "R" in the corresponding cells. If you are issuing a check or receiving a deposit by check, your transaction may not appear immediately on your bank account. When this step is completed, you are ready to start recording your transactions as they occur. If you have no opening balance, you may enter "0" or leave it blank. ![]() First, to ensure accuracy, you have to enter your Opening Balance if required, which essentially is the same as the "Balance Carried Forward". The main worksheet, labeled "Register", is where you will spend most of your time, but before you start recording your transactions, there are a couple of things you may need to do. The list already contains some predefined transaction types, which, if necessary, you can customize and add more rows for any new transaction type. It’s also wise to save the information in backups in case of data loss, and save them with a file name that reflects the period of time or the check range that is covered in the file, for easier sorting and saving into whatever filing system that is most convenient.Įveryone needs to keep track of their money, use the Excel Checkbook Register template to make it easier, and make the end result more useful and more readily available in the future when it’s actually needed.You can add and define transaction types on the Settings worksheet of this template. The interface is fully customizable, and readily available for download, so feel free to make it your own, colors and patterns can be used with the template to make it easier to read or simply more pleasant to look at, and using the sort function can present the information organized in any fashion that is desired. Additional Tips on Using the Excel Checkbook Register How to Use the Excel Checkbook Register TemplateĪfter downloading the free template from this page and opening it, fill in the data for the individual fields that are given, including a check number, a brief description of the transaction, and whether the check was a credit or debit, the fields are optional, with the exception of the credit and debit fields, as they contribute to the formula that gives the running balance on the far right side. ![]() The Excel checkbook register offers a convenient, easy-to-use method of keeping finances in order in a way that’s much simpler and more practical than the classic ledger format, presenting the same information, in a more accessible, versatile fashion. So the alternative? Use an Excel checkbook register template to provide a clean, easily sorted register of all checks written, easily re-organized by amount, date, or check number, and even gives the balance of all entered checks automatically. Certainly a ledger can be kept in the checkbook in question, but the ledger is easy to forget, difficult to sort through, and can overall simply be a hassle to use. ![]() Keeping track of money can be difficult to say the least, particularly in check form. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |