The Scenario
You're three days from the end of Q1 and your accountant just asked for a full transaction export — every payment processed through Paystack from January through March, with reference, amount, customer email, channel, status, and date. You open the Paystack dashboard and start clicking through the export options.
The bad version:
- You export the full CSV, open it in a separate tab, and discover the column order doesn't match your reconciliation sheet — so you spend 20 minutes renaming headers and dragging columns around.
- The export maxes out at 100 rows, so you export three separate date-range files and stack them manually, checking for overlaps.
- You paste everything into the Transactions sheet and realize the amount column is in kobo with no decimal formatting, and your accountant's template expects naira — so you write a conversion formula across 400 rows.
Your accountant needs this before the bank closes today. The conversion formula is the least of your problems.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your sheet, understands what you're looking at, and through its built-in Paystack integration it can pull your full transaction history and write it directly into the right tab — no exports, no reformatting, no formula patching. You just describe what you need.
List all Paystack transactions from January 1 to March 31 2025 and write each one to the 'Transactions' sheet with columns for reference, amount, customer email, channel, status, and date.
What You Get
- Column A: transaction reference (e.g., T202501140001)
- Column B: amount in the currency's smallest unit, with formatting notes if requested
- Column C: customer email address
- Column D: payment channel (card, bank, USSD, mobile money)
- Column E: transaction status (success, failed, abandoned)
- Column F: created date in ISO format
- One row per transaction, starting at row 2 — header row written automatically
What If the Data Is Not Quite Ready
The amount is in kobo and you need naira
List all Paystack transactions from Q1 2025 and write them to the 'Transactions' sheet — reference in A, amount converted from kobo to naira in B, customer email in C, channel in D, status in E, date in F.
You only want successful transactions
List all successful Paystack transactions from January 1 to March 31 2025 and write each one to the 'Transactions' sheet with reference, amount in naira, email, channel, and date — skip any failed or abandoned payments.
You need to join against a second tab to flag known dispute references
Fetch all Paystack transactions from Q1 2025, write them to the 'Transactions' sheet with the standard columns, then check each reference against the 'Disputes' tab column A and mark 'DISPUTED' in column G for any match.
Clean, convert, and reconcile in one shot
Pull all Paystack transactions from Q1 2025, convert amounts from kobo to naira, filter to successful payments only, check each reference against the 'Disputes' tab, mark disputed ones in column G, and write the full result to the 'Reconciliation' sheet sorted by date ascending.
When you have both the cleanup logic and the data pull in one prompt, you get a reconciliation-ready sheet instead of raw material you still have to process.
Try It
Open a Google Sheet where you track payments or run reconciliations, then Get the 7-day free trial of SheetXAI and ask it to pull your Paystack transaction history directly into the sheet. You can also look at how to verify individual transaction references or export your settlement history from the Paystack hub overview.