Chapter 10: General ledger

 

Journal Entries and Financial Reporting

The byproduct of automating the invoicing, accounts receivable, and accounts payable is an automated general ledger with financial reporting.

Structure

The general ledger consists of two files that interact to produce the necessary details of your bookkeeping.

The G/L Account file contains the chart of accounts, that is, for each account, the account number, account type, and description. Stored in each record are the monthly activity for the current year and the prior year, plus monthly budget figures. The Monthly Trial Balance will print from this file showing one line per account, with the account balance as of the beginning of the month, the month's activity, then the ending balance. The formatted financial statements also print from this file.

The G/L Detail file contains records of account activity. A record is added to this file whenever an account appears in the G/L Summary portion of one of your daily Journals. The Detail Trial Balance will print from this file producing an audit trail that helps you trace from a single source back to the actual detail of a transaction, recorded on the daily Journal.

Much of the daily posting to accounts occurs automatically. This is due to an internal structure that is for the most part invisible to the operators. You have seen references to G/L Cross-Reference codes in many sections of this manual. The system uses these codes, which are built into the programs, to post to certain accounts. You have attached these codes to your actual account numbers when you added the accounts to the G/L Account file. This is the method of crossing over between programs and your actual data.

For example, when an invoice is generated, the system will post a debit to Accounts Receivable, whose cross-reference code is "A/R", and a credit to Sales, cross-reference code "SALE". This is an oversimplified example, but the point is that certain assumptions have been made as to how each Journal should post to the general ledger. All you have to do is correctly set up the Chart of Accounts with the cross-reference codes.

Account Numbering

You may establish G/L account numbers as long as ten characters. They can contain numbers, letters, and other characters, like dashes, if desired. The actual numbers may be determined in any manner, but grouping by account type is suggested (assets begin with 1, liabilities 2, etc.) But there are a few specific rules for establishing your account numbers.

There are three levels of accounts; control, true, and department.

Control accounts are non-posting account that are established solely to accumulate totals of subordinate (true) accounts. You may have three bank accounts plus a petty cash account, for example. You should have one control account that always retains the running total of the four cash in bank accounts.

True accounts are the actual accounts that you will post to. Accounts Receivable, Sales, Auto Gas & Oil, for example.

You may choose to set up division accounts (department, or profit center). To do this, you split up your revenue and expense true accounts into several accounts, one for each department. For example, you might have a true account 5201 Automobile Gas & Oil. But, to track expenses by four departments, you create 52011, 52012, 52013 and 52014. Notice how the department number is attached as an extension of the true account number. When you do this, the true account becomes a non-posting account.

Each account level will have several account numbers. But each of these numbers MUST be the same length. So you might have control level accounts with 2 digits, true level accounts with 4 digits, and department level accounts with 5 digits.

Refer to chapter 2, Master Files, G/L Account Maintenance, for a greater explanation of setting up your chart of accounts.

Journal Posting

You post to the General Ledger each day when you print and update these journals: Sales, Cash Receipts, Purchases, Cash Disbursements, possibly P.O. Receipts, Inventory Adjustments, and Payroll. At the end of the month, the Finance Charge Journal and General Journal may post to the General Ledger. Each journal includes a G/L Summary page on which appears those accounts with activity on that journal during the current month. The current day's activity and month-to-date totals are shown. Each journal update adds one record to the General Ledger Detail file for each account on the G/L Summary with activity.

The General Journal Posting program is a simple data entry program to handle adjusting journal entries to any account, for the current period or any of the eleven prior periods. Each journal posting must, of course, be double entry and must balance.

Financial Reporting

Month end reports include the Monthly Trial Balance, and the G/L Detail Trial Balance. The Monthly Trial Balance is a worksheet showing one line per account with beginning balance, current period activity, and ending balance. The Detail Trial Balance lists those accounts with current period activity, and it shows one line for each posting, with the date, source (which journal), and amount of the posting. The Detail Trial Balance prints in account number sequence, or alternatively, can group records by source journal, then account number.

The G/L Insight program can be used to display accounts on the video screen. Input the account number to see the activity for each period (month), year-to-date and the prior year, and the monthly budgets and variance from budget. Then, a secondary screen will show the detail G/L transaction records, similar to the Detail Trial Balance, for any of the last 12 months.

If you've been accounting by division, or department, two reports will analyze departmental expenses. One lists a department, then all expenses charged to the department. The other report lists an expense account, then shows each department and the amount charged to the department.

The financial reporting system consists of a set of instructions which allow flexible formatting of financial reports. This means that you can create a variety of reports using your own account numbers and print formats. Once the reports are set up, you can print them at any time, in a matter of minutes.

To create a report, you must design, or lay out the desired format and determine the applicable accounts. Use the G/L Report Format Maintenance program to enter the instructions. Balance sheet reports may require 30 to 50 lines of instruction, income statements, perhaps 100 lines. Each report can have up to eight columns along with a 30 character account description or other text. Each column represents a field of information stored in the General Ledger file.

General Journal Posting

Post to the General Journal

Make direct entries into the General Ledger using the General Journal Posting. This program is most commonly used for posting adjustments as requested by your accountant, to post payroll or any other transactions that are not an integrated part of the computer system, post corrections to the inventory account, and to initially load the balances from your manual or prior computer system.

Begin by entering a reference number, reference date, and posting period. Then enter an account number, amount, and debit or credit code. Enter as many accounts as you desire. As each is entered, a proof total is computed and displayed. This proof must be zero before the posting can be accepted.

At any point you can change or delete a posted line, or simply review your postings. This makes it easy to get your work in balance.

Reference Information

Enter a reference number, reference date, and posting period so that you can easily recall the details of this posting at a future date.

Reference number

Enter as many as six characters.

Reference date

Enter a valid date using an MMDDYY (month,day,year) format.

Period

Enter the fiscal period 1 through 12 for which the postings will occur. You may enter the current accounting period or one of the prior eleven periods. Or, you may enter period "14", which is the period number used for "closing" entries.

Period 14 should be used only to close revenue and expense accounts AFTER the fiscal year ends.

Is the above correct? (Y)or(N)

You have an opportunity to correct the above fields. Reply "Y" if the information is correct and you want to proceed. Reply "N" to erase the above and return to the "Reference Number" prompt.

Add a Line

To add a journal posting line, when the following prompt appears:

(A)dd, (C)hange, (D)elete, or (R)eview lines, or (END)

Enter "A" to add a new line. The cursor moves to the account number prompt.

G/L Accounts and Amounts

Account number

Enter any valid account number that may be posted to. Control level and some true level accounts may not be posted to. The "allow posting" field is set up using the G/L Account Maintenance program. The account description displays for visual verification.

Amount

Enter an amount using a 99999999.99 numeric format. Precede the number with a minus (-) if desired.

DR/CR code

Immediately following the amount, indicate whether the amount is a debit or a credit to the account. Press (RETURN) for the default value that appears. It is based on the type of account you have just entered. Asset and expense accounts are debit (DR) accounts. Liability, equity, and revenue accounts are credit (CR) accounts.

Comment

You may type as many as 20 characters. This will show on the General Journal printout.

Proof

The system accepts the line and uses the amount and debit/credit code to compute a proof amount. Debits add and credits subtract from the proof.

Until the proof is zero, the system continues to cycle to the "Add, Change, Delete..." prompt for your entry of another account. When the proof is zero, the posting is considered complete. Then you are at a position to enter another reference number.

Change a Line

You may change the AMOUNT, DR/CR CODE, and COMMENT for any line you have previously entered. You cannot change the account number. If the account number is wrong, use the delete option to delete the line, then add the line correctly.

To change a line, you must indicate the LINE NUMBER to be changed. This line must be visible on the screen when you select the change option. Therefore, you may have to (R)eview lines in order to get the desired line to appear on the screen.

To change a posting line that you have entered:

(A)dd, (C)hange, (D)elete, or (R)eview lines, or (END)

Enter "C" to change a line.

Select a LINE NUMBER to change, or (END)

Each line you have posted has a line number. You must enter the line number you want to change.

Now you may change your previous entries for Amount, DR/CR code, and comment. The program returns to the "Add, Change, Delete..." prompt and you are in a position to continue with the posting.

Delete a Line

The procedure to delete a line is similar to the Change option. You must enter the LINE NUMBER to be deleted.

(A)dd, (C)hange, (D)elete, or (R)eview lines, or (END)

Enter "D" to delete a line.

Select LINE NUMBER to delete, or (END)

From the lines displayed on the screen, enter the line number of the posting line you want to delete.

The line is removed from the screen display and the amount is deducted from the PROOF. The program returns to the "Add, Change, Delete..." prompt and you may proceed with the posting.

Review Lines

Some of your journal postings may be lengthy ones including more accounts than can be displayed on the screen at one time. As you add lines, the previously entered lines will scroll off the screen.

The review option lets you bring portions of a lengthy posting to the screen to be viewed. You can review your work or bring lines you desire to change or delete onto the screen.

(A)dd, (C)hange, (D)elete, or (R)eview lines, or (END)

Enter "R" to review lines.

Enter the starting PAGE NUMBER or (END)

The program will display one "page" of posting lines at any time. To let you quickly get to the appropriate page, you may enter a starting page number to be displayed.

Each page of lines may be viewed. Press (RETURN) to view the next page until all pages have been displayed. The program returns to the "Add, Change, Delete..." prompt and you may proceed with your posting.

End The Posting

When you have completed entering accounts and amounts and you want to end the posting:

(A)dd, (C)hange, (D)elete, or (R)eview lines, or (END)

Press (END) to end the posting.

If the proof amount is zero, the posting is completed. Records are written to the General Journal file and included on the next printing of the General Journal and Update.

If the proof amount is NOT zero, you may not end the posting. This message appears:

This posting may not be completed until the PROOF is zero!

At this point, review the posting to determine where your error occurred. Continue to add, change, or delete lines until the proof is zero and your posting can be completed.

General Journal postings are not considered "official" and will not affect the G/L master file until the General Journal Print and Update program has been completed.

General Journal Print & Update

 

Print the journal as an audit trail of your entries using the General Journal Posting program. Save it for future use to track errors.

The journal lists the detail of each posting, then lists a G/L Summary.

After the journal is printed, you may update the entries. The new general journal postings are not "official" until this update is completed.

Select Report Options

There are no report options for this program. Press (RETURN) to start the report.

Review The Report

Notice that the first part is an audit trail detailing the entries you have made since the last update. The second part summarizes the General Ledger entries to be made by the update.

You should keep this report for future reference.

Update the Journal

After the journal printing has concluded the system displays this message:

Do you want to update the General Journal? (Y)or(N)

Check the journal BEFORE you respond to this question. Make sure all printing is legible and that the journal is complete and in balance.

Type "Y" to proceed with the update. Type "N" to return to the Selector without updating.

The update program scans the journal file and updates the General Ledger master and transaction files. When completed, the General Journal file is cleared for the next batch of postings. The information is retained for the Monthly General Journal, however.

G/L Report Format Maintenance

Add, Change, or Delete Financial Formats

This program lets you create your own financial report formats. Please refer to a separate booklet "Formatting Financial Statements" for instructions.

G/L Report Format Master List

 

As you create your own financial report formats, you need to see these format instructions on paper. This master list program will print your formats.

You should always keep within quick reach a current copy of your formats in printed form. You need to refer to them to answer vital questions about what accounts are included in which section of the report. When you add new accounts to your chart of accounts, you must add them to the appropriate financial reports also. Refer to the printed formats to determine where, and how to add the accounts.

You can print the Format Master List at any time, and as often as desired. You can select a range of report numbers to print.

Select Report Options

RANGE: First report to print

You can select to print a range of financial report formats. Report numbers are three character, alpha-numeric codes, like "PL1", or "B/S". Report formats will print in alphabetic sequence by the report number.

Enter the first report format number to be printed, or leave the field blank to begin with the first report format in the G/L Format file.

RANGE: Last report to print

Indicate the last report format number to be printed, or leave the field blank to print through the last report format in the G/L Format file.

Review the report options and if all selections are correct, press (RETURN) to start the report.

G/L Year End Closing

Close Revenue & Expense accounts

A common procedure at the end of a fiscal year is posting the closing entries to the revenue and expense accounts. This "closes" each account, making the balance forwarded to the new year equal to zero.

The opposing entry as each account is closed is made to an "income summary" or "profit & loss" account, and thus, when all accounts are closed, the income summary account contains the year-ending profit (or loss).

DR revenue or expense account
CR Income Summary account "INCSUMM"

This program performs this function automatically. You do not have to use the General Journal Posting program to close each account. The program will scan the G/L Accounts file, detecting only revenue and expense accounts with non-zero year-ending balances. It will add a posting to the General Journal to reduce the balance to zero, with the offsetting posting to an income summary account. You must run the General Journal Print & Update program to complete the closing task.

Be certain you have an income summary account in your chart of accounts. It is an equity account, and it must have the G/L cross-reference code equal to "INCSUMM".

You may run this program more than once after the year end. Each time, it will look at the prior year-end balance of revenue and expense accounts and make its postings. Thus, if adjusting entries have been made since you ran the program after year end, you can run it again before printing your final financial reports.

Let's look at an example of the postings that this program will make.

You have these accounts and account balances at year end:

1200 Accounts Receivable - trade 338,030.21

3100 Profit (or loss) .00

4010 Sales - California taxable 34,030.80

4020 Sales - California resale 2,838,391.04

4030 Sales - Out of state 18,922.60

5010 Cost of goods sold 1,733,803.80

5050 Freight out 118,625.50

5120 Salary and wages 164,116.24

These postings will result:

DR 4010 Sales - California taxable 34,030.80

DR 4020 Sales - California resale 2,838,391.04

DR 4030 Sales - Out of state 18,922.60

CR 5010 Cost of goods sold 1,733,803.80

CR 5050 Freight out 118,625.50

CR 5120 Salaries and wages 164,116.24

CR 3100 Profit (or loss) 874,798.90

No posting is made for the asset account Accounts Receivable.

The postings are made to period 14, a special area that does not appear when you display account history. Period 14 is used rather than period 12 to retain the significance of that period.

Be sure to run the General Journal Print & Update immediately following this program. None of the postings of this program will become "official" until the update is completed.

Type "CONTINUE" to proceed with update, otherwise
(END) to return to the selector.

Type "CONTINUE" or (END)

To proceed, type "CONTINUE", then press (RETURN).

To end the function without closing accounts, press (END).

The program scans the G/L Account file. When it encounters a revenue or expense account, it will add records to the General Journal file. The scan will take a few minutes. At the beginning, it will rapidly skip through the asset, liability, and equity accounts.

Monthly Trial Balance

 

The Monthly Trial Balance is a worksheet showing one line per account. Each line has the account balance at the beginning of the month, the current month's activity, then the ending balance.

The Trial Balance should be printed each month. It is designed to be printed AFTER the month is closed, thus allowing for adjusting entries and posting of vendor invoices to the prior period.

You may print the report at any time, as often as desired.

Select Report Options

SPECIFY fiscal period

You have the opportunity to print the Trial Balance for the current fiscal period (month), or any of the prior eleven periods. The main purpose for allowing different fiscal periods is to allow you to print a Trial Balance as of the end of any period, but several days or weeks after closing the month, allowing for any adjustments to be made.

For example, if you are currently several days into period 2, you can select "2" to print as of the end of the current month. Or you can enter period 1 to print as of the end of period 1 in the current fiscal year. Or, you can enter period 12 to print as of the end of the prior fiscal year.

Review the report options and if all selections are correct, press (RETURN) to start the report.

Detail Trial Balance-Account Sequence

 

The is a report to be printed monthly that helps you audit your bookkeeping. Each general ledger account with activity during the month will have at least one detail line. The detail lines are created by one of the many daily journals and journal updates. Each line shows the source journal code, the posting date, and the debit or credit amount.

You should be able to quickly analyze any account and refer to the daily journals for the detail of any transaction.

Select Report Options

SPECIFY fiscal period

You have the opportunity to print the Detail Trial Balance for the current fiscal period (month), or any of the prior eleven periods. The main purpose for allowing different fiscal periods is to allow you to print a Detail Trial Balance as of the end of any period, but several days or weeks after closing the month, allowing for any adjustments to be made.

For example, if you are currently several days into period 2, you can select "2" to print as of the end of the current month. Or you can enter period 1 to print as of the end of period 1 in the current fiscal year. Or, you can enter period 12 to print as of the end of the prior fiscal year.

Review the report options and if all selections are correct, press (RETURN) to start the report.

Detail Trial Balance-Journal Sequence

 

The is a report to be printed monthly that helps you audit your bookkeeping. Each general ledger account with activity during the month will have at least one detail line. The detail lines are created by one of the many daily journals and journal updates. Each line shows the source journal code, the posting date, and the debit or credit amount.

You should be able to quickly analyze any account and refer to the daily journals for the detail of any transaction.

This version of the Trial Balance prints in account number sequence, but grouped by source journal code. Thus, the first journal code, "AR", for the A/R Manual Posting Journal prints first, then the code "CR" for Cash Receipts, and so on.

Select Report Options

SPECIFY fiscal period

You have the opportunity to print the Detail Trial Balance for the current fiscal period (month), or any of the prior eleven periods. The main purpose for allowing different fiscal periods is to allow you to print a Detail Trial Balance as of the end of any period, but several days or weeks after closing the month, allowing for any adjustments to be made.

For example, if you are currently several days into period 2, you can select "2" to print as of the end of the current month. Or you can enter period 1 to print as of the end of period 1 in the current fiscal year. Or, you can enter period 12 to print as of the end of the prior fiscal year.

Review the report options and if all selections are correct, press (RETURN) to start the report.

Department Expense Analysis

 

If you are using department level accounts, this report gives a picture of your expenses by department. The system prints a department number, then scans the expense accounts, printing one line for each account number ending with the department number.

Use the report as you might use a Profit and Loss Statement broken out by profit center or department, to evaluate the expenditures of each department.

An account must be both an expense account (type 5) and a department level account (determined by the length of the account number), to be included on this report.

Select Report Options

SPECIFY fiscal period

You have the opportunity to print the Expense Analysis for the current fiscal period (month), or any of the prior eleven periods. The main purpose for allowing different fiscal periods is to allow you to print an Expense Analysis as of the end of any period, but several days or weeks after closing the month, allowing for any adjustments to be made.

For example, if you are currently several days into period 2, you can select "2" to print as of the end of the current month. Or you can enter period 1 to print as of the end of period 1 in the current fiscal year. Or, you can enter period 12 to print as of the end of the prior fiscal year.

ONLY Department no

You may elect to print expenses for a single department number. Enter the department number, or leave the field blank to print expenses for all department numbers.

Review the report options and if all selections are correct, press (RETURN) to start the report.

Expenses by Department Analysis

 

If you are using department level accounts, this report gives a picture of each of your expenses broken out by department. The system prints an expense account number, then prints one line for each department number.

Use the report to compare the expenditures of each profit center or department for the same expense account.

An account must be both an expense account (type 5) and a department level account (determined by the length of the account number), to be included on this report.

Select Report Options

SPECIFY fiscal period

You have the opportunity to print the Expense Analysis for the current fiscal period (month), or any of the prior eleven periods. The main purpose for allowing different fiscal periods is to allow you to print an Expense Analysis as of the end of any period, but several days or weeks after closing the month, allowing for any adjustments to be made.

For example, if you are currently several days into period 2, you can select "2" to print as of the end of the current month. Or you can enter period 1 to print as of the end of period 1 in the current fiscal year. Or, you can enter period 12 to print as of the end of the prior fiscal year.

RANGE: First Expense Acct

You can select a range of expense account numbers to be included on the report. Enter the first account number, or leave the field blank to begin with the first expense account in your chart of accounts.

RANGE: Last Expense Acct

Enter the last account number to be included, or leave the field blank to print through the end of your chart of accounts.

Review the report options and if all selections are correct, press (RETURN) to start the report.

Financial Statements

 

With GENESYS, you can create your own Balance Sheet and Income Statements as well as supporting notes. Use the G/L Report Format Maintenance program to enter instructions for printing according to your desires. Then, use this program to print those reports.

The system is designed to print financial reports AFTER the fiscal period has been properly closed. This means that new vendor invoices received after month end can be expensed to the prior period. Adjustments determined by your accountant weeks after the year-end closing, can be posted. Then, you can print reports as of the end of the period.

You can print any financial report at any time you desire.

Select Report Options

RANGE: First report to print

You can select to print a range of financial reports. Report numbers are three character, alpha-numeric codes, like "PL1", or "B/S". Reports will print in alphabetic sequence by the report number.

Enter the first report number to be printed, or leave the field blank to begin with the first report in the G/L Format file.

RANGE: Last report to print

Indicate the last report number to be printed, or leave the field blank to print through the last report in the G/L Format file.

SPECIFY report date

You must enter the "as of" date of the report. This should match the fiscal period you select in the next field. Enter a valid date using an MMDDYY (month, day, year) numeric format.

SPECIFY fiscal period

You have the opportunity to print the Financial Statements for the current fiscal period (month), or any of the prior eleven periods. The main purpose for allowing different fiscal periods is to allow you to print Financial Statements as of the end of any period, but several days or weeks after closing the month, allowing for any adjustments to be made.

For example, if you are currently several days into period 2, you can select "2" to print as of the end of the current month. Or you can enter period 1 to print as of the end of period 1 in the current fiscal year. Or, you can enter period 12 to print as of the end of the prior fiscal year.

SPECIFY number lines per page

This option lets you vary the printed length of the report, if desired. Printers normally print 6 lines per inch. The standard number of lines on an 11 inch page is 66. The system will skip to a new page and print page headings after the number of lines per page have been printed.

INCLUDE report heading (Y)or(N)

Report headings are the standard 2 line headings that appear on all other GENESYS reports. You may include or exclude these heading lines.

ONLY: Department no.

If you have department P&L's set up, you should indicate which department number you are printing. This way, the system can print percent of sales as a percent of the total revenue of that department rather than total revenue of the entire company.

If you have no department accounts, or you desire percent of total company revenue, leave this field blank.

Review the report options and if all selections are correct, press (RETURN) to start the report.

YTD G/L Spreadsheet

 

The YTD G/L Spreadsheet is designed to let you evaluate specific accounts over a 12 month period. For each G/L account it shows the beginning balance for the fiscal year, then the period activity for each period that has transpired, and an ending balance.

You may choose to compare the period activity with either the prior year's period activity or the current year's budget. The program calculates and prints the variance amount and percent.

This report shows seasonal swings in account activity and is a great aid to budgeting.

The report may be printed at any time. For a full year's analysis, print the report as part of the year end closing, that is, prior to the Month End Update for your 12th accounting period.

This can be a rather long report. You may wish to limit the accounts to be printed by selecting a range of accounts to print.

Select Report Options

RANGE: First Account# to print

You may specify a range of account numbers to be included on the report.

Enter the first G/L account number to print or leave the field blank to begin with the first account in the G/L master file.

RANGE: Last Account# to print

Enter the last account number to print or leave the field blank to print through the end of the G/L master file.

SPECIFY (P)rior yr. or (B)udget

The current year's period activity is compared to either the prior year's activity or the current year's budget.

Enter "P" to compare to prior year. Enter "B" to compare to current year budget.

INCLUDE Variance amt (Y)or(N)

You may choose to include a line for each account that shows the variance amount between the current year's period activity and either the prior year's activity or the current year's budget as selected above.

The variance amount is computed:

VARIANCE AMOUNT = CURRENT YEAR - PRIOR YEAR (OR BUDGET)

INCLUDE Variance pct (Y)or(N)

Similarly, you may choose to include a line for each account that shows the variance percent between the current year's period activity and either the prior year's activity or the current year's budget.

The variance percent is computed:

VARIANCE PCT = CURRENT YEAR / PRIOR YEAR (BUDGET) * 100

Review the report options and if all selections are correct, press (RETURN) to start the report.

YTD Detail Trial Balance

 

The Y-T-D Detail Trial Balance is a report that helps you audit your bookkeeping. It corresponds to the Monthly Detail Trial Balance in that it prints a line for each journal posting to an account. The detail lines are created by one of the many daily journals and journal updates. Each line shows the source journal code, the posting date, and the debit or credit amount.

The YTD report, however, prints the detail postings for the entire year to date. It subtotals the activity of each accounting period.

You should be able to quickly analyze any account and refer to the daily journals for the detail of any transaction.

This report may be printed at any time. For an entire fiscal year analysis, run this report as part of your year end closing, that is, just prior to the Month End Update for the 12th accounting period.

This can be a lengthy report. You may want to limit the size by selecting a range of accounts to print.

Select Report Options

SPECIFY fiscal period

You have the opportunity to print the YTD Detail Trial Balance through the current fiscal period (month), or any of the prior eleven periods. This allows you to print this report as of the end of any period.

RANGE: First Account# to print

You may specify a range of account numbers to be included on the report.

Enter the first G/L account number to print or leave the field blank to begin with the first account in the G/L master file.

RANGE: Last Account# to print

Enter the last account number to print or leave the field blank to print through the end of the G/L master file.

Review the report options and if all selections are correct, press (RETURN) to start the report.

G/L Account Insight

 

Use this program to retrieve any General Ledger account from the G/L Master file and display its history for the current year and prior year, the current year-to-date balance, and variance from budget. In addition, you can display the G/L detail records for any period in the current fiscal year.

You can choose "control" accounts as well as true or department level accounts.

Select An Account

Account number

Enter the desired account number. The system retrieves the G/L Account record and displays the history for the prior year, the current year, the budget, a variance amount between the current year and the budget, and the percent of budget. Only periods up through the current period appear. The balance forward line is the account balance that was carried forward from the end of the prior year.

If you have selected a "control" level account, or a true level account that has department accounts, then no detail records exist for this account. You will not have the option to display detail.

Press (RETURN) to continue

After viewing the account history, press (RETURN) to go back to the "Account number" prompt.

View G/L Detail

If you have selected an account that may be posted to, that is, a department or true level account, you may now choose to view the G/L detail records for any period in the current fiscal year.

Press (RETURN) for transactions, or (END)

Press (RETURN) to display G/L detail transactions, if any, for this account. A new screen appears. You may now select a fiscal period to display.

You can press (END) to go back to the "Account number" prompt, skipping the detail screen.

Period

Select a period between 1 and 12. The G/L detail records for the period appear, listing the source Journal, the posting date, and debit or credit amount.

Press (END) to return to the first screen, to the "Account number" prompt.

End The Program

Account number

Press (END) to return to the Selector.

.Begin Table C.