The Scenario
It's the last working day of the month. Your accountant sends a message at 9 AM: they need all outstanding supplier invoices from Ascora in a spreadsheet before the bank statement arrives this afternoon. Month-end reconciliation depends on it. You have three other things already open.
The bad version:
- Log into Ascora, navigate to Supplier Invoices, filter by status "Unpaid."
- Export whatever Ascora will give you — maybe a PDF, maybe a CSV with columns in the wrong order.
- Open it in Google Sheets, rearrange the columns so invoice number, supplier, amount, and due date are where the accountant expects them.
- Realize the date format Ascora exported doesn't sort correctly, fix it manually, and send the file.
Reconciliation shouldn't require half a morning of file wrestling.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Ascora and fetches supplier invoices directly — filtered, formatted, and written into the columns you specify.
Fetch all supplier invoices from Ascora and write invoice number, supplier name, invoice date, due date, amount, and status into this sheet.
What You Get
- One row per Ascora supplier invoice, written directly into the sheet.
- Invoice number, supplier name, invoice date, due date, amount, and status in separate columns.
- The data is live from Ascora — not a cached export that may have been pulled before last week's invoices were entered.
- Ready for bank statement cross-referencing without any reformatting.
What If the Data Is Not Quite Ready
You only need unpaid invoices, not the full history
Pull all Ascora supplier invoices with status 'Unpaid' and paste invoice number, supplier, amount, and due date into the Excel 'AccountsPayable' sheet. Sort by due date, earliest first.
Due dates are formatted inconsistently and won't sort correctly in Sheets
Fetch all Ascora supplier invoices. Write invoice number, supplier name, invoice date, due date, amount, and status into this sheet. Convert all date columns to ISO 8601 format (YYYY-MM-DD) before writing.
You need a subtotal per supplier at the bottom of each supplier's invoice group
Fetch all Ascora supplier invoices with status 'Unpaid'. Group by supplier name. For each supplier, write invoice number, invoice date, due date, and amount. After each group, add a subtotal row showing the supplier name and total amount owed, labeled 'Subtotal'. Leave a blank row between groups.
Month-end crunch: pull unpaid invoices, flag overdue ones, match against a second tab of expected invoices, and surface gaps
Fetch all Ascora supplier invoices with status 'Unpaid'. Write invoice number, supplier name, due date, and amount into columns A through D. Flag any invoice where the due date is before today by writing 'Overdue' in column E. Then look up each invoice number in the 'Expected' tab — column A is invoice number. For any invoice in the Ascora pull that has no match in the Expected tab, write 'Not in expected list' in column F. Write 'OK' in column F for all others.
Everything the accountant needs for reconciliation, in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet, then ask SheetXAI to pull all unpaid Ascora supplier invoices into it. Related: export completed jobs for invoicing review and bulk add or update suppliers. Full overview: Ascora integration hub.