<%= title %> as of <%= new Date().toLocaleDateString('en-US', { year: 'numeric', month: 'long', day: 'numeric' }) %>

<% generalReports.forEach(report => { %> <% }) %>
Client Name Unpaid Invoices Partial Payments Total Balance
<%= report.BusinessName %> ₱ <%= report.UnpaidInvoices.toLocaleString('en-US', { minimumFractionDigits: 2, maximumFractionDigits: 2 }) %> <% if (report.PartialPayments < 0) { %> (₱ <%= Math.abs(report.PartialPayments).toLocaleString('en-US', { minimumFractionDigits: 2, maximumFractionDigits: 2 }) %>) <% } else { %> ₱ <%= (report.PartialPayments == null ? 0 : report.PartialPayments).toLocaleString('en-US', { minimumFractionDigits: 2, maximumFractionDigits: 2 }) %> <% } %> ₱ <%= (report.UnpaidInvoices - (report.PartialPayments == null ? 0 : report.PartialPayments)).toLocaleString('en-US', { minimumFractionDigits: 2, maximumFractionDigits: 2 }) %>
Total Collectible ₱ <%= generalReports.reduce((sum, report) => sum + (report.UnpaidInvoices - (report.PartialPayments == null ? 0 : report.PartialPayments)), 0).toLocaleString('en-US', { minimumFractionDigits: 2, maximumFractionDigits: 2 }) %>
<% recoveries.forEach(recovery => { %> <% }) %>
RECOVERIES
Operators Amount
<%= recovery.ClientCode %> ₱ <%= Number(recovery.Recoveries).toLocaleString('en-US', { minimumFractionDigits: 2, maximumFractionDigits: 2 }) %>
<% cashOnHand.forEach(cash => { %> <% }) %>
NET INCOME
Bank Account Amount
<%= cash.ClientCode %> (**** 3822) ₱ <%= Number(cash.CashOnHand).toLocaleString('en-US', { minimumFractionDigits: 2, maximumFractionDigits: 2}) %>

BACK