Click on the [Reports] tab on the left hand side menu under Invoice.
Once a report is selected, there are options to select different parameters for the generation of the report. The Report Options listed in the following table are:
C –Customer selection. Choose either All Customers or Select Customers (opens a list of all customers to select from).
D –Date Period. Choose a report date range from Last Month, Last Quarter, Last Year, This Month, This Quarter, This Yearor Custom(select report start and end periods where appropriate).
eD-End Date Only. Report relates to a specific time period and the only option is
to select an end date for the report.
E –Includes reports formatted especially for Microsoft Excel.
F –Filter report. Report will show information based on filters e.g. Detailed or Summary,Include Invoice Manager balances, Single or Multiple Columns etc.
T –Type of printout. Choice of print layout or specific print media.
Types of Reports –Customers/Sales
The following table summarises the reports available in the Invoice Sales (Customer) section. More information is included below for reports highlighted by an asterisk*.
Sales by Product:
This report lists the item, unit price and number of items in the Inventory List sold
to each customer, as well as the total sales.
Note: Items need to be listed in Inventory to be included. However, prices are updated from invoices.
You can choose to print either a Sales Report with Summary or Detailed formats or a
Sales & Profit Report. You can also order by any of the column titles. For example, if you want to know which products give the highest level of sales, order by the ‘Total’ column.
The Sale sand Summary options list the item, the unit price, the number of products sold to each customer, and the total sales. (The Detailed option provides a list of volume sold and total for each customer who has purchased each product.)
The Sales & Profit option provides an indication of the contribution each Inventory Item makes to the profitability of the business. For each item, it advises the number sold, Total, Average Sale Price, Unit Cost (as per the Inventory List), Profit per Unit and Total Profit.
GST: There are four choices for printing the GST report:
1. The Sales GST Report is designed to match the Outputs section of the Tax Office GST Calculation Worksheet. It reports the totals from the GST types used in your invoices and your adjustment notes for the selected period.
Section 1 calculates the total from your Invoices.
Section 2 calculates the total from your Adjustment Notes. These would be a decreasing adjustment. The amount at G6 in section 2 can be either transferred to
box G18 on the GST worksheet (after taking into account any other adjustments
outside of this system) or can be used to negatively adjust boxes G1 to G4.
Section 3 provides adjusted totals that can be used for adjusting boxes G1 to G4.
The Detailed option includes the GST components for customers and invoices.
2.The Sales GST (Closing Balances) Report provides the same information as the Sales GST Report but only includes closing balances at the selected date. This will provide you with the closing balance information to combine with your Cashflow Manager GST Report if you are lodging your BAS on the ‘accruals’ method.
3.The Sales and Purchases GST Report (GOLD) provides the GST Calculation Worksheet information for both sales and purchases.
4.The Sales and Purchases GST (Closing Balances) Report (GOLD) provides the GST Calculation Worksheet information for both sales and purchases but only includes
closing balances at the selected date.