Microsoft Office Accounting Professional 2008

Report descriptions

This training article lists all the reports for each report sub-area in Office Accounting. The reports marked with an asterisk (*) are only available in Office Accounting Professional and Professional Plus.

Analysis Tools

Sales Analysis (Excel pivot table) – The sales analysis report enables you to see your sales by customer, product, product type, date range or number of units simply by using the pivot table in Excel.

Purchase Analysis (Excel pivot table) – The purchase analysis report enables you to see your purchases by supplier, product, product type, date range or number of units simply by using the pivot table in Excel.

Supplier List (Access report) – The supplier list gives you a complete list of your suppliers, their balance and their contact information sorted by supplier ID.

Payment List (Access report) – The payment list lists all the payments made, the date, payment method, amount paid and whether they have been applied or not.

Product List (Access report) – The product list is a complete listing of all your stock products, non-stock products, services and kits with product number, description, type, product group, quantity on hand, and sales price sorted by product number.

Invoice List (Access report) – The invoice list is a complete list of all invoices to customers with date, number, status, customer name, price, remaining balance, due date and customer phone number sorted by invoice date.

Employee list (Access report) – The employee lists display all employees with employee ID, name, title, and various phone numbers sorted by employee ID.

Customer List (Access report) – The customer list is a complete list of all customers with customer ID, customer name, balance, and customer contact information sorted by customer ID.

Profit and Loss Standard (Access report) – The profit and loss standard is a US version of the profit and loss report with different groupings and titles.

Company and Financial

Chart of Accounts* - The Chart of Accounts provides a complete listing of all the nominal accounts that have been created for your business and their current balances.

Profit and Loss - The Profit and Loss statement displays your company's turnover, expenses and financial results in detail over a period of time.

Profit and Loss by Department* – This version of the profit and loss statement displays your company's P&L by showing one column per department as well as the total for the company. This report is only available when departments are enabled.

Balance Sheet - The Balance Sheet reports your company’s assets, liabilities net assets as well as your capital and reserves at a given point in time. This report is grouped into categories, such as fixed assets, current assets, creditors due within one year, creditors due after one year and capital and reserves.

Cash Flow Statement - The Cash Flow statement shows the sources of cash that have come into your company and how cash has been spent. This report is broken into two main categories: Operating and Financing activities. Cash sources included in the cash flow report are cash sales, collection of customer accounts, bank loans and the sale of fixed assets; cash uses included in the cash flow report are supplier account payments, employee wages, purchases of fixed assets and dividend payments.

Trial Balance - The Trial Balance is a listing of all the nominal account balances from the Chart of Accounts. It is similar to the Chart of Accounts report, except that columns are provided for both debits and credits.

Transaction Detail by Account - The Transaction Detail by Account report provides a detailed look at the entries posted to the Chart of Accounts over a period of time. Information displayed can include transaction dates, types, numbers, names, offset accounts, amounts and balances.

GL Report – The GL Report contains detailed information about the debit and credit activity that occurs in all the accounts over a period of time. When you run periodic statements, such as profit and loss statements or balance sheets, you or your accountant use this report to ensure accuracy and to answer questions about how the results were obtained.

Audit trail - The Audit trail report provides a detailed, chronological view of the entries posted to the Chart of Accounts over a period of time. Information displayed can include transaction dates, types, numbers, names, accounts, and debit and credit amounts. It is similar to the Transaction Detail by Account report, except that columns are provided for both debits and credits.

Change Log* - The Change Log report provides a complete listing of activities in Microsoft Office Accounting. This report is helpful for auditing purposes and can be used to trace fraudulent activity and other unknown adjustments or errors.

Budget for Profit and Loss* - The Budget for Profit and Loss report compares the budget to the actual result for a given period and displays the variance in Sterling and percent.

Budget for Profit and Loss by Department* - The Budget for Profit and Loss by Department report is similar to the Budget for Profit and Loss report, but it is broken out by department.

VAT 100 Liability - The VAT 100 Liability report shows the actual VAT returns you have sent in the past as well as how the next VAT return would look, should you send it today. By default the reports shows the current Vat period.

VAT Summary by VAT Code - The VAT Summary by VAT Code report displays net amount and VAT amount for all VAT sales and purchase transactions, totalled by VAT code for a given VAT period.

VAT Detail - The VAT Detail report displays all VAT sales and purchase transactions for a given VAT period.

VAT Exception - The VAT Exception report displays all VAT transactions or corrections for previous VAT periods that have been made after the VAT return has been submitted. These will be included on the VAT return for the selected VAT period. For prior VAT periods these were the exceptions included is that Vat return.

EC Sales List - The EC Sales List report displays all the invoices made to EU-exempt customers totalled by customer. The report displays customer, country, VAT registration number and net amount.

Customers and Debtors

Aged Debtors Summary* - The Aged Debtors Summary report helps you maintain control of the cash flow into your company by displaying the balance owed to you by each customer arranged by the number of days outstanding at any date you select.

Aged Debtors Detail - The Aged Debtors Detail report provides an in-depth view of the amounts your customers owe to your company at a selected date. Information includes dates, transaction types and numbers, customer names, amounts, aging, due date and balances outstanding.

Customer Transaction History - The Customer Transaction History report displays all transactions with your customers through any date range you select. Information displayed includes transaction types and numbers, dates, invoiced amounts, and paid amounts.

Profitability by Customer Summary* - The Profitability by Customer Summary report helps you focus your marketing efforts by displaying the profit made on sales to each of your customers over a selected time range. Information displayed includes customer names, invoiced amounts, cost as well as margin in Sterling and percent.

Profitability by Customer Detail* - The Profitability by Customer Detail report gives you an in-depth view of the profits made on sales to each of your customers over a selected time. Information displayed includes transaction types and numbers, product and service names and quantity, invoiced amounts, cost as well as margin in Sterling and percent. The report distinguishes between profit margin on invoiced products and services and total profit margin.

Customer Refund* – The Customer Refund report lists all the customer refunds in a specific period along with reference number, payment method and cheque number and whether they have been issued or not.

Sales

Sales by Customer Summary - The Sales by Customer Summary report helps you to adjust your marketing efforts by listing total sales made to your customers over a period of time.

Sales by Customer Detail - The Sales by Customer Detail report provides in-depth information about the total sales made to your customers over a selected time range. Information displayed can include transaction types and numbers, products and services sold, quantity and sales amount.

Sales by Salesperson Summary* - The Sales by Salesperson Summary report helps you track your salespersons' performance by displaying their total sales made to your customers over a selected time range. Information displayed includes sales amounts and comparisons to previous periods.

Sales by Salesperson Detail* - The Sales by Salesperson Detail report provides in-depth information for tracking salesperson performance. Information displayed includes transaction types and numbers, customer names, product and service names, sales amounts and commissions.

Sales by Product Summary - The Sales by Product Summary report helps you to adjust your marketing efforts by tracking which products and services are selling well or selling poorly. Information includes product and service names, product groups, quantity sold, sales amounts, and comparisons to previous periods.

Sales by Product Detail - The Sales by Product Detail report provides an in-depth look at product sales over a period of time. Information displayed includes product and service names and numbers, sales amount, quantity sold and sales prices.

Suppliers and Creditors

Aged Creditors Summary* - The Aged Creditors Summary report helps you to control your cash flow by displaying all of your company's outstanding supplier balances arranged by the number of days outstanding at a determined date.

Aged Creditors Detail - The Aged Creditors Detail displays an in-depth view of the amounts your company owes to its suppliers at a selected date. Additional information includes the date and number of supplier invoices and due dates.

Supplier Transaction History - The Supplier Transaction History report displays all transactions with your suppliers through any date range you select. Information displayed includes transaction types and numbers, dates, amounts and paid amounts.

Supplier Payments* – The Supplier Payments report shows detailed information for all payments that you have issued to suppliers in a selected date range. Default information in this report includes dates, names, payments methods, cheque numbers, error messages, and payment issue status.

Purchases (Office Accounting Professional Only)

Purchases by Supplier Summary* - The Purchases by Supplier Summary report displays purchases from your suppliers in a summarised form over a selected date range. The information displayed includes supplier name and number, supplier group, purchase amounts, and comparisons to prior periods.

Purchases by Supplier Detail* - The Purchases by Supplier Detail report gives you an in-depth view of purchases from your suppliers over any date range you select. Information displayed includes dates, transaction types and numbers; purchase order numbers, payment terms, Product codes, purchase prices, delivery dates and amounts.

Purchases by Product Summary* - The Purchases by Product Summary report displays product and service purchases in a condensed form over any date range you select. The basic information displayed is product and service names and numbers, quantities purchased, and Sterling value purchased.

Purchases by Product Detail* - The Purchases by Product Detail report gives you an in-depth view of purchases over a selected date range. Information displayed includes product and service types and numbers, date, purchase order numbers, payment terms, due dates and quantity purchased.

Stock (Office Accounting Professional and professional Plus)

Price List* - The Price list shows the current price for all your products and services at a selected date. The information includes product and service names, product groups, product descriptions and prices.

Stock Valuation* - The Stock Valuation report lists all transactions affecting each stock product and their impact on the number and value of stock on hand. Information displayed for each product includes the transaction date, customer name, quantities purchased or sold, value of purchases and sales, quantity on hand and balance value.

Stock Status by Product* - The Stock Status by Product report lists products currently in stock by Product Group. The information includes reorder points, quantities on hand, quantities on purchase orders, quantities on sales orders, and the dates of next deliveries to and from the company.

Stock Take Worksheet* - The Stock Take Worksheet is a printable checklist for taking a physical count of your stock. You can use this information to trace theft, track shrinkage, and make adjustments to the financial records to bring them in line with the count.

Product and Service Profitability* - The Product and Service Profitability report helps you to fine tune your marketing efforts by giving you a detailed view of the profit margin from the sales of products and services over a period of time. Information displayed includes product or service description, quantity sold, invoiced sales amounts, cost of sales, and profit margins by amount and percentage.

Jobs and Time (Office Accounting Professional and professional Plus)

Profitability by Job Summary* - The Profitability by Job Summary report allows you to track which of your jobs are profitable and which are not by listing sales amounts and margins in Sterling and percentage format, grouped by customer.

Profitability by Job Detail* - The Profitability by Job Detail report provides an in-depth view of job success by including details of what was sold and what has yet to be invoiced. The default date range is the current month to date.

Job Estimates vs. Actual Summary* - The Job Estimates vs. Actual Summary report helps you to determine how your job invoices compares to your quotes. This report compares job turnover and costs broken out by Sterling and percent.

Job Estimates vs. Actual Detail* - The Job Estimates vs. Actual Detail report displays a detailed listing of all actual job invoices and quotes over a period of time. The report provides more information for use in analysing why job invoicing varied from the quotes. Information detail includes quantities sold, product or service descriptions, incurred costs, sales amounts and estimated job information.

Job Progress Invoices vs. Quotes* - The Job Progress Invoices vs. Quotes report tracks the invoicing of jobs to customers by comparing the amount invoiced in progress invoices against the total amount quoted for customer jobs.

Banking

Deposit Detail* - The Deposit Detail report lists all deposit transactions for your bank accounts over a designated period of time.

Cheque Detail* - The Cheque Detail report lists all cheques and amounts issued from your bank accounts over a designated period of time.

Bank Transactions* - The Bank Transactions report lists all transactions, including deposits and withdrawals, for all of your bank accounts over a designated period of time.

Missing Cheques* - The Missing Cheques list shows all numbered transactions that are missing from the cheque sequence for the current month, arranged by bank account.

Reconciliation Detail - The Reconciliation Detail report shows a given bank reconciliation with cleared deposits and withdrawals as well as un-cleared deposits and withdrawals and totals them to the balance of the statement date.

Payments – The Payments report shows detailed information for all payments that you have issued to customers, suppliers, or employees in a selected date range. Default information in this report includes dates, names, payments methods, cheque numbers, error messages, and payment issue status.

Failed Payments – The Failed Payments report shows detailed information for all payments that you have issued to customers, suppliers, or employees in a selected date range. You can use this report to determine the reason why a payment failed to issue.

Employees and Payroll

Time Report - The Time Report shows how your employees are accounting for their recorded hours. It helps you to determine whether billable job time is properly accounted for and to create invoices to send to your customers. Information displayed includes customer names, job names, services billed, status and billable hours.

Employee Payments* – The Employee Payments report shows detailed information for all payments that you have issued to employees in a selected date range. Default information in this report includes dates, names, payments methods, cheque numbers, error messages, and payment issue status.