The Scenario
You're the ops manager for a small e-commerce business that accepts Bitcoin. Last Tuesday, your accountant sent a message: "I need a list of all outstanding and completed payment requests from BTCPay so I can reconcile them against accounts receivable."
You know the data is in BTCPay. You've seen it in the dashboard. But getting it out — structured, with status flags, in a format your accountant can actually work with in Excel — is a different problem entirely.
The bad version:
- You log into BTCPay, navigate to payment requests, and start reading through the list in the dashboard.
- You copy titles, amounts, and statuses by hand into a new workbook, one row at a time.
- Halfway through, you realize you forgot to include creation dates — so you go back and add a column, then re-enter the dates for the rows you already entered.
Seventy payment requests is not a number that bends to manual extraction. Your accountant needed this yesterday. The time you're spending on data entry is time that isn't going toward any of the three other things on your list for the week.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to your BTCPay Server instance and pulls the records you need directly into the workbook — no dashboard scraping, no CSV wrestling. Open the sidebar and tell it what you want.
Export all BTCPay payment requests from store ID 'xyz' into my Excel sheet and flag any that are still pending so I can follow up
What You Get
- Every payment request from your BTCPay store written into the workbook, one row per request.
- Columns populated: title, amount, currency, status, and creation date.
- Pending requests flagged inline so your accountant can filter immediately.
- The full list in one pull — not paged or truncated.
What If the Data Is Not Quite Ready
You only want requests from the last 90 days
Your store has two years of payment history and you don't need all of it for this reconciliation.
Pull BTCPay Server payment requests created in the last 90 days into my workbook — include title, amount, currency, status, and creation date — skip anything older than 90 days from today
You need to match requests against your internal invoice IDs
Your AR ledger uses internal invoice IDs stored in the payment request memos. You want those pulled through too.
Export all BTCPay payment requests into my workbook and include the memo field in column G — cross-reference memo values against column A of my "AR Ledger" worksheet where column A holds internal invoice IDs, and mark any matches in column H
You're pulling from multiple stores
You manage two BTCPay stores for two sub-brands and need all requests in one workbook.
Pull payment requests from both BTCPay store IDs 'store-001' and 'store-002' into my workbook — add a "Store" column to indicate the source, and include title, amount, currency, and status
Full reconciliation pipeline in one pass
Pull all BTCPay payment requests created this calendar year into my workbook with title, amount, currency, status, memo, and creation date — flag pending ones in a "Status Flag" column, mark any whose memo doesn't match a value in my "AR Ledger" worksheet column A as "Unmatched," and sort the results by creation date descending
Asking for the pull, the flag logic, and the cross-reference in a single prompt means you get a clean workbook instead of one that needs three more passes.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook where you'd normally build your BTCPay reconciliation report, then ask SheetXAI to pull in the payment requests and flag what needs attention. You can also see how to bulk-create payment requests from invoice rows or return to the BTCPay Server hub overview.