This page describes the data model for the Document Insights application integrated with MoneyThumb, used for analyzing bank statement data and displaying financial insights.
🧩 Object Relationship Overview
-
Document Insights is the central object, and all other objects are related to it via Master-Detail or Lookup relationships.
-
The model captures data at multiple levels: overall insight, per-statement, per-transaction, and per-month.
🧾 Object Schema
1. Document Insights
|
Field |
Description |
|---|---|
|
Average Revenue |
Average revenue calculated from all uploaded statements. |
|
Average Balance |
Overall average balance across all accounts. |
|
Total Bank Accounts |
Total number of unique bank accounts identified. |
|
Source Record Link |
Lookup to the parent record (e.g., Loan, Opportunity, etc.). |
|
Dashboard (LWC) |
A Lightning Web Component displays key financial metrics visually. |
Relationships:
Parent: Source Record (e.g., Loan, Application)
Children: Document Insight Item, Statement Summary, Bank Transactions, Fraud Signals, Company, Monthly Negative Days
2. Document Insight Item
|
Field |
Description |
|---|---|
|
NSF Days |
Number of Non-Sufficient Fund days. |
|
Reconcile Status |
Whether the statement was successfully reconciled. |
|
Address Information |
Address information retrieved from the statement. |
Relationship:
Parent: Document Insights (Master-Detail)
3. Statement Summary
|
Field |
Description |
|---|---|
|
Total Credits |
Total credits for the given statement month. |
|
Total Debits |
Total debits for the statement month. |
|
Average Balance |
Monthly average balance. |
|
Statement Month & Year |
Month and year of the bank statement. |
Relationship:
Parent: Document Insights (Lookup)
4. Bank Transactions
|
Field |
Description |
|---|---|
|
Transaction Amount |
Amount of the transaction. |
|
Transaction Date |
Date of the transaction. |
|
Bank Account Info |
Associated account for the transaction. |
Relationship:
Parent: Document Insights (Lookup)
One record per bank transaction from uploaded statements.
5. Fraud Signals
|
Field |
Description |
|---|---|
|
Fraud Score |
Value from 0–1000 indicating likelihood of fraud (higher = more fraud). |
|
Contributing Factors |
List of issues like alignment mismatch, reconciliation errors, etc. |
|
Detected Issues |
Flags for calculation anomalies, inconsistencies, etc. |
Relationship:
Parent: Document Insights (Lookup)
6. Company
|
Field |
Description |
|---|---|
|
Company Type |
MCA or Recovery company. |
|
Period |
Whether the data is monthly or total. |
|
Linked Data |
Associated company financial summary. |
Relationship:
Parent: Document Insights (Lookup)
7. Monthly Negative Days
|
Field |
Description |
|---|---|
|
Statement Month |
Month of the statement being analyzed. |
|
Negative Days Count |
Number of days with negative balance in that month. |
Relationship:
Parent: Document Insights (Lookup)
8. Historical Balance
|
Field |
Description |
|---|---|
|
Cash Flow |
Inflow/Outflow for that day |
|
Balance |
Ending Day Balance for that day |
|
Balance Date |
Date for which we’ve created the Historical Balance record. |
Relationship:
Parent: Document Insights (Lookup)
📊 Visual Overview
