Results 1 to 6 of 6

Thread: Need Your Suggestions in Expense Register

  1. #1
    Seeker Arshmaan's Avatar
    Join Date
    Oct 2011
    Location
    Pakistan
    Posts
    10
    Articles
    0
    Excel Version
    2007, 2016

    Need Your Suggestions in Expense Register



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hye Excel Gurus,

    Hope you all doing well. I need your help in making my Expenditure Register. I have a master sheet where I do Data Entry i.e in Column B I am entering Description of Expenditure, in Column C I am entering Amount, In Column D I am entering Budget Head from which the Expenditure is Charged, In Column E I am Entering the 2nd Budget Head if the Expense is charged from the Different Budget Head and in Reporting Sheet I am generating a report. In Reporting sheet in Cell A2 I put Criteria (Main Budget Head) and it will fetch all the related records from the Master Sheet.

    We got an Annual Budget every year and divide it into 5 different Budget Heads and when we have a Nil Budget in one Budget Head, we can charge the Budget from other Budget Heads. For example, if Expenditure Cost of Purchasing a Laptop is Rupees One Hundred Thousand and We Have no Budget in Office Equipment Budget Head then we can obtain this expense from the Furniture Budget Head. In this case, the Reporting Sheet will look like this:

    Column A displaying Expense Description, Column B displaying Expense Amount, Column C displaying 2nd Budget Head if the expense is charged from different Budget Head (Otherwise Blank).

    Now I am explaining my problem in Which I need your suggestions. For Example Purchasing of Laptop Costed Rs. One Hundred Thousand and we have budget in only 3 Budget Heads (i.e) Rs. 40,000 in Furniture, 40,000 in Maintenance and 20,000 in Stationary and Equipments, so how should I generate the Report?

    Column A will display Expense Description, Column B will display Expense Amount and what about Different Budget Head Column because we charged it from 3 different Budget Heads.

    Please suggest me how should I prepare the Master Sheet and Reporting Sheet as well.

  2. #2
    Acolyte macropod's Avatar
    Join Date
    Mar 2017
    Posts
    35
    Articles
    0
    Excel Version
    2010
    Cross-posted at: https://chandoo.org/forum/threads/ne...egister.41105/
    For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
    Cheers,
    Paul Edstein
    [MS MVP - Word]

  3. #3
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,652
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Links added although not all of them...
    Last edited by Pecoflyer; 2019-03-07 at 07:15 AM.
    Thank you Ken for this secure forum.

  4. #4
    Seeker Arshmaan's Avatar
    Join Date
    Oct 2011
    Location
    Pakistan
    Posts
    10
    Articles
    0
    Excel Version
    2007, 2016
    Thanks for the good info. I appreciate, acknowledge and will follow as per instructions in the link posted by macropad. I have posted almost two hours after this post https://www.mrexcel.com/forum/excel-...-register.html now I know that how and when to cross post (thanks macropad for the link).
    Last edited by Pecoflyer; 2019-03-07 at 07:15 AM. Reason: Removed unnecessary quote

  5. #5
    Acolyte macropod's Avatar
    Join Date
    Mar 2017
    Posts
    35
    Articles
    0
    Excel Version
    2010
    Cheers,
    Paul Edstein
    [MS MVP - Word]

  6. #6
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,186
    Articles
    0
    Excel Version
    Office 365 Subscription
    Posted on every forum I have visited this evening.

    One of the unfortunate side effects of choosing to do this is that nobody bothers to answer any of the threads you have started because there might be four more people doing the same thing elsewhere. Not a great tactic - it backfires almost every time.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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