Finance Data Checklist

22High Priority
40Remaining
3Done
43Total
# Priority Category Task How Effort
1 HIGH Bank Exports Download fresh Wells Fargo credit card statement for card ending 4348 (Platinum Card)
You pay $650/mo to this card but we can't see what's charged to it. Could be $7,800/year in hidden expenses.
WF.com → Card ending 4348 → Statements → Download CSV → save to Downloads 5 min
2 HIGH Bank Exports Download fresh WF credit card statement for card ending 9296 (Active Cash Visa)
$600/mo in payments, charges invisible.
WF.com → Card ending 9296 → Statements → Download CSV 5 min
3 HIGH Bank Exports Download fresh WF credit card statement for card ending 2433 (Autograph Visa)
$200/mo in payments, charges invisible.
WF.com → Card ending 2433 → Statements → Download CSV 5 min
4 HIGH Bank Exports Download fresh WF credit card statement for card ending 7763 (Active Cash Visa #2)
$60/mo in payments, charges invisible.
WF.com → Card ending 7763 → Statements → Download CSV 5 min
5 MEDIUM Bank Exports Download PayPal transaction history (all of 2025)
Multiple PayPal charges in FNB and WF. Can't identify vendors/amounts without PayPal-level data.
paypal.com → Activity → Download → All Transactions → Date range: Jan 1 2025 to today → CSV 5 min
6 MEDIUM Bank Exports Download Cash App transaction history
Cash App deposits in BoA ($480, $940, etc.) — can't identify who sent the money or why.
Cash App → Activity tab → Export → CSV 5 min
7 LOW Bank Exports Download fresh Chase credit card statement
Confirmed "Whole Foods only" — small impact. Already have 6 transactions from Transaction.csv.
Chase.com → Statements → Download CSV for 2025 5 min
8 LOW Bank Exports Download fresh First National Bastrop 2026 Q1
The fnb2025AccountHistory.csv covers through 3/30/2026 but a fresh export would catch the last 10 days.
FNB online banking → Account History → Export CSV 5 min
10 HIGH Debt Balances Get total balance owed on WF Platinum Card (4348)
Need for balance sheet. Currently marked "Unknown."
WF.com → Card 4348 → Current balance. Write it down. 2 min
11 HIGH Debt Balances Get total balance owed on WF Active Cash (9296)
Balance sheet gap.
WF.com → Card 9296 → Current balance 2 min
12 HIGH Debt Balances Get total balance owed on WF Autograph (2433)
Balance sheet gap.
WF.com → Card 2433 → Current balance 2 min
13 HIGH Debt Balances Get total balance owed on WF Active Cash #2 (7763)
Balance sheet gap.
WF.com → Card 7763 → Current balance 2 min
14 HIGH Debt Balances Get total balance owed on Chase credit card
Balance sheet gap.
Chase.com → Account → Current balance 2 min
15 HIGH Debt Balances Get total balance owed on BoA credit card (CRD 0001)
$300/mo payments, total balance unknown.
BoA.com → Credit Card → Current balance 2 min
16 HIGH Debt Balances Get GreenSky loan total remaining balance + interest rate + payoff date
$432/mo loan — don't know total owed or what it's for.
GreenSky portal or call 866-936-0602 10 min
17 DONE Debt Balances Get Sheffield Financial total remaining balance
Swim spa loan. $28,000 remaining at ~$1,050/mo.
Paul confirmed April 10.
18 HIGH Debt Balances Get Hyundai Motor Finance (HMF) remaining balance + payoff date
$1,795/mo car payment — total owed and term remaining unknown.
hmfusa.com or call 800-523-4030 10 min
20 HIGH Property/Insurance Confirm the two Germania Insurance policies — what each covers
$586 + $586/mo = $1,172/mo. One is probably property/landlord, other is vehicle. Which is which?
Call Germania or check policy docs. Write down: policy #, coverage type, premium, renewal date. 15 min
21 HIGH Property/Insurance Get property insurance details for 180 Ladybug Lane
Is there a separate homeowner/landlord policy beyond Germania? Mortgage lender may require specific coverage.
Check mail/email for insurance renewal notices, or call Germania. 10 min
22 MEDIUM Property/Insurance Confirm: is there a mortgage on 180 Ladybug Lane?
The $2,038 + $1,024 bank checks in January are unidentified. Could be mortgage payments.
Tell Claude what the Jan 7 bank checks ($2,037.94 and $1,023.97) were for. 1 min
23 MEDIUM Property/Insurance Get property tax details for Hot Springs AR property
If you own the Hot Springs property, there are AR property taxes too. Only Bastrop County taxes are in the data ($1,847/yr).
Check Garland County AR tax records or prior year tax return. 10 min
30 DONE Income Verification Confirm Paul's Social Security amount
$1,206/month deposited to First National Bastrop.
Paul confirmed April 10.
31 DONE Income Verification Confirm Dorothy's Social Security amount
$2,300/month deposited to WF 8517.
Paul confirmed April 10.
32 HIGH Income Verification Explain TC Vintage Park LLC payments (~$2,500/mo)
$2,500/mo from TC Vintage Park LLC via Zelle to WF 2225. Who is this? What is it for? Is it guaranteed? When does it end?
Tell Claude what TC Vintage Park LLC is. 1 min
33 HIGH Income Verification Explain Cindy Rents LLC payments (~$1,470/mo)
~$1,470/mo from Cindy Rents LLC via Zelle. Combined with TC Vintage Park = ~$3,970/mo. Paul says ends in ~2 years. Need details.
Tell Claude what Cindy Rents LLC is and exactly when payments end. 1 min
34 MEDIUM Income Verification Identify Cash App income senders in BoA
Multiple "CASH APP*PAUL" deposits ($480, $940, $440, etc.). Who are these from?
Open Cash App → Activity → identify each deposit sender. Report to Claude. 10 min
40 HIGH Subscriptions Audit: do you still need Google Speechify at $107/month?
This is one of the most expensive subscriptions. Text-to-speech — do you use it daily?
If not using regularly, cancel at speechify.com. Saves $1,284/year. 2 min
41 HIGH Subscriptions Audit: are you paying for Claude AI twice? ($89 + $21 = $110/mo)
Two Anthropic charges on WF 9970. One is Max ($89), the other might be an old Pro plan or API credits.
Check claude.ai/settings → Billing. If two active subscriptions, cancel the one you don't need. 5 min
42 MEDIUM Subscriptions Audit: do you need LinkedIn Premium at $37/month?
$444/year. Are you actively recruiting, job searching, or using Premium features?
If not using InMail/insights regularly, downgrade to free LinkedIn. 2 min
43 MEDIUM Subscriptions Audit: do you need X (Twitter) Blue at $9/month?
$108/year for verification badge + longer posts. Worth it for your use case?
If not actively posting on X, cancel at x.com/settings. 2 min
44 MEDIUM Subscriptions Audit: do you need YouTube TV at $99/month?
$1,188/year. Do you watch enough live TV to justify this vs. a cheaper streaming bundle?
Consider switching to a basic plan or dropping for antenna + individual streaming services. 5 min
45 LOW Subscriptions Audit: Modern Storage at $182/month
$2,184/year for a storage unit. What's in there? Is it worth $182/mo or could contents be sold/donated/moved home?
Visit the storage unit. Inventory what's inside. Decide keep/sell/donate. 2 hrs
50 MEDIUM Tax Prep Gather 2025 1099 for Daniel "DJ" Weems
You issued him a 1099 for $14,400 in 2025. Need copy for your own tax filing.
Check your records or Freshbooks for the 1099 copy. 10 min
51 MEDIUM Tax Prep Gather all W-2s and 1099s received for 2025 tax filing
SS-1099 from SSA, any 1099-INT from banks, any 1099-MISC from other sources.
Check mail for January/February tax documents. Download from SSA.gov, bank portals. 30 min
52 MEDIUM Tax Prep Compile rental income for 2025 Schedule E
Need total rent collected by tenant for the full year 2025.
Freshbooks general_ledger.csv has this, or Claude can compute from bank data. 15 min
53 MEDIUM Tax Prep Compile deductible expenses for 2025 Schedule E
Property taxes, insurance, maintenance, Daniel's 1099, repairs, utilities. The combined ledger has most of this.
Filter the combined ledger by expense category for 2025. Export CSV for your CPA. 30 min
60 HIGH Accounts Receivable Collect Tim Squire's March rent ($660)
Overdue 10+ days. He's ignoring messages.
In-person ask. If still silent after 48 hours, written notice. 5 min
61 HIGH Accounts Receivable Collect Stephen Hood's March rent ($640)
Overdue 10+ days. Probably normal late, not ignoring.
Text or in-person gentle reminder. 2 min
62 HIGH Accounts Receivable Send Bergeron $800 invoice to Nancy
Draft sitting in Gmail Drafts since April 7. 5+ days overdue on Net 14 terms.
Open Gmail Drafts → find the invoice email to nancybergeron@kw.com → review → hit Send. 1 min
70 HIGH Unknowns What are the $2,038 + $1,024 bank checks from January 7?
Two large "PURCHASE BANK CHECK OR DRAFT" entries in WF 2225 on 1/7/2026 totaling $3,062. Mortgage? Insurance? Something else?
Tell Claude what these were for. 1 min
71 MEDIUM Unknowns What is "TRB Donnie Stark" in Vermont? ($58/month recurring)
$696/year going to someone named Donnie Stark in Vermont via WF 2225.
Tell Claude what this payment is for. 1 min
72 MEDIUM Unknowns Why is Wyze Labs $125-211/month?
Security camera subscription is usually $10-15/mo. $125-211/mo suggests hardware purchases mixed in.
Check wyze.com account → Billing → what subscriptions + recent hardware orders. 5 min
73 LOW Unknowns What is "Bastrop Co Womens" ($55)?
One-time charge on WF 8517 from "BASTROP CO WOMENS." Donation? Membership? Event?
Ask Dot what this was. 1 min
Updated April 10, 2026 · Check items off as you complete them (saves to browser localStorage)