Export the Loyverse Supplier Directory to an Excel workbook

The Scenario

Month-end close landed on the accounts-payable coordinator this week. She needs to reconcile the AP system's vendor list against what's actually in Loyverse — 55 suppliers — and identify any gaps. The AP system works from an Excel import. The Loyverse vendor list lives in Loyverse.

Her predecessor apparently updated Loyverse and the AP system separately, without keeping them in sync. There's at least one vendor in Loyverse that AP has never heard of, and possibly two in AP that aren't in Loyverse.

The bad version:

• Click through all 55 Loyverse supplier records. Copy the relevant fields manually into Excel.
• Compare against the AP vendor master.
• 55 records, five fields each. An hour of manual extraction, then 20 minutes of comparison.
• Find three discrepancies. Go back into Loyverse to verify the details on those three.

This is a reconciliation task dressed up as a supplier export problem. The data isn't hard to get — the path to it is.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It pulls all Loyverse supplier records directly into the workbook in the format AP needs — one call.

Open the SheetXAI sidebar and paste this prompt:

Export all Loyverse suppliers to Excel 'Vendor Master' with supplier_name, contact, email, phone, and country

What You Get

• All 55 supplier records written to 'Vendor Master' with the five columns specified.
• Data ready to compare against the AP system's vendor list or import directly into AP.
• No manual extraction, no per-record clicking.

What If the Data Is Not Quite Ready

She needs to add a column for the AP system's internal vendor code

Export all Loyverse suppliers to 'Vendor Master' with supplier_name, contact, email, phone, country — add a blank column F labeled 'AP Vendor Code' for manual entry after export

She wants to cross-reference against the existing AP vendor list in the workbook

Export all Loyverse suppliers to 'Loyverse Vendors' worksheet with supplier_name and email — then compare against 'AP Master' worksheet column A (vendor names) and column C (email): flag any Loyverse supplier not found in AP Master in column C with 'Missing from AP'

She needs the full address included for AP's payment processing

Export all Loyverse suppliers to 'Vendor Master' with supplier_name, contact_person, email, phone, street_address, city, country, created_date — sort by supplier_name ascending

Full AP reconciliation export in one shot

Export all Loyverse suppliers — sort by supplier_name ascending — write to 'Vendor Master' with supplier_name, contact_person, email, phone, country — add a header row — then on a second worksheet 'AP Gaps' compare against 'AP Master' column A (vendor names) and flag any Loyverse supplier not present in AP with the note 'Add to AP system'

Try It

Get the 7-day free trial of SheetXAI and open your reconciliation workbook at month-end, then ask SheetXAI to pull the full Loyverse supplier directory so the AP comparison takes minutes instead of an hour. See also bulk import suppliers and the Loyverse integration overview.