Sales Report – Invoice Type & Payment Status

Enabling the Report

This is a custom report and must first be enabled from the “App Manager” before it can be accessed:

1. From the main menu click on “Settings“.
2. Click “App Manager“.
3. Click on “Manage External Apps“.
4. Search for the report and install it.

Steps to View the Report

1. From the main menu click “Reports“.
2. Click on “Sales Reports“.
3. From the “Sales Reports” page, select “Sales Report – Invoice Type & Payment Status.”
4. Before displaying the report, you can apply several filters:
   • From Date / To Date: Select the time period for which you want to display sales by manually entering the start and end dates in the designated field.
   • Invoice Number: Enter a specific invoice number to filter the results and display its data only.
   • Client: Select one or more clients to display only their invoices. You can search by name, email, or phone number.
     • If no client is selected, the system will display the report for all clients.
   • Payment Status: Filter the results based on the invoice payment status. Available options are: Unpaid, Partially Paid, Paid.
     • If no status is selected, the system will display the report for all statuses.
   • Staff Name: Select one or more employees to display only the invoices associated with them.
     • If no employee is selected, the system will display the report for all employees.
   • Salesperson: Select one or more salespersons to filter results based on the salesperson assigned to the invoice.
     • If no salesperson is selected, the system will display the report for all salespersons.
   • Invoice Type: Filter results based on the document type. Available options include: Invoice, Refund, Credit Note.
     • If no invoice type is selected, the system will include all invoice types in the report.
   • Branch: Select one or more branches to display their sales only.
     • If no branch is selected, the system will include all branches in the report.
   • Group by: Choose how the report data should be grouped. Available options include: Yearly, Monthly, Weekly, Daily, Client, or Branch.
   • Sort by: Select how the results should be ordered. Available options include: Date Descending, Date Ascending.
5. After adjusting the filters, click “View Report” to update the results, or click “Clear Filters” to return to the default settings.
6. You can switch between “Summary” view to display totals for each period only, or “Details” view to display each invoice separately.
7. You can print the report using “Print” or export it from “Export” to:
   • CSV
   • Excel
   • PDF

Report Columns

The table displays invoice data grouped according to the selected grouping method (yearly, monthly, weekly, daily, client, or branch). A header appears at the beginning of each group indicating the relevant period or category. When details view is selected, each invoice appears separately. The columns are organized as follows:

• Date: The date the invoice was issued.
• Invoice Number: The invoice number in the system, with a direct link to view its details.
• Client: The name of the client associated with the invoice.
• Invoice Type: The type of document, for example: Invoice, or Refund Invoice.
• Status: The payment status of the invoice, such as: Paid, Unpaid, or Refund.
• Payment Date: The date the invoice payment was collected. This field appears blank for unpaid or refunded invoices.
• Branch: The branch from which the invoice was issued.
• Total: The total value of the invoice. Negative values appear in a highlighted color for refunded invoices.
• Refund: The refunded amount associated with this invoice.
• Paid: The amount that has actually been collected. Negative values appear in a highlighted color for paid refund invoices.
• Unpaid: The remaining uncollected amount. Negative values appear in a highlighted color for negative balances.

At the bottom of each group, a subtotal row appears summarizing the total invoice values, refunds, paid amounts, and unpaid amounts for that period. At the bottom of the table, a grand total row aggregates the data for all periods within the selected date range.