Payable Cheques Report

Report Overview

The Payable Cheques Report displays all cheques issued by the company and tracks their status from issuance until collection or cancellation. It shows details such as the payee name, bank, receiving account, issue date, due date, and amount.

This report is used to monitor issued cheques, track their status, and identify cheques that are due or delayed for collection.

How to Access the Report

1. Go to the Reports menu.
2. Click on Cheques Reports.
3. Select Payable Cheques Report.

You can apply the following filters before displaying the report:

• Received Account: Select the accounting account where the cheque is recorded.
  If not selected, cheques for all accounts will be included.
• Bank Name: Filter cheques by the bank they are drawn on.
  If not selected, cheques from all banks will be included.
• Issue Date (From – To): Select a date range to filter cheques based on their issue date.
• Due Date (From – To): Select a date range to filter cheques based on their due date.
• Status: Filter cheques based on their current status:
  Issued
  Delivered
  Collected
  Cancelled
  Rejected
• Group By: Choose how to group the report data:
  Cheque Book Number
  Yearly
  Monthly
• Currency: Select the currency for displaying the report:
  All to (SAR)
  Separate
  Or select a specific currency such as SAR

After adjusting the filters, click Show Report to update the results, or click Clear Filters to reset to default settings.

You can switch between:

• Summary View: Displays totals per group only.
• Detailed View: Displays each cheque individually.

You can print the report using Print, or export it via Export to:

• CSV
• Excel
• PDF

Report Columns

• Cheque Number: The serial number of the cheque within the cheque book.
• Name on Cheque: The name written on the cheque.
• Bank Name: The bank on which the cheque is drawn.
• Received Account: The accounting account where the cheque amount is recorded in the system.
• Issue Date: The date the cheque was issued.
• Due Date: The date the cheque is due for collection.
• Status: The current cheque status (Issued, Delivered, Collected, Cancelled, or Rejected).
• Amount: The cheque value in the selected currency.

At the end of each group, a subtotal row summarizes the total cheque amounts within that group. At the bottom of the table, a total tow summarizes all cheque amounts.