# Afton Electric — Master Punch List

_Generated: 2026-05-24 from focused TB map + bank rec + AR aging review_
_Scope: 2025 / 2026 only per Jimmie's scope decision_

## At-a-glance: total cleanup universe

| Category | Items | Est. $ Impact | Priority |
|---|---|---|---|
| **Critical — wrong-direction balances** | 3 accounts | $45K mislabeled | HIGH |
| **Known-pending from prior sessions** | 5 items | $1.1M BS hygiene | MIXED |
| **AR collection candidates** | ~8 customers | $63K (91+ delinquent) | OWNER ACTION |
| **Equity cleanup** | 2 items | $855K BS hygiene | MEDIUM |
| **Sales tax verification** | 1 account | $40K | OWNER VERIFY |
| **Loans to Shareholders verify** | 1 account | $199K | OWNER VERIFY |
| **CC accounts — need statements** | 5 cards | $30K mostly Cabelas Cap One | LOW — verify only |
| **Income account anomalies** | 2 accounts | from our cleanup JEs | INFO |

---

## CRITICAL — Wrong-direction balances (immediate red flags)

These accounts have balances in the wrong direction for their type — strong signal of recording errors:

| Acct | Name | Type | Should be | Actual | $ |
|---|---|---|---|---|---|
| 131 | LOC Payable - Kubota | Other Current Liability (LineOfCredit) | Cr | **Dr** | $32,140.78 |
| 128 | Payable to Van | Other Current Liability (LoanPayable) | Cr | **Dr** | $7,000.00 |
| 97 | Direct Deposit Payable | Other Current Liability (DirectDepositPayable) | Cr | **Dr** | $6,088.69 |

All three are Liabilities currently showing as Assets. Likely one of:
- They've been overpaid (rare)
- Payments were recorded against them without the original payable being recorded
- Setup error where the account was used backwards

**Action:** investigate each to determine root cause. Likely needs JE correction.

---

## KNOWN PENDING — from prior session work

### 1. Process 24 unbooked bank-feed transactions (Jimmie UI) — $14,600 IN / $17,860 OUT
QBO Banking → For Review for RBFCU 9015. Detail in `afton_transfers_audit_report.md`. **Closes the $148K real-vs-book bank gap by recording the missing Feb-Apr 2026 owner contributions/distributions.**

### 2. Record 16 eDeposit batches — $43,010
Real customer CC payments deposited to RBFCU that were never recorded as Deposits in books. Need create_deposit MCP tool or UI work. Detail in `afton_acct61_bank_rec_report.md`.

### 3. Plug 23 held UF entries — $22,466
All 2026-dated, ready for the same proportional Income routing as JE 27062.

### 4. Investigate 156 unrecorded outflows + 81 phantom outflows — $49K + $82K
From bank rec. Likely small fees, expenses, transfers that need categorization sweep.

### 5. Bundle BS cleanup: Opening Balance Equity + Reconciliation Adjustments → Retained Earnings — $855K
- OBE acct 48: $55,839 Dr (historical setup-time imbalance)
- Reconciliation Adjustments acct 162: $800,070 Dr (historical equity plug from prior cleanups)
- Standard PPA: Cr each / Dr Retained Earnings. After: both accounts $0.

---

## AR — Validate the $135,463 open

### True delinquent (91+ days) — $63,383 of collection candidates

Top 91+ accounts that look like real collection work:

| Customer | 91+ $ | Total Open $ | Notes |
|---|---|---|---|
| **Jimmy Martinson** | $13,891 | $49,725 | Also has $35,833 in "current" — biggest customer balance. Worth a relationship conversation. |
| **Corbin** | $13,270 | $13,270 | All 90+ — known collection candidate per prior notes |
| **Audry Nelson** | $7,745 | $10,161 | Mostly 90+ — collection candidate |
| **Daniel Rivera** | $5,340 | $9,708 | Spread across all buckets |
| Jake | $3,865 | $3,865 | Apply $2,240 already noted as pending |
| Darcy | $2,595 | $2,595 | |
| Wesley Studdard | $1,925 | $1,925 | |
| Tamara Black | $1,621 | $1,621 | |

### Aging cleanup artifacts (small/negative balances — likely from our work)
| Customer | Balance | Likely cause |
|---|---|---|
| Debra Hazle | -$31.10 | From recovery invoice cleanup work |
| Pat Tons | -$16.91 | Likely overapplied payment historically |
| Bobby Husky | $0.14 | Rounding artifact |
| Mike Fischer | $0.41 | Rounding artifact |
| Shebin Sam | $0.07 | Rounding artifact |
| Jean Autrey | $68.00 | Possibly from dup-pair recovery |

**Action:** clean up these tiny/negative balances via write-off or apply-credit. Quick clean-up.

### Newer entries to verify
- Steven Williams: $1,218 in 90+ — we entered a $2,550 catch-up pmt for him on 5/13. Confirm this aging matches expectations.

---

## EQUITY — Validate balances

### Owner accounts
| Acct | Balance | Notes |
|---|---|---|
| 120 Owner's Distribution | $344,192 Dr (cumulative) | Driven by T. Bowen $1,500/wk + J. Bowen small recurring + AT &T transfers |
| 125 Owner's Investment | -$130,989 Cr | Reflects historical owner contributions |
| Net owner equity | -$213,203 cumulative outflow | Owner has taken out more than put in. Normal for established business. |

After processing the 24 unbooked transactions:
- Owner's Distribution gains ~$17,860 (T. Bowen + J. Bowen distributions)
- Owner's Investment gains ~$14,600 (J. Bowen contributions)

### Cleanup items (already on radar)
- **Opening Balance Equity** $55,839 Dr → zero via PPA
- **Reconciliation Adjustments** $800,070 Dr → zero via PPA

### Retained Earnings
- $1,393,657 Cr (cumulative) — accumulated profit history
- Will absorb the BS cleanups above

---

## LIABILITIES — Other items

### Sales Tax — Texas State Comptroller $40,028 Cr
Significant accumulated sales tax payable. **Verify against Texas Comptroller's website to ensure this matches actual liability.** If higher than expected, may have unpaid sales tax. If lower, books may be overstating liability.

### Payroll Liabilities — $25K total
| Sub-account | Balance |
|---|---|
| Federal Taxes (941/944) | $14,088 |
| Cronin Child Support | $4,737 |
| Child Support Withholding - CS | $3,504 |
| Federal Unemployment (940) | $941 |
| TX Unemployment Tax | $749 |
| IRS GARNISHMENT | $495 |
| Child Support - JH | $442 |
| Payroll Liabilities (root) | $0.02 (rounding) |

**Action:** verify each against actual payroll provider statements (Intuit Workforce). Stale balances should be investigated and paid or written off.

### Loans (Long-Term)
| Acct | Name | Balance | Status |
|---|---|---|---|
| 130 | Union Square ECM - Van | $41,855 Dr | Wrong direction — loans should be Cr |
| 138 | TD Auto Finance - Van 2020 | $38,251 Dr | Wrong direction — loans should be Cr |

**Wait — these are ALSO showing wrong direction.** Two long-term loans both as Dr is the same pattern as the current liabilities above. Need to verify against actual loan statements.

---

## ASSETS — Verify

### Loans To Shareholders — $198,557 Dr
This says the owner(s) owe Afton ~$199K. **Verify:** is this real (active shareholder loan) or historical accumulation that needs reclassification? If real, what's the repayment plan?

### Credit Card Receivables — $3,263 Dr
Small. Likely Stripe-style holding for pending CC settlements. Verify against processor reports.

### QuickBooks Tax Holding — $1,651 Dr
Likely sales tax collected via QBO Payments waiting to be remitted. Verify.

### UF — $60,566 Dr
Already cleaned to defensible state.

### Fixed Assets — $23,166 net
| Tools, Machinery & Equipment | $25,590 |
| Furniture | $3,177 |
| Machinery & Equipment (older acct 127) | $97 |
| Accumulated Depreciation | -$5,698 |

Acct 127 with $97 looks like a possibly-dormant duplicate of acct 137. Worth merging.

---

## CREDIT CARDS — Need statement verification

5 active cards on books. All had activity in the Feb-Apr 2026 gap window, so they weren't completely paused — but **without matching against real CC statements, we can't confirm books are accurate.**

| Acct | Name | Balance | YTD Txns |
|---|---|---|---|
| 135 | Cabelas Cap One (8831) | -$21,647 | 44 |
| 134 | Cap One Venture (5475) | -$6,550 | 92 |
| 144 | Southwest Credit Card | -$1,231 | 43 |
| 80 | Capital One Credit Card | -$828 | 5 |
| 57 | Business Gold Rewards | -$75 | 2 |

**Action:** pull most recent CC statements, do a quick balance reconcile against books for the high-balance ones (Cabelas $21K, Cap One $6.5K, Southwest $1.2K). Capital One ($828) and Business Gold ($75) are low priority.

---

## INCOME — Cleanup artifacts to be aware of

After today's PPA (JE 27064), the following income accounts have YTD activity that reflects our cleanup, not real business activity:

| Acct | Name | YTD Net | What it represents |
|---|---|---|---|
| 132 | Thryv Transactions | +$83,266 Cr | Real income with our $12K dup cleanup baked in |
| 49 | Services | +$24,128 Cr | Real income with proportional cleanup activity |
| 1 | Sales | **-$44,931 Dr** | Heavily negative — JE 27062 Dr'd this heavily; JE 27064 partly restored. Real underlying activity is small. |
| 55 | Uncategorized Income | -$3,200 Dr | Cleanup artifact mostly |
| 118 | QBPay Sales | +$2,361 Cr | Real activity |

**Action:** when running P&L for stakeholders, note that 2026 YTD income statement has ~$110K of in-scope cleanup adjustments mixed in. Use the Adjustment flag to filter if needed.

---

## What's NOT broken

These accounts look clean per the focused map and don't need attention:

- Most expense accounts ($95K total across 28 expenses) — normal payroll, materials, utilities
- 2 bank accounts (will be fine once 24 unbooked transactions processed)
- Most current liabilities (other than the 3 wrong-direction flagged above)

---

## Recommended execution order

### Wave 1 — Quick wins / unblocks (this week)
1. Jimmie processes 24 unbooked transactions in Banking For Review (~12 min)
2. Plug 23 held UF entries via proportional JE (~10 min Ledger work + 5 min approve)
3. Resolve 3 wrong-direction liability balances ($45K — investigate root cause)
4. Clean up tiny/negative AR balances (write off rounding artifacts)

### Wave 2 — Investigation + bigger cleanups (next week)
5. Riv adds create_deposit to MCP (unblocks proper Deposit transaction staging)
6. Record 16 eDeposit batches via the new tool (~$43K accuracy)
7. Categorization sweep on 156 unrecorded outflows + 81 phantoms
8. CC statement verification for Cabelas Cap One + Cap One Venture (largest balances)
9. Verify Texas Sales Tax accuracy
10. Verify Loans To Shareholders accuracy ($199K is significant)

### Wave 3 — Strategic balance sheet cleanup (when ready)
11. Bundle Equity cleanup PPA: zero OBE + Reconciliation Adjustments ($855K BS hygiene)
12. Verify both loan balances ($80K) match actual lender statements; fix direction
13. Review and clean Payroll Liabilities subledger
14. Collection calls on the 91+ AR ($63K — owner work)

### Out of scope (per Jimmie's 2025/2026 scope)
- $2.54M historical Income double-counting from direct-cash deposits — leave alone
- Pre-2024 UF stragglers — leave alone

---

## Confidence rating

**Are we caught up?** With this map, **yes** — assuming the items above are addressed. The unknown unknowns have been substantially reduced.

**Remaining risk areas:**
- Credit card statements not yet verified
- Texas Sales Tax not yet verified
- Loans To Shareholders not yet verified

These three areas could reveal additional cleanup if their source-of-truth doesn't match book balances. But they're the only material balances we haven't fully audited.