View Daily Payments Report

Steps to View the Report

1. Click on the “Reports” menu.
2. Click “Sales Reports.”
3. From the “Sales Reports” page, select “Daily Payments.”
   1. Choose “Summary” to display the total payments for each employee without showing the details of each individual payment.
   2. Choose “Details” to display each payment separately, including the invoice number, customer, and payment method.
4. You can apply several filters before displaying the report:
   • Invoiced By: Select one or more employees to display payments related to the invoices they created. You can search by name, code, email, department, or branch.
     • If no employee is selected, the system will display the report for all creators.
   • Collected By: Select one or more employees to display the payments they collected. You can search by name, code, email, department, or branch.
     • If no employee is selected, the system will display the report for all collectors.
   • Currency: Select the currency in which you want to display the report.
     • All (in Saudi Riyal): All currencies are converted to SAR using the exchange rates shown at the top of the report.
     • All (each currency separately): Each currency is displayed in a separate section without conversion.
     • You can also select a specific currency from the list to display only the payments recorded in that currency.
   • Payment Method: Filter payments by the payment method used, such as:
     • Cash, Check, Bank Transfer, Credit Card, Manual Payment, Tabby, and other added methods.
     • If no specific method is selected, the report will display all payment methods.
   • Clients: Select the client whose payments you want to display. You can search by name, email, or phone number.
     • If no specific client is selected, the report will display all clients.
   • Client Category: Filter payments based on the classification assigned to the client record.
     • If no classification is selected, the report will display all classifications.
   • Date Range: Specify the start and end dates of the report period. You can choose from predefined ranges or select a custom range.
     • Last week, Last month, Current month to date, Last year, Current year to date
     • Or click the date field to manually select a custom period.
   • Order Source: Select the sales channel or platform from which the invoices originated.
     • If no specific source is selected, the report will display all sources.
   • Branch: Select one or more branches to display only their payments.
     • If no branch is selected, the report will display data for all branches.
5. After adjusting the filters, click “Show Report.”
6. The report displays a vertical bar chart showing the total payments issued by each employee during the selected period.
7. You can print the report using “Print”, or export it using “Export Options” to:
   • CSV
   • Excel
   • PDF (With chart)
   • PDF (Without chart)

Note: You can change how the report data is grouped by clicking the Grouping button above the table. Available grouping options are:
Daily, Weekly, Monthly, Yearly, Invoice Creator – Employee, Collected By – Employee, Client, Method.

Report Columns

The report table displays data grouped by day, with the details of each group distributed across the following columns:

• ID: The internal serial number of the payment record in the system.
• Invoice Number: The number of the invoice or document associated with this payment, with a link to view its details. Payments related to returned invoices appear labeled “Return” next to the number and with a red background for distinction.
• Client: The name of the client associated with the invoice that was paid.
• Method: The payment method used for this payment (e.g., Cash, Bank Transfer, Credit Card).
• Reference Number: The external reference number for the payment, if available, such as the check number or bank transfer number.
• Total: The payment amount in the selected currency. Returned invoice values appear as negative amounts because they represent a refund of previously collected payments.

At the bottom of each day, a subtotal row appears showing the total payments related to invoices created on that day. At the bottom of the table, a grand total row appears summarizing the payments for all days across the entire period.