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. You need every order from the last 90 days, with order ID, account name, total value, discount, and order date — and separately the line items for each order so you can verify that line-item totals match the order totals.
Two CSV exports. A VLOOKUP to join them in Excel. The familiar forty-minute ritual.
The bad version of this week:
- You export orders from Fireberry for Q3, open the CSV in Excel
- You find the discount column is formatted as a decimal (0.15) instead of a dollar amount
- You multiply by the order total to get the dollar discount, copy-paste as values, delete the helper
- You export line items separately in a second CSV
- You VLOOKUP order ID from the line items export to the orders workbook
- Excel formats order IDs as numbers in one file and text in the other, so every VLOOKUP returns #N/A
- You add TEXT() wrappers to both sides of the VLOOKUP
- You finish Thursday. Q3 ended three days ago.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that pulls both the orders and line items with consistent formatting and writes them to separate tabs 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' tab with columns for order ID, account name, total amount, discount as a dollar value, 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' tab, with order ID as the first column.
SheetXAI pulls both datasets with order ID formatted consistently in both tabs. No TEXT() wrapper, no VLOOKUP failures.
What You Get
Two tabs set up for reconciliation:
- Q3 Orders tab — order ID, account name, total amount, discount in dollars, order date for all Q3 orders
- Order Line Items tab — order ID, product name, quantity, unit price for every line item
Order ID is formatted the same way in both tabs. The join works without wrapper formulas.
What If the Data Is Not Quite Ready
Financial reconciliations catch 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' tab. Fetch line items for each order ID. For any order where no line items are returned, write "No line items" into the 'Order Line Items' tab with the order ID, so I can investigate those separately.
When the discount column needs to be expressed as a percentage
The accounting system expects discount as a percentage of order total.
Pull all Q3 Fireberry orders. Add a 'Discount %' column that expresses the discount as a percentage of total amount. Then pull the line items into the 'Order Line Items' tab.
When you only need orders above a threshold for the reconciliation
Your manager only needs orders over $5,000.
Pull all Q3 Fireberry orders where total amount is greater than $5,000. Write them into the 'Q3 Orders' tab. Fetch line items for those specific order IDs and write them to the 'Order Line Items' tab.
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' tab with ID, account name, total amount, discount as dollar value, and date. Fetch all line items into the 'Order Line Items' tab. Add a calculated 'Line Item Total' per order in the line items tab. Compare each line item total to the order total: flag any order where they differ by more than $0.01 in a new 'Discrepancies' tab with order ID, order total, line item total, and the difference.
The pattern: both datasets, the join logic, and the validation happen in one prompt.
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 Excel workbook. The Fireberry integration is included in every plan. For related workflows, see how to export the Fireberry pipeline for forecasting or the Fireberry in Excel overview.