The Scenario
It's the third week of the quarter, and your finance lead has flagged a discrepancy. The total in your revenue tracking sheet doesn't match what's showing up in the bank. The MoonClerk dashboard looks right. The sheet doesn't. And the last time someone updated it manually was six weeks ago.
The bad version:
- Log into MoonClerk, go to the Payments section, set the date range to the last 90 days, and export a CSV
- Open the CSV in a separate window, reformat the date column because MoonClerk exports in a format Excel reads as text, reorder the columns to match the sheet, and delete the columns you don't need
- Paste the result into the 'Q1 Payments' tab, realize the status labels don't match the filter you built earlier, and spend another twenty minutes cleaning up
Every reconciliation cycle starts the same way. The bank statement is fixed. The sheet is always the thing that needs catching up. And the cleanup time doesn't show up anywhere in your workday — it just quietly eats into it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads what's in the sheet and, through its built-in MoonClerk integration, can pull payment data directly into your tab — so the sheet catches up to MoonClerk rather than the other way around.
List all MoonClerk payments from the last 90 days and write the payment date, amount, status, customer name, and form name into the 'Q1 Payments' tab — one row per payment
What You Get
- One row per payment written to the 'Q1 Payments' tab
- Columns: payment date, amount, status (Successful, Failed, Refunded — exactly as MoonClerk stores them), customer name, and form name
- Any failed or refunded payments are included with their status intact, so your reconciliation filters work immediately
- If the tab has existing headers, SheetXAI matches them; if it's blank, it creates the headers and writes the data below
What If the Data Is Not Quite Ready
The status labels don't match my existing filter dropdown
List all MoonClerk payments from the last 90 days and write them into the 'Q1 Payments' tab — but normalize the status to 'Paid', 'Failed', or 'Refunded' so it matches my existing column C dropdown
I need to exclude test payments and internal accounts
List all MoonClerk payments from the last 90 days and write them into 'Q1 Payments' — skip any customer whose email contains '@yourcompany.com' or whose name starts with 'Test'
I want to match against the bank deposit totals in a second tab
Pull all MoonClerk payments from the last 90 days into the 'Payments Raw' tab, then look up each payment date in the 'Bank Deposits' tab and write the corresponding deposit total in a new column called 'Matched Deposit' — flag any payment date with no match as 'Unmatched'
Full reconciliation with cleanup in one shot
Fetch all MoonClerk payments from the last 90 days, write them into 'Q1 Payments' with date, amount, status, customer name, and form name, normalize the status labels to 'Paid' / 'Failed' / 'Refunded', and then add a totals row at the bottom summing the Paid amounts — skip any row where the customer email contains 'test'
The cleaner pattern: handle the status normalization and the filter exclusions in the same prompt as the data pull. You get reconciliation-ready output in one step.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where you track revenue or bank reconciliations — ask it to pull the last quarter's MoonClerk payments into your sheet. See also: analyzing payment success vs. failure rates by form and the full MoonClerk integration overview.