The Scenario
You are the owner of a boutique. It is the first of the month and your accountant needs last month's transaction detail by 9 AM Thursday for the bookkeeping close.
Your Square dashboard has everything, but what your accountant needs is an Excel workbook with date, amount, currency, card brand, and status for every payment in the month, formatted consistently and ready for import. The CSV export from Square's dashboard is close but never exactly right: column names are wrong, there are summary rows at the bottom that break the import, and the date column comes through as text rather than a real Excel date.
The bad version of this workflow:
- Log into Square, go to Reports, set the date range, export CSV
- Open the CSV in Excel, find the column names are wrong again
- Rename six columns by hand
- Delete the summary rows at the bottom
- Reformat the date column so Excel recognizes it as a date
- Email the file, get a reply that the currency column is missing
- Start over from the CSV because you already closed the file.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads your Square account and writes the transaction data exactly where you need it, with the columns your accountant asked for.
Open the SheetXAI sidebar and type:
Fetch Square payments from the past 30 days for my main location and put transaction date, gross amount, currency, card brand, and status into columns A through E of the Transactions tab, starting at row 2. Sort by date descending.
SheetXAI calls Square's payments API, handles pagination, and writes the rows into your workbook tab. The date is formatted as an Excel date. Currency and card brand are included. The columns match what you asked for.
What You Get
A clean transaction log in the Transactions tab:
- Column A: Date — formatted as a real Excel date, not text
- Column B: Amount — gross payment amount
- Column C: Currency — ISO code for multi-currency books
- Column D: Card brand — Visa, Mastercard, Amex, or whatever Square returned
- Column E: Status — COMPLETED, FAILED, or CANCELED
Sorted by date descending so the most recent transactions are at the top. Your accountant can scan for anomalies without scrolling.
Next month, you give SheetXAI the same shape of prompt with the new dates. No CSV to download, no columns to rename.
What If the Data Is Not Quite Ready
Payment data has real-world complications across locations and date ranges. SheetXAI handles them in the same prompt.
When you have multiple locations and need them in one tab
You have three Square locations and your accountant wants one workbook tab with all transactions labeled by location.
Fetch all Square payments from the past 30 days across all my locations. Write date, amount, currency, card brand, location name, and status into columns A through F of the Transactions tab. Sort by location and then by date descending.
When you only want completed payments
The raw export includes failed attempts and canceled transactions. Your accountant only needs what actually settled.
Fetch Square payments from the past 30 days where status is COMPLETED. Write date, amount, currency, and card brand into columns A through D of the Transactions tab. Skip FAILED and CANCELED records.
When the date range spans a full quarter for tax prep
Your tax preparer needs January through March as a single export across all locations.
Fetch all Square payments from January 1 through March 31 across all locations. Write date, amount, currency, card brand, and status into the Transactions tab starting at row 2. Add a subtotal row at the bottom of the tab showing total gross amount per currency.
When you need the full chain: fetch, filter, and summarize in one pass
Your accountant wants the line-item detail and a summary tab with totals by card brand and by location.
Pull all Square payments from the past 30 days. Write the full detail — date, amount, currency, card brand, location name, status — into the Transactions tab starting at row 2. Then in the Summary tab, create two tables: total gross amount by card brand, and total gross amount by location. Only include COMPLETED payments in both summary tables.
The pattern: instead of downloading a CSV and building summary tables separately, ask for all of it in one prompt. SheetXAI writes to both tabs.
Try It
Get the 7-day free trial of SheetXAI and connect it to Square, then ask it to pull last month's payments into any workbook you have open. The Square integration is included in every SheetXAI plan. For more on what you can pull, see how to export Square invoices for AR tracking in Excel or the Square in Excel overview.