Items marked with an asterisk (*) are available in Microsoft Office Accounting Professional 2009 only.
The Transaction Detail by Account report contains detailed information about the activity that occurs in all the accounts over a period of time.
Information in this report comes from cash receipts and cash disbursements. 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 Transaction Detail by Account.
This report includes account information as it is shown in the chart of accounts. Default information includes transaction dates and numbers, names, memo information, amounts, and balances.
To view transactions that you created and modified, and to view debit, credit, pay type, and void information, 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 Filter reports.
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 transaction amounts in the account currencies. In addition, the report changes to include columns that show the three-letter code for the account currencies, the exchange rate between the account currencies and U.S. dollars (USD), the transaction amounts in USD, and the account balances in USD.
For more information about using foreign currency in Office Accounting 2009, see Use foreign currency.