Weekly Payments Report
Overview
The Weekly Payments Report displays all purchase invoice payments recorded in the system, grouped by week or any selected time period. It provides detailed information for each payment, including the supplier, employee, payment method, and amount.
This report is useful for tracking outgoing cash flow, monitoring weekly supplier payments, and verifying how payments are distributed across different payment methods.
Steps to View the Report
- Click on the Reports menu.
- Select Purchase Reports.
- From the Suppliers Reports page, choose Weekly Payments.
Before displaying the report, you can apply several filters:
-
Invoice by: Filter results to show only payments linked to invoices created by a specific employee.
-
If no employee is selected, the system will display payments for all employees.
-
-
Currency: Select the currency in which you want to view the report.
-
All (Converted 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 payments based on a specific payment method.
-
Cash, Check, Bank Transfer, Cash on Delivery.
-
If no method is selected, all payment methods will be displayed.
-
-
Supplier: Select a specific supplier to display only their payments.
-
If no supplier is selected, payments for all suppliers will be displayed.
-
-
Date Range (From / To): Specify the time period for the report.
-
Last Week: The past 7 days
-
Last Month: The past 30 days
-
Month to Date: From the beginning of the current month until today
-
Last Year: The past 12 months
-
Year to Date: From the beginning of the current year until today
-
Custom: Manually select the start and end dates
-
After setting the filters, click View Report to update the results.
You can switch between:
-
Summary View: Shows total payments for each period only
-
Detailed View: Displays each payment individually
You can also change the grouping method from the dropdown above the table. Available grouping options include:
Daily, Weekly, Monthly, Yearly, Employee, Supplier, Method
To print or export the report:
-
Click Print
-
Or use Export Options to download as:
-
CSV
-
PDF
-
PDF (without chart)
-
Report Columns
The table displays payments grouped under each week or selected time period. When using the detailed view, each payment appears individually within each day. The columns are organized as follows:
-
ID: The unique identifier of the payment record in the system.
-
Invoice Number: The purchase invoice number linked to the payment, with a direct link to view full invoice details.
-
Supplier: The name of the supplier who received the payment.
-
Invoice Creator: The code and name of the employee who created the purchase invoice.
-
Method: The payment method used (e.g., cash, check, bank transfer, or supplier balance).
-
Reference ID: The external reference number of the payment, such as a check number or bank transfer number (if available).
-
Total: The payment amount in the selected currency.
At the end of each day, a total row appears summarizing the payments for that week. At the bottom of the table, a grand total row displays the overall payments across the entire selected period.