In each Excel checkbook register template, using the category field, you can tag your financial transactions with a spending category such as groceries, restaurants or gas or an income category such as salary or bonus. Checkbook Features: (watch video below for overview) Start tracking your money and spending so you can take control of your finances, know where your money is going, cut expenses, and save money for your future. Track up to 10 of your personal financial accounts in the registers whether they are bank accounts, credit card accounts, savings accounts or other financial accounts. Since the voided transaction was never posted by the bank or credit card company, there is nothing to match or compare during account reconciliation.Excel checkbook register with categories, account reconciliation, and spending reports to manage your money in Microsoft Excel. When its time to do your bank reconciliation, you can mark the voided transaction as Reconciled (cleared) so it will not show up as an outstanding transaction. If you want to keep an audit trail of the transaction in the register, then voiding the transaction is better then deleting the transaction in the register. Then you can change the amount in the Amount column to $0.00. To void a transaction in the Excel register, you can just leave the transaction in there Excel register and mark is as "VOID" in one the fields such as the Memo field. How to void a transaction in the Excel checkbook register? Note: the Delete Empty Rows & Sort button will not work if there are error message(s) in the Balance column other than "missing data in row?" You must first fix those errors and then use Delete Empty Rows & Sort.Ĭlicking the Delete Empty Rows & Sort button will first remove any applied Filters in the Register and then it will delete empty rows and sort. If the transaction(s) to be deleted are at the bottom of the transactions listed in the Register, then just select them and use the Delete key to delete those transactions. Then use the Delete Empty Rows & Sort button to delete empty row(s) and then sort. If you want to delete a transaction(s) that are not at the bottom of the transactions, select the transaction(s) to be deleted and press the Delete key or use the Clear Contents command. The Delete Empty Rows & Sort button at the top of the Registers is to delete empty rows and sort the Register. Do not use the "Clear all" or "Clear formats" commands. To delete information in cells, use the Delete key on the keyboard or the "Clear Contents" command. Please note that if you delete a transaction in the Excel checkbook register, that information will be gone from the Excel checkbook register and Excel file if you save the Excel file after you perform the steps to delete the transaction. How to delete a transaction in the Excel checkbook register?īefore you delete a transaction, make a backup copy of the Excel file that has the information you plan to delete and name the backup copy appropriately. Deleting or voiding a transaction applies whether you are using the register to track your bank accounts or credit card accounts. Be careful deleting transactions in the register already marked as Reconciled (cleared) as this could impact your account reconciliation. For example, you may have duplicated a transaction in the Excel checkbook registers (entered the same transaction twice by mistake) or wrote a check and entered the check into the Excel checkbook register and then decided to void the check or maybe you just entered a dummy (test) transaction in the Excel checkbook register. There are different reasons to delete or void a transaction. Why delete or void transactions in the Excel register? Applies to Excel templates: " Georges Budget for Excel", " Georges Excel Checkbook Register", " Georges Excel Checkbook for Mac"
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |