- Obligo Report
 

Customer Obligation & Debt Visibility Module
 

- Conceptual Overview (What the Obligo Report Is)
 

The Obligo Report is a financial responsibility and exposure reporting module designed to give organizations a clear, aggregated view of how much money customers owe at any given time.
 

Rather than focusing on individual invoices or payments, the Obligo Report answers a higher-level business question:
 

“What is each customer’s total financial obligation to us?”

It consolidates data from documents, payments, and customer records into a single, customer-centric financial view.
 

- Why the Obligo Report Exists
 

In real-world business operations, financial risk is not measured per invoice — it is measured per customer.
 

The Obligo Report exists to:
 

• Monitor customer debt exposure

• Support credit control decisions

• Identify high-risk or overdue customers

• Enable management-level financial oversight

• Provide a foundation for collections, follow-ups, and policy enforcement
   

This report is especially critical for:
 

• Finance teams

• Account managers

• Business owners

• Credit control departments
   

- Understanding “Obligo” in the System
 

The term Obligo represents financial commitment, not just unpaid invoices.
 

It combines:
 

• Open invoices

• Outstanding balances

• Customer-level obligation limits

• Historical document data
   

This is why the Obligo Report reads from both:
 

• documents (actual financial transactions)

• contactus (customer obligation metadata)
   

- Data Sources & Their Roles
 

- Documents Table
 

Provides:
 

• Invoice totals

• Credit documents

• Financial movement history
   

- Contactus Table
 

Provides:
 

• Official obligo amount

• Payment terms

• Shared ownership (team visibility)

• Customer identity
   

Together, these create a reliable, reconciled view of customer debt.
 

- Filtering Philosophy (Why So Many Filters Exist)
 

The Obligo Report supports extensive filtering because financial questions vary by role.
 

Examples:
 

• Management: “Who owes us the most?”

• Sales: “Which of my customers are overdue?”

• Finance: “What is our exposure per company or team member?”
   

Filters allow slicing the same data from multiple strategic angles.
 

- Company-Level Filtering
 

Supports organizations that:
 

• Operate under multiple companies

• Use different invoice settings

• Need legal separation of obligations
   

This ensures:
 

• Accurate reporting

• Legal clarity

• Correct financial responsibility
   

- Team Member Visibility & Control
 

The Obligo Report respects internal ownership.
 

How this works:
 

• Normal users see only customers assigned to them

• Shared customers are visible via shared_with

• Admins and member-admins see everything
   

This prevents:
 

• Data leakage

• Unauthorized financial insight

• Cross-team confusion
  
   

⚙️ Smart Processing Logic (Behind the Scenes)
 

The module dynamically decides:
 

• Whether to filter in SQL (for performance)

• Or filter in PHP (for flexibility)
   

This hybrid approach ensures:
 

• Speed for large datasets

• Accuracy for complex filters

• Scalability as data grows
   

- Export & Reporting Use
 

The Obligo Report supports full export, making it suitable for:
 

• Management presentations

• External accounting

• Audits

• Legal follow-ups
   

Exports always respect:
 

• Active filters

• Visible columns

• User permissions
   

- Integration with the Rest of the System
 

The Obligo Report is deeply connected to:
 

• Customer profiles

• Document history

• Payment tracking

• Team management

• Invoice creation
   

It acts as a financial hub, not an isolated report.
 

- Security & Data Isolation
 

Because obligo data represents financial risk, strict controls apply:
 

• Organization-level isolation

• Role-based access

• Shared-customer logic

• SQL injection protection
   

This ensures financial confidentiality at all times.