## Documentation Index Access the complete documentation index at: https://www.zoho.com/en-fr/books/kb/llms.txt Use this file to discover all available documentation pages before proceeding. [Back](./) # How do I view the customer-wise breakdown of the total unearned revenue in Zoho Books? ![](/books/images/ue-resources/llm-utility-menu/sparkle-ai.svg) Explore With AI ![](/books/images/ue-resources/llm-utility-menu/dd-arrow.svg) * [Open in ChatGPT (opens in new tab)](https://chatgpt.com/?prompt=Analyze+the+content+of+https%3A%2F%2Fwww.zoho.com%2Fen-fr%2Fbooks%2Fkb%2Freports%2Fview-customer-wise-breakdown-of-total-unearned-revenue.html+and+understand+it+thoroughly+so+I+can+ask+questions+about+it.) * [Open in Claude (opens in new tab)](https://claude.ai/new?q=Analyze+the+content+of+https%3A%2F%2Fwww.zoho.com%2Fen-fr%2Fbooks%2Fkb%2Freports%2Fview-customer-wise-breakdown-of-total-unearned-revenue.html+and+understand+it+thoroughly+so+I+can+ask+questions+about+it.) * ![Copy for LLM](/books/images/ue-resources/llm-utility-menu/copy.svg) Copy for LLM * [![View as Markdown](/books/images/ue-resources/llm-utility-menu/md.svg) View as Markdown (opens in new tab)](/en-fr/books/kb/reports/view-customer-wise-breakdown-of-total-unearned-revenue.md) You can view the customer-wise breakdown of the total unearned revenue by adding the Unused Advance Payment column to the Customer Balance Summary report. Here’s how: * Go to the **Reports** module on the left sidebar. * Select the **Customer Balances Summary** report under _Receivables_. * On the _Customer Balances Summary_ page, click **Customize Report** on the top. ![Customize Report](/books/kb/images/reports/receivables/cbs-report.png) * On the _Customize Report_ page, go to the **Show or Hide Columns** tab. * In the _Available Columns_ sections, hover over _Unused Advance Payment_ and click the **+** button next to it. * If you have created transactions in different currencies, hover over _Unused Advance Payment (FCY)_ and click the **+** button next to it. ![Click + next to Unused Advance Payment](/books/kb/images/reports/receivables/cbs-customize-report-uap.png) * Unused Advance Payment will be added to the _Selected Columns_ section. * Click **Run Report**. You can now view the customer-wise total unearned revenue of your organization from the unused advance payment columns of the Customer Balance Summary report. ![Unused Advance Payment column](/books/kb/images/reports/receivables/cbs-uap.png) * * *