The Scenario
It is the third week of July. Your finance analyst needs to reconcile this quarter's Nutshell quotes and invoices against the accounting system — 60-odd records, each with a linked lead, an amount, a status, and a date. The source of truth is Nutshell. The reconciliation happens in an Excel workbook.
The bad version:
- You navigate to Nutshell's quotes section, set the date filter for Q2, and export a CSV.
- The CSV has 18 columns, three of which you need. You delete the others and reformat the dates.
- You do the same for invoices, get a second CSV, and now you're merging two exports in a workbook while the finance analyst pings you asking for an ETA.
The reconciliation is straightforward. The data collection is what keeps getting in the way.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook and, through its built-in Nutshell integration, pulls quotes and invoice data directly — no CSV export, no column pruning, no reformatting.
Open SheetXAI in the sidebar and ask:
Fetch all Nutshell invoices from the current quarter and dump them into my Excel reconciliation sheet with invoice ID, lead, total amount, payment status, and issue date
What You Get
- One row per invoice with ID, linked lead description, total amount, payment status, and issue date.
- Dates in ISO format, amounts as numeric values — ready for reconciliation formulas without reformatting.
- Row count written below the last data row so the analyst can confirm completeness.
- No extra columns, no merged cells, no formatting that breaks downstream lookups.
What If the Data Is Not Quite Ready
You need quotes alongside invoices in the same workbook
Fetch all Nutshell quotes from this quarter and write them into the Quotes worksheet — then fetch all invoices and write them into the Invoices worksheet — both with ID, linked lead, amount, status, and date
You need to filter to a specific status
List all Nutshell invoices from this quarter where payment status is Unpaid or Overdue — write invoice ID, linked lead description, total amount, payment status, and issue date into this workbook
The accounting system uses a different quarter definition
Fetch all Nutshell invoices where the issue date falls between April 1 and June 30, 2026 — write invoice ID, linked lead, amount, status, and date into this workbook
Full reconciliation export in one shot
Fetch all Nutshell quotes and invoices created between April 1 and June 30, 2026 — write quotes into the Quotes worksheet and invoices into the Invoices worksheet, both with ID, linked lead, amount, status, and date — add a total-amount row at the bottom of each worksheet
When the finance team needs the reconciliation export ready before close, describe the full pull — the date range, the separate worksheets, the totals rows — in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your next reconciliation workbook — then ask it to pull the Nutshell quotes and invoices directly. You can also export the full open pipeline for a QBR, build a revenue forecast by close month, or pull a won/lost conversion report by rep.