Spread Annual Budget Article

Spread Annual Budget Article

This screen provides the Administrator the ability to spread budget data entered by users.  In other words, users can enter a budgeted number for the year in a single month, say January, and the Administrator can then spread this number using the Simple Spread Methods.


Print, Export to Excel, Print to PDF, Auto-fit Columns, Filter, Expand/Reduce Column Width, Column Data Sort Ascending/Descending, and Select/Deselect All functionalities are available.


The following Right Click Menu and Short Cut Keys are available:



The setting whether hide or show Period Columns (P00 - P12) is available on App Config/Menu Editor/Application Configuration tab:






1) Select from the dropdown menus the Company DB and Source BudgetID that you wish to spread - in our example, the FY15 Budget;

2) Select the Destination BudgetID that you wish to spread the data to, in our example the FY201711 budget.  Please note the Source budget and the Destination budget do not need to be the same BudgetID.

3) Click the "Show Source Data" button; and

4) The Source data will display; in our example FY15 Budget data.



5) Select the row/s for the data you wish to spread;

6) Select the SpreadMethodID from the dropdown menu;

7) Click the "Calculate Now" button; and

8) the spread data will appear according to the SpreadMethodID.



9) If you wish the spread data to be Locked on the Accounts Detail tab, check this box;

10) Click the "Process Spread Data" button to process the spread data into the Destination BudgetID;

11) The system will warn you if there is data in the Destination BudgetID.  Please note that this process will overwrite existing budget account details.  If you are OK with this overwrite, click "Yes".


In our example, there was an original value of $0:


When "Yes" is clicked the process will run the following message will appear.  Click "OK" to exist the pop-up screen.



Now if we refresh our search on the FY201711 BudgetID we will note that the $0 has changed to $22,100 spread monthly:


    • Related Articles

    • Manage Spread Methods Article

      Users can define how to spread the budget for each line item over the year. 1) Search on the required CompanyDB, and Budget ID that you wish to add a user defined spread method; 2) Click on the "Manage Budget Spread Metholds" tab; 3) Enter the ...
    • Simple Spread Methods Article

      Spread Methods provides a way to allocate a total budget expense by AccountNum into each budget month. There are three options: A) The Manual Spread Method Enter the required amounts by typing them in manually.  In the below example, $50, was ...
    • Refresh Spread Method Source Values Article

      The Simple Spread Methods provides the option to spread a budget over months in the budget year using as the spread basis Actual data from Great Plains Accounting (ERP) software.  Should the selected Actual spread year remain open for posting, ...
    • Show Spread Calculation (Expanded Spread Method) Article

      By clicking on the below button the "Show Spread" columns will appear.  These columns provide for on screen calculations. 1) Enter the assumptions you would like to calculate.  In this example, 1 shipment of 10 boxes at $100 per box.  2) Then in ...
    • Custom Budget Entry Article

         Tutorial Link Custom Budget Entry is used for entering and viewing budgets.   As discussed in the Define Custom Budgets Entry Forms, all of the columns can be user defined. Custom Budget Entry has two tabs: Dashboard and Account Details. Other ...