Using a Declining Balance Spreadsheet

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. 

Click the picture for a larger image. 

Or download the Declining Balance Worksheet for free.