Reports

Accounts Payable Reports

The Accounts Payable Reports Module generates the different Reports such as

• Accounts Payable
• Accounts Payable Voucher Report
• Accounts Payable by Currency Report
• Purchase Request Detail Report
• Purchase Order Summary and Detail Reports
• Receiving Receipt Summary and Detail Reports
• Disbursement Summary and Detail Reports
• Debit Memo Detail and Summary Report
• Top Purchased Item Report
• Top Supplier Report
• Cancelled Reports
  • Cancelled Purchase Request
  • Cancelled Purchase Order
  • Cancelled Receiving Receipt
  • Cancelled Disbursement Report

Accounts Payable Report

Accounts Payable Report is an aging report wherein the total amount per receiving receipt transaction will be reflected. It reflects outstanding balances that a company must pay within specified terms such as 30 days, 60 days, 90 days, and over 120 days.

Accounts Payable Report is recorded as liabilities on the Balance Sheet. These liabilities are usually settled through the disbursement of money or debit memos (adjustments) to the suppliers according to the agreed terms.

What is this Report for?
Accounts Payable Report is a report where the users, Accounts Payable incharge or the management  can check the total Receiving Receipts that are not yet paid. The report has the following columns:

• Branch – this is the indicator where the RR Transaction was made
• Supplier Name – Name of the Supplier where you purchase your goods or services
• RR Number – refers to the transaction number
• RR Date – date of transaction was made
• Document Reference – document reference or manual reference or delivery receipt reference
• Due Date – Date when the payments should be made
• Balance – Running Balance or Outstanding Balance
• Current – All Balances that are not yet due for payment
• 1-30 Days – All Balances that are overdue for 1 day to 30 days
• 31-60 Days – All Balances that are overdue for 31 day to 60 days
• 61-90 Days – All Balances that are overdue for 61 day to 90 days
• 91-120 Days – All Balances that are overdue for 91 day to 120 days
• Over 120 Days- All Balances that are overdue for over 120 Days

To open or generate Accounts Payable Report here are the steps to follow:
1. Go to Purchases
2. Select Accounts Payable
3. Click Accounts Payable Report
4. Enter Date as of
5. Select Branch you want to generate
6. You can have the option to Print or Download the PDF Report

Accounts Payable Voucher Report

Accounts Payable Voucher Report is a report wherein you can generate the Total Accounts Payable that are DUE on the specified dates.

What is this Report for?
Accounts Payable Voucher Report is a report where the users, Accounts Payable in charge or the management  can check the total Payable that is not yet paid or due for payment on the specified dates. The report has the following columns:

• Branch – this is the indicator where the RR Transaction was made
• Supplier Name – Name of the Supplier where you purchase your goods or services
• RR Number – refers to the transaction number
• RR Date – date of transaction was made
• Document Reference – document reference or manual reference or delivery receipt reference
• Due Date – Date when the payments should be made
• Amount Due – Total Amount of the transaction
• Paid – total amount that has been paid
• Adjusted – total amount that has been adjusted (example of these amount are the Supplier Return Amount that was created in the Debit Memo)
• Balance – Running Balance or Outstanding Balance (Amount Due – Paid – Adjusted)

To open or generate Accounts Payable Report here are the steps to follow:
1. Go to Purchases
2. Select Accounts Payable
3. Click Accounts Payable Voucher Report
4. Enter Date Start and Date End
5. Select Branch you want to generate
6. You can have the option to Print or Download the PDF Report

Accounts Payable By Currency Report

Accounts Payable By Currency Report is a report same with Accounts Payable but there is an indicator as to which Currency you are using during the transaction.

What is this Report for?
Accounts Payable By Currency Report is a report where the users, Accounts Payable incharge or the management  can check the total Receiving Receipts that are not yet paid on a per currency. The report has the following columns:

• Currency – currency used during the transaction
• Branch – this is the indicator where the RR Transaction was made
• Supplier Name – Name of the Supplier where you purchase your goods or services
• RR Number – refers to the transaction number
• RR Date – date of transaction was made
• Document Reference – document reference or manual reference or delivery receipt reference
• Due Date – Date when the payments should be made
• Balance – Running Balance or Outstanding Balance
• Current – All Balances that are not yet due for payment
• 1-30 Days – All Balances that are overdue for 1 day to 30 days
• 31-60 Days – All Balances that are overdue for 31 day to 60 days
• 61-90 Days – All Balances that are overdue for 61 day to 90 days
• 91-120 Days – All Balances that are overdue for 91 day to 120 days
• Over 120 Days- All Balances that are overdue for over 120 Days

To open or generate Accounts Payable by Currency Report here are the steps to follow:
1. Go to Purchases
2. Select Accounts Payable
3. Click Accounts Payable by Currency Report
4. Enter Date as of
5. Select Branch you want to generate
6. You can have the option to Print or Download the PDF Report

Purchase Request Summary Report

Purchase Request Summary Report is a Report wherein you can generate the Summary of All Purchase Request within the specified dates. It will only show the Summary of the Transactions.

To open or generate Purchase Request Summary Report here are the steps to follow:
1. Go to Purchases
2. Select Accounts Payable
3. Click Accounts Purchase Request Summary Report
4. Enter Start Date and End Date
5. Select Branch you want to generate
6. You need to click the Functions to download the data

Purchase Request Detail Report

Purchase Request Detail Report is a Report wherein you can generate the All Purchase Request within the specified dates. It will show the details of each Transactions.
To open or generate Purchase Request Detail Report here are the steps to follow:
1. Go to Purchases
2. Select Accounts Payable
3. Click Accounts Purchase Request Detail Report
4. Enter Start Date and End Date
5. Select Branch you want to generate
6. You need to click the Functions to download the data

Purchase Order Summary Report

 Purchase Order Summary Report is a Report wherein you can generate the summary of All Purchase Order within the specified dates.

To open or generate Purchase Order Summary Report here are the steps to follow:
1. Go to Purchases
2. Select Accounts Payable
3. Click Accounts Purchase Order Summary Report
4. Enter Start Date and End Date
5. Select Branch you want to generate
6. You need to click the Functions to download the data.

Purchase Order Detail Report

Purchase Order Detail Report is a Report wherein you can generate All Purchase Order within the specified dates. It will show the details of each Transactions.
To open or generate Purchase Order Detail Report here are the steps to follow:
1. Go to Purchases
2. Select Accounts Payable
3. Click Accounts Purchase Order Detail Report
4. Enter Start Date and End Date
5. Select Branch you want to generate
6. You need to click the Functions to download the data.

Purchase Order Detail With Balance Report

Purchase Order Detail with Balance Report is a report where you can generate all purchase orders with balance within the specified dates.

To generate Purchase Order Detail with Balance Reports here are the steps to follow:

1. Go to Purchases
2. Select Accounts Payable
3. Click Purchase Order Detail with balance Report
4. Enter Start and End Date
5. Select the Branch
6. You need to click Functions to download the data

1. Then Select download data to generate the excel file

7. Here is the excel file that was extracted from system