Executive Summary

 

Function

Use the Executive Summary for a “snapshot” look at your company’s key financial details. Accounts receivable, accounts payable, open orders, purchase orders, sales totals, and gross profit displays. The summary provides a calendar view with totals by week (cross totals), totals for the same day in each week (down totals), and a monthly total in the bottom right corner. There is also a Chart Tab that presents the data graphically. The Executive Summary data is refreshed by selecting and running the Executive Summary Update task.

 

NOTE: When the Generate Executive Summary task is run in a multi-firm environment, new executive summary data is created for all companies.

 

=> To access this task...

Select Executive Summary from the AddonSoftware Administration menu.

 

Sample Executive Summary

 

About the Fields

Depending on which modules your system is running, this display can show aged accounts receivable and accounts payable, future sales orders and purchase orders, historical sales volume and profit percentages, the value of inventory on hand, committed, available, and the work in process. It also displays the last date that executive summary data was generated.

 

Based on a standard aging format, the current and immediate past or future two months of summary information is displayed on the initial screen. The information is divided into four sections. Use the up/down arrow keys to move to different sections. Press Return when you are ready to access the option menu.

 

Date Selection

The date selector defaults to the current month and year. Use the navigation buttons to select Previous Year, Previous Month, Next Month, and Next Year. The current month can be selected using the calendar button.

 

Accounts Receivable

The balances of open accounts receivable invoices are aged by invoice due date into the correct month/day. Totals for each month are shown.

 

Accounts Payable

The balances of open accounts payable invoices are aged by invoice due date into the correct month/day. Totals for each month are shown.

 

Open Orders

Open sales orders line items are aged using the line item ship date (if one exists). If no line item ship date has been entered, then the ship date from the order header is used. If no ship date has been entered on the order header then the order date is used. Line item extensions are then accumulated by the month/day. Totals for each month are shown. Order header fields are not included in the aging amounts. These fields include tax amounts, freight, and discount.

 

Purchase Orders

Open purchase order line items are aged using the line item required date (if one exists). If no line item required date has been entered, then the order date from the purchase order header is used. Line item extensions are then accumulated by the month/day. Totals for each month are shown.

 

Sales Totals

Invoice history total sale amounts, including tax, freight and discount, are aged by invoice date into the correct month/day. Totals for each month are shown. The sales totals are based on the number of invoices available at the time the Executive Summary was generated.

 

Gross Profit

Invoice history total cost amounts are aged by invoice date into the correct month/day. The percentage is calculated by dividing the profit (total sales minus total cost) by the total sales amount. The total percentages for each month are shown. The percentages are based on the number of invoices available at the time the Executive Summary is generated.

 



______________________________________________________________________________________

Copyright BASIS International Ltd. AddonSoftware® and Barista® Application Framework are registered trademarks.