![]() Execute and document your past due procedures.Filter the due date column, such that only those items past the due date are shown.Add a column to the end of the template and label it “Notes”.Here is how you could leverage this template to monitor past due invoices. However, the fact remains there will still be old items that must be dealt with. By establishing a process to better manage accounts receivable while current, the amount of past due invoices should be minimized. Past due invoices are not the focus of this post. Going through this process on a regular basis and establishing a formal process will help you company better manage its accounts receivable. To use the filter, click the drop down arrow and select the information you want to include or exclude. Use the filters to identify those that need to be followed-up on. The last column in the table will either say “Follow-up” or “Ok” as necessary. Once this done the red highlight will go away. Follow-up is documented by entering an “x” next to the date of follow-up. When follow-up is required and has not occurred the date turns red. See below for a process to review past due invoices. ![]() Past due invoices are not intended to be included in the follow-up section as these generally require more attention. Currently the follow-up schedule is 7, 14, 30 and 60 days after invoice date. You can also adjust the follow-up dates by changing the numbers in the header. You can add additional information and track as many individual components as you see fit. Additionally, no part of this excel template is locked.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |