The Scenario
You are a finance analyst. It is the first week of October and you need to reconcile Q3 Fireberry orders against the accounting system. That means pulling every order from the last 90 days, with order ID, account name, total value, discount, and order date, into one sheet — and separately pulling the line items for each order into a second sheet so you can verify the line-item totals match the order totals.
Two exports. A VLOOKUP to join them. The usual forty-minute ritual.
The bad version of this week:
- You export orders from Fireberry for Q3 and open the CSV in Sheets
- You realize the discount column is missing from the export — you forgot to include it
- You go back, reconfigure the export, re-download
- You export line items for those order IDs in a second CSV
- You VLOOKUP the order ID from the line items sheet to the orders sheet
- You find mismatched order IDs because Fireberry formatted them as numbers and your VLOOKUP expects text
- You write a TEXT() wrapper and redo the VLOOKUP
- You finish on Thursday. Q3 ended three days ago and you are already behind.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that pulls both the orders and the line items in the right format, without the export-and-join gymnastics.
Open the SheetXAI sidebar and type:
Pull all Fireberry CRM orders from the last 90 days and paste them into my 'Q3 Orders' sheet with columns for order ID, account name, total amount, discount, and order date. Then fetch all order items for those order IDs and write product name, quantity, and unit price for each line item into a new 'Order Line Items' sheet, with the order ID as the first column so I can join the two sheets.
SheetXAI pulls both datasets with consistent order ID formatting and writes them into separate sheets. No VLOOKUP needed — the order ID is already the join key in both.
What You Get
Two sheets set up for reconciliation:
- Q3 Orders sheet — order ID, account name, total amount, discount, order date for all Q3 orders
- Order Line Items sheet — order ID, product name, quantity, unit price for every line item across those orders
Order ID is formatted consistently in both sheets. The JOIN condition works without a TEXT() wrapper.
If you want a quick validation, add one line: "Add a calculated total per order ID in the line items sheet and flag any order where the line-item sum does not match the order total."
What If the Data Is Not Quite Ready
Financial reconciliations catch the edge cases.
When some orders have no line items in Fireberry
A few orders were processed outside the normal flow and have no associated line items.
Pull all Q3 Fireberry orders into the 'Q3 Orders' sheet. Fetch line items for each order ID. For any order where no line items are returned, write "No line items" into the line items sheet with the order ID, so I can investigate those separately.
When the discount column needs to be expressed as a percentage instead of an absolute value
The accounting system expects discount as a percentage of order total, but Fireberry stores it as a dollar amount.
Pull all Q3 Fireberry orders with order ID, account name, total amount, and discount amount. Add a 'Discount %' column that expresses the discount as a percentage of the total amount. Then pull the line items into a second sheet.
When you want to filter to orders above a threshold for a focused reconciliation
Your manager only needs the reconciliation for orders over $5,000 — the small ones clear automatically.
Pull all Q3 Fireberry orders where the total amount is greater than $5,000. Write them into the 'Q3 Orders' sheet. Then fetch line items for those specific order IDs and write them into the 'Order Line Items' sheet.
When you need the full reconciliation: orders, line items, totals check, and discrepancy report in one pass
Pull all Q3 Fireberry orders into the 'Q3 Orders' sheet with ID, account name, total amount, discount, and date. Fetch all line items for those orders into the 'Order Line Items' sheet. Add a calculated 'Line Item Total' per order in the line items sheet. Compare each line item total to the order total: flag any order where they differ by more than $0.01 in a new 'Discrepancies' sheet with the order ID, the order total, the line item total, and the difference.
The pattern: both datasets, the join logic, and the validation happen in one prompt. You get a reconciliation-ready workbook instead of a Friday afternoon problem.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull your Fireberry Q3 orders and line items into a reconciliation-ready sheet. The Fireberry integration is included in every plan. For related workflows, see how to export the full Fireberry pipeline for forecasting or the Fireberry in Google Sheets overview.