Customer Debt Summary

Collections teams need a quick view of who owes what without opening each partner ledger. This module adds a wizard that builds one line per customer or vendor with the last invoice, last payment and closing balance. It reads the accounting entries of Odoo Accounting and can be filtered by date, partner tags, partners and minimum balances. The result can be previewed, printed as a portrait or landscape PDF or exported to Excel. It saves accountants the manual work of compiling debt lists.

1. 1

   Open the wizard

   From the OSLOOP Customer Debt Summary menu open the wizard form. It shows the date range, the partner types and the report language. Nothing is created until you press Preview.

   • Set From and To dates
   • Choose report language and font scale
2. 2

   Choose partner types

   Tick Customers, Vendors or both, and pick the journal types (bank, cash, miscellaneous) that count as payments. The wizard uses them to find the last payment of each partner.

   • Include Customers / Vendors
   • Journal types Bank, Cash, Miscellaneous
3. 3

   Filter by tags and balances

   Narrow the list by partner tags, by specific partners and by minimum positive or negative balance. This hides small balances so the list stays actionable.

   • Partner tags and partners
   • Minimum positive / negative balance
4. 4

   Preview the lines

   Press Preview to generate the lines. Each line shows sequence, partner name, phone, partner type, last invoice, last payment and closing balance in the company currency.

   • Sorted list of partners
   • Closing balance column
5. 5

   Print the PDF

   Use Print PDF (Portrait) or Print PDF (Landscape) to produce the report with the configured paper format. The layout follows the chosen language and font scale.

   • Two paper formats
   • Language and font scale applied
6. 6

   Export to Excel

   Press Export Excel to download the same lines as a spreadsheet for analysis or sharing. The export uses the filters currently set on the wizard.

   • Spreadsheet download
   • Same filters as the preview

Back to version applications