Naviga-COA Calculation
Type: AR and GL
Cash On Account (COA) grouped by Client
Naviga-COA Calculation Downloads
Cash On Account (COA) grouped by Client
Bundle (TGZ): Naviga-COA Calculation
Definition JSON: naviga-coa-calculation.json
Description
Dataset that can be joined to other dataset to pull in COA information for Advertisers. Based on AR Cash mapping. See this documentation for a clear understanding of how each field is calculated. COA is tricky and this dataset is not guaranteed to be correct 100% of the time. https://naviga-informer-docs.netlify.app/docs/informer/informer-sample-reports#coa-report
Fields
| Label | Alias | Type | Hidden | Description |
|---|---|---|---|---|
| Client Id | clientId | keyword_text | ||
| True Coa Total | trueCOA_Total | double | Final Aggregated value for a customer: Genuinely uncommitted cash available for use. This represents customer funds that are not tied to any specific orders or commitments. If the calculation results in a negative value, return zero. This can occur when prepayment commitments have been partially refunded, leaving the committed amount higher than the actual available balance. ----- True COA = Whole COA - Prepayment Amount IF result < 0, THEN True COA = 0 | |
| Whole Coa Total | wholeCOA_Total | double | Total payment balances that have not yet been applied to invoices. This represents all cash received from customers that remains unallocated. --- AR Cash --- SUM of all CHECK_BAL <4> values WHERE CHECK_BAL > 0 | |
| Pre Pay Total | PrePay_Total | double | Total Pre Pay amount calculated on each line and then aggregated to the client ----- Prepayment Amount = Total matched PP Amount - Total matched PP Applied Amount | |
| Whole Coa | wholeCOA | double | ✓ | Detail Whole COA see Whole COA Total for details. |
| Payments Total | Payments_Total | double | Total of this client's payments |