Expenses Control Sheet

Hi,

Dunno, what subject this post under, but here goes...

Been tasked with setting up an expenses control sheet with budget coding, so that my line manager can monitor the budget from a monthly and annual basis.

Have attached a copy of the spreadsheet with some sample data.

What is desired, to the right of the sheet, there is a list, where we want to document each month’s total spending, corresponding with a limit on each “budgeting code”.

Is there formula(s) that can be inserted that connects the budget list with the actual expenses control, so it automatically takes the amounts’ spent and puts them in the right coding columns for each month?

Also, is there a way of showing each month, if the budget has been overspent or under spent, and this amount is either subtracted from or added to the next month’s budget.

Many thanks.

Matt

Hi Matt and welcome

In the attached I've added formulas to the table on the right that sums the spend by month using the below formula (in column S for budget code 1)

Formula:

Please Login or Register  to view this content.

For the other budget codes in subsequent columns I've used the same formula but substituted the number in red for the appropriate budget code.

As for the 2nd part of your question, it can be done in several ways.
You could use conditional formatting to change the colour of the spend totals, red if they're over budget and green if they're within budget for example.
Adding/Subtracting the Underspend/Overspend would require you to add some additional columns so you have an "original budget" and "revised budget" column for each of the budget codes.

Does that sound like something that would work?

BSB

Hi BSB.

Many thanks for your assistance, I very happy to take the advice and expertise from someone so skilled in Excel.

Am happy to add the additional columns to gain the extra functionality that we need.

Many thanks,
Matt

Have a look at this version and see if it does what you need.

BSB