Ledger report

Use this report to reconcile account balances with other applications or subsidiary journals. This report provides the details behind the financial statement for a complete financial picture.

This report displays a one-line summary for each account’s current activity, including beginning and ending balances for the selected period. The accounts can be grouped by account or department. Drill down to the detailed entries that make up the activity for the month to easily identify the entries that make up the account balance.

Note: If you select to run the report for a period of more than a month, the report will take significantly longer to finish processing.

Audience

Accounting

CPA

Producing the report

From the > Reports menu, click Financial > Ledger.

Report options

Option Description

Company

Multi-company only. The report contains information for all companies in your organization, unless you select a specific company in this field.

Account

The report contains information for all accounts unless you select a specific account in this field.

Department

The report contains information for all departments unless you select a specific department in this field.

Month

The report contains information for the current month unless you select a different time period in this field.

After changing report options, click (Refresh). 

Customize options

Option Description

Report title

You can change the title of the report.

Sort order

Sorts the report by account or department. If you use multi-company, you can also sort by company.

Basis to print

Prints information for a cash or accrual accounting basis

Use drilldown

If selected, you can drill down to further detail on the report. If cleared, all information, including the lowest level of detail, prints on the report.

Print all

If selected, it prints all accounts. If not selected, only accounts that have an ending balance or activity during the given period print on the report.

Print account number

If selected, it prints the account numbers for accounts.

Include close year entries

If selected, it includes year-end closing entries on the report. It allows you to verify or review the entries made from the Close Fiscal Year task on the > Setup > Company menu.

Print customize options on report

If selected, it prints a list of the options that you select.

Report contents 

Column Description

Account or department

The account from your chart of accounts. If you are producing the report by department, this column contains the departments.

Beginning Balance

The balance of the account on the first day of this reporting period

Debit

The total of all debits posted to the account during this period

Credit

The total of all credits posted to the account during this period

Ending Balance

The balance of the account on the last day of this reporting period