The Scenario
You are a finance analyst at a mid-size retailer. It is the third business day of the month and your ERP team is waiting on last month's Braintree settlement report to close the books. The data they need: transaction IDs, amounts, settlement dates, and status — one row per transaction, in a Google Sheet, matched against the ERP's expected format.
The slow version:
- Log into the Braintree control panel
- Run the settlement report for last month
- Export the CSV
- Open it in Sheets
- Rename columns to match the ERP's expected header names
- Delete the columns the ERP does not need
- Fix date formats because Braintree's export uses a different format than the ERP
- Spend an hour before the ERP team can even start the match.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that queries the Braintree settlement report via PayPal and writes the data into your sheet, formatted the way your ERP team expects.
Open the SheetXAI sidebar and type:
Query the Braintree settlement report for last month via PayPal's API and write each transaction row — ID, amount, settlement date, status — into the Braintree Settlement sheet.
SheetXAI calls PayPal's Braintree reporting endpoint, fetches the settlement data for last month, and writes it into the Braintree Settlement sheet with the column structure you specified.
What You Get
A settlement report sheet ready for the ERP team:
- Transaction ID — the Braintree transaction reference
- Amount — the settled amount
- Settlement date — when the transaction settled
- Status — SETTLED, SETTLEMENT_DECLINED, or the relevant Braintree status
The ERP team can start the match immediately. No column renaming, no date reformatting, no CSV wrangling.
If your ERP expects a specific column order or header name, specify it in the prompt and SheetXAI will structure the output accordingly.
What If the Data Is Not Quite Ready
Settlement reports always need a bit of shaping for ERP matching. SheetXAI handles it inline.
When the date range is defined by cells in the sheet
Your ERP team sets the date range in cells B1 and B2. You want the prompt to read those cells rather than hardcoding the dates.
Fetch a Braintree transaction report for the date range in cells B1:B2 of my Excel sheet and populate the Report sheet with transaction ID, amount, and outcome columns.
When you need to split settled and failed transactions into separate tabs
The ERP processes SETTLED and SETTLEMENT_DECLINED transactions differently.
Query the Braintree settlement report for last month. Write all SETTLED transactions to the Settled tab with transaction ID, amount, and settlement date. Write all SETTLEMENT_DECLINED transactions to the Failed tab with transaction ID, amount, and decline reason.
When the ERP needs a running total column
The accounts team reconciles against a running total, not just a list.
Query the Braintree settlement report for last month and write transaction ID, amount, settlement date, and status into the Settlement sheet sorted by settlement date ascending. Add a Running Total column that cumulates the amount for SETTLED transactions only.
When you need to match against last month's ERP export
You already have last month's ERP data in the ERP Transactions tab. You want to know which Braintree transactions have a match and which do not.
Query the Braintree settlement report for last month. Write transaction ID, amount, settlement date, and status into the Braintree Settlement tab. Then look up each transaction ID in the Transaction Reference column of the ERP Transactions tab. Write "MATCHED" or "UNMATCHED" into a Reconciliation column. List unmatched rows at the bottom.
The pattern: the Braintree query, the column shaping, and the ERP match all happen in one prompt. You do not export first and reconcile second.
Try It
Get the 7-day free trial of SheetXAI and connect your PayPal account, then ask it to pull your Braintree settlement report for any date range. The PayPal integration is included in every SheetXAI plan. See also how to build a full PayPal payment history sheet or the PayPal in Google Sheets overview.