Accounts Payable Summary Report - Smarter Sales & Inventory Management | Zayls

by Zayls
3 years ago
0 Views
Knowledge Base Reports | Accounts Payable Summary Report

Accounts Payable Summary Report

Accounts Payable Summary Report contains an aggregate amount of all unpaid bills and overdue amount to your suppliers. This report helps you keep track of the company’s outstanding balance as well as the overdue amount/s that should be immediately settled to the supplier/s.   

 

Accounts Payable Summary Report Overview

 

Report Filters

  • As of – This filter will show the suppliers and their overdue amounts from the date selected.
  • Supplier Group — This filter will show the overdue amounts of the supplier/s belonging to the supplier group selected.
  • Supplier – This filter will show the overdue amounts of the supplier/s selected.

By default, the report shows the accounts payable as of the current date. 

The Supplier filter is multi-select, which means that you can have as many suppliers as possible to get your desired results.  

Accounts Payable Summary Report Columns

  • Supplier Group — This column shows the supplier group where the supplier belongs.
  • Supplier — This column shows the suppliers involved in the transactions
  • # of Transactions — This column shows the number of unpaid Purchase Orders or Purchase Returns transacted with the supplier.
  • Invoice Balance — This column shows the total unpaid invoice balance.
  • Returned Balance — This column shows the total balance that the supplier must return based on Purchase Returns.
  • Total Balance — This column shows the total balance that the company owes the supplier. A value enclosed in parenthesis i.e. (150.00) means that the supplier owes the company based on Purchase Returns.

Total Balance = Invoice Balance – Returned Balance

  • Overdue – This column shows the overdue amount the company owes the supplier.

Export Accounts Payable Summary Report to PDF or Excel

  1. In the Accounts Payable Summary Report, click Export. 
  2. There are two Export options: Export to PDF and Export to Excel. Click your desired format. 
  3. Upon clicking your desired formatthe file will be automatically downloaded to your computer. 
  4. You may also view the Export History of the report.

Related Article: Accounts Payable Aging