Standard General Ledger
Access this report using Reports>General Ledger Analysis>Standard General Ledger. |
Use this report to print the general ledger. It contains the opening balance and complete detail for any report range and account codes selected.
- This report prints in a stair-step format: all the account codes are in one column, all the account titles in another column, and all the account short titles in yet another column if selected.
- Since the general ledger is basic to your accounting records and is a must for auditors, you will want to print an archive copy each month after all adjustments are entered and posted of either the Standard General Ledger or the Expanded General Ledger (depending on the presentation style preferred).

Account Level Security is available for this report. This feature allows you to define the account codes and related amounts a user can view in the report. When account level security is activated for the organization (Security>Set Up Account Level Segments) and enabled for a user (Security>Set Up Account Level Security), the report will only print account information the user is allowed to see. Note that if a user does not have Account Level Security enabled, the user will see all account codes.
If the "Print Disclaimer on Report" check box is selected on the Security>Set Up Account Level Segments form, "This report may be affected by Account Level Security" prints in the header of this report. In that case, an * also prints after the report title.

Additional columns and filters are available to help track electronic payments to your vendors.

The Session Currency, Session Currency Description, Source Currency, Source Currency Description, Exchange Rate, Source Debit, Source Credit, Invoice Currency, Invoice Currency Description, Invoice Debit, and Invoice Credit columns are only available if the Multicurrency module has been installed and added by the Administrator (Organization>Add a Module). "Source" currency columns follow the formatting of the source currency, while other currency columns follow the functional currency.
Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.
Specify the date range for the data included in the report by entering Balances Dates and Current Transaction Dates. The Account Balances Begin date and Current Reporting Year Begins date are used to obtain the beginning balances for the Opening Balances date.
The Cross Year Reporting feature (A Year-End Close will be simulated for this report) allows reports to be run for closed years and cross years at the same time.
Use this tab to determine what data to include in the report and to define the report layout.
- By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
- By selecting Available Columns, the data that appears in the body of the report is determined.
Column |
Description |
Account Code |
The actual account code, plus the Group Code you selected on the Groups tab. The report prints the account code, such as 201, 05, or 45001. One column displays for each code type, such as Fund Code or GL Code. |
Account Title (plus Group Code selected from Group Sets) |
The title associated with each code above, plus the Group Title you selected on the Groups tab. The system prints one column for each code type, such as Fund Title or GL Title. |
Account Short Title (plus Group Code selected from Group Sets) |
The short title for the title above (15 characters or less), plus the Groups Short Title you selected on the Groups tab. |
Session ID |
The Session ID assigned to the batch of documents. |
Session Date |
The date of the session. |
Session Currency |
The currency type assigned to the session, such as USD, CAD, EUR, GBP, or MXN. Currencies were created and activated by the Administrator using the Organization>Currency Setup form. |
Session Currency Description |
The description associated with the currency, such as US Dollar, Canadian Dollar, or Euro. |
Document Number |
The document number that was entered on the transaction entry form. |
Document Date |
The date of the document. |
Document Description |
The description of the document. |
Reversed Invoice | A designation of Yes or No, determining whether the A/P invoice/credit has been automatically reversed in the system using the Reverse Invoice check box on the Activities>Check Writing>Void Checks/Vouchers/Invoices form. This only applies if the Accounts Payable module is installed and the Allow Appending Entries to Reversed Invoices check box is selected on the Organization>Set Up Modules>Accounts Payable form. |
Reversed Invoice Date | If the Accounts Payable module is installed, the date the invoice was reversed during transaction entry using the Reverse Invoice check box on the Activities>Check Writing>Void Checks/Vouchers/Invoices. |
ID |
If the Accounts Payable, Accounts Receivable Reporting, or Payroll modules are installed, this is the Vendor ID, Customer ID, or Employee ID assigned. |
Name |
This is the name on checks/vouchers. If the Accounts Payable or Accounts Receivable Reporting modules are installed, this information was set up using the Maintain>Accounts Payable>Vendors or Maintain>Accounts Receivable>Customers forms. |
Payment Type |
The payment type associated with the document—either Check or Voucher. |
Source |
A source of Customer, Vendor, Employee, or Processing Group. The report shows C, V, E, or P. |
Effective Date |
The line item's effective date. |
Entry Type |
The entry type chosen during transaction entry—Normal, End of Year Adjustment, Adjust Opening Balances, or Beginning Balance. The system prints an N, A, AO, or UO. |
Transaction Description |
The description entered for the transaction line item. |
Debit |
For functional currency, the debit amount entered during transaction entry. For non-functional currency, the Source Debit times the Exchange Rate. |
Credit |
For functional currency, the debit amount entered during transaction entry. For non-functional currency, the Source Credit times the Exchange Rate. |
Check Address Code |
The vendor’s check address code, such as Main or Austin Office. |
Source Currency |
The source currency type associated with the transaction, such as USD, MXN, or CAD. |
Source Currency Description |
The description associated with the currency, such as US Dollar, Mexican Peso, or Canadian Dollar. |
Exchange Rate |
The exchange rate associated with the transaction. Exchange rates were entered using the Maintain>Multicurrency>Exchange Rates form. This is only used with non-functional currency sessions. |
Source Debit |
The debit amount entered during transaction entry. |
Source Credit |
The credit amount entered during transaction entry. |
Invoice Currency |
The currency type, such as USD, MXN, or CAD, assigned to Accounts Payable or Accounts Receivable transaction lines. |
Invoice Currency Description |
The description associated with the currency, such as US Dollar, Mexican Peso, or Canadian Dollar. |
Invoice Debit |
The invoice debit amount used in Accounts Payable or Accounts Receivable transaction lines. |
Invoice Credit |
The invoice credit amount used in Accounts Payable or Accounts Receivable transaction lines. |
Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.
Use this tab to designate the Group Sets for the report. Groups provide an alternate way of reporting summarized accounting data. Selecting a group code on the report is the same as filtering by group code on the entire report. Any accounts not included in a Group Set will not be included in the report. In order for groups to be applied to the report, the group selected on the Groups tab must also be selected in at least one of the following: Content tab or Filter tab.
If the report is printed using groups rather than individual account codes, only account codes included in the groups created for this Group Set print on the report. If there are account codes not included in a group, they do not print on the report.
Use this tab to set up any Available Options for the report.
Options |
Description |
Year-End Adjustments |
Select this option to include year-end adjustments on the report. This entry type was designated during transaction entry. |
Opening Entries in Detail |
Select this option to include opening balances (system or user opening entries) in detail. This entry type was designated during transaction entry. |
Summarize Amounts |
Select this option to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together. |
Suppress Lines with All Zeros |
Select this option, along with the Summarize Amounts option, so that documents with zero amounts do not print. If the debit and credit on the same line nets to zero then it is suppressed. For example, there is a GL code with a debit of $100 (USD) and a credit of $100 (USD) and it is on the same line with no other entries. The GL code will not appear on the report. |
Subtotal Detail by Calendar Month |
Select this option to subtotal the detail by a calendar month. This subtotal always calculates according to calendar month end, (1-31) not the month end of the Fiscal Year. |
Use this tab to change the font and page setup for a report.
Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.
- A cross year report can be created with balances outside the organization's fiscal year (Setup tab). However, this report cannot be generated with groups and balances outside the organization's fiscal year.
- When the organization was set up by the Administrator using the File>New Organization wizard, a fiscal year-ends was designated for it. Ideally, at the end of the organization's fiscal year, the year should be closed using the Activities>Close Fiscal Year form. When a fiscal year is closed, the balances are carried forward to the new year.
- Use balances for Assets, Liabilities, and Net Assets. Revenue and Expense accounts always have a zero balance at the beginning of the year. When an organization's fiscal year is closed, the balance sheet account is carried forward to the new year, but new net assets balances are calculated based on the prior year.
- To print totals for each account code combination, select the Show Totals box on the Content tab.
- The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).