Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
One of the most basic accounting principles is that you never delete a transaction. Instead of removing invoices from the table when a customer cancels an order, you can make them void and then use the contents of the void field to filter the table to show only active invoices. In this case, I will need to create a new field that keeps track of whether an invoice is void or not. So, to do that, I will click in the cell beside the right-most table column and name it InvoiceVoid. When I press Enter, Excel adds that field to the table.
The best way to indicate that an invoice has been voided is to add the word Void to the appropriate table column. So in this case, if customer 1825 decided to cancel this order, I can change it so that the invoice is marked as void. To do that, I will just type in the word Void. Now I can filter my table to only show those invoices that are active. To do that, I will click the InvoiceVoid column's filter arrow, clear Select All, and Display only those rows where this field is blank. When I am ready to bring it back, I can click the filter arrow and click Clear Filter.
By contrast, the best way to indicate an invoice is active is to do nothing. It can be difficult to discern between two words in a spreadsheet, especially in a crowded data table, so a blank cell is the best option. Finally, note that the presence or absence of a date in the InvoicePaid field indicates whether an invoice has been paid or not. You don't need to use anything in the InvoiceVoid field to indicate whether payment has been received or not. Voiding invoices maintains a record of your customer interactions. If a customer consistently changes their mind and you end up voiding a lot of their invoices, you might want to fire them as a customer.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 98863 Viewers
80 Video lessons · 141673 Viewers
59 Video lessons · 60022 Viewers
52 Video lessons · 73190 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.