CONSTRUCTION INFORMATION SYSTEM - SYSTEM 20/20

GENERAL LEDGER

The General Ledger module is designed to be the "end" depository for all "monetary" transactions either entered directly into the general ledger or processed by any other module of System 20/20. The General Ledger module has two functional components. The first component maintains the balances in the Chart of Accounts and produces the Trial Balance Reports. The second component computes and prints the Financial Reports based on user specified parameters. The Financial Report options include the ability to compare budget and actual values.

FEATURES

• Multi-company capability with automatic intercompany clearing entries allow all companies to be in balance at all times.
• Allows any number of user-defined fiscal periods within a fiscal year.
• Fiscal periods can be closed to subsidiary modules, but remain open for General Ledger.
• Flexible chart of accounts coding system consists of three required data elements, Company, Operating Center (Division or Department), Account and one optional data element, Sub-account.
• A total of seventeen characters are available, including a single space character between each data element. These characters can be distributed among the above elements in any combination. The result is a customized coding structure that matches your company's requirements.
• Separate Chart of Accounts for each company.
• Chart of Accounts and Financial Report schedules can be copied between companies.
• A new fiscal year can be started before completing the closing entries for the prior fiscal year.
• Consolidation of subsidiary module transactions into a single journal based on user-defined consolidation options available in each source module.
• Journals may be on-line, batch, accrual, auto-reversal, inter-company, inter-module, year-end close, or encumbrance.
• Journals can be posted to any open fiscal period.
• Recurring journal entries can be established for either a specific company or across multiple companies.
• Separate financial report formats are available for each company in a multi-company environment.

• Preparation and generation of customer invoices in custom or standard AIA formats.
• Multiple methods of arriving at invoice cost.
• Time and materials billing capability allows you to bill at an individual cost transaction level through the utilization of billing rate schedules.
• Income Recognition processes automates the computation of General Ledger journals according to user-specified rules.
• External audit requirements can be met through the compilation of detail transactions.
• Multi-level Cost Account On-line inquiry provides immediate access to detail transaction information for cost accounts.
• Flexible financial reports can display any of the following options within a four-column report format.

COLUMN CONTENT		OPTIONS
Beginning Balance	Current Period	Prior Period	This Period Last Year
	Current Quarter	Prior Quarter	This Quarter Last Year
	Current Year To Date	Prior Year To Date

Activity	Current Period	Prior Period	This Period Last Year
	Current Quarter	Prior Quarter	This Quarter Last Year
	Current Year To Date	Prior Year To Date

Ending Balance	Current Period	Prior Period	This Period Last Year
	Current Quarter	Prior Quarter	This Quarter Last Year
	Current Year To Date	Prior Year To Date
		Prior Year Total

Original Budget	Current Period	Prior Period	This Period Last Year
	Current Quarter	Prior Quarter	This Quarter Last Year
	Current Year To Date	Prior Year To Date
	Current Year Total	Prior Year Total

Revised Budget	Current Period	Prior Period	This Period Last Year
	Current Quarter	Prior Quarter	This Quarter Last Year
	Current Year To Date	Prior Year To Date
	Current Year Total	Prior Year Total

Original Budget	Current Period	Prior Period	This Period Last Year
Variance	Current Quarter	Prior Quarter	This Quarter Last Year
	Current Year To Date	Prior Year To Date

Revised Budget	Current Period	Prior Period	This Period Last Year
Variance	Current Quarter	Prior Quarter	This Quarter Last Year
	Current Year To Date	Prior Year To Date

• In addition to the above, other options calculate variances between specified columns of the financial report.
• Financial report formatting features include scaling, spacing and grand totals with single or double underscore.
• Consolidation of Financial Reports in a user-defined sequence across multiple companies.
• Financial reports can be calculated at any time for any fiscal period.
• Multi-level On-line Inquiry by General Ledger Account/Sub-account
                Summary of Account Activity by Fiscal Period
                        Selected Fiscal Period Summary Journals
                                 Selected Detail Journal Transactions
• Multi-level On-line Financial Report Inquiry
                Line Display of selected financial report
                        Accounts within selected report line
                                 Detail Journals within selected account
• Purge processes for deleting fiscal period details and posted journals.
• Bank account reconciliation for all bank accounts used in subsidiary modules

MODULE INTERFACE

The following System 20/20 modules send () transactions to and receive () transactions from the General Ledger module.

					TRANSACTIONS
			Accounts Payable		Vendor invoices, credit memos, automatic, manual & void checks, encumbrance relief’s, relief of materials received but not invoiced
			Accounts Receivable		Customer invoices, payments, service charges, debit memos, unbilled retention
			Cost Accounting		Cost journals, income recognition, cost reclassification, allocations
			Equipment		Rental revenue, operating and repair expenses
			Fixed Assets		Capitalization, depreciation, transfer, retirement charges
			Inventory		Material receipts, issues, transfers, surcharges, physical inventory adjustments
			Payroll		All computed payroll amounts
			Purchasing		Purchase order encumbrances
			Receiving		Cost of materials received but not invoiced
			Subcontracts		Subcontract encumbrances
			Work Order		Cost journals, transactions from allocations to final destinations, revenue from billing
			Cost Accounting		Adjusting journals
			Equipment		Adjusting journals
			Work Order		Adjusting journals

REPORTS

		Control File Section Listings		Budget Comparisons
		Chart of Accounts		Accounts Budget
		Unposted and Posted Journals		Budget Worksheet
		Account Detail		Accounts Budget Notes
		Detail and Summary Trial Balance		Prior Year Comparisons
		Subsidiary Modules Subledger		Account Encumbrance Detail
		Financial Statements		Posted Encumbrance Journals
		Financial Statement Audit		Financial Statement Factors