Using a Declining Balance Spreadsheet
I can hear what some of you are saying, “What exactly is a Declining Balance Sheet and why in the hell would I want to use it?” A declining balance worksheet helps you manage your food cost by keeping track of your month-to-date food purchases. If your food budget is $70K, you simply enter your daily food vendor invoice totals (not individual line item purchases, just the total food purchases per vendor per day), and the form calculates how much cash you have left for food purchases based upon your budget.
If your sales volume is on target for the month, then your food purchases should also be on track. This tool will let you know if purchases are in line with budget so that you can deal with it before over-purchasing becomes a problem. It is a forecasting tool. And, it is helpful for double-checking what the accounting department says you have spent on food when they produce your food cost report. The number they have for food purchases should be very close to what you have documented in the declining balance sheet has for a total. If not, then one of you have made a mistake.
The Declining Balance Worksheet is an Excel spreadsheet which will keep track of how much budget you have left for monthly purchases. Enter your monthly budget number in the cell where you see $50,000 and enter your daily invoice totals by vendor into the lower section. The Declining Balance Worksheet calculates the rest! It tells you how much total $ you have spent month to date, how much you have left to spend, and subtotals by vendor.
The chart comes with 16 columns for vendors and a separate tab/worksheet for each month. Simply enter your vendors names. Delete or add extra columns as needed.
To Unprotect the Sheet
The password to unprotect this sheet if you want to make additional edits is simply “Password“.
Comments from before Site Migration