Since the voided transaction was never posted by the bank or credit card company, there is nothing to match or compare during account reconciliation.With reduced hours in branches and measures of physical distancing in place due to COVID-19, here are some ways for personal and business members to continue doing their banking. 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. Select the account for which you want a cheque book for. ![]() All your account details will be displayed. Click on the Cheque Book Request option, from the drop-down menu. On the new page, click on Request & Enquiries option after login. 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. Visit SBI net banking account and enter your user name and password. 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. |