Using this utility, annual monthly budget amounts for each G/L
Revenue and Expense account for each division can be imported into
Texada SRM.
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.
The columns on this spreadsheet are predefined as follows:
Item Excel Column Item Excel Column ------------------------------------ ------------------------------------- Account #...........: B Division..............: C January.............: D February..............: E March...............: F April.................: G May.................: H June..................: I July................: J August................: K September...........: L October...............: M November............: N December..............: O
After building the spreadsheet saved it locally to a flat ASCII file on your Client on your workstation as a Text (TAB delimited) file to give it a *.txt extension.
In preparation for importing, move it from your Client to
the Server by clicking the UPLOAD button, as
outlined in Select File to Upload.
The Budget information file will then automatically be saved as
budget.txt in the correct folder on the server ready to be
imported, as displayed with the path in the Filename
field.
Note: Any budget information that is imported and updated using Imported Budget Information will replace every existing record for this year that may previously be saved in Budgets.
If no errors are reported, the division and company totals can then be viewed and confirmed using Imported Budget Information before they are accepted and copied into the Budgets table, where they can be further modified as required.
ACTIONS:
Additional actions provided by buttons on
the Import Budgets screen include:
Move the Budget file to the Server:
Click UPLOAD to copy the TAB delimited budget text
file to the server, using the Select File to
Upload utility and naming it budget.txt, as explained
above in the File Requirements.
In Linux the directory path and name default to./budget.txt
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |