The Scenario
The finance administrator cleared her inbox at 2 PM on a Thursday and found 25 payment confirmations from the bank reconciliation — all matching MOCO invoices that are now paid. The statement is in an Excel workbook. 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, 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 workbook, click into it, click Record Payment, enter date and amount, save.
- Return to the workbook, find the next invoice ID, repeat.
- On payment 18, notice the bank amount differs slightly from the invoice total (a rounding difference on a foreign currency transaction) — decide whether to log the bank amount or the invoice total and make a note to ask finance.
Month-end close is tomorrow. Twenty-five payments logged by hand is 45 minutes she does not have.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. 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 worksheet — 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 workbook.
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 worksheet, 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 invoice numbers (text) rather than MOCO numeric IDs
For each row in my Reconciliation worksheet, 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 from columns B and C and write results to column D.
I need to verify invoice status before recording (skip already-paid invoices)
For each row in my Reconciliation worksheet, check the current status of MOCO invoice ID in column A. If 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 worksheet. 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 already-paid invoices, write Skipped. For invalid IDs, write Error. Then add a summary row: 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 workbook, 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 arrive.