web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Allocating Expense Balances

(0) ShareShare
ReportReport
Posted on by 115

Hello- We have a number of expense accounts for our Home Office that need to be allocated to our locations in the field. The issue we have is that we still need the expenses booked in our Home Office expense accounts. We currently allocate to the field by running monthly financials, getting the total for all G&A for the Home Office and an entry through a manual G&A allocation account for each location.  

It can be better explained with an example. We have $300 in Professional Fees Expense and we have a Home Office Location and 3 Additional Locations in the field. We want to allocate this $300.00 between the 3 Locations.

 

Currently, this is what we are doing.

 

Professional Fees Home Office                  300.00

           Accounts Payable                                                    (300.00)

 

At month end we run reports and allocate to our additional locations manually:

G&A Allocation Location 1                    100.00

G&A Allocation Location 2                    100.00           

G&A Allocation Location 3                    100.00

           G&A Allocation Home Office                                     (300.00)

 

I am aware that GP can allocate Fixed/Variable amounts if you setup a shell account and list out the allocations. This feature does not work for what I am looking for because it never posts an entry to the allocation account.

 

We are looking for a feature that would auto post the entry below between the different locations while still being able to drill into Professional Fee’s Home Office to see what we spent for the year in G&A before allocating to locations. Does anyone know if GP has a feature like what I have described above?

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    65,271 on at

    Hi,

    Here's an idea. Accumulate your expenses in Posting Account 1. At the end of the period, use a clearing account entry to clear Account 1 to your allocation account. That way, you'll always be able to see what the total was that got allocated. Make the clearing entry a recurring entry. The distribution accounts of the allocation account will hold the individual allocations.

    Does that sound like it might work?

    Kind regards,

    Leslie

  • Community Member Profile Picture
    on at

    Hi Meredith,


    Are you using Analytical Accounting? If not you can try it.

    The way I think this can implemented is that you can define expense as dimension and location names as codes.

    For example in your case Professional Fees Expense should be dimension and Location1, Location2 and Location3 should be dimension codes for Professional Fees Expense dimension.

    For reporting, Analytical Accounting provides you MQW(Multilevel query report) which will provide the data based on dimension or based on the codes, in your case based on the locations.

    Thanks,

    Appasaheb  

     

  • Meredith Villatore Profile Picture
    115 on at

    Thanks Appasaheb and Leslie. Unfortunately, none of those options would work. Leslie-we are currently running a range of account for the month and then moving that total between the Home Office allocation account and the additional locations. We currently use analytical accounting in other areas of the system, but it would not work for what we are trying to accomplish. Right now its a manual process for us, but I wanted to post here to see if anyone was aware of a tool that GP has that can help. 

  • L Vail Profile Picture
    65,271 on at

    Why would using a range of accounts be a problem? Can you give me an example that shows how the range works? When you allocate to the different office locations, what method do you use to calculate the amounts that go to each office?

    Leslie

  • Community Member Profile Picture
    on at

    A range of accounts is what we are currently doing. Throughout the month we post G&A to their respective expense accounts for the Home office. At month end I run a report for the total of G&A for Home office and post one entry allocating from an “admin credit” account in Home office to each location.

    Example:

    1-Home Office G&A totals at Month End:

    Utilities 300

    Travel 200

    Meeting        100

    2- At month end after everything is posted we take the balances of all the G&A for Home Office and allocate between our different locations.

    Home Office G&A:

    Admin Credit Home office (600)

    Admin Credit Location 1 (45%) 270

    Admin Credit Location 2 (35%) 210

    Admin Credit Location 3 (20%) 120

    This way we can run our G&A for the home office and look in each account, but by posting to the Admin credit account for each of the locations we can allocate the G&A.

  • L Vail Profile Picture
    65,271 on at

    OK,

    I'm still thinking GP's Allocation accounts will do this for you. How do you figure the percentage that goes to each location?

    Leslie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans