The General Ledger Report lists the posting from each source for a single general ledger account or a designated group of ledger accounts for a specified period of time. You can set up the report to list the postings individually, subtotaled by source by day, or subtotaled only by source.
For a description of the report layout, see Report Data at the end of the topic.
To run the General Ledger Report:
From the G/L > G/L Reports menu, select General Ledger to display the General Ledger window.
In the Branch/Territory field, enter or select the branch or territory for which you want to run the report. Enter all to run the report for all branches and territories.
In the Start Date field, enter the first date of the period to include in the report.
In the End Date field, enter the last date of the period to include in the report.
Note: For both the Start Date and the End Date field, you can enter an actual date or a variable date, which the system converts to an actual date based on the As of Date entered when the program runs.
In the Account field, enter the account name for which you want to run the report or enter a report template ID in the Template field.
In the Subledger field, enter or select a subledger to include in the report.
Note: If you leave the Account field and the Template field blank but enter a subledger or multiple subledgers in the Subledger field, the report contains all accounts that have postings for those subledgers.
In the Sort By field, select one of the following ways to sort the report:
Account# (Default)
Account# by Branch
In the Summary/Detail field, select one of the following options:
Summary - Totals the transactions for each source and prints a line for each subtotal on the report.
Branch Summary - Subtotals the transactions for each source by branch and prints a line for each branch on the report.
Totals by Day - Totals the transactions for each source for each day and prints a line for each subtotal on the report.
Detail - Prints a line for each transaction on the report. Any detail notes added when the general ledger is distributed against in A/P, with cash receipts, or for inventory adjustments are included when you run the report in detail mode.
In the Report Currency field, do one of the following:
Leave the field blank to print the report in your system's base currency.
Select or enter a currency other than the default base currency. For example, if you are running the report a branch in Germany, select Dtsch as the report currency.
In the Calculate Exchange field, if you have defined a currency other than your company's base currency in the Report Currency field, select one of the following to indicate how to convert the transaction funds:
As ofCurrent Date - Converts each transaction amount using the current date's exchange rate.
Historically - Converts each transaction amount using the exchange rate in effect on the transaction date.
Average - Uses an average exchange rate by taking the average of all exchange rates within the reporting period and dividing the balance by the amount for that period. Days that do not carry a balance are not included in the average.
In the Break on Periods check box, do one of the following:
If the report period spans any two fiscal months:
Select the check box to print separate reports for each fiscal month.
Deselect the check box to print one report for a single month. This is the default.
If the report does not span two fiscal months, deselect the check box. This is the default.
In the Spreadsheet Format check box, do one of the following:
To format the report for downloading purposes. Selecting the check box moves the Account Name into the first column, and adds a Posting Date column after the Source column.
Deselect the check box to format the report for on-screen viewing.
The General Ledger Report lists the following columns of information:
Column | Description |
Account | The name of the account and the date a journal entry was made. |
Curr Period | The amount of the journal entry. |
Balance | The account as of a given date. |
Grand Totals | The total amount of the deposits as well as the total amount in the account as of the report date. |
See Also: