G/L Budgets

Set G/L Budget by Account ID

Navigate to the menu G/L Budgets -> G/L Account Budgets.

Choose the G/L Account from the drop down in the top right, as well as the year.

In the respective fields for each month, enter the budget amount, and any forecast amounts you expect of this month. You may use the “Auto Fill Numbers” button for a speedier data entry. Click the “Save” button when finished.

Another shortcut for manual budget entry is to utilize the copy feature. Click Copy from the bottom of the screen

Could copy from a different account and/or different year. Use the % field to copy a portion of the other budget. Some examples:

Copy the same G/L account, but I want this years forecast to be 105% of last year's Actuals -
For the Digital product G/L, the Budget will be 25% of the Print Product's Budget -

Repeat the process if applicable for each rep and product in this screen. (Or see below for procedure to Import)

List Budgets

To see a list of all budgets and forecasts that have been setup, navigate to List Budget node and select Company, budget type and desired year and click Get Accounts.

Import G/L Budgets

Navigate to the menu G/L Budgets -> G/L Account Budgets and select Import Budgets node.

Note that you can choose the import to be for Budget or Forecasts. Choose which one you wish from the drop-down menu.

Select the year into which you want to import the budget

Click the button “Download Template” and fill in the columns as described below in the template section.

Save the template on your desktop. Click the “Select” button to browse for the saved template. Then click “Test import File”.

If there are errors in the file, the system alerts you to that during the testing step. If there are errors, click the x remove button and then fix the errors in the template.

Resave the template and re-upload the file. Repeat the step to iron out all the issues in the template.

When there are no more errors, click “Import File”.

Once the file is successfully imported, then you see the budgets in the List Budget node and in the Account Summary screen

Sales rep Budgets by Product Template

Field

Example

Conditions

Mandatory/ Optional

Account ID

01*10*000*10100

This is the G/L Account ID as it is in the system in the G/L Account Maintenance Screen

Mandatory

Description

Bank of America - Cash

Description of the G/L Account ID

Optional

Type

The valid values are B or P. This is where you state whether it is a profit and loss or balance sheet.

Optional

444,000