View Daily Payments Report

Report Overview

The Daily Payments Report displays all purchase invoice payments recorded in the system, grouped by day or any selected time period. It shows the details of each payment, including the supplier, staff member, payment method, and payment amount.

This report helps monitor outgoing cash flow, track daily payments made to suppliers, and review how payments are distributed across different payment methods.

Steps to View the Report

1. Click the Reports menu.
2. Click Purchases Reports.
3. From the Suppliers Reports page, select Daily Payments.

Before displaying the report, you can apply several filters:

• Invoiced By:
  Filter results to display payments related to invoices created by a specific staff member.
  If no staff member is selected, the report will display payments related to invoices created by all staff members.

• Currency:
  Select the currency used to display the report.

  • All (to SAR): Displays all payments converted to Saudi Riyal.
  • All (Each Currency Separately): Displays each currency in a separate table.
  • Or select a specific currency such as SAR.

• Payment Method:
  Filter results to display payments made using a specific method:

  • Cash

  • Cheque

  • Bank Transfer

  • Cash on Delivery

  If no method is selected, the report will display all payment methods.

• Supplier:
  Select a specific supplier to display only their payments.
  If no supplier is selected, the report will display payments for all suppliers.

• Date Range:
  Select the time period for which you want to display payments.

  • Last Week: The past seven days.
  • Last Month: The past thirty days.
  • Month to Date: From the beginning of the current month until today.
  • Last Year: The past twelve months.
  • Year to Date: From the beginning of the current year until today.
  • Custom: Click the field and manually select the start and end dates.

After adjusting the filters, click Show Report to update the results.

You can switch between:

• Summary View: Displays the total payments for each period only.
• Details View: Displays the details of each payment individually.

You can also change the grouping method using the dropdown menu above the table. The available grouping options are:

• • Daily
  • Weekly
  • Monthly
  • Yearly
  • Staff
  • Supplier
  • Method

You can print the report by clicking Print, or export it by clicking Export Options to:

• CSV
• PDF
• PDF without chart

Report Columns

The table displays payments grouped by day or by the selected grouping period. When Details View is selected, each payment appears individually within its group. The columns are organized as follows:

• ID: The unique identifier of the payment record in the system.
• Invoice Number: The purchase invoice number associated with this payment, with a direct link to view the full invoice details.
• Supplier: The supplier who received the payment.
• Invoiced By: The code and name of the staff member who created the purchase invoice associated with the payment.
• Method: The payment method used, such as Cash, Cheque, Bank Transfer, or Supplier Credit.
• Reference Number: The external reference number for the payment, such as a cheque number or bank transfer number, if available.
• Total: The payment amount in the selected currency.

At the end of each day (or selected period), a Total Row appears summarizing the total payments for that period.

At the bottom of the table, a Total Row displays the combined total payments across the entire selected period.