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.

Description

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.

 

Declining Balance Worksheet

Download the Declining Balance Worksheet for free

 

 

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

Add a Comment!

HERI ROXX [36.81.144.5]    [ Mar 11, 2015 ]

I am rookie to this culinary business, find this website with a lot of useful tools help me a lot to get more perspective understanding this business. Thank you very much and GBU

CHEF GARNETTE [168.167.117.42]    [ Dec 09, 2014 ]

Hi Chef,

I really found your information here very useful. I Really appreciate for the time spent to build these templates and the resources spread on your site. Thank you. Keep it Chef B. Am right behind you.

DAVID BUCHANAN    [ Aug 30, 2012 ]

I’m sorry but I don’t have it in an earlier version of Excel.  But I think you can download it and then save it as an earlier version.  Select “save as” and then try “Excel Worksheet” for the extension type.

REVSTAN [71.164.217.195]    [ Aug 26, 2012 ]

Any chance to get this in an earlier version of excel