Budgets can be created in Dynamics GP directly, but the most efficient way of creating a budget for use in Microsoft Dynamics GP is to create it using Microsoft Excel.
There are four steps to create a budget in Dynamics GP. They are as follows:
Create the budget.
Export the budget to Microsoft Excel from Dynamics GP.
Edit the budget in Microsoft Excel.
Import the budget back into Dynamics GP.
It is strongly recommended that the budget be created in Dynamics GP and exported to Microsoft Excel for editing, as the import process requires the structure of the file to be exactly the same as the one being exported. The attempts to create the budget template manually can be very problematic.
To create a budget in Microsoft Excel, follow the given steps:
Open the Budget Selection window in Dynamics GP by clicking on Financial from the Navigation Pane on the left, and then clicking on Budgets in the area page under Cards | Financial.
Click on the New button and then...