# Final Financial Report Generated: 2026-05-30T13:49:36 ## 1. Executive summary This report is generated from local files plus the local Plaid-backed SQLite database. No source documents were uploaded to any third party by this pipeline. Material values are derived from source tables or explicitly marked Unknown/Needs Review. - Source inventory rows: 26 - Normalized transactions: 5,132 - Transaction date range: 2024-12-09 to 2026-05-29 - Documents indexed: 51 - Loans/liabilities indexed: 5 - Tax-return rows indexed: 13 - Investment rows indexed: 10 - Review queue items: 874 - High-priority review items: 605 ## 2. Data sources reviewed | source_id | file_name | detected_document_type | institution_or_sender | extraction_status | |:-------------------------------------|:---------------------------------------------------------------------------------------|:-------------------------|:------------------------|:--------------------| | src_a41552f0a5d3fbd0 | tax-debt-seed.json | tax_return | Unknown | extracted | | src_70d9d24211acd003 | drive-tax-returns.json | tax_return | Unknown | extracted | | src_448f7c3d3e4cd204 | manifest.json | k1_1099_w2 | American Express | extracted | | src_4319dacf9159b108 | 2025-09-09.pdf | statement | American Express | extracted | | src_c82c4e383ef6ddbe | 2025-05-09.pdf | statement | American Express | extracted | | src_4adb8824fa638b8f | 2025-12-10.pdf | statement | American Express | extracted | | src_3d80b6e16932cc1e | 2025-02-07.pdf | statement | American Express | extracted | | src_ccf25d47543f6db2 | 2025-10-10.pdf | statement | American Express | extracted | | src_003c12e79a578e9e | 2026-04-09.pdf | statement | American Express | extracted | | src_8dd30cbffa2eed2b | 2025-11-09.pdf | statement | American Express | extracted | | src_4cf90e8c9efe0c8c | 2025-08-10.pdf | statement | American Express | extracted | | src_0be32fed2262406b | 2026-03-10.pdf | statement | American Express | extracted | | src_9cde0dab2cbae8e6 | 2025-01-10.pdf | statement | American Express | extracted | | src_91103bdda5777bb7 | 2025-04-09.pdf | statement | American Express | extracted | | src_8e3f15823508996e | 2025-03-10.pdf | statement | American Express | extracted | | src_89042ae33c01dbb3 | 2026-01-09.pdf | statement | American Express | extracted | | src_fb8b2d6e663b73e8 | 2025-06-09.pdf | statement | American Express | extracted | | src_90d94415f8cd3be1 | 2025-07-10.pdf | statement | American Express | extracted | | src_eb99ccababd76f17 | 2026-02-06.pdf | statement | American Express | extracted | | src_8746dad344c8969f | 2025-taxdocuments-6880-.pdf | k1_1099_w2 | Chase | extracted | | src_766991c30e29a534 | Heartland 2025 K-1 Package - 2025_George Bolotin_3181_K1_Partnership_1775177490157.pdf | tax_return | IRS | extracted | | src_223a36e92ad89eb4 | 2025-taxdocuments-6292-.pdf | k1_1099_w2 | Chase | extracted | | src_e630d0b041b44066 | 2025-taxdocuments-9853-.pdf | k1_1099_w2 | Chase | extracted | | plaid_sqlite_db | dev.db | plaid_sqlite_database | Unknown | ready | | plaid_item_cmo68m79g0000g1hul4es5e1a | Plaid item cmo68m79g0000g1hul4es5e1a | plaid_item | Chase | ready | | plaid_item_cmo6nqub6000y13skux2efu8a | Plaid item cmo6nqub6000y13skux2efu8a | plaid_item | American Express | ready | ## 3. Missing or unavailable data Expected folders that do not exist and month-level coverage gaps are logged in the review queue. Placeholder charts were created only where source evidence is not yet available, such as historical balance snapshots or brokerage holdings. | source_id | account_name | year_month | |:-------------------------------------|:------------------------|:-------------| | plaid_item_cmo6nqub6000y13skux2efu8a | Business Platinum Card® | 2025-02 | | plaid_item_cmo6nqub6000y13skux2efu8a | Business Platinum Card® | 2025-03 | | plaid_item_cmo6nqub6000y13skux2efu8a | Business Platinum Card® | 2025-04 | | plaid_item_cmo6nqub6000y13skux2efu8a | Business Platinum Card® | 2025-05 | | plaid_item_cmo6nqub6000y13skux2efu8a | Business Platinum Card® | 2025-06 | | plaid_item_cmo6nqub6000y13skux2efu8a | Business Platinum Card® | 2025-07 | | plaid_item_cmo6nqub6000y13skux2efu8a | Business Platinum Card® | 2025-08 | | plaid_item_cmo6nqub6000y13skux2efu8a | Business Platinum Card® | 2025-09 | | plaid_item_cmo6nqub6000y13skux2efu8a | Business Platinum Card® | 2025-10 | | plaid_item_cmo6nqub6000y13skux2efu8a | Business Platinum Card® | 2025-11 | | plaid_item_cmo6nqub6000y13skux2efu8a | Business Platinum Card® | 2025-12 | ## 4. Key financial metrics - Total source-backed true income in transaction window: $11,190,224.51 - Total source-backed true spending in transaction window: $7,227,363.24 - Net cash flow in transaction window: $3,962,861.27 - Current known net worth: $9,915,063.67 - Known total assets: $10,092,312.14 - Known total liabilities: $177,248.47 ## 5. Net worth | line_item | side | amount | source | notes | |:------------------------------------------|:--------------------------|:------------|:--------------------------------------|:--------------------------------------------------------| | Chase MANAGED BROKERAGE | asset | 2473866.48 | plaid_item_cmo68m79g0000g1hul4es5e1a | investment/brokerage; last4=0884 | | Chase PLAT BUS CHECKING | asset | 918019.45 | plaid_item_cmo68m79g0000g1hul4es5e1a | depository/checking; last4=1157 | | Chase PLAT BUS CHECKING | asset | 1984.22 | plaid_item_cmo68m79g0000g1hul4es5e1a | depository/checking; last4=2695 | | Chase GEORGE BOLOTIN TOD | asset | 204000.0 | plaid_item_cmo68m79g0000g1hul4es5e1a | investment/brokerage; last4=4006 | | Chase BROKERAGE RETIREMENT | asset | 0.02 | plaid_item_cmo68m79g0000g1hul4es5e1a | investment/ira; last4=4977 | | Chase PLAT BUS CHECKING | asset | 233246.84 | plaid_item_cmo68m79g0000g1hul4es5e1a | depository/checking; last4=5079 | | Chase MANAGED BROKERAGE | asset | 522630.33 | plaid_item_cmo68m79g0000g1hul4es5e1a | investment/brokerage; last4=5662 | | Chase PLAT BUS CHECKING | asset | 16768.89 | plaid_item_cmo68m79g0000g1hul4es5e1a | depository/checking; last4=6225 | | Chase CPC CHECKING | asset | 119955.18 | plaid_item_cmo68m79g0000g1hul4es5e1a | depository/checking; last4=6292 | | Chase MANAGED BROKERAGE | asset | 2043406.25 | plaid_item_cmo68m79g0000g1hul4es5e1a | investment/brokerage; last4=6880 | | Chase BROKERAGE | asset | 0.54 | plaid_item_cmo68m79g0000g1hul4es5e1a | investment/brokerage; last4=7410 | | Chase BROKERAGE | asset | 0.08 | plaid_item_cmo68m79g0000g1hul4es5e1a | investment/brokerage; last4=8806 | | Chase G. BOLOTIN | liability | 891.35 | plaid_item_cmo68m79g0000g1hul4es5e1a | credit/credit card; last4=8987 | | Chase MANAGED BROKERAGE | asset | 1701090.88 | plaid_item_cmo68m79g0000g1hul4es5e1a | investment/brokerage; last4=9090 | | Chase MANAGED BROKERAGE | asset | 1743041.53 | plaid_item_cmo68m79g0000g1hul4es5e1a | investment/brokerage; last4=9247 | | Chase CPC CHECKING | asset | 34730.71 | plaid_item_cmo68m79g0000g1hul4es5e1a | depository/checking; last4=9853 | | Chase MANAGED RETIREMENT | asset | 79570.74 | plaid_item_cmo68m79g0000g1hul4es5e1a | investment/ira; last4=9869 | | American Express Business Centurion® Card | liability | 70385.46 | plaid_item_cmo6nqub6000y13skux2efu8a | credit/credit card; last4=1002 | | American Express Business Platinum Card® | liability | 105971.66 | plaid_item_cmo6nqub6000y13skux2efu8a | credit/credit card; last4=3003 | | Rocket Mortgage | liability_unknown_balance | | plaid_sqlite_db; src_a41552f0a5d3fbd0 | Balance unavailable; excluded from numeric net worth | | Unknown | liability_unknown_balance | | plaid_sqlite_db; src_a41552f0a5d3fbd0 | Balance unavailable; excluded from numeric net worth | | U.S. Bank | liability_unknown_balance | | plaid_sqlite_db; src_a41552f0a5d3fbd0 | Balance unavailable; excluded from numeric net worth | | TD Bank | liability_unknown_balance | | plaid_sqlite_db; src_a41552f0a5d3fbd0 | Balance unavailable; excluded from numeric net worth | | Unknown | liability_unknown_balance | | plaid_sqlite_db; src_a41552f0a5d3fbd0 | Balance unavailable; excluded from numeric net worth | | Total assets | summary | 10092312.14 | derived | From account balances only | | Total liabilities | summary | 177248.47 | derived | From Plaid credit/loan balances plus manual liabilities | | Net worth | summary | 9915063.67 | derived | Excludes unknown balances and off-platform assets | | Liquid net worth | summary | 1147456.82 | derived | Depository assets minus known liabilities | | Investable assets | summary | 8767606.85 | derived | Investment account balances only | | Retirement assets | summary | 79570.76 | derived | Only accounts whose names/subtypes indicate retirement | | Debt-to-assets ratio | summary | 0.0176 | derived | Known liabilities divided by known assets | ## 6. Income | year | true_income | transaction_count | |:-------|:--------------|:--------------------| | 2024 | 870.91 | 177 | | 2025 | 1168.4 | 68 | | 2026 | 11188185.2 | 4887 | ## 7. Spending | year | true_spending | tax_payments | transaction_count | |:-------|:----------------|:---------------|:--------------------| | 2024 | 169743.1 | 0.0 | 177 | | 2025 | 53547.56 | 0.0 | 68 | | 2026 | 7004072.58 | 4255325.63 | 4887 | ## 8. Business activity Business classification is conservative. Transactions are marked business only when entity tags or business-purpose keywords support it; otherwise they remain Unknown or Needs Review. ## 9. Taxes Missing forms: See review queue and missing-document checklist. | tax_year | source_id | return_type | filing_status | agi | taxable_income | total_tax | effective_tax_rate | wages | business_income | k1_income | interest | dividends | capital_gains | rental_income | estimated_tax_payments | withholding | refund_or_balance_due | qbi_deduction | depreciation | charitable_deductions | salt_deductions | mortgage_interest | carryforwards | missing_forms | audit_flags | confidence | |:-----------|:--------------------------------------|:----------------|:----------------|:--------|:-----------------|:------------|:---------------------|:--------|:------------------|:------------|:-----------|:------------|:----------------|:----------------|:-------------------------|:--------------|:------------------------|:----------------|:---------------|:------------------------|:------------------|:--------------------|:----------------|:----------------|:------------------------------------------------------------------------------------|:-------------| | 2021 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | 1040 | Unknown | | | | | | | | | | | | | | | | | | | | | | Entity: PERSONAL; Merged duplicate tax-return evidence from multiple local indexes. | 0.45 | | 2021 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | business return | Unknown | | | | | | | | | | | | | | | | | | | | | | Entity: TCR; Merged duplicate tax-return evidence from multiple local indexes. | 0.45 | | 2022 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | 1098 | Unknown | | | | | | | | | | | | | | | | | | | | | | Entity: PERSONAL; Merged duplicate tax-return evidence from multiple local indexes. | 0.45 | | 2023 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | 1098 | Unknown | | | | | | | | | | | | | | | | | | | | | | Entity: PERSONAL; Merged duplicate tax-return evidence from multiple local indexes. | 0.45 | | 2024 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | 1098 | Unknown | | | | | | | | | | | | | | | | | | | | | | Entity: PERSONAL; Merged duplicate tax-return evidence from multiple local indexes. | 0.45 | | 2022 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | 1099-NEC | Unknown | | | | | | | | | | | | | | | | | | | | | | Entity: PERSONAL; Merged duplicate tax-return evidence from multiple local indexes. | 0.45 | | 2024 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | 1065 | Unknown | | | | | | -43228 | | | | | | | | | | | | | | | | Entity: NOVA; Merged duplicate tax-return evidence from multiple local indexes. | 0.75 | | 2023 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | 1040 | Unknown | 2638588 | 2325449 | 793254 | 0.3006 | | | | | | | | 651335 | | 297896 | | | | | | | | Entity: PERSONAL; Merged duplicate tax-return evidence from multiple local indexes. | 0.75 | | 2023 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | business return | Unknown | | | | | | | | | | | | | | | | | | | | | | Entity: TCR; Merged duplicate tax-return evidence from multiple local indexes. | 0.45 | | 2020 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | 1120S | Unknown | | | | | | | | | | | | | | | | | | | | | | Entity: TCR; Merged duplicate tax-return evidence from multiple local indexes. | 0.45 | | 2020 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | 1040 | Unknown | | | | | | | | | | | | | | | | | | | | | | Entity: PERSONAL; Merged duplicate tax-return evidence from multiple local indexes. | 0.45 | | | plaid_sqlite_db; src_a41552f0a5d3fbd0 | tax return | Unknown | | | | | | | | | | | | | | | | | | | | | | Entity: PERSONAL; Merged duplicate tax-return evidence from multiple local indexes. | 0.45 | | 2020 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | W-2 | Unknown | | | | | | | | | | | | | | | | | | | | | | Entity: PERSONAL; Merged duplicate tax-return evidence from multiple local indexes. | 0.45 | ## 10. Loans and liabilities | liability_id | source_id | lender | borrower | type | original_principal | current_balance | interest_rate | apr | fixed_or_variable | payment_amount | minimum_payment | term | maturity_date | collateral | personal_guarantee | tax_deductible_interest | last_payment_date | risk_level | notes | |:----------------------|:--------------------------------------|:----------------|:-----------|:---------------|:---------------------|:------------------|:----------------|:------|:--------------------|:-----------------|:------------------|:-------|:----------------|:-------------|:---------------------|:--------------------------|:--------------------|:-------------|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------| | liab_b4e59aa321efa422 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | Rocket Mortgage | Unknown | mortgage | | | | | Unknown | 4496.68 | | | | | Unknown | Needs Review | | Needs Review | Detected from recurring payment activity; current principal balance still needed.; Merged duplicate liability evidence from multiple local indexes. | | liab_7901135b9fac08c3 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | Unknown | Unknown | line_of_credit | | | | | Unknown | | | | | | Unknown | Needs Review | | Needs Review | Placeholder requested by user; add lender, limit, and balance when statement is available.; Merged duplicate liability evidence from multiple local indexes. | | liab_1daa43b825e52fb3 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | U.S. Bank | AI_BIZ_OPS | mortgage | | | | | Unknown | | | | 2026-05-27 | | Unknown | Needs Review | | Needs Review | Gmail thread with Rachel Purcell: loan payments set up on autopay from U.S. Bank checking, beginning 2026-05-27.; Merged duplicate liability evidence from multi | | liab_fc15a4c12bc196e6 | plaid_sqlite_db; src_a41552f0a5d3fbd0 | TD Bank | TCR | loan | | | | | Unknown | | | | | | Unknown | Needs Review | | Needs Review | U.S. Bank closing thread referenced original loan amount $177,103 needing paid-in-full proof; do not count as current balance until verified.; Merged duplicate | | liab_a89b203a5a86c37a | plaid_sqlite_db; src_a41552f0a5d3fbd0 | Unknown | TCR | other | | | | | Unknown | | | | | | Unknown | Needs Review | | Needs Review | U.S. Bank reapproval thread: opened 2021-04, involuntarily closed 2025-03, collections reported 2025-11; later condition was waived, but Equifax follow-up recom | ## 11. Investments | investment_id | source_id | account_name | institution | last4 | date | symbol | cusip | security_name | asset_class | quantity | price | market_value | cost_basis | unrealized_gain_loss | realized_gain_loss | dividends | interest | fees | contribution | withdrawal | account_type | tax_status | confidence | |:---------------------|:-------------------------------------|:---------------------|:--------------|:--------|:-----------|:---------|:--------|:---------------------|:--------------|:-----------|:--------|:---------------|:-------------|:-----------------------|:---------------------|:------------|:-----------|:-------|:---------------|:-------------|:---------------|:-------------|:-------------| | inv_15a4eaa3d722553e | plaid_item_cmo68m79g0000g1hul4es5e1a | MANAGED BROKERAGE | Chase | 0884 | 2026-05-30 | | | Account balance only | Unknown | | | 2473866.48 | | | | | | | | | brokerage | Needs Review | 0.55 | | inv_e43aabcdba1230c9 | plaid_item_cmo68m79g0000g1hul4es5e1a | GEORGE BOLOTIN TOD | Chase | 4006 | 2026-05-30 | | | Account balance only | Unknown | | | 204000.0 | | | | | | | | | brokerage | Needs Review | 0.55 | | inv_5a8b2bfe132f2b45 | plaid_item_cmo68m79g0000g1hul4es5e1a | BROKERAGE RETIREMENT | Chase | 4977 | 2026-05-30 | | | Account balance only | Unknown | | | 0.02 | | | | | | | | | ira | Needs Review | 0.55 | | inv_e118508e189ca35d | plaid_item_cmo68m79g0000g1hul4es5e1a | MANAGED BROKERAGE | Chase | 5662 | 2026-05-30 | | | Account balance only | Unknown | | | 522630.33 | | | | | | | | | brokerage | Needs Review | 0.55 | | inv_8816d3884e4d4dd9 | plaid_item_cmo68m79g0000g1hul4es5e1a | MANAGED BROKERAGE | Chase | 6880 | 2026-05-30 | | | Account balance only | Unknown | | | 2043406.25 | | | | | | | | | brokerage | Needs Review | 0.55 | | inv_a5e5652f2abdaf73 | plaid_item_cmo68m79g0000g1hul4es5e1a | BROKERAGE | Chase | 7410 | 2026-05-30 | | | Account balance only | Unknown | | | 0.54 | | | | | | | | | brokerage | Needs Review | 0.55 | | inv_8709b4050cd38307 | plaid_item_cmo68m79g0000g1hul4es5e1a | BROKERAGE | Chase | 8806 | 2026-05-30 | | | Account balance only | Unknown | | | 0.08 | | | | | | | | | brokerage | Needs Review | 0.55 | | inv_f0f9379ab23ba219 | plaid_item_cmo68m79g0000g1hul4es5e1a | MANAGED BROKERAGE | Chase | 9090 | 2026-05-30 | | | Account balance only | Unknown | | | 1701090.88 | | | | | | | | | brokerage | Needs Review | 0.55 | | inv_7150f033a3128647 | plaid_item_cmo68m79g0000g1hul4es5e1a | MANAGED BROKERAGE | Chase | 9247 | 2026-05-30 | | | Account balance only | Unknown | | | 1743041.53 | | | | | | | | | brokerage | Needs Review | 0.55 | | inv_09cb674d7ac82b87 | plaid_item_cmo68m79g0000g1hul4es5e1a | MANAGED RETIREMENT | Chase | 9869 | 2026-05-30 | | | Account balance only | Unknown | | | 79570.74 | | | | | | | | | ira | Needs Review | 0.55 | ## 12. Recurring expenses | normalized_merchant | account_name | transaction_count | first_date | last_date | median_amount | total_amount | cadence | |:----------------------------------|:-------------------------|:--------------------|:-------------|:------------|:----------------|:------------------|:----------------------------| | Nys Dtf Ptet | PLAT BUS CHECKING | 5 | 2026-03-15 | 2026-03-18 | 60000.0 | 417000.0 | monthly/recurring candidate | | Wch Service Bureau | Business Platinum Card® | 23 | 2026-01-21 | 2026-04-15 | 15000.0 | 285156.93 | monthly/recurring candidate | | Ach To Contego | PLAT BUS CHECKING | 4 | 2026-01-19 | 2026-05-07 | 42929.5 | 204761.0 | monthly/recurring candidate | | Wch Service Bureau | Business Centurion® Card | 13 | 2026-04-30 | 2026-05-27 | 13700.0 | 167304.33 | monthly/recurring candidate | | Medtronics | Business Platinum Card® | 13 | 2026-01-22 | 2026-05-28 | 10000.0 | 164343.53 | monthly/recurring candidate | | Nyc Dept Of Fina | PLAT BUS CHECKING | 3 | 2026-03-16 | 2026-03-16 | 10577.0 | 134938.0 | monthly/recurring candidate | | Angiodynamics | Business Platinum Card® | 11 | 2026-01-22 | 2026-05-21 | 13065.0 | 105326.3 | monthly/recurring candidate | | Henry Schein | Business Platinum Card® | 33 | 2026-02-23 | 2026-05-14 | 854.55 | 94164.56 | monthly/recurring candidate | | Wch Service Bureau 0Brooklyn Ny | Business Platinum Card® | 9 | 2024-12-11 | 2025-01-08 | 10700.0 | 92019.63 | monthly/recurring candidate | | Merit | PLAT BUS CHECKING | 3 | 2026-02-18 | 2026-05-03 | 25000.0 | 75000.0 | monthly/recurring candidate | | Fay Servicing | PLAT BUS CHECKING | 4 | 2026-02-01 | 2026-04-30 | 18557.66 | 74230.64 | monthly/recurring candidate | | Medical Liab | PLAT BUS CHECKING | 4 | 2026-02-24 | 2026-05-26 | 13254.5 | 73856.0 | monthly/recurring candidate | | Medical Supplies | Business Platinum Card® | 26 | 2026-01-23 | 2026-05-28 | 2144.935 | 71200.79000000001 | monthly/recurring candidate | | Memorandum | CPC CHECKING | 5 | 2026-01-25 | 2026-05-25 | 12630.48 | 60289.3 | monthly/recurring candidate | | Ach To Abbott | PLAT BUS CHECKING | 4 | 2026-01-20 | 2026-05-03 | 11250.0 | 52500.0 | monthly/recurring candidate | | Wch Service Bure | PLAT BUS CHECKING | 4 | 2026-04-29 | 2026-04-29 | 14750.0 | 49827.85 | monthly/recurring candidate | | Uber | Business Platinum Card® | 693 | 2024-12-17 | 2026-05-28 | 59.63 | 45699.4 | monthly/recurring candidate | | Methapharm | Business Platinum Card® | 5 | 2026-01-19 | 2026-05-28 | 10384.0 | 44860.3 | monthly/recurring candidate | | Astoriarent | PLAT BUS CHECKING | 4 | 2026-01-28 | 2026-04-29 | 10500.0 | 42000.0 | monthly/recurring candidate | | Ach To Landlord | PLAT BUS CHECKING | 5 | 2026-01-28 | 2026-05-28 | 8360.15 | 41800.75 | monthly/recurring candidate | | Medline Industries | Business Centurion® Card | 19 | 2026-03-20 | 2026-05-27 | 1683.85 | 37187.36 | monthly/recurring candidate | | Guralnikseo | PLAT BUS CHECKING | 4 | 2026-02-16 | 2026-05-14 | 7500.0 | 35600.0 | monthly/recurring candidate | | Nys Dtf Pit | PLAT BUS CHECKING | 3 | 2026-03-16 | 2026-04-16 | 500.0 | 35525.0 | monthly/recurring candidate | | Dus Sale | Business Platinum Card® | 5 | 2026-02-05 | 2026-05-13 | 6986.15 | 31755.22 | monthly/recurring candidate | | Asahi | PLAT BUS CHECKING | 4 | 2026-02-09 | 2026-05-27 | 8991.5 | 30558.0 | monthly/recurring candidate | | Netembark | Business Platinum Card® | 4 | 2026-02-11 | 2026-05-08 | 6600.0 | 26400.0 | monthly/recurring candidate | | Core | Business Centurion® Card | 8 | 2026-02-19 | 2026-05-15 | 3268.355 | 26280.99 | monthly/recurring candidate | | Vein | Business Platinum Card® | 3 | 2026-01-26 | 2026-02-09 | 7740.5 | 25921.5 | monthly/recurring candidate | | Robert Jacobson Surgical Pharmacy | Business Platinum Card® | 3 | 2026-01-21 | 2026-04-20 | 12500.0 | 25460.0 | monthly/recurring candidate | | Con Ed Of | PLAT BUS CHECKING | 24 | 2026-01-26 | 2026-05-28 | 773.86 | 22146.****0002 | monthly/recurring candidate | | Medtronic | Business Platinum Card® | 3 | 2026-04-22 | 2026-05-27 | 10000.0 | 21513.36 | monthly/recurring candidate | | Alibaba | Business Platinum Card® | 5 | 2026-03-09 | 2026-04-03 | 1356.09 | 19477.99 | monthly/recurring candidate | | Facebook Ads | Business Platinum Card® | 10 | 2026-01-22 | 2026-05-29 | 2000.0 | 18001.43 | monthly/recurring candidate | | Rocket Mortgage | PLAT BUS CHECKING | 4 | 2026-02-10 | 2026-05-10 | 4496.68 | 17986.72 | monthly/recurring candidate | | Vascular | PLAT BUS CHECKING | 3 | 2026-03-23 | 2026-04-28 | 2298.74 | 17954.94 | monthly/recurring candidate | | Saks Fifth Avenue | Business Platinum Card® | 5 | 2026-01-24 | 2026-01-27 | 1736.56 | 16418.36 | monthly/recurring candidate | | Vasorum | Business Platinum Card® | 3 | 2026-01-27 | 2026-05-05 | 5381.0 | 13975.0 | monthly/recurring candidate | | Mytheresa | Business Platinum Card® | 8 | 2026-01-19 | 2026-05-14 | 1137.74 | 13777.79 | monthly/recurring candidate | | Mbatpa | PLAT BUS CHECKING | 5 | 2026-01-27 | 2026-05-27 | 2417.52 | 11927.6 | monthly/recurring candidate | | Methapharm 0754Coral Springs Fl | Business Platinum Card® | 3 | 2024-12-11 | 2025-01-08 | 3546.0 | 11864.25 | monthly/recurring candidate | | Henry Schein Hq | Business Platinum Card® | 11 | 2026-01-20 | 2026-02-09 | 521.98 | 11439.39 | monthly/recurring candidate | | Amazon | Business Platinum Card® | 16 | 2026-02-10 | 2026-05-17 | 26.****9997 | 11041.93 | monthly/recurring candidate | | Farfetch | Business Platinum Card® | 3 | 2026-01-23 | 2026-05-28 | 3089.87 | 10791.7 | monthly/recurring candidate | | Aleph Daycare | Business Platinum Card® | 5 | 2026-01-31 | 2026-05-27 | 1733.68 | 9999.54 | monthly/recurring candidate | | Geico | Business Platinum Card® | 5 | 2026-02-14 | 2026-05-14 | 2374.96 | 9279.32 | monthly/recurring candidate | | Expertpay | PLAT BUS CHECKING | 9 | 2026-01-26 | 2026-05-18 | 936.73 | 8430.57 | monthly/recurring candidate | | Enexia Specialty Pharmacy | PLAT BUS CHECKING | 51 | 2026-01-19 | 2026-05-27 | 156.98 | 7921.15 | monthly/recurring candidate | | Weave Rb | Business Platinum Card® | 8 | 2026-01-30 | 2026-05-17 | 983.2 | 7866.****9999 | monthly/recurring candidate | | Bmw | PLAT BUS CHECKING | 4 | 2026-02-08 | 2026-05-05 | 1935.27 | 7741.08 | monthly/recurring candidate | | Drchrono | Business Platinum Card® | 5 | 2026-01-21 | 2026-05-21 | 1353.01 | 6687.59 | monthly/recurring candidate | ## 13. Transfers and cash flow Internal transfers, credit-card payments, brokerage transfers, and loan-like transfers are separated where evidence supports it. Unmatched transfer candidates are in the review queue. | year_month | true_income | true_spending | tax_payments | transfer_volume | net_cash_flow | transaction_count | |:-------------|:--------------|:----------------|:---------------|:------------------|:----------------|:--------------------| | 2024-12 | 870.91 | 169743.1 | 0.0 | 127987.99 | -168872.19 | 177 | | 2025-01 | 1168.4 | 53547.56 | 0.0 | 0.0 | -52379.16 | 68 | | 2026-01 | 823948.47 | 551275.64 | 182798.38 | 1042200.54 | 272672.83 | 414 | | 2026-02 | 1864830.16 | 1052614.0 | 438875.55 | 1791715.8 | 812216.16 | 974 | | 2026-03 | 2477520.61 | 1961282.52 | 872723.89 | 2165566.89 | 516238.09 | 1157 | | 2026-04 | 3220911.84 | 2166647.36 | 1855977.17 | 2533794.07 | 1054264.48 | 1192 | | 2026-05 | 2800974.12 | 1272253.06 | 904950.64 | 6046441.96 | 1528721.06 | 1150 | ## 14. Risk flags | review_id | item_type | item_id | issue_type | why_flagged | recommended_resolution | priority | source_id | |:------------------------|:------------|:--------------------------|:-----------------------|:---------------------------------|:---------------------------------------------------------------------|:-----------|:-------------------------------------| | review_8cf4c81e828f687a | transaction | cmo6abu8l00038g38ckz8vzie | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_cac2fb9ae6c227c0 | transaction | cmo6abu8p00078g38z0w8ikm7 | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_c1def69f19d310a0 | transaction | cmo6abu91000j8g38cvyzdp3q | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_42b5da3a7f3adbba | transaction | cmo6abu9f001b8g38zuo3x9ue | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_0bf04a37de86b3b5 | transaction | cmo6abu9g001d8g38txokv2dz | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_37613fc0b325e1e8 | transaction | cmo6abu9i001f8g38plo4qh72 | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_c7ef18f1e8ececc1 | transaction | cmo6abu9k001j8g389dc89uxq | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_101c4a693484769b | transaction | cmo6abu9t001x8g38oopbbecv | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_5e182ffa91e2e8f4 | transaction | cmo6abua0002f8g38x9bbyb4h | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_773a20e26133180e | transaction | cmo6abua1002h8g38qq9pvrib | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_d7067982fa1e5c04 | transaction | cmo6abua5002r8g38f62jn4j4 | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_fee42faa145a875c | transaction | cmo6abua6002v8g38c873yety | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_40711086fd039abc | transaction | cmo6abua900338g38c9xaa3e1 | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_b3aeb4938f5e681f | transaction | cmo6abuaa00378g38aa2eu7jn | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_2f2e411405a7b0c5 | transaction | cmo6abuab003b8g385gbx4no7 | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_52c78e294ce39e00 | transaction | cmo6abuad003j8g386za2e0hg | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_79a273700da649a0 | transaction | cmo6abuae003n8g380pu2yije | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_8764df564ec598b7 | transaction | cmo6abuah003v8g38d1odwlsw | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_c47ab6c3e48db0de | transaction | cmo6abuah003x8g38y1rqhx48 | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_6511722a6f47a0be | transaction | cmo6abuaj00438g38ka41ezlw | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_0b895adc7e8ee0a3 | transaction | cmo6abuak00478g38oxgb2mjb | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_563c3da6f46845bc | transaction | cmo6abual004d8g38zsslkqyg | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_6cb2436d6cc43f1b | transaction | cmo6abuao004n8g386d9t4n0k | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_58b97e4e2f2498e3 | transaction | cmo6abuao004p8g38kf7kjxx8 | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_5a322b01af33442f | transaction | cmo6abuap004r8g38xytj2t0x | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_a8606814189da5ce | transaction | cmo6abuap004t8g38yw7ro9pu | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_032cfec1d081fb5e | transaction | cmo6abuar004z8g38bdi9z1wx | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_c2019707778be7c1 | transaction | cmo6abuar00538g38etbdj6er | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_c62651209478b609 | transaction | cmo6abuau005d8g382pq4dsyf | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_f57d714118313de7 | transaction | cmo6abuau005f8g38spm54fqw | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_fa42f9c3e15e49a3 | transaction | cmo6abuav005h8g38ttw7c8yg | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_0eefe075ba98e783 | transaction | cmo6abute005l8g38ik1mwym1 | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_32032885bdcb0399 | transaction | cmo6abutk005r8g38xvy3l92b | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_0168a35e1b579032 | transaction | cmo6abutn005t8g387qb0104c | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_b0652c65835187fc | transaction | cmo6abutp005v8g38ufm2ioo9 | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_6faec01187c4dc76 | transaction | cmo6abuu8006j8g389dq1gfqt | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_e51946484fb1dff4 | transaction | cmo6abuug00718g38ww8hy8rj | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_dcf0f84028a4eaa2 | transaction | cmo6abuuj00778g38oc2kjgkt | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_30050629987b552a | transaction | cmo6abuul007d8g38jujwutf0 | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_65029d4f692c8544 | transaction | cmo6abuup007p8g38jpwfth2u | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_a641b5a1a860bc82 | transaction | cmo6abuuv00858g38uimejves | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_b9a5ad9af5ccd015 | transaction | cmo6abuv6008v8g387zq3k89w | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_07d7c969f764683c | transaction | cmo6abuv7008x8g3805drpufi | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_957ca87220a14b5c | transaction | cmo6abuv800918g380tofqos9 | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_22c379ea316de3cf | transaction | cmo6abuv900938g384la9odg4 | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_695d400eaa823337 | transaction | cmo6abuvg009n8g38kipsfzhi | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_6e521a7c01c2ce86 | transaction | cmo6abuvg009p8g38hwqhl99s | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_8dfc4f5354d6ebf8 | transaction | cmo6abuvh009r8g38pdxpkrbl | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_9f4e2ccbe62c1f43 | transaction | cmo6abuvi009t8g38smproja6 | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_21df77331fd660f9 | transaction | cmo6abuvi009v8g38egawxvpp | transaction_over_10000 | Transaction is at least $10,000. | Confirm business/personal/tax/transfer treatment and retain support. | 1 | plaid_item_cmo68m79g0000g1hul4es5e1a | ## 15. Cleanup tasks - Resolve high-priority review queue items. - Add missing expected source folders or confirm they are not applicable. - Add brokerage holdings, historical account-balance snapshots, and missing statements for stronger net worth and investment analysis. - Confirm business/personal classification for mixed-use and owner-related transactions. ## 16. Recommendations - Use the review queue as the accountant handoff list. - Prioritize transactions over $10,000 and uncategorized transactions over $1,000. - Re-run the pipeline after adding each new source folder so coverage and reconciliations update reproducibly. ## 17. Charts - output/charts/annual_income.png - output/charts/annual_income_spending.png - output/charts/annual_spending.png - output/charts/cash_balance_trend.png - output/charts/category_spending_heatmap_by_month.png - output/charts/current_asset_allocation.png - output/charts/current_balance_sheet.png - output/charts/dividend_interest_income.png - output/charts/income_by_source.png - output/charts/investment_allocation.png - output/charts/liability_composition.png - output/charts/monthly_income.png - output/charts/monthly_income_spending.png - output/charts/monthly_spending.png - output/charts/net_worth_over_time.png - output/charts/outlier_transaction_timeline.png - output/charts/recurring_expenses.png - output/charts/rolling_3_month_and_12_month_trends.png - output/charts/sankey_cash_flow.png - output/charts/spending_by_category.png - output/charts/spending_by_entity.png - output/charts/spending_by_merchant.png - output/charts/taxes_paid_over_time.png - output/charts/top_25_transactions_2024.png - output/charts/top_25_transactions_2025.png - output/charts/top_25_transactions_2026.png - output/charts/transfer_network_graph.png ## 18. Evidence index | document_id | source_id | document_type | tax_year | confidence | |:--------------------------|:---------------------|:----------------|:-----------|:-------------| | doc_ea73c164b0781248 | src_a41552f0a5d3fbd0 | tax_return | 2026 | 0.85 | | doc_10031b6acd1e0d32 | src_a41552f0a5d3fbd0 | 1040 | 2021 | 0.85 | | doc_8352f348b522aa0c | src_a41552f0a5d3fbd0 | business return | 2021 | 0.85 | | doc_c323bed216ab5e24 | src_a41552f0a5d3fbd0 | 1098 | 2022 | 0.85 | | doc_db5aff1c8d75052a | src_a41552f0a5d3fbd0 | 1098 | 2023 | 0.85 | | doc_42e06ac12e96f2ad | src_a41552f0a5d3fbd0 | 1098 | 2024 | 0.85 | | doc_13220a231b74cb77 | src_a41552f0a5d3fbd0 | 1099-NEC | 2022 | 0.85 | | doc_2cc99a0f98051ec1 | src_a41552f0a5d3fbd0 | 1065 | 2024 | 0.85 | | doc_2daaeaa541cc826f | src_a41552f0a5d3fbd0 | 1040 | 2023 | 0.85 | | doc_af32401f880085d8 | src_a41552f0a5d3fbd0 | business return | 2023 | 0.85 | | doc_4d3e9629595e488e | src_a41552f0a5d3fbd0 | 1120S | 2020 | 0.85 | | doc_ab1ffb50cb2f4cbe | src_a41552f0a5d3fbd0 | 1040 | 2020 | 0.85 | | doc_e56ce21e1693cb8d | src_a41552f0a5d3fbd0 | tax return | | 0.85 | | doc_b8028e2f8f8d21ca | src_a41552f0a5d3fbd0 | tax return | | 0.85 | | doc_ba1972539aca2beb | src_a41552f0a5d3fbd0 | W-2 | 2020 | 0.85 | | doc_2a14e2cf53ba0abd | src_70d9d24211acd003 | tax_return | 2026 | 0.85 | | doc_e57df39748d9f1ea | src_448f7c3d3e4cd204 | k1_1099_w2 | 2026 | 0.85 | | doc_b90459f76faa6d2b | src_4319dacf9159b108 | statement | 2025 | 0.85 | | doc_821e3924fb2a7c83 | src_c82c4e383ef6ddbe | statement | 2025 | 0.85 | | doc_1ff99d1106135372 | src_4adb8824fa638b8f | statement | 2025 | 0.85 | | doc_27a2c24a9e03bf77 | src_3d80b6e16932cc1e | statement | 2025 | 0.85 | | doc_13fbe67b61274261 | src_ccf25d47543f6db2 | statement | 2025 | 0.85 | | doc_af408769f35690e6 | src_003c12e79a578e9e | statement | 2026 | 0.85 | | doc_bfb25b65cd7afc3f | src_8dd30cbffa2eed2b | statement | 2025 | 0.85 | | doc_29394993cbf2594c | src_4cf90e8c9efe0c8c | statement | 2025 | 0.85 | | doc_6d93586328070fab | src_0be32fed2262406b | statement | 2026 | 0.85 | | doc_3fad0d043d27458d | src_9cde0dab2cbae8e6 | statement | 2025 | 0.85 | | doc_d64aedac26da1b79 | src_91103bdda5777bb7 | statement | 2025 | 0.85 | | doc_8634a5f8a4b04255 | src_8e3f15823508996e | statement | 2025 | 0.85 | | doc_db69411a06ec732a | src_89042ae33c01dbb3 | statement | 2026 | 0.85 | | doc_97a359468daff895 | src_fb8b2d6e663b73e8 | statement | 2025 | 0.85 | | doc_08282d2a41366879 | src_90d94415f8cd3be1 | statement | 2025 | 0.85 | | doc_82232830ba19b83c | src_eb99ccababd76f17 | statement | 2026 | 0.85 | | doc_502b67fa6111252f | src_8746dad344c8969f | k1_1099_w2 | 2025 | 0.85 | | doc_ab2f13c53ffbaebc | src_766991c30e29a534 | tax_return | 1990 | 0.85 | | doc_883a86646f8bb3c7 | src_223a36e92ad89eb4 | k1_1099_w2 | 2025 | 0.85 | | doc_9e59c1fd66dea474 | src_e630d0b041b44066 | k1_1099_w2 | 2025 | 0.85 | | cmp24m4ix0000q0yx5mkpb4sh | plaid_sqlite_db | 1065 | 2024 | 0.85 | | cmp24m4j4000fq0yx5h8d8nlk | plaid_sqlite_db | 1040 | 2023 | 0.85 | | cmp24m4j8000wq0yx8dlnyool | plaid_sqlite_db | 1040 | 2020 | 0.85 | | cmp24m4j8000xq0yxnf77ymzk | plaid_sqlite_db | tax return | | 0.85 | | cmp24m4j9000yq0yxq1cukaya | plaid_sqlite_db | tax return | | 0.85 | | cmp24m4j9000zq0yxypbborhs | plaid_sqlite_db | W-2 | 2020 | 0.85 | | cmp24van90000uhtkstr6lyoj | plaid_sqlite_db | 1040 | 2021 | 0.85 | | cmp24vana0001uhtkf5620p0q | plaid_sqlite_db | business return | 2021 | 0.85 | | cmp24vanb0002uhtk92ok8bho | plaid_sqlite_db | 1098 | 2022 | 0.85 | | cmp24vanb0003uhtk6wejpn4z | plaid_sqlite_db | 1098 | 2023 | 0.85 | | cmp24vanc0004uhtkreeg92gj | plaid_sqlite_db | 1098 | 2024 | 0.85 | | cmp24vanc0005uhtksh7162ld | plaid_sqlite_db | 1099-NEC | 2022 | 0.85 | | cmp24y7dl00124bvsdcl1msuo | plaid_sqlite_db | business return | 2023 | 0.85 | | cmp24y7dm00134bvs0vtknq17 | plaid_sqlite_db | 1120S | 2020 | 0.85 | ## 19. Review queue | review_id | item_type | item_id | issue_type | why_flagged | recommended_resolution | priority | source_id | |:------------------------|:--------------|:--------------------------|:----------------------------------------|:----------------------------------------------------------------------------------------|:-----------------------------------------------------------------------------------|:-----------|:-------------------------------------| | review_0fc3df01025020ab | source_folder | bank_exports | missing_source_folder | Expected source folder 'bank_exports' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_71d224d126eff0fa | source_folder | credit_card_exports | missing_source_folder | Expected source folder 'credit_card_exports' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_17da8d88971d5f7e | source_folder | brokerage_exports | missing_source_folder | Expected source folder 'brokerage_exports' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_0a29615cb8c80d1a | source_folder | gmail_exports | missing_source_folder | Expected source folder 'gmail_exports' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_f4ed194acee0b53b | source_folder | gmail_attachments | missing_source_folder | Expected source folder 'gmail_attachments' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_0d6ce105f3e36b8c | source_folder | google_drive_exports | missing_source_folder | Expected source folder 'google_drive_exports' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_ed0d2d31aec039a3 | source_folder | tax_returns | missing_source_folder | Expected source folder 'tax_returns' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_5b612cc11296b058 | source_folder | k1_1099_w2 | missing_source_folder | Expected source folder 'k1_1099_w2' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_6c8056c09c878d4a | source_folder | loans | missing_source_folder | Expected source folder 'loans' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_ada31e968d93f36e | source_folder | receipts | missing_source_folder | Expected source folder 'receipts' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_d03283eb3ab3814b | source_folder | invoices | missing_source_folder | Expected source folder 'invoices' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_72249328557cf9a4 | source_folder | statements | missing_source_folder | Expected source folder 'statements' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_4913728fd90feacb | source_folder | whatsapp_sms_exports | missing_source_folder | Expected source folder 'whatsapp_sms_exports' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_61f4768c0469482e | source_folder | business_docs | missing_source_folder | Expected source folder 'business_docs' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_be18c9108a8eab2f | source_folder | photos_scans | missing_source_folder | Expected source folder 'photos_scans' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_b72f8d3dbfcd062c | source_folder | accounting_exports | missing_source_folder | Expected source folder 'accounting_exports' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_bedf29e2d01d3105 | source_folder | real_estate | missing_source_folder | Expected source folder 'real_estate' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_32fcf87e4cf0aff6 | source_folder | insurance | missing_source_folder | Expected source folder 'insurance' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_5be59536d772d6f9 | source_folder | legal | missing_source_folder | Expected source folder 'legal' is not present. | Add the folder when those source files are available, or ignore if not applicable. | 3 | | | review_30693301c21e3c97 | transaction | cmo6abuv0008h8g38ul1rzkxr | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_4fb71624ac550570 | transaction | cmo6abxyd01678g38iqd90odx | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_241af596f90ba9a9 | transaction | cmoeguvz5025zgk3cs4c2p4a5 | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo6nqub6000y13skux2efu8a | | review_a2a79544728c25eb | transaction | cmoeguwfo029rgk3ct731tm67 | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo6nqub6000y13skux2efu8a | | review_597f5345636dadd5 | transaction | cmoeguwzj02f3gk3ciawgt00i | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo6nqub6000y13skux2efu8a | | review_d3fa62cf24b22ab3 | transaction | cmoeguxvo02rpgk3cetkosnwn | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo6nqub6000y13skux2efu8a | | review_1e0987c00a38164c | transaction | cmoeguys602wzgk3c0gto5v1g | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo6nqub6000y13skux2efu8a | | review_d9555c96d519d557 | transaction | cmoglhi0802mdvocwp9lhgh5p | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_f33b6bafa0abdca5 | transaction | cmoglhi0902mhvocw3n6vzvqg | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_da3a9c962e4ee85f | transaction | cmoglhi0a02mjvocwgu3chkx9 | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_79d5b892f02a325d | transaction | cmoi2qch102gnsjaq20gmyns9 | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo6nqub6000y13skux2efu8a | | review_6093937ebef98053 | transaction | cmormxugz0011kklak01cheyi | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo6nqub6000y13skux2efu8a | | review_880d2fec59458c3b | transaction | cmormxujg006xkklardnhth5r | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo6nqub6000y13skux2efu8a | | review_c739face061d1164 | transaction | cmp24kz14004t2gi1j0b9fosx | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_54a499a922844189 | transaction | cmp24l0ii00br2gi1cto1txk0 | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo6nqub6000y13skux2efu8a | | review_5e98ac0dd44579e7 | transaction | cmp24l1gp00hl2gi1ikvlqrch | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo6nqub6000y13skux2efu8a | | review_59fc2bb55bd65742 | transaction | cmpsn7av60019j9p6swjk4yd8 | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo68m79g0000g1hul4es5e1a | | review_9f8a5710de570a17 | transaction | cmpsn7dsh00kpj9p6uoqd4mwo | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo6nqub6000y13skux2efu8a | | review_3636b625658264e2 | transaction | cmpsn7fs400wtj9p69q6kbdbm | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo6nqub6000y13skux2efu8a | | review_220112434ca5b8ee | transaction | cmpsn7g69010fj9p6oiy1erls | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo6nqub6000y13skux2efu8a | | review_d529a440a6427faf | transaction | cmpsn7gjp012zj9p6dsmn0a6v | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo6nqub6000y13skux2efu8a | | review_c4966109d919156a | transaction | cmpsn7h9r0193j9p6jujpjpgm | duplicate_or_near_duplicate_transaction | Same date, amount, direction, account last4, and normalized merchant as an earlier row. | Review whether this is a real duplicate or separate same-day transaction. | 2 | plaid_item_cmo6nqub6000y13skux2efu8a | | review_f826a45b9fab8f4a | document | doc_b8028e2f8f8d21ca | duplicate_or_near_duplicate_document | Same document type/date/year/payer/payee signature as an earlier row. | Compare source files and keep the strongest evidence copy. | 3 | src_a41552f0a5d3fbd0 | | review_f1a8498c47287127 | document | doc_883a86646f8bb3c7 | duplicate_or_near_duplicate_document | Same document type/date/year/payer/payee signature as an earlier row. | Compare source files and keep the strongest evidence copy. | 3 | src_223a36e92ad89eb4 | | review_540f903015ae9cdf | document | doc_9e59c1fd66dea474 | duplicate_or_near_duplicate_document | Same document type/date/year/payer/payee signature as an earlier row. | Compare source files and keep the strongest evidence copy. | 3 | src_e630d0b041b44066 | | review_533ffdd51019ae0d | document | cmp24m4ix0000q0yx5mkpb4sh | duplicate_or_near_duplicate_document | Same document type/date/year/payer/payee signature as an earlier row. | Compare source files and keep the strongest evidence copy. | 3 | plaid_sqlite_db | | review_8ca36fb1798ed4ef | document | cmp24m4j4000fq0yx5h8d8nlk | duplicate_or_near_duplicate_document | Same document type/date/year/payer/payee signature as an earlier row. | Compare source files and keep the strongest evidence copy. | 3 | plaid_sqlite_db | | review_25576232d3f763f7 | document | cmp24m4j8000wq0yx8dlnyool | duplicate_or_near_duplicate_document | Same document type/date/year/payer/payee signature as an earlier row. | Compare source files and keep the strongest evidence copy. | 3 | plaid_sqlite_db | | review_d0ed8f2d80e10649 | document | cmp24m4j8000xq0yxnf77ymzk | duplicate_or_near_duplicate_document | Same document type/date/year/payer/payee signature as an earlier row. | Compare source files and keep the strongest evidence copy. | 3 | plaid_sqlite_db | | review_e0f34ed2688ded00 | document | cmp24m4j9000yq0yxq1cukaya | duplicate_or_near_duplicate_document | Same document type/date/year/payer/payee signature as an earlier row. | Compare source files and keep the strongest evidence copy. | 3 | plaid_sqlite_db | | review_e262920e74fdad42 | document | cmp24m4j9000zq0yxypbborhs | duplicate_or_near_duplicate_document | Same document type/date/year/payer/payee signature as an earlier row. | Compare source files and keep the strongest evidence copy. | 3 | plaid_sqlite_db | ## 20. Next 30/60/90-day action plan ### Next 30 days - Resolve high-priority review queue items and all tax-payment classifications. - Add missing bank, credit-card, loan, brokerage, and tax folders. - Confirm entity tags on all accounts and any mixed-use accounts. ### Next 60 days - Reconcile receipts/invoices to bank and credit-card transactions. - Add brokerage holdings and historical balance snapshots. - Review loan terms, APRs, and payoff/refinance candidates. ### Next 90 days - Prepare accountant package from normalized tables, evidence index, and final review queue. - Build a repeatable monthly close habit: add exports, run pipeline, resolve queue. - Compare finalized tax returns against transaction-level tax payments and deduction support.