🔒

FPCS Tax HQ

Sign in with Google to access the dashboard

💬 Ask the Tax Bots

Ollama: Not Connected | Set up: ollama serve then configure endpoint below
DeductBot
Ask me anything about your 2022 taxes! Try: "How much did I spend at Home Depot?" or "What deductions am I missing?"

📊 FPCS Tax Command Center MAX Plan

Friendly PC Support, LLC — Daniel Marshall — 2022 Tax Year (Federal + Oregon)
MAIL DEADLINE: April 10, 2026 (USPS Certified)
Loading...

⚡ Token Economy & Agent Control Center

Claude Max Plan — $200/mo Billing resets: Model: Claude Opus 4.6
Last Minute
--
tokens
Last 10 Min
--
tokens
This Hour
--
tokens
Today Total
--
tokens
Est. $/Hour
--
at current pace
Session Usage
11%
of 5hr window
Session usage: 11% — Resets in 4h 37m Status: Comfortable headroom

💚 Token Heartbeat Monitor (simulated — feed real data via localStorage)

Rate: -- tok/min
Avg/hr: --
Peak: --
Idle: -- min ago
Trend: --
Usage Readings Log (click to expand)
Feb 18, ~16:4011% used| Reset in 4h37m | Session 4 start + DDBOT + dashboard build

Drop more readings here to calibrate token burn rate. Each reading helps estimate cost per task type.

AgentModelStatusMissionEst. Cost
Opus CMD claude-opus-4-6 Active Commander. Talks to James. Issues orders to The Sarge only. $0 (Max)
The Sarge SUP claude-opus-4-6 Active Supervisor. Dispatches to staff. Injection firewall. Low budget
Penny Pincher S1 claude-sonnet-4-6 Active UX & aesthetics. Visual polish, layout review. Minimal
SHIELD S2 claude-sonnet-4-6 Active Security sentinel. Injection hunting, machine security. Low (research)
DeductBot S3 claude-sonnet-4-6 Awaiting Tax deductions + Ollama sub-agents (miniDuct 1 & 2) ~$0.08/hr
Cruncher S4 claude-sonnet-4-6 Active Data analyst. Bank reconciliation, CSV cross-ref. Minimal
Scribbles S5 claude-sonnet-4-6 Active Documentation, reports, TurboTax input sheets. Minimal
DDBOT LOC Python (local) 5/5 Fixed Discrepancy detector. 2-pass fingerprint dedup. $0.00
TokenWatchBot DOG claude-haiku-4-5 Initialized Hourly efficiency audit. Feeds Heartbeat Monitor. ~$0.01/hr

🕵 DDBOT — Discrepancy Detector

5 Resolved 5 Warning 1 Info

Last scan: -- | Files: 15 | Checks: 10 | Fix: 2-pass dedup (925 CC dupes removed)

📜 Rules & Operating Guidelines

Custom rules that govern agent behavior, workflow, and decision-making. Rules persist across sessions via localStorage.

QBO Gross Income (2022)
$17,097.15
Services $14,727 + Sales $13,052 - AR $10,725 + Other $44
Total Business Deductions
$42,024.74
Down from $67,439 after dedup fix (925 dupes removed)
Net Business Loss
-$24,927.59
Income $17,097 - Deductions $42,025
DDBOT Findings
5 Resolved
5 critical fixed, 5 warnings, 1 info remain
Data Sources Processed
9 / 12
QBO, Ledger, Email, FPCS, Expenses done

⚡ Overall Progress

55%
Data Collection: 80% | Tax Prep: 45% | Filing: 0%
Target: Print & mail by April 10, 2026

🏆 The Great Tax Adventure of 2022

From "oh no we forgot to file" to "check's in the mail" — one checkbox at a time.

The Awakening: "Wait, We Never Filed 2022?"
Realized 4 years of taxes are unfiled. Panic level: moderate.
DONE
Operation Trello Rescue
Merged 60 job cards. 50 matches, 9 new entries discovered.
DONE
The Email Avalanche (63,587 emails)
Found 6,315 tax-relevant emails for 2022.
DONE
QuickBooks: The $17.50 Rescue Mission
Exported 143 vendors, 2,155 transactions before data expired.
DONE
The Great Cross-Reference
$625 in QBO not in ledger, $2,459 in ledger not in QBO.
DONE
1099 Hunt: Following the Paper Trail
Found 1099-K, TD Ameritrade 1099, AGT property report.
DONE
Schedule C Sorting Hat
2,284 emails categorized. 842 Amazon orders flagged.
DONE
DDBOT Activated: Audit Bot Awakens
Found 5 critical double-counts worth ~$8,600+.
DONE
Token Economy Dashboard
Live usage tracking, agent monitoring, settings control panel.
DONE
The Great Dedup: 925 CC Duplicates Slain
Built 2-pass fingerprint system. Deductions $67K → $42K. All 5 critical DDBOT findings resolved.
DONE
The Unified Ledger
Merge QBO GL + Sheets Ledger + FPCS Work into master document.
IN PROGRESS
Bank Statement Bingo: 7 Banks
Download/cross-reference with QBO.
PENDING
Amazon Archaeology: Biz or Shopping?
842 orders need classification.
PENDING
Contractor Chronicles
Mitchell, Waters, J. Marshall — 1099-NEC if >$600.
IN PROGRESS
Home Office (Form 8829)
Square footage, internet %, office deduction.
PENDING
Vehicle Deduction
100% biz use. GEICO + mileage or actual expenses.
PENDING
Cyberattack Deduction
AGT Mortgage incident — casualty/theft loss.
PENDING
TurboTax Data Entry
All Schedule C data into TurboTax 2022 Desktop.
PENDING
Final Review + Print + Mail
Triple-check, print, USPS Certified. We're DONE!
PENDING

📝 2022 Schedule C Expenses (Corrected — 925 CC dupes removed)

LineCategoryAmountTxnsStatus
8Advertising$23.181OK
9Car/Truck (Gas + Reg + Repairs)$3,239.6241Fixed (was $4,840)
11Contract Labor$10.001Check Venmo/bank
15Insurance (Vehicle)$422.541Fixed (was $845)
16bCC Interest$248.9017Fixed (was $1,618)
18Office Expense$1,024.1413OK
21Repairs$39.981OK
22Supplies + Small Tools + Costco$12,731.70125Fixed (was $33,933)
--Equipment/Depreciation (Furniture)$12,654.3926Review: 100% biz?
25Utilities (Phone + Internet)$1,066.3411Fixed (was $1,811)
27aOther Expenses (Fees/Subs/Ship)$7,919.51232Fixed (was $7,134)
--Meals (50% deductible)$97.3915Fixed (was $630)
--COGS/Inventory$2,595.7511OK
Total Business Deductions$42,024.74-37% from $67K
Dedup Fix Summary: 925 CC duplicate transactions identified & removed. QBO double-entry GL creates rows in BOTH expense sub-accounts AND CC/bank liability accounts. Pass-1/Pass-2 fingerprint dedup solved systemic double-counting.

💰 2022 Income (Schedule C)

SourceCategoryDetailsAmount
QBOTech Services21 invoices$14,726.50
QBOeBay Product Sales42 txns$13,051.65
QBOAccounts Receivable (offset)19 entries-$10,725.00
QBOClient Deposits (offset)7 entries-$180.00
QBOTip Revenue1 txn$174.00
QBOLate Fee Income1 txn$50.00
Gross Income (Schedule C)$17,097.15
Less: Business Deductions-$42,024.74
Estimated Net Business Income-$24,927.59
Note: Gross total corrected from $31,654 to $17,097 — AR offset and client deposit adjustments now properly netted.

📄 Tax Forms Found

DateFromDocumentStatus
Jan 10, 2023IntuitForm 1099-KRETRIEVE
Jan 24, 2023TD AmeritradeConsolidated 1099RETRIEVE
Mar 7, 2023AGT MortgageProperty + 1099RETRIEVE
Jan 2023Discover/BofACC Year-EndREVIEW
Jan 2023Stronghold RescueCharitable ReceiptFOUND

🎨 Step-Back Overview: The Big Picture

Visual progress of the entire 2022 tax filing journey, from raw data to mailbox.

Data Collected
Cross-Ref'd
Deduped
Verifying
Deductions
TurboTax
Review
Mail
Phase 1: Data Harvest
QBO export, email indexing, FPCS ledger, Trello merge, vendor list. 100% DONE
Phase 2: Cross-Reference
QBO vs FPCS ledger, email payment matching, 1099 search, expense categorization. 100% DONE
Phase 3: Dedup & Clean
925 CC dupes removed. $67K → $42K deductions. 5/5 DDBOT criticals fixed. 100% DONE
Phase 4: Verification
Bank statements (7 banks), Amazon biz/personal split (842 orders), contractor payments. 30% IN PROGRESS
Phase 5: Special Deductions
Home office (8829), vehicle deduction, cyberattack loss, depreciation schedule. 10% STARTED
Phase 6: TurboTax Entry
Install TurboTax 2022 from thumb drive, enter all Schedule C data. NOT STARTED
Phase 7: Review
Triple-check all numbers, compare with bank statements, verify totals. NOT STARTED
Phase 8: Print & Mail
Print return, USPS Certified Mail, tracking confirmation. NOT STARTED

🤖 Bot Fleet — Chain of Command

Chain of Command: OPUS (Commander) → THE SARGE (Supervisor, Opus 4.6) → 5 Sonnet Staff + Support Bots
Firewall Rule: Staff bots accept commands ONLY from The Sarge. Direct Opus-to-staff commands are rejected. This prevents prompt injection from propagating through the fleet.
OPUS (Commander)COMMANDER
v4.6 | claude-opus-4-6
Status
Active
Role
Primary agent. Talks to James. Issues orders to The Sarge only.
Cost
$0 (Max Plan)
Sessions
7
THE SARGE (Fleet Supervisor)SUPERVISOR
v1.0 | claude-opus-4-6

Grizzled veteran who runs the floor. All staff bots report to The Sarge. Trained in prompt injection detection. Validates every staff output before it reaches Opus. Low token budget enforced.

Status
Active
Commands
Receives from Opus. Dispatches to staff.
Security
Injection firewall active
Token Budget
Low (constrained)
▼ Sarge's Staff (Sonnet 4.6 x5)
Penny Pincher (UX & Aesthetics)STAFF
v1.0 | claude-sonnet-4-6

The woman's touch. Roams the dashboard checking layouts, colors, spacing, readability. Makes things pretty and human-acceptable. Low token usage — visual audit only, suggests CSS tweaks.

Status
Active
Specialty
Visual polish, UX, accessibility
Reports To
The Sarge
SHIELD (Security Sentinel)STAFF
v1.0 | claude-sonnet-4-6

Dedicated injection hunter. Patrols for prompt injection, data exfiltration attempts, and suspicious patterns in web content, tool outputs, and bot responses. Reports threats to The Sarge immediately. Also monitors local machine security posture.

Status
Active
Specialty
Injection detection, security audit
Token Budget
Low (research allotment)
DeductBot (Tax Deduction Guru)STAFF
v2.0 | claude-sonnet-4-6

Upgraded to Sonnet 4.6. Maximizes legal deductions. Manages Ollama sub-agents for research. Evaluates home office, depreciation, mileage, casualty losses (AGT cyberattack).

Status
Awaiting Deploy
Sub-Agents
2 (Ollama local)
Reports To
The Sarge
Cruncher (Data Analyst)STAFF
v1.0 | claude-sonnet-4-6

Number cruncher. Cross-references bank statements vs QBO, verifies income totals, reconciles expense categories. Batch-processes CSV data efficiently.

Status
Active
Specialty
Data verification, CSV analysis
Reports To
The Sarge
Scribbles (Documentation)STAFF
v1.0 | claude-sonnet-4-6

Keeps the paperwork tight. Writes TurboTax input sheets, updates SESSION_LOG, drafts reports. Compresses verbose outputs into clean summaries. The one who remembers everything.

Status
Active
Specialty
Reports, summaries, logs
Reports To
The Sarge
▼ Support & Local Bots
DDBOT (Discrepancy Detector)LOCAL
v1.0 | Python local
Status
5/5 Critical Fixed
Cost
$0.00
Findings
11 (5 resolved)
TokenWatchBot (Efficiency Auditor)WATCHDOG
v1.0 | claude-haiku-4-5

Independent auditor. Reports directly to The Sarge. Hourly token burn analysis across all bots. Flags waste, recommends compression. Feeds the Heartbeat Monitor.

Status
Initialized
Frequency
Every 1hr
Cost
~$0.01/hr
miniDuctBot1LOCAL
Ollama: mistral:7b
Status
Not Deployed
Specialty
Financial RAG
Cost
$0.00
miniDuctBot2LOCAL
Ollama: llama3.1:8b
Status
Not Deployed
Specialty
Deduction research
Cost
$0.00

🗃 Centralized Data Inventory & Status

Every data source for 2022, its location, format, and processing status.

Data Source
Format
Status
Location
QBO General Ledger (2022)
CSV (309KB)
PROCESSED
2022\qbo_export\QBO_GeneralLedger_2022.csv
QBO Full Export (all years)
XLSX zip
EXPORTED
2022\qbo_export\QBO_Export_20260218\
FPCS Work Ledger (revised)
XLSX
MERGED
2022\income\FPCS Work (revised).xlsx
Proton Email Index
CSV (25MB)
INDEXED
2022\email_data\proton_email_index.csv (63,587 emails)
2022 Tax Emails (categorized)
CSV
CATEGORIZED
2022\email_data\proton_emails_2022_tax.csv (6,315 relevant)
Expense Summary (corrected)
TXT
FINAL
2022\reports\2022_qbo_expense_summary.txt
Income Cross-Reference
TXT
COMPLETE
2022\reports\2022_income_crossref.txt
DDBOT Findings
JSON
5/11 FIXED
ddbot_findings.json
Google Sheets Ledger
Google Sheet
NEEDS MERGE
docs.google.com/...1IF-YeGRQGCuIk6... (tabs: Tech work, ledger 2022)
Bank Statements (7 banks)
PDF/CSV
NOT STARTED
Wells Fargo, Chase, CapitalOne, Citi, BofA, US Bank, First Tech
Amazon Orders (842)
Email/HTML
NEEDS REVIEW
In Proton email export, flagged but not classified biz/personal
1099 Forms (3 found)
PDF
RETRIEVE
Intuit 1099-K, TD Ameritrade 1099, AGT Mortgage 1099
TurboTax 2022
Software
NOT INSTALLED
On thumb drive. Judith's personal data partially entered.
Google Drive __TAXES
Folder
REMOTE ONLY
drive.google.com/...1wi0OL0J... (2022 subfolder has receipts, docs)
Physical Receipts
Paper
NOT SCANNED
Box of receipts for verification against ledger

🔗 Integrations & Tools

External services connected (or planned) for the FPCS 2022 tax project.

🐙 GitHub CONNECTED
Code repo for tax scripts, dashboard, and bot configs. Version control for all project files.
Use: scripts, dashboard versioning, issue tracking
📊 Google Sheets NEEDS MERGE
FPCS Work ledger (Tech work, ledger 2022 tabs). Cross-ref with QBO for unified ledger.
Use: ledger merge, income verification, live data sync
📋 Jira PLANNED
Project/task tracking. Replicate Trello board for tax prep milestones and bot assignments.
Use: task board, sprint tracking, bot mission queues
📋 Trello ACTIVE
Current task board for tax prep. Will migrate to Jira for better automation and bot integration.
Use: current task tracking (migrating to Jira)
📦 QuickBooks Online EXPORTED
Full GL export processed. Read-only access until ~April 2, 2026. API integration planned.
Use: GL data (exported), potential API for live queries
📶 Ollama (Local AI) NOT RUNNING
Local LLM server for DeductBot agents. Mistral 7B + Llama 3.1 8B. Needs ollama serve.
Use: chat queries, DeductBot sub-agents, free inference
📩 Proton Mail INDEXED
63,587 emails exported and indexed. 6,315 flagged as 2022 tax-relevant. Do NOT re-index.
Use: receipt verification, 1099 retrieval, Amazon orders
💾 Google Drive REMOTE ONLY
__TAXES folder with 2022 subfolder containing receipts and docs. Needs local sync review.
Use: receipt storage, document backup, shared access
💻 TurboTax 2022 NOT INSTALLED
Desktop version on thumb drive. Paper-file only (cannot e-file late returns). ~60-90 min entry.
Use: final filing (manual data entry from our summaries)
💬 Slack / Discord OPTIONAL
Bot notifications and alerts. TokenWatchBot could push hourly reports here if configured.
Use: bot alerts, status notifications (optional)
👁 Notion / Confluence OPTIONAL
Knowledge base for tax research, deduction strategies, and DeductBot findings wiki.
Use: research wiki, DeductBot knowledge base (optional)
🔧 ClickUp AVAILABLE
Alternative to Jira for task management. Connected via MCP. Can supplement or replace Trello/Jira.
Use: task management alternative, document storage

☑ Data Collection Checklist

What we have, what we still need, and exactly where to find it.

COLLECTED (ready to use)

QBO General Ledger (2,155 transactions)
C:\Users\James\__Taxes\2022\qbo_export\QBO_GeneralLedger_2022.csv
QBO Full Export (P&L, Balance Sheet, Vendors, Journal)
C:\Users\James\__Taxes\2022\qbo_export\QBO_Export_20260218\
FPCS Work Ledger (22 entries, merged from Trello)
C:\Users\James\__Taxes\2022\income\FPCS Work (revised).xlsx
Proton Email Archive (63,587 emails, 6,315 tax-relevant 2022)
C:\Users\James\Downloads\proton-mail-export-cli-windows_x86_64 (1)\marshalldanman@proton.me\
QBO Vendor List (143 vendors)
2022\reports\2022_profit_and_loss.txt
Expense Summary (corrected, 925 dupes removed)
C:\Users\James\__Taxes\2022\reports\2022_qbo_expense_summary.txt

PARTIALLY COLLECTED (need action)

Google Sheets Ledger (Tech Work + Ledger 2022 tabs)
WHERE: Google Sheet | ACTION: Merge into unified ledger with QBO data
Contractor Payments (Mitchell, Waters, J. Marshall)
WHERE: Venmo/PayPal transaction history, bank statements | ACTION: Verify if >$600 total per person for 1099-NEC
1099 Forms (3 identified, not downloaded)
WHERE: Intuit account, TD Ameritrade portal, AGT Mortgage email attachment | ACTION: Download PDFs

STILL NEEDED (requires James's action)

Bank Statements from 7 banks (2022 full year)
WHERE: Online banking portals | Wells Fargo, Chase, CapitalOne, Citi, BofA, US Bank, First Tech FCU | ACTION: Download CSV/PDF for Jan-Dec 2022
Amazon Order History (842 orders need biz/personal split)
WHERE: amazon.com/gp/css/order-history → Download order reports | ACTION: Export 2022, classify biz vs personal
Home Office Info (Form 8829)
WHERE: Physical measurement of home office | ACTION: Square footage of office vs total home, % internet use for business
Vehicle Mileage or Actual Expenses
WHERE: Google Maps timeline (if enabled), GEICO policy for annual miles | ACTION: Choose mileage vs actual method
TurboTax 2022 Installation
WHERE: Thumb drive (James has it) | ACTION: Install on PC, open Judith's partially-entered return
Cyberattack Documentation (AGT Mortgage)
WHERE: Email from AGT/David re: Marion County property report + 1099 | ACTION: Gather loss documentation for casualty/theft deduction
Physical Receipt Box Scan
WHERE: Physical box of receipts | ACTION: Scan or photograph, cross-reference against QBO categories

💻 TurboTax 2022 — Filing Progress & ETA

Filing ETA
Mar 15-22
~25-30 days from now
Safety Margin
19+ days
before April 10 mail deadline
TT Entry Time
~60-90 min
once all data is finalized

TurboTax Data Entry Steps

1
Income: Schedule C gross receipts
$17,097.15 total. Services $14,727 + Sales $13,052 - AR $10,725. DATA READY
2
COGS: Cost of goods sold
$2,595.75 inventory. DATA READY
3
Expenses: Lines 8-27a
All 13 categories totaled from corrected expense summary. DATA READY
4
Vehicle: Line 9 detail
Choose mileage ($0.585/mi) or actual expenses ($3,240). Need mileage log. NEEDS INFO
5
Home Office: Form 8829
Need sq footage of office vs home, utility amounts. NEEDS INFO
6
Depreciation: Form 4562
$12,654 furniture. Determine if Section 179 or standard depreciation. NEEDS REVIEW
7
Self-Employment Tax: Schedule SE
Auto-calculated by TurboTax from Schedule C net. AUTO
8
Oregon Return: Form OR-40
Federal data flows through. Oregon additions/subtractions. AFTER FEDERAL
9
Print, Review, Sign, Mail
USPS Certified Mail to IRS + OR DOR. Keep tracking numbers. FINAL STEP

✅ TurboTax Input Sheet — CREATED

File: 2022/reports/TURBOTAX_INPUT_SHEET.txt — Every Schedule C line mapped with amounts, sources, and action items.

READY TO ENTER
11 lines
Lines 1,2,4,6,8,16b,18,21,22,24b,27a
NEEDS DECISION
4 lines
Vehicle method, Depreciation, Insurance, Utilities split
NEEDS JAMES INFO
7 items
Contractors, licenses, home office, mileage, 1099s, EIN, start date
Vehicle Deduction Comparison
Option A: Actual Expenses
$3,662
Gas $2,616 + Reg $368 + Repair $256 + Ins $423
+$7,616 if vehicle Sec 179 = $11,278 total
Option B: Standard Mileage
$0.585/mi
10K mi = $5,850 | 15K mi = $8,775 | 20K mi = $11,700
⚠ James must provide mileage log

🔭 SCOUT Bot Recommendations

Research findings from SCOUT (Haiku-powered, $0.02/run) on dashboard design, bot communication, context survival, and tax filing.

Dashboard: Add quarterly tax obligation estimates
Pro tax dashboards (Drake, CCH) emphasize tax-owing projections. Since we show a -$24,928 net loss, estimate the actual tax impact: SE tax savings, potential refund from loss carryback.
Bot Comms: Use shared SQLite + JSON-RPC for agent messaging
Create agents.db with tables for agent_messages, shared_state, task_queue. Each bot reads its inbox atomically. Cheaper than API-based orchestration.
Context Survival: Session handoff JSON with file manifest
Create tax_session_handoff.json with: progress state, completed forms, remaining work, key metrics, and explicit "files to load next session" list. Load this + SESSION_LOG.md first thing each session.
✅ TurboTax: Pre-fill a "TurboTax Input Sheet" before data entry
DONE (Session 8) — Created TURBOTAX_INPUT_SHEET.txt with all Schedule C lines, amounts, sources, vehicle comparison, home office guide, and entry checklist. 11 of 15 lines ready to enter.
QBO API: Free Builder tier (500K calls/mo) for live data access
python-quickbooks library + OAuth2 private app. No publishing needed. Would give live access to all historical data while QBO subscription is active (expires ~April 2026).

📜 Session 4 Closeout — Next Session Pickup Guide

Everything needed to resume work in the next session.

Files to Load First (Context Guard Protocol)

1. MEMORY.md — Quick-reference project brain (read this FIRST)
2. CLAUDE.md — Project rules, token discipline, scoped work protocol
3. SESSION_LOG.md — Full project history (5 sessions)
4. .claudecodeignore — Blocks 63K email files + workpapers from context
--- only if needed for specific tasks ---
5. dashboard.html — Live dashboard (read specific sections, not all 1338 lines)
6. ddbot_findings.json — Current audit findings
7. 2022\reports\2022_qbo_expense_summary.txt — Corrected expenses

Where We Left Off

Completed in Session 4:
• QBO expense categorizer built + rewritten with 2-pass dedup (925 CC dupes removed)
• Deductions fixed: $67,439 → $42,025
• DDBOT created: 11 findings, 5 critical all resolved
• Dashboard built with Token Economy, DDBOT panel, Rules Engine, all 7 overview sections
• SCOUT research bot deployed for best practices
• Bot fleet profiled with versions and performance ratings

Priority Tasks for Next Session:
Create TurboTax Input Sheet — Single-page summary of every number TT needs
Unified Ledger — Merge QBO GL + Google Sheets Ledger + FPCS Work
Vehicle decision — Mileage ($0.585/mi) vs actual expenses ($3,240)
Home office calc — Needs sq footage from James
QBO API setup — If James wants live data access (free tier available)
Tax Auditor bot + Manager Bot — Architecture design per James's request

Key User Instructions (all sessions)

See: SESSION_LOG.md lines 24-42 (instructions 1-16) and lines 265-272 (instructions 17-23)
See: logs\session1_user_instructions.txt for full original messages
See: Rules Engine (above) for runtime rules — Rule #1: Ask for help when stuck > 1 minute