Square Import Agent Skill

by openaccountant

> Import Square sales CSV exports with tips, refunds, and fee handling.

1.1k tokens

context cost

SKILL.md, read when the skill is used

files

instructions only

copies elsewhere

how many repositories repackaged it

101

stars on the repo

on the repository, not the skill itself

Install

one command, takes just this skill from the repository

npx skills add https://github.com/openaccountant/skills --skill square-import

The instruction itself

10 sections, as written by the author

Square Import

Overview

Import transaction data from Square POS CSV exports. Handles sales, tips, refunds, and Square processing fees. Maps Square's item-level detail into Open Accountant's transaction format.

Wilson Tools Used

transaction_search — check for existing Square transactions to prevent duplicates
categorize — assign categories to imported Square transactions
export_transactions — export reconciled Square data

Column Mapping

| Square CSV Column | Open Accountant Field | Notes |

|---|---|---|

| Date | date | Transaction date |

| Time | — | Not stored |

| Transaction ID | reference_id | Square payment ID for dedup |

| Description or Item | description | Item or payment description |

| Gross Sales | amount | Total before fees (positive = income) |

| Tips | amount (separate row) | Tip amount (positive = income) |

| Processing Fees | amount (separate row) | Square fee (negative = expense) |

| Refunds | amount (separate row) | Refund amount (negative) |

| Net Sales | — | Calculated, not stored directly |

| Payment Method | notes | Cash, card, etc. |

Workflow

Ask the user for the Square CSV file path.
Parse the CSV and validate Square column headers.
For each transaction row, create up to four entries:
Sale: gross sales amount (positive), category "Revenue:Sales"
Tips: tip amount (positive), category "Revenue:Tips" (if > $0)
Fee: processing fee (negative), category "Fees:Payment Processing" (if > $0)
Refund: refund amount (negative), category "Revenue:Refunds" (if > $0)
Cash transactions have $0 processing fees — still import the sale.
Deduplicate using Square Transaction ID.
Preview the import summary: total sales, total tips, total fees, total refunds, net.
Insert transactions and confirm.

Without Wilson

To work with Square exports manually:

Downloading from Square

Log in to squareup.com (Square Dashboard)
Go to Transactions (left sidebar)
Click Export (top right, or the download icon)
Select date range
Choose Transactions CSV (not Items CSV — that's inventory)
Download
Alternative: Reporting > Sales > Export for summary-level data

Manual Processing in a Spreadsheet

Open the CSV in Google Sheets or Excel.
Separate revenue streams:
Column E: Gross Sales (your product/service revenue)
Column F: Tips (income, not taxed the same as sales in some jurisdictions)
Column G: Processing Fees (expense)
Column H: Refunds (negative revenue)
Create separate category rows (or use multiple category columns):
For each row with a tip > $0, create a new row for the tip amount
For each row with a fee > $0, create a new row with the negative fee
Summary formulas:

   Gross Sales:       =SUM(E:E)
   Total Tips:        =SUM(F:F)
   Total Fees:        =SUM(G:G)
   Total Refunds:     =SUM(H:H)
   Net Revenue:       =GrossSales + Tips - Fees - Refunds
   Effective Fee %:   =TotalFees / (GrossSales + Tips) * 100
   Avg Transaction:   =GrossSales / COUNTA(D:D)

Reconcile with bank: Square deposits funds daily or weekly. Sum Net Sales between deposit dates and match against your bank statement.

Square Reports (No Export Needed)

Square Dashboard has built-in reports at Reporting > Sales Summary that show gross sales, fees, and net by day, week, or month. Use these for quick reference without exporting.

Important Notes

Square CSV exports can be either transaction-level or item-level. This skill expects transaction-level exports. Item-level exports have one row per item per sale, which requires grouping by Transaction ID first.
Tips are separated because they may have different tax treatment than sales revenue.
Cash transactions appear in Square if rung through the POS but have $0 processing fee. These are still imported.
Square deposits to your bank are net of fees. Do not import deposit rows from your bank as Square revenue — use this skill for the gross breakdown instead.
If you use Square for both in-person and online sales, both appear in the same export.

Other skills for the same job

different authors, same section of the catalogue

XLSX

by anthropics

vendor ×17

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas

Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like \"the xlsx in my downloads\") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.

Picks random winners from lists, spreadsheets, or Google Sheets for giveaways, raffles, and contests. Ensures fair, unbiased selection with transparency.

Query openFDA API for drugs, devices, adverse events, recalls, regulatory submissions (510k, PMA), substance identification (UNII), for FDA regulatory data analysis and safety research.

MATLAB and GNU Octave numerical computing for matrix operations, data analysis, visualization, and scientific computing. Use when writing MATLAB/Octave scripts for linear algebra, signal processing, image processing, differential equations, optimization, statistics, or creating scientific visualizations. Also use when the user needs help with MATLAB syntax, functions, or wants to convert between MATLAB and Python code. Scripts can be executed with MATLAB or the open-source GNU Octave interpreter.

UMAP dimensionality reduction. Fast nonlinear manifold learning for 2D/3D visualization, clustering preprocessing (HDBSCAN), supervised/parametric UMAP, for high-dimensional data.

Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like \"the xlsx in my downloads\") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.

Creating interactive data visualisations using d3.js. This skill should be used when creating custom charts, graphs, network diagrams, geographic visualisations, or any complex SVG-based data visualisation that requires fine-grained control over visual elements, transitions, or interactions. Use this for bespoke visualisations beyond standard charting libraries, whether in React, Vue, Svelte, vanilla JavaScript, or any other environment.

5.4k tokens

How to use it

Copy the folder

Take openaccountant/square-import from the repository into ~/.claude/skills for personal use, or into .claude/skills inside a project.

Check the name does not clash

The agent identifies a skill by the name field in its header. Two skills with the same name cannot sit side by side — one of them will be ignored.