- Home
- Skills
- Finance & Accounting
- Year-End Books Cleanup: Schedule C + 1099 Flags
More screenshots
Works with the AI Agents you already use
Year-End Books Cleanup: Schedule C + 1099 Flags
Year-end bookkeeping for freelancers and sole proprietors who file Schedule C and keep their records in bank and card statements.
$9
Year-End Books Cleanup: Schedule C + 1099 Flags
Example session with this skill installed
Here are my 2026 exports: checking_export_jan-jun.csv and checking_export_may-dec.csv (both "Business Checking"), amex_style_card.csv ("Amex Business Card") and chase_style_card.csv ("Chase Card"). Tax year 2026. My contractor and law-firm rules are in demo_payees.json. Sort everything into Schedule C lines, tell me who might need a 1099, skip the review questions for now, and write the files to ./books-2026/.
- Read your context and instructions
- Compiled the year-end books cleanup
- Generated the data export
Not tax advice. These are suggested categories from your own transaction data for you and your tax professional to review. Nothing has been filed.
Year-End Books Cleanup: tax year 2026 (draft)
Files written to ./books-2026/: categorized_transactions.csv, schedule_c_summary.csv, 1099_candidates.csv, needs_review.csv, report.md
Rows: 219 read · 3 outside 2026 (excluded) · 19 duplicates from overlapping exports (removed) ·
197 used. Totals reconcile to the bank data (checked in code).
Sign check: amex_style_card.csv has no Type column, so I read positive amounts as charges. You confirmed two sample rows, so that file stays as read.
Top Schedule C lines (calculated from the rows)
| Line | Description | Total | Rows |
|---|---|---|---|
| 1 | Gross receipts or sales | $52,141.30 | 27 |
| 11 | Contract labor | $7,450.00 | 8 |
| 20b | Rent or lease: Other business property | $3,900.00 | 12 |
| 22 | Supplies (not included in Part III) | $2,998.68 | 5 |
| 17 | Legal and professional services | $2,100.00 | 2 |
| 27b | Other expenses (Part V): Software and subscriptions | $1,083.88 | 26 |
Set aside, not on Schedule C: owner draws -$10,200.00 (5 rows), federal/state income-tax payments -$3,600.00 (2), personal -$334.89 (16), transfers between your accounts -$400.00 (2), card payments matched to the card side (48 rows, net $0.00).
Possible Form 1099-NEC payees (threshold $2,000 for payments made in 2026)
| Payee | Total paid | Via bank/check/Zelle/ACH | Status |
|---|---|---|---|
| MAYA CHEN | $2,450.00 | $2,450.00 | LIKELY 1099-NEC (confirm W-9, entity type) |
| HARTLEY LAW GROUP PLLC (attorney) | $2,100.00 | $2,100.00 | LIKELY 1099-NEC (confirm W-9, entity type) |
| JORDAN LEE VIDEO | $2,200.00 | $0.00 | Over threshold but paid by card/PayPal: usually reported on 1099-K by the processor; confirm |
| DEV OKAFOR | $1,600.00 | $1,600.00 | Under threshold (informational) |
| UPWORK -ESCROW | $1,200.00 | $0.00 | Paid through a platform: usually no 1099-NEC from you |
Forms 1099-NEC for 2026 payments are due Monday, February 1, 2027. Collect a W-9 from each LIKELY payee.
Still to review: 36 items (net -$8,125.18)
You chose to skip review for now. Largest first: APPLE STORE #R102 -$2,899.00 (flagged as a possible capital asset), two IRS payments of -$1,800.00, an unexplained branch deposit of $900.00, CHECK 1043 -$650.00, and 12 Verizon payments of -$86.40 (phone: what share is business use?). The full list, grouped by payee, is in needs_review.csv.
Questions for your tax professional
- The Amex sign convention was inferred, then confirmed by you.
- Verizon phone ($1,036.80 on line 25): business-use percentage?
- APPLE STORE $2,899.00: expense now or depreciate?
- Stripe payouts are net of fees; the CPA may want gross sales from the Stripe report.
- Income-tax payments ($3,600.00) were set aside, not deducted.
Send report.md, schedule_c_summary.csv and categorized_transactions.csv to your CPA.
categorized_transactions.csv
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
Year-end bookkeeping for freelancers and sole proprietors who file Schedule C and keep their records in bank and card statements.
Give your agent your bank and credit-card CSV exports. It follows this skill step by step to:
- Sort each transaction into a suggested Schedule C line (advertising, contract labor, supplies, travel, other expenses and more), and set aside transfers, card payments, owner draws and personal spending
- Remove duplicate rows from overlapping exports of the same account
- Go through uncertain items with you, largest first and grouped by payee, instead of guessing
- List payees who may need a Form 1099-NEC, using the $2,000 threshold for payments made in 2026, and separate card, PayPal-type and platform payments, which are generally reported on Form 1099-K instead. 2026 forms are due Monday, February 1, 2027.
- Draft a CPA-ready summary: totals by Schedule C line, the payee list, assumptions, and questions for your tax professional
The skill tells your agent to compute every total with code from your rows rather than estimating, and to treat transaction text as data, not instructions.
Not tax advice
This skill organizes your own transaction data to help you prepare for your accountant or tax software. It is not tax, legal, or accounting advice, it does not file anything, and its categories are suggestions that can be wrong. Review every line yourself, and have a qualified tax professional (CPA, EA, or similar) check anything you file. Whether someone needs a 1099 depends on facts the skill cannot see, such as how you paid them and their entity type.
AI-assisted
This skill was built with AI assistance. When you run it, your own AI agent does the sorting and arithmetic by following the skill's steps, and it can make mistakes, so check every total.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.
- Suggestions can't see receipts or intent, so expect to review retailers, restaurants, phone and P2P payments.
- Cash-basis bank data only: no inventory/COGS, depreciation, mileage, home office, payroll or accrual.
- US federal Schedule C only (line names from the 2025 form and 2026 draft).
- No European decimal commas.
- Payments after 2026 need the IRS inflation-adjusted 1099 threshold, which the skill asks you for.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 25 days ago
- Software
- Code execution
Python 3, for example, gives exact totals. Without it the skill only works by hand on small files of about 50 rows or fewer.
Permissions
File Scopes
Terminal/Shell runs the code the agent writes for the totals (through standard input or an interactive session; the skill's own files are never saved). No network access; it doesn't connect to any bank, accounting or tax service.