- Home
- Skills
- Finance & Accounting
- Freelancer Tax Organizer: Schedule C Prep from Bank CSVs
Freelancer Tax Organizer: Schedule C Prep from Bank CSVs
Sorts your own bank and card exports into Schedule C lines, with invoices, mileage and an estimated-tax worksheet, for your tax professional.
Free
Works with the AI Agents you already use
Freelancer Tax Organizer: Schedule C Prep from Bank CSVs
Example session with this skill installed
I'm a freelance designer. Here are my 2025 business checking and credit card statements and my mileage log. Can you sort everything into Schedule C categories for my accountant and tell me when my quarterly payments were due?
- Read your context and instructions
- Compiled the freelancer tax organizer
For review with your tax professional.
Plan: write categories.json (your merchant map) next to your CSVs, then organize 2025. Card purchases read positive (90.0%), so it gets --flip-sign.
1. The first run fell short
The starter map left 11 client deposits (43500.00) uncategorized, so gross receipts were only 3656.15 and net profit -2122.64. You confirmed the two clients as income, K Patel Studio as contract labor, Harbor Steakhouse as meals and the Amazon order as office expense.
2. Headline (rerun with categories.json)
| Gross receipts (13 deposits mapped to income) | 46556.15 |
| Expenses as recorded | 9677.81 |
| Net profit before adjustments | 36878.34 |
| Left out: transfers / personal / tax payments | -1000.00 / -15.49 / -7500.00 |
Net profit is before the meals limit, business-use shares and depreciation.
| Line | Label | Total |
|---|---|---|
| 8 | Advertising | 250.00 |
| 9 | Car and truck | 99.42 |
| 11 | Contract labor | 3730.00 |
| 15 | Insurance | 412.00 |
| 18 | Office expense | 198.26 |
| 20b | Rent: business property | 325.00 |
| 22 | Supplies | 2899.00 |
| 23 | Taxes and licenses | 185.00 |
| 24a | Travel | 1030.93 |
| 24b | Meals | 456.10 |
| 25 | Utilities | 92.10 |
3. Questions for your accountant
- Meals (4,
-456.10): which had a business purpose, and who attended? [Meals - Pub 463] - Equipment (B&H Photo
-2899.00): supply, or depreciated property? [Equipment and depreciation - Pub 946] - Contract labor (3,
-3730.00): does K Patel Studio need a 1099-NEC? [Contractors and 1099s - Pub 334]
Vehicle: 221 business miles on 5 trips plus -99.42 of fuel. Standard rate or actual costs? One trip lacks a purpose. [Vehicles and mileage - Pub 463]
- Mixed use (Verizon, Amazon,
-226.37): what is the business share? - Zelle from M Ortiz (
600.00, uncategorized): income or personal?
4. Estimated-tax periods
| Period | Net profit | Due |
|---|---|---|
| Jan-Mar | 12143.09 | 2025-04-15 |
| Apr-May | 624.32 | 2025-06-16 (weekend) |
| Jun-Aug | 7175.03 | 2025-09-15 |
| Sep-Dec | 16935.90 | 2026-01-15 |
Uneven profit is why the annualized method exists [Estimated tax - Pub 505].
Next steps
- Give me the IRS mileage rate for 2025, your own planning rate and last year's total tax, for the mileage, tax and safe-harbor lines.
- An organized summary of your own records for review with your tax professional, not tax advice or a return.
Connects securely to your tools. The creator never sees your data.
About this skill
Point your agent at your bank and card CSVs, plus optional invoices and a mileage log. A local standard-library Python script sorts every bank and card transaction into Schedule C expense lines using your own merchant map, totals gross receipts with transfers left out (or from your invoices file), totals business miles, lists anything uncategorized, and flags items that usually need a professional's judgment: meals, vehicle, home office, mixed use, large equipment and contractor payments. The estimated-tax worksheet uses the IRS payment periods, with due dates moved for weekends and holidays noted. Every figure comes from the script, every flag cites an IRS publication, and the mileage rate and any tax rates always come from you. It organizes; it never decides deductions, files or gives tax advice. Output is labelled for review with your tax professional.
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.
US Federal Schedule C only. No state/local tax or corporate filings. User must provide annual IRS rates. No automated deduplication of overlapping CSV rows.
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
Free to use
No account required to browse
Trust & safety
Security scan
Security scan passed 9 days ago
- Free with an Agensi account
- Software
Python 3
Permissions
Runs the bundled scripts locally on the files the user names. Writes output only inside the user's project, after asking, and makes no network requests.