To analyse sales and customer information using Business Insights

To find information specific to your needs, sort the table columns by clicking a column heading. For example, you can sort the list of outstanding invoices to find the most overdue invoice or the largest overdue amount.

See Business Insights—Overview for more information.

To analyse customers

1. Anchor
   1346830 1346830

   Click Business Insights in any command centre. The Business Insights window appears.
2. Click the Customer Analysis tab. This tab shows you:
   • the total you are owed and details of each overdue customer payment (based on their invoiced credit terms), including the number of days overdue
   • your top ten customers by year-to-date sales value
   • the amounts owing for each ageing period
   • a summary of your customer sales and payment history.
   You can use this information to:
   • Contact customers for overdue payments Identify which customer payments are the most overdue or which customers owe you the most money.
   • Renegotiate a customer’s credit terms View the customer’s outstanding balances and payment history, such as the average number of days it takes for them to pay you.
3. If you want to use one of the graphs or tables in another document, right-click it and choose:
   • Copy to Clipboard. This copies the graph or table to the clipboard, ready to paste into a document.
   • [Graphs only] Save As. Choose where you want to save the image and click Save. This saves the graph as an image file, so you can use it later.
4. If you want to customise the look of Business Insights, click Customise. The Customise window appears, enabling you to show or hide information in Business Insights.

To view a list of all unpaid sales sorted by days overdue 

1. Anchor
   1346889 1346889

   Click To Do List in any command centre. The To Do List window appears.

2. Click the Accounts Receivable tab. A list of all unpaid sales appears.
   The Overdue column shows the number of days an invoice is overdue. (A negative number in the Overdue column indicates that the payment is not yet due.) The number of days an invoice is overdue is calculated by checking the original date of the invoice, comparing it to today’s date and looking at the customer’s credit terms.
3. If you want to send a collection letter to customers with overdue payments:
   1. Select those customers by clicking in the select column (   ).
   2. Click Mail Merge to create the letter directly in Microsoft Word. Otherwise, click Disk to save a mail merge file that you can use in another word processor.

To view sales reports 

1. Go to the Reports menu and choose Index to Reports. The Index to Reports window appears.
2. Click the Sales tab. A list of available sales report groups appears.
3. Click a group category to view the available reports.

For information on displaying, customising and printing your reports, see Reports.

To view sales history 

1. Display the Item Information window for an item or the Card Information window for a customer or an employee.

2. Click the History tab. The History tab displays seven years of sales history for the item or card: the five years preceding the current financial year (as displayed in the Company Information window), the current financial year and the next year.

   UI Text Box
   type note
   Employee sales history (Not Basics) To record employee sales history, you need to select the employee as the salesperson when you record a sale in the Sales window.