Items marked with an asterisk (*) are available in Microsoft Office Accounting Professional 2009 only.
The GL report contains detailed information about the debit and credit activity that occurs in all the accounts over a period of time.
The information in this report is derived from all sources in your system, including accounts receivables, accounts payables, cash disbursements, and receipts, or anywhere financial information is created in the system. When you run periodic statements, such as profit and loss statements or balance sheets, you or your accountant can use this report to check accuracy and to answer questions about how the results were obtained.
Note: This is the cash basis version of this report. For the accrual basis version, see the link under Related topics.
Open the report
On the Reports menu, point to Cash Basis, and then click GL Report.
The report lists account information as it is shown in the Chart of Accounts. Information in this report includes transaction dates and numbers, names, memo information, debit and credit amounts, and balances.
To view additional information, such as last modified by, pay types, and void status, do the following:
On the toolbar, click Modify Report, and then in the Modify Report pane, select the appropriate Columns options.
For detailed information about how to view individual transaction details, or modify, display, save, print, or export the report data, see Working with reports. For detailed information about how to filter report data, see Report filter options: GL report.
Change report basis or date range
To change the report basis for this report, do the following:
On the toolbar, click the arrow next to Report Basis, and then select Cash or Accrual.
To change the date range for this report, do the following:
On the toolbar, click the arrow next to Date Range, From, or To.
Sort by report groups
You can sort the groups within the report in addition to sorting the rows within the groups:
To sort the groups within the report, on the toolbar, click the arrow next to Sort Report Groups by, and then select an option.
To switch between ascending and descending order, click the sort by ascending or sort by descending buttons on the toolbar.
When Microsoft Office Accounting 2009 is set to use foreign currency, this report displays the amounts in the account currencies. In addition, the report changes to include columns that show the three-letter codes for the account currencies, the exchange rates between the account currencies and U.S. dollars (USD), the debit amounts in USD, the credit amounts in USD, and the balance amounts in USD.
For more information about using foreign currency in Office Accounting 2009, see Use foreign currency.