The primary files in the General Ledger Module are the Chart Of Accounts, Budgets and Transactions.
Click below for greater detail on the following subjects:
|Divisions and Pools||Post Transactions|
|Other Direct Costs||Sort General Ledger|
|Accounting Periods||Print General Ledger|
The structure of the General Ledger Account Number is as follows:
A 7-digit number comprised of a 4-digit account number (nnnn), two digit division (dd), and a 1-digit pool (p). The first digit in the account number indicates the classification of the account:
|1 = Assets|
|2 = Liabilities|
|3 = Equity|
|4 = Income|
|5 = Direct Expenses|
|6 = Indirect Expenses (Overhead and G&A)|
|7 = Fringe Benefit expenses|
|8 = Non-Allocable expenses|
|9 = Bids and Proposals (B&P) and Independent Research and Development (I R&D) costs|
The second, third, and fourth digits indicate the function of the account, and are alpha-numeric characters.
DIVISIONS AND POOLS
The fifth and sixth digits indicate the division and are alpha-numeric characters. The division code can be used to indicate a division, location, or department. This field is used as a method of recording income and expenses that can be identified with either an activity or a location.
The seventh digit indicates the pool (i.e., Overhead / G&A) and is an alpha-numeric character. Pools indicate the collection of a specific type of indirect expense (e.g., On-site, Off-site, G&A). The example below illustrates the use of the divisions and pools.
EXAMPLE: ABC Company has an office in Washington and one in Virginia Beach. The Washington Office uses on-site (at their facility) and off-site (at a government facility) overhead rates. Virginia Beach uses only the on-site rate. One company-wide G&A rate is used. Their divisions/locations and pools could be structured as follows:
|Washington = 10|
|Virginia Beach = 20|
|G&A - All Departments = 01|
|On-site Overhead = A|
|Off-Site Overhead = B|
|G&A Expenses = G|
Each income, direct, and overhead account in the General Ledger would have 10A, 10B, 20A as the division and pool, as follows:
Income : (4001)
|400110A - Washington On-site|
|400110B - Washington Off-site|
|400120A - Virginia Beach On-site|
Direct Labor: (5010)
|501010A - Washington On-site|
|501010B - Washington Off-site|
|501020A - Virginia Beach On-site|
Overhead -Rent: (6510 )
|651010A - Washington On-site|
|651010B - Washington Off-site|
|651020A - Virginia Beach On-site|
|651001G - G & A|
This account structure allows for the printing of financial statements showing division 10A, 10B, 20A, all of division 10 (Washington) regardless of pool, 20A, all On-Sites (Pool A for Washington and Virginia Beach combined), and all divisions combined (All of Washington regardless of Pool and Virginia Beach).
The concept of divisions and pools also extends to the job costing aspect of the system. Each contract is assigned to a division and pool, and can be shared by more than one such group.
EXAMPLE: ABC Company has a CPFF contract with 2 tasks, each of which are subdivided into 3 subtasks. Subtask 1 of both tasks uses the off-site overhead rate (Pool B); all others use the on-site rate (Pool A). The contract belongs to the Washington Office (Division 10) but the Virginia Beach Office (Division 20) is also working on Task 2, Subtask 3. The contract would be numbered as follows:
|A1000 001 01 10B|
|A1000 001 02 10A|
|A1000 001 03 10A|
|A1000 002 01 10B|
|A1000 002 02 10A|
|A1000 002 03 10A|
|A1000 002 03 20A|
OTHER DIRECT COSTS
ODC's are posted to the Contract Cost Master Record in based on the 3 digit of the General Ledger Account numbers.
EXAMPLE: If you want to breakdown the travel expenses in the G/L use the following type of structure. (All items comprising Travel (5100 - 5109) would be posted to the Contract Record Other Direct Cost and labeled TRAVEL.)
|5101 Location Mileage|
|5106 Auto Rental|
|5108 Other Transportation|
The user defines the Accounting cycle. A calendar year, fiscal year or 52-53 week year may be entered. The Chart of Accounts contains 27 dates -- 13 closing dates for the current year, 13 closing dates for the previous year, and the current year opening account balance. When an accounting period is closed, the appropriate date is marked as having been closed. The system keeps track of the 'open' accounting period for purposes of posting transactions (see the discussion below on POST TRANSACTIONS), printing general ledgers, trial balances, and financial statements. Transactions for a period beyond the current accounting period may be entered, but cannot be posted until the Transaction date falls within the current accounting period (i.e., February Transactions may be entered in January, but may not be posted until January is closed and February becomes the 'Current Accounting Period').
As in most double entry accounting systems, the basic ingredient in CLOSER is a transaction consisting of balancing debits and credits. In many batch-type systems, transactions are summarized in modules (e.g., Accounts Payable) and then posted to the General Ledger at month-end. In CLOSER, transactions are posted (on a daily basis if applicable), reviewed, un-posted, corrected, and posted as many times as needed during the current accounting period, to ensure the information is correct.
Transactions are stored in CLOSER for the entire fiscal year. They are numbered sequentially within the various types of journals (General, Accounts Payable, Disbursement, Contract Billing, Cash Receipts, Employee Payroll). All transactions, regardless of where they originate (e.g., Accounts Payable, Payroll, etc.) or how they are generated (e.g., manually or automatically by the system), are in the same format to allow sorting and printing of the General Ledger.
SIGNIFICANCE OF JOURNALS
The journals used for transactions are:
The significance of each of these journals is discussed below.
The Billing and Receipts journals are used to record Accounts Receivable invoices, and cash receipts.
The Purchase and Disbursements journals are used to record the distribution, and payment, of Accounts Payable. Purchase journal entries are created automatically when the Accounts Payable Invoice is entered. Disbursement entries are created when checks are generated. Manual checks are also entered as Disbursement entries.
Two Payroll journal entries are created automatically in the Payroll Module. One entry records the labor expense and credits Accrued Salaries. The other records the cash and withholdings (Gross-To-Net) and debits Accrued Salaries.
General Journal entries are typically used to correct entries from a previous month. General journal entries can be entered manually, or by using Recurring Journal entries or Reversing Journal entries.
All accounting data in CLOSER is eventually reflected in a transaction. Some transactions are created by the system , and some are manually entered directly into the system. When entering a transaction the following editing functions are performed by the system. These include:
|ensuring the transaction is in balance;|
|validating a Contract Number;|
|verifying that a Contract has not been closed to future charges;|
|comparing the Vendor Number to the Accounts Payable Invoice number to ensure they are a proper match;|
|verifying that the General Ledger account number is in the Master file;|
|ensuring that when the account number represents a direct cost (i.e., a 5000 series account), that a Contract Number is present;|
|ensuring that the division and pool reference on a contract agrees with the division and pool on the General Ledger account number;|
|ensuring that the correct type of contract is being referenced for the account number being charged (e.g., a proposal (P) contract for a B & P expense).|
Transactions are entered continually during an accounting period, with the majority of the activity being generated through Accounts Payable. Transactions are printed, proofread, and corrected as necessary. Until posted, the transactions are not reflected in any of the subsidiary records. There are, however, general ledger prints that, at the users option, will reflect un-posted transactions.
Until a transaction is posted it does not affect the Chart of Accounts or any of the other subsidiary records which are referenced on the transaction. Posting a Transaction updates all the subsidiary record referenced on the transaction. These subsidiary records are:
|Contract Cost Record for THIS MONTH.|
|Vendor Record for Month-To-Date INVOICES [Purchase Transactions] or Month-To-Date PAYMENTS [Disbursement Transactions]|
|Accounts Payable Invoice Status and Amount Paid.|
|General Ledger Chart of Accounts for the current accounting period.|
SORT THE GENERAL LEDGER
In order to print a General Ledger, the transactions are first sorted in an order appropriate to the account(s) being printed. They are sorted on any four of the six items recorded on a transaction:
For most General Ledgers, the transactions will first be sorted by the Account Number; thus enabling the printing of accounts in a sequential order. The second sort criteria is the most important in determining the order in which transactions in a certain account are printed. The third and fourth sort options are less important, since the first and second options ensure that most of the transactions will be in a sensible order.
EXAMPLE: In order to do bank reconciliations, the cash accounts should be in numeric order [first sort option by ACCOUNT NUMBER]; the checks should be listed in numeric order [second sort option by INVOICE/CHECK NUMBER]; the deposits should be listed in order by date [third sort option by DATE]. The fourth sort option is, at this point, not material. However, in the event there are transactions in the cash accounts that have no check number (Debit Card, Wire Transfers and Electronic Payments), they can be put in order by vendor number [fourth sort option by VENDOR/EMPLOYEE NUMBER].
The sort order which would be used for cash would have no relevance to the order needed for Accounts Receivable or Accounts Payable, for example. Therefore, typical sort orders for various account types are provided to make this process easier.
Note that the first sort order for the ODC REPORT is by contract, and the second by account. This allows a report to be printed which lists the ODC's by contract by account.
A single account, a sequential range of accounts, or the entire General Ledger can be sorted. Based on the sort order selected, appropriate account numbers to be sorted will be prompted. These can, and should, be changed when appropriate or desired.
We recommend that the final month-end General Ledgers be sorted and printed in groups of accounts which use the same sort sequence. This means that the General Ledger must be printed in pieces rather than in one step. This procedure, however, results in more meaningful and helpful General Ledger reports. It also makes more sense to print the Balance Sheet accounts year-to-date, but it may not be necessary to print the income and expense accounts year-to- date every month. Once the sort is completed, the general ledger can be printed.
PRINT THE GENERAL LEDGER
When printing the General Ledger, numerous options are available that control, for example, the time period printed, where subtotal levels are shown, and at what level contracts are summarized.
The General Ledger can be printed year-to-date, current month-to-date (which is the normal default), any particular month in the fiscal year, or any range of dates in the fiscal year. It is possible, for example, to print the first quarter of the year by selecting periods 01-03.
Contract or Vendor subtotals within accounts can be selected when printing the General Ledger. For example, if a General Ledger for Accounts Payable is being printed, subtotals by vendor would be the appropriate selection. For Accounts Receivable or direct costs, subtotals by contract would be the normal response. Contracts can be totaled at the subtask, task, or contract level.