Chart of Accounts Listing Report

Top  Previous  Next

The Chart of Accounts Listing Report [glcap] generates a listing of all account numbers in your database.  These account numbers are pulled from the Chart of Accounts Entry [glca] screen.  Chart of Accounts is the master list of all account numbers used to track Production costs including Assets, Liabilities, Capital, Income and Expenses.

 

 

Open:

 

To access the Chart of Accounts Listing Report [glcap], click the 'G/L' module from the menu tree (see following screen shot).

 

The Chart of Accounts Listing Report [glcap] is also located in the 'Report' folder under the 'General Ledger' and 'Setup & Maintenance' sub-folders.

 

You can also access this report by typing the screen or acronym name in the blue prompt bar located above the 'Setup' menu.  Then, press Enter.

 

 

 

The screen then appears.

 

       

 

 

To select criteria, press the F2 Key or right click in most fields to make your selection. You can also simply type in the criteria in the allotted fields. If you wish to include all criteria information, leave all fields blank.

 

 

Chart of Accounts Information:

 

Starting and Ending Account - Account numbers to include in the report. To restrict the report to only include information for a single account number, input the same account in both the Starting Account and Ending Account fields. To select all account numbers, leave both fields blank.

 

 

Account Type Information: The report can also be run to include only certain account numbers based on the following option types:

 

Account Type - Single letter classification indicating the Account Type (Asset, Liability, Capital, Income, Expense).

 

Line Type - Single letter classification indicating the Line Type (A, B, C, D, E, F, G).  Only Expense Accounts have a Line Type.

 

Allow Posting - Indicate (Y/N) if you want to include only account numbers that can have transactions posted to them.

 

Sub-Account - Indicate (Y/N) if you want to include only Sub-accounts or only Header and Standalone Accounts.

 

Subtotal Level - Indicate if you want to include only accounts with a specific Level.  If so, enter a number between 0 through 9.

 

 

Integrity Check:

 

Integrity Check Only - Check mark this option to view if there are any errors or formatting issues within your Chart of Accounts.  Selecting this option will generate the Chart of Accounts Integrity Check Report in which the errors are display in bold (if any).

 

 

Print/Preview the Report: Located in the top right hand corner of the screen, you can choose the following options to generate the report:

 

Print - Opens the Print Dialogue box and sends the report directly to the printer.

 

Preview - Generates a PDF format report and appears instantly on your screen.  You are still able to print from the PDF format.

 

Spreadsheet - Generates an Excel format report and appears instantly on your screen.  You are still able to print from the Excel format.  Please note if you select this option, you are able to have additional sorting options within Excel.