BlogSage 100Tips and Tricks

How to Import Your Budget into Sage 100

By January 6, 2021January 7th, 2021No Comments

Erin Oldaker-Moul

Senior Consultant – Sage 100

SWK Technologies, Inc.

Looking to import your budget files into Sage 100 to manage all your accounting data in one place? Your ERP allows you to transfer your spreadsheets over from Excel with some set up, but this guide will take you through all the steps one by one. Working within the General Ledger module, you will be ale to successfully migrate over your worksheets or CSV files and automatically produce financial status reports in your software menus.

Read below to discover how to import your budget into Sage 100:

Importing Budget Files in Sage 100

Budgets can be viewed for individual accounts through General Ledger / Budget / Budget Maintenance.

OR General Ledger / Main / Account Maintenance select the Budget Button to display detail.

import-budget-sage-100-account-maintenance

import-sage-100-budget-maintenance

Change the budget for the individual account by selecting the Change Budget icon.sage-100-change-budget

Or Select Budget Maintenance from the Budget Menu.

  • Select the account(s) to be changed
  • Select the budget to be modified

The Budget Revision Entry can be utilized to create a new budget.

sage-100-budget-revision

Budget to Revise Year is the budget to be modified.

Note: The year must have been created in Fiscal Year Maintenance to be selected.

Revision Methods are based upon the Revised Based On Field.

  • Copy amount
  • Percentage Change
  • Amount Change

Select the Periods to be changed Rounding factors.

Display options: Precision of Dollars or Cents.

Select Enable Account Selections to activate field selections.

  • Account number
  • Main Account number
  • Department
  • Location
  • Select Proceed to calculate the revisions
  • Run the Budget Revision Register and Update to save the changes to the budget

More in-depth and detailed budgets may be imported using Visual Integrator.

From Visual Integrator Main Menu select Import Job Maintenance.

sage-100-visual-integrator-budget-revisionJob Name: Enter a name for the import
Table Name: Choose GL_Budget Revision from the list. ACCEPT to save the import job.

 

Configure the import by providing a description and selecting the file to be used for the import.

Note: The import file must be a comma delaminated or text file. Example: Excel .csv

sage100-import-job

Import File Layout Example

Account number is the full account.
Columns 1 through 12 for each period (month) to be imported. Up to 13 periods can be used.

Select Tab 2 “Data”:

Tab-2-data

From the Available Fields select the field.budget-import-field

Double click the field name to assign the parameters.

To have the import select data on the spreadsheet choose Replace and assign the Column Position.

revise-budget

To assign a fixed value choose Assign and enter the Default.

sage100-budget-code-assign-default

When all Fields are selected and parameters are assigned, ACCEPT to save and launch the import.
Execute this job? YES

Import File Name: Browse to the file and open it.

import-budget-file-name-sage-100

It is recommended to ALWAYS Test an import.

buget-job-testEnter a number of records (rows) to test or select ALL Records.
OK will run the import.

 

sage100-budget-import-summarySelect Yes to view the job log.
All red lines have errors.
Double click to open the Record # and view the error.

Some errors will not allow for the import to take place and must be addressed by going back to the import and fixing the error(s).

 

sage-budget-header-records-errorHeader records will display as an error, but will be ignored by the import.

 

import-your-budget-sage-100-account

Example of successful Record Detail

  • To make changes to the import select
  • To import select ACCEPT
  • To view the import, select General Ledger / Budget Menu / Budget Revision Entry

sage-100-budget-revision-entry

Note: Credit balance accounts such as revenue will display as a negative.

  • Select the printer icon to print the revision register
  • To update the revision register select YES, this will save the budget
  • Or NO to go back to Revision Entry and make changes

View the Budget by individual account in Budget Maintenance

import-your-budget-sage-100-account

Select Budget Report to print the budget(s).

import-budget-report-sage

Speak to the Sage 100 Experts for More Tips & Tricks

This is one of many tips and tricks SWK Technologies can provide to Sage ERP users. SWK is a top Sage Partner with intimate knowledge of Sage 100 and Sage 100cloud, and we leverage this experience to make sure you capture the best possible value from your software investment.

Contact SWK today to answer all of your questions on how to best use your Sage 100 or Sage 100cloud ERP.

Talk to the Sage 100 Support Experts

SWK Technologies, Inc.