A checkbook register template is the kind of template that people can use to make record of every expense that they pay with their checkbook. Using checkbook is very convenient since all they need to do is write the amount and sign on it. But how to keep records for every single check that they make? This is when this template comes handy. It is simply a template that people can use to keep everything in order. This way by the end of the month they can see how much money that they spend out using their checkbook. When dealing with a monthly budget, this record will be very helpful. The owner can evaluate their expenses and see which expenses that actually he or she doesn’t really need so they can cut it out next time. Checkbook Register Template The templates consist of personal information of the checkbook owner, checkbook period, beginning balance, statement balance, and checkbook balance. Then it will list on the type of expenses, category, description, debit, credit and balance. ![]() ![]() It looks like a simple accounting job but it is far easier to work on. The description about the type and category of person’s expenses and income is available at different page that people can refer to when they evaluate the information that they have written down for the whole month. [wpdm_file id=55]. Posted in category Maintaining a Checkbook Register is crucial for staying on top of your financial well-being and re-assuring yourself with up-to-date information of your spending. It also keeps a check on your extra spending habits, as you are forced to look at where the money is going and how much you are left with. Also, there can be those rare events when bank commits mistakes, you can identify them and get them corrected. Lastly, you can also prevent the events of bounced checks and unnecessary fees charged on your account. How to use Checkbook Register First of all you can define type of transactions with their actual definitions in the first sheet of this template. You can add more transaction types as and when you discover new ones. Thereafter you can use the second sheet named 'Register' to record the Account number, dates between which the records are maintained and opening and closing bank and cash balances. Then under the transactions table, in the first row specify the 'Balance Carried Forward' if any or otherwise enter '0' and start recording transactions as when a deposit or withdrawal happens. In case you are issuing a check or receiving deposit by check then your transaction may not appear immediately on your bank account as a debit or credit hence you need to wait till it reflects and then you can mark your transactions as reconciled in this sheet by writing 'r' or 'R' against it. Till you mark them as Reconciled, you transaction will appear as 'Outstanding' in Reconciliation Data. On the top of sheet you can watch the Summary where it shows beginning balance, total deposits and withdrawals and end balance. It also reflects the amount to reconcile, current check book balance and final difference, if any. How to Create a Simple Checkbook Register With Microsoft Excel. Each of these versions also works a little bit. Click on the first template option. This free electronic checkbook register spreadsheet in Microsoft Excel XLS format can be downloaded for balancing of any checkbook, business or personal. Microsoft works free download software. And save documents in the Works Downloadthe Latest from Microsoft Windows. Georges Excel Checkbook Register. ![]() For clear indication of financial state, the checkbook register clearly show a message in green - THE CHECKBOOK IS BALANCED when everything is balanced or message in red appears that says - CHECK BANK CLOSING BALANCE, if a incorrect entry is done or some other mistake is done while recording. We recommend you to record transactions as early as possible in this sheet, if not daily, to avoid any mistakes, saving you hours of effort in identifying the missed transactions. In case you are managing multiple account, you can create copies of this sheet. Also remember not to delete formulas that is contained in 'Balance' column, 'Reconciliation Data' section and 'Summary' section. Once you become more familiar with the template you can simply protect these columns from unnecessary changes using Excel's Protect Sheet option. Add more rows Adding additional rows can be little tricky as most formulas which calculate totals have to expand correctly to accommodate new rows that you will add. Watch this short video to learn how to do it to avoid possible complications. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |