The Scenario
The finance administrator cleared her inbox at 2 PM on a Thursday and found 25 payment confirmations from the bank reconciliation — all corresponding to MOCO invoices that are now paid. The statement is in an Excel sheet. The payments need to be logged in MOCO before month-end close.
She has done this manually before. Each payment means opening MOCO, finding the invoice by number, navigating to payments, entering the date and amount, saving. Twenty-five times.
The bad version:
- Open MOCO Invoices, search for invoice ID from row 1 of the statement, click into it, find the Record Payment button, enter the date and amount, save.
- Return to the statement, find the next invoice ID, repeat.
- On payment 18, realize the amount in the bank statement is slightly different from the invoice total (a rounding difference in a foreign currency transaction) — decide whether to log the exact bank amount or the invoice total and make a note.
Month-end close is tomorrow. Twenty-five payments logged by hand is 45 minutes she doesn't have.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the payment data and uses its built-in MOCO integration to record all 25 payments in one operation.
Create invoice payments in MOCO for every row in my Reconciliation tab — column A is invoice ID, B is payment date, C is payment amount
What You Get
- One MOCO invoice payment recorded per row.
- Column D populates with the MOCO payment ID and status for each row.
- Rows where the invoice ID doesn't resolve in MOCO surface as errors immediately.
- Payment date and amount are recorded exactly as they appear in the sheet.
What If the Data Is Not Quite Ready
The payment amounts differ slightly from invoice totals due to currency rounding
For each row in my Reconciliation tab, create a MOCO invoice payment using column A (invoice ID), B (payment date), and C (payment amount). For rows where the payment amount differs from the invoice total by less than 1 unit of currency, add a note to the payment record flagging the rounding difference. Write results to column D.
Some rows have the invoice number (text) rather than the MOCO numeric invoice ID
For each row in my Reconciliation tab, check if column A contains a numeric MOCO invoice ID or a text invoice number. For text invoice numbers, look up the MOCO invoice to get the numeric ID. Then record the payment using column B for date and column C for amount. Write results to column D.
I need to verify the invoice status before recording payment (don't record against already-paid invoices)
For each row in my Reconciliation tab, check the current status of MOCO invoice ID in column A. If the status is already Paid, write Skipped-Already-Paid to column D. If status is Open or Partial, record the payment from columns B and C and write the payment ID to column D.
Validate all invoice IDs, skip duplicates, record payments, and produce a reconciliation summary
Take my Reconciliation tab. Look up each invoice ID in column A in MOCO to confirm it exists and is not already fully paid. For valid invoices, record the payment from columns B and C. For invoices already paid, write Skipped. For invalid IDs, write Error. Then write a summary row at the bottom: total payments recorded, total amount, and count of skipped or errored rows.
Twenty-five payments recorded. Month-end close runs on time.
Try It
Get the 7-day free trial of SheetXAI and open your bank reconciliation spreadsheet, then ask it to record all the MOCO invoice payments in one pass. See also the open invoices export spoke to pull the AR list before the payments come in.