Budget Imports

Budget Imports
Settings > Budgeting > New Budget Import Format

This is for importing budgets from outside systems into SGA.

Name: The name that will be displayed as the name of the import.

Connection: See import connections for help setting up a connection to import files.


General

Reference columns by: See import connections.

Budget amounts stored: Specify if the budget amount columns are stored horizontally (one column for each month) or vertically (one column with an extra column to determine the period).

Create accounts that don’t exist: The imported budget must be valid. If you wish to create an account that doesn't exist, check this. All added accounts will be marked as active.

True sign: Check this if revenue budgets are negative. If you are budgeting everything as a positive number, leave this unchecked.


Columns

Account: The column where the G/L account resides.

Period: This is the column where the period or month is located. If you do not specify a period, the budget will be allocated for the first period.

Period format: Defines the format in which the period is stored.

Budget(s): The column where the budget amount resides. If amounts are stored horizontally, then you must specify the column for every month. If the amounts are stored vertically, select the one budget column.

Comments: This is optional. You can specify the comments column unique to the account and budget year.


Importing Specifications

  • Components cannot be imported. Any components that do exist for an account’s budget being imported will be deleted.

  • Blank rows are not allowed.

  • Any blank cells will be filled in with zeros during the import process.

  • An error log will be displayed with any error that occurs. If an error occurs, you can fix it in the data source, save it again, and re-import it.

  • The account must be on the first budget line of a budgeted account. If not, budgeting will be assumed for the last account specified in the rows above.

  • The account must have dashes.

  • If an account is not found, budgets for that account will be skipped.

  • To import specific months, designate these months on the columns tab, leaving the rest blank. (Horizontal setup only)

  • To import comments, leave month totals alone and specify only comments on the columns tab. (Horizontal setup only).