Managing a growing business, while rewarding, is a lot of work. It's easy to stress and lose track of how your expenses are being allocated. With the use of a program like Microsoft Dynamics GP, an expense accrued at the corporate office can easily be shared with numerous different departments with the click of a button.
In Microsoft GP, Allocations accounts provide a great tool for companies that split up various expenses across different departments. Rather than spend valuable time manually entering information, Dynamics GPeliminates the headache by doing the math for you! Setting up fixed and variable allocation methods with Microsoft Dynamics GP is a simple and effective way to streamline your business.
My name is Brent Stabler and I'm a consultant here at Logan Consulting.
Today's video I will be showing you how to set up fixed and variable allocation
in Microsoft GP. Allocations accounts provide a great tool for companies that
split up certain expenses between various departments. For example
telephone expense at a corporate office can be shared between the accounting, IT,
human resources, and administrative departments based on a fixed percentage
allocation accounts come in two varieties fixed and variable. Fixed
allocation accounts are simpler and divide expenses based on certain
percentages that are predetermined. Variable allocation accounts are more
complex and rely on balances and other accounts to calculate a location amounts.
I will show you how to set up both. We'll start with pics that location first
you'll need to set up a fixed allocation account by clicking on the financial tab
and finding fix a location under the card section. Here you will set up a
posting a location account account number and description
then and so the accounts you want to allocate the sixpence 2 I'll take
telephone expense which is account number 6510 and allocate to segments
100, 200 and 300 with percentages of 10, 20 and 70 respectively.
Start with 10%
and then 70%. Make sure the percentages equal 100. Hit save, and then
you are done. now I'll show you
variable allocation you will find this window right above fix a location. You
will again set up a posting it
allocation account and tear and account number and description as before
choose whether you want to base allocation off the year to date or the
transaction period numbers. Now you have distribution accounts and a breakdown
account. The distribution accounts function the same as fix that location
these are the accounts that the expense will be allocated between. The breakdown
account is used to calculate the percent allocation you can choose a different
breakdown account for each distribution or have one for all of them a popular
breakdown account is sales so you have your distribution accounts as before and
Then when you have the selected account, you choose a breakdown account and I
would choose sales.
If you would like to learn more about Microsoft Dynamics GP, contact Logan Consulting your Chicago based Microsoft Partners.