The Scenario
You are a controller. It is the first week of January and you need to add 200 new general ledger account codes to Coupa for the new fiscal year.
The account list came from your ERP as a spreadsheet export: account code in column A, account name in column B, and account type in column C. Coupa needs all 200 before the budget load can start, and finance is already asking when they can begin entering requisitions.
The slow version:
- You open Coupa, navigate to the chart of accounts
- You create the first GL account manually: code, name, type
- You save, go back to the sheet, check it off
- You work through 200 accounts over the course of a morning and an afternoon
- At account 150 your focus breaks and you transpose two digits in an account code
- The budget analyst hits a validation error on day one when a requisition fails to match the account
- You spend an hour tracking down which account was wrong and recreating it.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads each account row and creates the Coupa GL accounts for you.
Open the SheetXAI sidebar and type:
Create a Coupa GL account for each row in this sheet using the account code from column A, account name from column B, and account type from column C. Write the new Coupa account ID back into column D for each row. Flag any rows where the account code already exists in Coupa.
SheetXAI reads all 200 rows, creates each GL account in Coupa, and writes the confirmation IDs back into column D. Rows where the account code already exists get flagged so you do not accidentally create duplicates.
What You Get
Two hundred Coupa GL accounts created from a single prompt:
- Account per row — each ERP code becomes a Coupa GL account with the right code, name, and type
- Account ID written back — each Coupa ID lands in column D for reconciliation against your ERP
- Duplicate flags — existing codes are surfaced before they create chart-of-accounts conflicts
- Budget-load-ready — finance can start entering budget lines the same day
The duplicate flag is the difference between a clean fiscal year and a reconciliation headache in March. Catching collisions now costs thirty seconds. Catching them in Q1 when requisitions start failing costs hours.
If your ERP export also includes active/inactive status or a segment code, tell SheetXAI which column holds it and it adds those attributes on creation.
What If the Data Is Not Quite Ready
ERP exports come in many formats and rarely match what Coupa expects out of the box. SheetXAI normalizes and creates in the same prompt.
When account type values are in your ERP's format, not Coupa's
Your ERP uses account type codes like EX for expense and AS for asset. Coupa expects full type names.
Map the account type codes in column C to Coupa account type names: EX → Expense, AS → Asset, LI → Liability, RE → Revenue, EQ → Equity. Write the mapped names into column D. Then create a Coupa GL account for each row using code from column A, name from column B, and type from column D. Write the Coupa account ID into column E.
When account names have inconsistent capitalization
Some rows have TRAVEL & ENTERTAINMENT, others have Travel & Entertainment, others have travel and entertainment. Coupa's chart of accounts will show all three as different.
Normalize all account names in column B to title case. Then create a Coupa GL account for each row using the account code from column A, normalized name from column B, and account type from column C. Write the Coupa account ID into column D.
When some accounts should be created as inactive
New fiscal year accounts start active, but you have 20 legacy accounts in the sheet that should be created as inactive because they are being phased out.
For each row where column D says Legacy, create the Coupa GL account as inactive. For all other rows, create it as active. Use the account code from column A, name from column B, and type from column C for all rows. Write the Coupa account ID into column E.
When you need the full chart-of-accounts load: normalize types, dedupe codes, handle active status, create, confirm
Your ERP export has type codes in ERP format, inconsistent capitalization, 20 legacy accounts to create as inactive, and a handful of codes that already exist in Coupa from last year's mid-year additions.
Map account type codes in column C to Coupa type names using: EX → Expense, AS → Asset, LI → Liability, RE → Revenue, EQ → Equity. Write mapped types into column D. Normalize account names in column B to title case and write into column E. Check each account code in column A against Coupa. For codes that already exist, write the existing ID into column F and mark column G as Existing. For new codes, create the Coupa GL account using code from column A, normalized name from column E, and mapped type from column D. Set inactive status for rows where column H says Legacy. Write the new account ID into column F and mark column G as Created.
The pattern: describe the full chart-of-accounts load in one prompt. SheetXAI handles validation, normalization, deduplication, and creation in sequence.
Try It
Get the 7-day free trial of SheetXAI and open your ERP account export, then ask it to create the Coupa GL accounts and write the IDs back. The Coupa integration is included in every SheetXAI plan. For related workflows, see how to bulk-create budget lines from an allocations sheet or the Coupa in Google Sheets overview.