## Documentation Index

Access the complete documentation index at:
https://www.zoho.com/books/kb/llms.txt

Use this file to discover all available documentation pages before proceeding.

[Back](./)

# Why does the closing balance in the Vendor Balances Summary report not match with the accounts payable in the Balance Sheet report?

The accounts payable in the Balance Sheet report displays the total outstanding payables for the selected period. However, if you’ve recorded any advance payments, those transactions will be listed under prepaid expenses. To calculate the closing balance for the selected period, subtract the accounts payable from the prepaid expenses.

The closing balance in the Vendor Balances Summary report includes the outstanding payables for your vendors and the excess payments made.

If you want to view the accounts payable in the Vendor Balance Summary report, you can add the Payable Amount column to the report. Here’s how:

*   Go to the _Reports_ module on the left sidebar.
    
*   Select **Payables** under _Report Category._ Choose **Vendor Balance Summary** report.
    
*   On this page, click **Customize Report Columns.**
    
    ![Click Customize Report](/books/kb/images/reports/payables/vbs-report.png)
*   On the _Customise Report_ page, go to the **Available Columns** section. Hover over _Payable Amount_ and click the **+** button next to it.
    
*   If you have created transactions in different currencies, hover over _Payable Amount (FCY)_ and click the **+** button next to it.
    
    ![Click + next to Payable Amount](/books/kb/images/reports/payables/vbs-customize-report.png)
*   The Payable Amount field will be added to the _Selected Columns_.
    
*   Click **Run Report**.
    

The Payable Amount field will be added as a column to the Vendor Balance Summary report.

![Payable Amount Column in report](/books/kb/images/reports/payables/vbs-payable-amount.png)

* * *