Import Budgets by Date

System Maintenance Menu -> Configure System Settings -> Accounting Tab -> General Ledger -> Budgets -> IMPORT BY DATE button -> Import Budgets

Using this utility, annual monthly budget amounts for each G/L Revenue and Expense account for each division can be imported into Texada SRM by specific date.

The budget amounts can then be viewed and further modified from Budgets for reporting on the Budget Summary Report by Account and Budget Summary Report by Layout.

Process Flow:

•Create a spreadsheet or click the TEMPLATE button to create the spreadsheet, and enter the budget data in the columns defined as follows:

Item                    Excel Column
------------------------------------
Account #...........:        B
Division.............:       C
Date................:        D
Amount..............:        E
D/C..................:       F
 

Note: It is important to match the Date value on the spreadsheet with the selected Date Format displayed on the header of this Import Budget screen to ensure the records are imported successfully.

•Save the completed spreadsheet as an ASCII tab delimited file with a *.txt extension.

•Move the tab delimited text file to the server by clicking the UPLOAD button, as outlined in Select File to Upload.
 The Budget information file will then automatically be saved in the folder and path displayed in the Filename field on the header of this Import Budget screen.

•Click ACCEPT to initiate the import, or CANCEL to abort.
 Records with no errors will be imported over-writing any existing records for the same account/division/date in the Budgets table, where they can be manually adjusted as required.

Errors:
 Any errors in the import data will not be imported and will be displayed in the Information Log on the screen.
 e.g. GL account not an Expense or Revenue type account
 Only records without errors will be imported.

ACTIONS:
 Additional actions provided by buttons on the Import Budgets By Date screen include:

•Create a Template to Capture the Budget Data:
 Click on the TEMPLATE button to generate an empty spreadsheet layout and enter the GL accounts with the budget amounts by division and date.

•Move the Budget file to the Server:
 Click UPLOAD to copy the tab delimited text file to the server, using the Select File to Upload utility.

Topic Keyword: GLBU04 (5865)