Monthly Report (Sub-Module)

- What Is the Monthly Report?
 

The Monthly Report is a time-based financial intelligence report that shows how customer financial activity evolves month by month over a rolling 12-month window.
 

Instead of showing transactions or totals, this report answers a deeper question:
 

“How does each customer’s financial situation change over time?”

It transforms raw documents (invoices, receipts, orders) into a clear monthly timeline that reveals trends, risk patterns, and long-term behavior.
 

- Why This Report Exists
 

In growing organizations, financial risk rarely appears in a single month.
It builds gradually.
 

The Monthly Report exists to help teams:
 

• Detect rising customer debt early

• Identify persistent unpaid behavior

• Understand seasonal patterns

• Track open orders that stay unresolved

• Make credit and collection decisions based on trends
   

This is a strategic report, not an operational one.

 

- Mode 1: Debt Tracking
 

data_type = "debt"
 

What It Shows
 

Debt Mode shows how much money a customer owes at the end of each month.

For every customer and every month, the system calculates:
 

Monthly Debt = Invoices − Receipts

This reveals:

• Months where debt increases

• Months where payments catch up

• Long-term debt accumulation patterns
   

How the System Calculates Debt
 

For each customer, for each month:
 

1. Invoices
    

   • invoice → added

   • receipt_tax_invoice → added

   • credit_invoice → subtracted
      

2. Receipts
    

   • receipt → subtracted

   • gi_ir → subtracted
      

3. Monthly Debit
    

   • Total Invoices − Total Receipts
      

If there is no activity in a month, the report still shows that month with 0, ensuring visual continuity.
 

Why This Is Powerful
 

Debt Mode doesn’t just show how much is owed —
it shows when debt starts, grows, or stabilizes.
 

This allows teams to:
 

• Identify risky customers

• Adjust payment terms

• Trigger collection actions early

• Support financial forecasting
   

- Mode 2: Open Orders
 

data_type = "open_orders"
 

What It Shows
 

Open Orders Mode tracks orders that remain unresolved over time.
 

Instead of money owed, it answers:
 

“Which customers keep orders open, and for how long?”

For each month, the report shows:
 

• Number of open orders

• Associated order amounts

• Persistence of open orders across months
   

How Open Orders Are Calculated

For each month:
 

1. Load order documents:
    

   • detail_orders

   • purchase_orders
      

2. Resolve related documents:
    

   • Check linked invoices

   • Check payment status
      

3. Determine “open”:
    

   • Invoice unpaid or missing

   • Order not fully resolved

This ensures only truly open business obligations are counted.
 

- How the Monthly Timeline Works
 

The report always displays exactly 12 months:
 

• Current month

• Previous 11 months
   

This rolling window:
 

• Updates automatically every month

• Preserves historical continuity

• Eliminates manual date selection errors
   

Month names are localized and displayed clearly (Jan → Dec).

 

- Export: Strategy-Ready Data
 

The Monthly Report supports full Excel export, including:
 

• Customer names

• All 12 month columns

• Localized month headers

• Exact calculated values
   

Exports are ideal for:
 

• Board reports

• Financial planning

• Credit policy reviews

• External accounting analysis
   

- Access Control & Security
 

The report respects:
 

• Organization isolation

• Team-based customer visibility

• Admin vs normal member permissions
   

Normal users only see:
 

• Customers they own

• Customers shared with them
   

Admins see all customers.