These budgets can be exported as blank budgets or can be based on prior year’s budgets, which include the ability to adjust those past budget numbers by a defined percentage. Any of these budgets can also include actual amounts on a separate worksheet tab, allowing a quick reference of budget versus actual for completion.
Once each division has completed their budget, the Excel workbooks can then be imported into Microsoft Dynamics GP to update numbers in the corresponding system budget. These individual budgets can remain standalone or rolled into a Master level budget using the Combine Budgets tool in Microsoft Dynamics GP version 2010.
Learn more helpful tips by contacting a Microsoft Dynamics GP partner like The Resource Group (
By The Resource Group, Microsoft Dynamics GP Partner in Washington.