Skip to main content

Creating a Budget in Dynamics GP is Easy

You may create a Budget or Forecast report using "Budget Wizard" tool which available in Dynamics GP. The step-by-step wizard tool will guide you to pull out the GL account code and form into Excel spreadsheet template. Next, complete the Excel by filling up the budget amounts and re-import using the wizard. User can later pull out the budget figure from Report Designer.

Creating Budget Template

Path: Cards > Financial > Budgets

  1.   Select [New], then select "using Budget Wizard for Excel".

2.   Select [Next].

3.   Enter the Budget ID name, description and the Fiscal Year. Take note that the Fiscal year for the budget must be created before creating the Budget.

4.   Select "Blank Budget".

5.   Select [Next].

6.   You can set which GL Account code to track budget. If the Budget that you need to create is only consist of Profit and Loss account, you may just mark "Profit & Loss Accounts".

7.   You can filter which GL account code to include for budget.

8.   A view of GL account code to be included in the Budget template that system going to create.

9.   Select "A new workbook".

10.   Select "Finish"

11.   Set the location to "save" the budget template, as the budget wizard will export the budget template to Excel spreadsheet.

12.   The screenshot below shows the result of the Budget template which export from GP. It is breakdown by period and GL Account code which set in previous Budget Wizard.
               Take Note that:-
                    -  If the amount is Credit, it should be entered as negative.
                    -  Do not change the template layout. (Eg. Add new column or                             new account code to the template)
                    -  Remove all the formulas



Importing Budget Template Back to Dynamics GP

Path: Cards > Financial > Budgets

      1.   Select "Import from Excel" from the Excel button.

2.   Select [Next].

3.   Select the Budget ID that need to import.

4.   Locate the budget file that has been updated with data.

5.   Proceed to select [Finish].



***If you need to revise the existing budget which have uploaded to the GP, simply just export the budget out to spreadsheet, change it, and re-import it again using the same Budget ID as thought in Step 1.
Labels:
Location: Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia

Comments

Post a Comment

Popular posts from this blog

Reprinting GP Posting Journal after Posting in Dynamics GP

As there is no shortcut to reprint the posting journal from one screen, you need to know the original screen location. Financial and Bank 1. To reprint General Journal entries.      Path: Reports > Financial > Cross-Reference > Select "Journal Entries"             Take note that the document printed from here will include transaction posted from other source too like Payables, Receivables, and Fixed Assets and etc. 2. To reprint Bank Posting Journal/ Bank Recon Reports      Path: Reports > Financial > Bank Posting Journal Sales Order Processing and Receivables 3. To reprint Sales Transaction Entry      Path: Reports > Sales > Posting Journal > Select "Sales Posting Journal" 4. To reprint Receivables Entry      Path: Reports > Sales > Posting Journal > Select "Receivable Posting Journal" 5. To reprint Cash Receipt Entry      Path: Reports > Sal...
Post a Comment
Read more

How to Create Recurring Transaction in Dynamics GP

If you have a handful of journal entries to be created in regular basis, whether for  numerous accruals and reversals,  allocation, or reclassification entries, setting up Recurring Transaction in Dynamics GP will be helpful and speed up your month end process. Step 1 - Setup Recurring Batch Path: Transaction > Financial > Batches  i.    After entering the " Batch ID " and " Comment ", setting up the " Frequency " is the most important part for recurring transaction. " Single Use " is the one we use all the time for single posting, once posted, the batch will remove from Batch ID. But if you set the Frequency to " Monthly ", which means the batch automatically becomes a recurring batch, the batch will be there forever for multiple posting. ii.    There is another useful option here, " Clear Recurring Amounts ", which will clear the amounts in journal entries after the posting. You can then later enter the amount in the j...
1 comment
Read more

How to Record a Refund from a Vendor in Dynamics GP

Assuming you have scenario where there is over payment to your vendor or supplier, but you don't have any open invoice due to this vendor, you can simply enter a Return transaction using Payable Transaction Entry screen. Path: Transaction > Purchasing > Transaction Entry > Select "Return" from Document Type. 1.     Assuming there is a refund of $100 from the supplier, enter the refund details as per screenshot attached. 2.     Enter the refund amount to "Returns" and also "Check" field. 3.     The check entry screen will pop out to record the cash receipt details. 4.     Take note of the Distribution entry, DR Bank and CR Purchase. 5.     After the Return is posted, the document status will be "HIST". No apply require. 6.     This will also create a Bank Deposit to be deposited.         (Transaction > Financial > Bank Deposits) 
1 comment
Read more