Freelancer Tax Organizer: Schedule C Prep from Bank CSVs

    1

    Sorts your own bank and card exports into Schedule C lines, with invoices, mileage and an estimated-tax worksheet, for your tax professional.

    Free

    Security scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    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 recorded9677.81
    Net profit before adjustments36878.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.

    LineLabelTotal
    8Advertising250.00
    9Car and truck99.42
    11Contract labor3730.00
    15Insurance412.00
    18Office expense198.26
    20bRent: business property325.00
    22Supplies2899.00
    23Taxes and licenses185.00
    24aTravel1030.93
    24bMeals456.10
    25Utilities92.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

    PeriodNet profitDue
    Jan-Mar12143.092025-04-15
    Apr-May624.322025-06-16 (weekend)
    Jun-Aug7175.032025-09-15
    Sep-Dec16935.902026-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.

    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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    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 forever

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 9 days ago

    • Free with an Agensi account

    Requires

    Python 3

    Permissions

    Terminal / Shell
    Read Files
    Write Files

    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.

    Listed9 days ago

    What's inside

    Frequently Asked Questions

    Bank and card CSV exports (it finds the header row and handles debit/credit columns, US or day-first dates and purchases shown as positive), plus an optional invoices file and an optional mileage log. Bank and card transactions are sorted into Schedule C lines by your own merchant map, where the longest match wins. An invoices file sets gross receipts, and the mileage log gives total business miles, and a deduction only if you supply the rate.

    This skill includes a standalone Python 3 script that runs locally, ensuring your sensitive financial data is never sent to a third-party cloud database. It is compatible with any AI agent capable of executing Python environments or local scripts.

    No. It organizes your own records and flags items that usually need a professional's judgment. It never decides what is deductible, never files, and never gives tax advice. Every report is labelled for review with your tax professional.

    SKILL.md (the agent's rules and workflow), scripts/organize.py (the organizer, Python standard library only), categories.example.json (a starter map of about 95 merchants to Schedule C lines that you extend) and reference.md (short notes that cite the relevant IRS publications).

    Figures that change every year are never built in as current. The mileage rate has no default, so the mileage deduction appears only when you pass the rate for that year, and tax is computed only from rates you supply. Due dates are worked out for the --year you pass.

    It lists every transaction your merchant map does not cover under uncategorized, with totals, so the agent can ask you where each belongs and run again. Separately, it raises review flags for items that need judgment even when they are categorized, such as meals, vehicle costs, home office, mixed personal and business use, large equipment and contractor payments.

    New in Finance & Accounting