+ Reply to Thread
Results 1 to 3 of 3

Suggestion needed for Template (Budget Vs Actual)

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Suggestion needed for Template (Budget Vs Actual)

    Hi, our company always have those Upgrading project. They have set aside a certain amount for each project. Example, $3000 for Chairs. Whenever we received invoices pertaining to this budgeted $3000. We have to put it in excel so that we know how much is left in this $3000. However, most of the time, a single $3000 budget is make up of many invoices. This make presentation very ugly and We need constantly update formula and inserting row etc. See attached file and you know what i roughly mean.

    Does anyone have any better idea how to keep track?
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,202

    Re: Suggestion needed for Template (Budget Vs Actual)

    I would suggest that you enter all bills on a separate sheet with an added column to identify the budget, then on the summary sheet you can use a SUMIF statement to work out how much of the budget has been used.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,673

    Re: Suggestion needed for Template (Budget Vs Actual)

    Based on Ali's recommendation, see the attached:

    Totals are based on this type of formula ..

    =SUMIFS(Expense!$C:$C,Expense!$B:$B,Summary!$E3,Expense!$F:$F,Summary!$C3)


    You may want to consider "Estimates" (from Suppliers) vs Actual invoice amounts (I consider "Estimates" different from Budget). If Supplier contracts are not fixed price, then it likely the Actual will not match the estimate.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 03-15-2017, 03:14 AM
  2. Budget vs Actual Analysis
    By ruchi1127 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-18-2015, 01:06 PM
  3. Actual as a % of Budget formula
    By nier06 in forum Excel General
    Replies: 1
    Last Post: 02-13-2012, 01:19 PM
  4. Dashboard - Actual Vs Budget and Re-forecast
    By Blake 7 in forum Excel General
    Replies: 3
    Last Post: 10-05-2011, 05:36 AM
  5. Budget versus actual formula
    By Norah in forum Excel General
    Replies: 5
    Last Post: 06-07-2010, 01:09 AM
  6. Budget vs. Actual
    By Stanley in forum Excel General
    Replies: 0
    Last Post: 12-16-2005, 05:10 PM
  7. [SOLVED] YTD Budget Sum if Actual Month has activities
    By AGnes in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-24-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1