Understand the reporting framework

Applies to:     Office Accounting Express, Office Accounting Professional

One of the most important features in a modern accounting application is the ability to report accurately on the transactions that are entered into the accounting application. It is just as important to get data from an accounting application as it is to enter data.

Microsoft Office Accounting 2008 provides a solid reporting framework with a large number of reports with features such as sorting, filtering, customisation, saving and exporting to Microsoft Office Excel.

Reports Home page

The Reports Home page differs from the other Home pages in Office Accounting 2008 in that there isn't a task flow view. Instead of a task flow view, the main area shows a sample preview of the selected report, to make it easier for you to select the report you are looking for.

reports home page
Reports Home page

The Navigation Pane in the Reports Home page is divided into report types to give you a better overview of the reports: Analysis Tools, Company and Financial, Customers and Debtors, Sales, Suppliers and Creditors, Purchases (Office Accounting Professional and Office Accounting Professional Plus), Stock (Office Accounting Professional and Office Accounting Professional Plus), Jobs and Time (Office Accounting Professional and Office Accounting Professional Plus), Banking and Employees and Payroll.

Generate a report

To generate a report from the Reports Home page, select the appropriate report type and report, select a date range and click the Display button.

You can also generate reports from the Reports menu. However, a date range cannot be selected until after the report is displayed.

Also, you can generate reports from the Customers, Suppliers, Employees and Banking Home pages.

profit and loss report
Sample Profit and Loss report

Select a date range

You can change the date range for a report either by selecting another range in the Date Range box on the toolbar or by specifying dates in the From and To boxes. When you change the date range, the report is recalculated based on the new date range. Depending on the amount of data in the database, the recalculation may take a few seconds.

Some reports, such as the Balance Sheet report, are based on a single date, rather than a range. You can change the reporting date either by selecting another date in the As of box or by specifying a specific date in the Date field.

View detailed report information

You can view detailed information about a line in all reports in Accounting 2008 to see what the line is composed of. To view detailed information about a line in a report, double-click the line, and a report with the detail appears in a new window.

profit and loss report
Profit and Loss report
transaction detail by account
Profit and Loss report with detailed information

You can typically expand the information twice: First to view the details as a list of documents and then to view a specific document.

journal entry
Transaction Detail by Account report with detailed information

Export to Excel

With Accounting 2008, you can take advantage of the extensive functionality of Office Excel because it is easy to export reports directly to Excel. Click the Export to Excel button on the report toolbar to export the report to Excel.

Accounting 2008 exports reports with formulas and formatting to Excel. The following figures show examples of reports.

sales by customer detail
Sales by Customer Detail report in Accounting 2008
sales by customer detail
Report exported to Microsoft Office Excel 2007, including formulas and formatting

Accounting 2008 can export reports to Microsoft Office Excel 2007, Excel 2003 and Excel 2002.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!