Monthly Vendor Management System
It is so important to have a system to track your vendors and how much you are spending each month.
This Vendor System is one way to gain control of your expenses. This system widely used in many restaurants, even corporate restaurants. Corporate restaurants have working systems, and controls in place to keep management following through with the procedures on a daily basis. In fact, you could use this form for personal expense management or for any business.
This system has all the features that you will need, plus it shows the due dates and number of days until due. It’s so cool that the dates past due will highlight like a traffic light showing which bills are currently due in green, progresses to yellow for due within 30 days, and progressing to red for bills that are over 90 days past due.
This spreadsheet is a great tool and it is simple to use.
Begin by entering in the invoice number, vendor name, category, date of delivery, dollar amount before credit, credit amount if it applies, the dollar amount after the credit will automatically calculate, next to that column is (credit amount) is a rolling dollar amount that automatically calculates.
A comparison chart tracks Monthly and Year-to -date dollar amounts based on what you input on the vendor reports. You can compare current vendor dollars to the expenses of the previous month. At a glance you will see where you money is going.
Click to enlarge