Need Your Suggestions in Expense Register
Results 1 to 3 of 3

Thread: Need Your Suggestions in Expense Register
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2008
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Need Your Suggestions in Expense Register

    Hye Mr. Excel Cummunity,

    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
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    25,407
    Post Thanks / Like
    Mentioned
    442 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Need Your Suggestions in Expense Register

    Cross posted
    https://www.excelguru.ca/forums/show...pense-Register
    https://chandoo.org/forum/threads/ne...5/#post-245328

    While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
    This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    New Member
    Join Date
    Dec 2008
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need Your Suggestions in Expense Register

    Quote Originally Posted by Fluff View Post
    Cross posted
    https://www.excelguru.ca/forums/show...pense-Register
    https://chandoo.org/forum/threads/ne...5/#post-245328

    While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
    This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
    I apologize for any inconvenience. I have posted on the above-mentioned platforms and also on https://www.ozgrid.com/forum/forum/h...pense-register about 2 hours after this post. I acknowledged and will follow the rules in the future.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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