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.
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.
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.
You can typically expand the information twice: First to view the details as a list of documents and then to view a specific document.
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.
Accounting 2008 can export reports to Microsoft Office Excel 2007, Excel 2003 and Excel 2002.