Results 1 to 3 of 3

Trying to compare actual results to budget with multiple IS items per Budget Line

Threaded View

  1. #1
    Registered User
    Join Date
    03-01-2010
    Location
    Portland, OR
    MS-Off Ver
    Office 365
    Posts
    58

    Trying to compare actual results to budget with multiple IS items per Budget Line

    Currently I am trying to create a budget to actual analysis when there are often multiple Financial Statement line items per a single line in the budget. For instance on for the Plant Supplies Budget Item, there will be Safety Supplies, Misc Supplies, Plant Supplies - Drums, and small tools. Using some kind of formula would then add up all those accounts to compare with the given Budget Line Item.

    Ideally I would want a supporting tab with all the different Financial Statement Accounts mapped out to the corresponding Budget Line Item which are then summed on the main page for review. This would be much easier to maintain as opposed to having a six argument formula.

    Basically basically if the budget line equals this, then sum certain IS accounts that are mapped on the supporting page.

    is what I am describing realistic at all?
    Last edited by ppilot; 03-13-2017 at 07:32 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Nested IF statement to show under budget, within a % of budget, over budget
    By clafleur in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-15-2015, 10:36 AM
  2. Replies: 1
    Last Post: 10-14-2015, 01:32 AM
  3. Replies: 2
    Last Post: 10-13-2015, 07:58 PM
  4. [SOLVED] using sumifs() to compare cumulative totals for actual versus budget based on financial pe
    By Woodstock in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 12-12-2012, 08:26 AM
  5. Actual as a % of Budget formula
    By nier06 in forum Excel General
    Replies: 1
    Last Post: 02-13-2012, 01:19 PM
  6. Bar Graph - Compare Budget to Actual
    By zjenni01 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-30-2011, 11:19 AM
  7. Budget vs. Actual
    By Stanley in forum Excel General
    Replies: 0
    Last Post: 12-16-2005, 05:10 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