Withdrawals: All the withdrawal entries are to be entered in this column.ĭeposits: All the deposit entries are to be entered in this column.īalance: Balance will show you the balance after each transaction by adding or deducting the deposits and withdrawals. Ref: You can put any reference or check numbers in this column.ĭescription: Description of the payment or receipt You can select the type of transaction from the drop-down menu. Transaction Type: Contains the Transaction types like deposits checks issued, checks receipt, ATM, NEFT, etc. It contains the following column headings: In this section, the user needs to enter the transaction details as and when they occur during the period. Otherwise, it will display “Balanced” next to the cell. If there is a difference then it will display a message “Check Statement” next to the amount. To easily reconcile the entries you need to put “R” next to the entries. If the reconciliation of any entry pending, this section will display it in the outstanding column.Ĭurrent Balance: This cell will display the ending Balance of account as per the data entered by the user.ĭifference: This cell displays the difference if any. Reconciliation Amount: This will reflect the opening balance from the Balance section. If the closing balance will not match the closing balance of the data input section it will show a remark “Incorrect balance” next to this column. Withdrawal: Total of Withdrawals column in the data input section.Ĭlosing Balance: This will reflect the closing balance from the Balance section. Opening Balance: This will reflect the opening balance from the Balance section.ĭeposits: Total of Deposits column in the Data input section. It displays all balances automatically as it contains predefined formulas.
In addition to the above, it consists of the summary section. Opening: Opening balance of Bank and Cash as per the records.Ĭlosing: Closing balance of Bank and Cash as per the records. Insert opening and closing balances in the balance info section on the right side. The Formula given here is =MAX(A15: A41), the last date of entry of the date column.
The Formula given here is =A15, the first line of date column of the data input section. Number: Number for the respective accounts.įrom: Start date. Type: Type of account like Checking, Current, Savings, Personal, etc. Insert the following Account Information: This list is used for creating the dropdown menu in the Checkbook Register Template.Īt the top, there is the heading of the sheet. The Datasheet consists of lists of the type of transactions. This template consists of 2 worksheets: Datasheet and Checkbook Register
#Checkbook pro account definition download#
Important Note: To edit and customize the Google Sheet, save the file on your Google Drive by using the “Make a Copy” option from the File menu.Īdditionally, you can download other accounting templates like Accounts Payable Template with Aging, Accounts Receivable Template with Aging, and Cash Flow Template. You can use this template to keep a track of all your income and expenditures.Ĭlick here to Download All Accounting Excel Templates for ₹299. This template can be helpful to individuals, accounting professional,s, and students. Just insert your bank transaction daily and easily reconcile at the end of every month. We have created an easy to use Checkbook Register Excel Template with predefined formulas. Thus, avoiding unnecessary fees charged on your account. If you maintain Checkbook Register, you can identify those errors and get them corrected.Īdditionally, you can also prevent bouncing back of checks due to the unavailability of balance. Many a time, it happens that bank officials commit some mistakes. Purpose of Maintaining A Checkbook Register It helps you to look where the money is coming/going from and how much is left with you. The Checkbook Register is a crucial document to remain on top of your financials. In simple terms, it records all deposits and withdrawals for a given checking account and used for performing bank reconciliation. Purpose of Maintaining A Checkbook RegisterĪ Checkbook register is a very useful document for keeping track of your Bank balances for personal and business accounts.
0 kommentar(er)
