The Scenario
You're onboarding 30 new vendors to your marketplace this week. Before any of them can receive split payments, each needs a Paystack subaccount configured with their business name, bank code, account number, and your agreed settlement percentage. Your ops coordinator put all 30 rows in an Excel workbook Monday morning.
It's now Wednesday. The vendors have been asking when they'll be active.
The bad version:
- You open Paystack, navigate to Subaccounts, and click Create Subaccount.
- You fill in the business name, select the bank from a dropdown (30+ options, you scroll), enter the account number, and set the settlement percentage.
- On vendor 9 you mistype the account number — one digit off. The subaccount is created, but the next payout to that vendor will be rejected. You won't find out until after the first settlement run.
30 vendors at 5 minutes each is two and a half hours of form entry — with no audit trail and one wrong digit creating a support ticket that takes three more hours to unwind.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your vendor data and creates each Paystack subaccount through the API, writing the returned subaccount code back into the Subaccount Code column — so you have a complete audit record and your developers can wire up the split payment routing immediately.
For every row in my Excel 'Vendors' table, create a Paystack subaccount using the Business Name, Bank Code, Account Number, and Settlement % columns, then record the subaccount code returned.
What You Get
- Subaccount Code column filled with the Paystack subaccount code per row (e.g., ACCT_xxxxxxxxxxxxxxxx)
- Rows where creation fails — invalid account number, bad bank code — get an error note in the Subaccount Code column
- All 30 subaccounts created in one run with a row-by-row record
What If the Data Is Not Quite Ready
The Settlement % column is stored as a decimal (0.85) not a percentage (85)
For every row in the 'Vendors' table, multiply the Settlement % value by 100 to convert to a whole number, then create a Paystack subaccount using Business Name, Bank Code, Account Number, and converted percentage — write the returned subaccount code to the Subaccount Code column.
Bank codes are stored as bank names
Look up the Paystack bank code for each bank name in the Bank Code column and write to a helper column, then create a Paystack subaccount for each row using Business Name, resolved bank code, Account Number, and Settlement % — write the returned subaccount code to the Subaccount Code column.
Account numbers have leading zeros stripped by Excel's number formatting
Treat the Account Number column as text and pad values to 10 digits with leading zeros, then create a Paystack subaccount for each row using Business Name, Bank Code, padded account number, and Settlement % — write the returned subaccount code to the Subaccount Code column.
Resolve bank names, pad account numbers, convert percentages, and create in one shot
Resolve bank names in the Bank Code column to Paystack bank codes in a helper column, pad Account Number values to 10 digits, convert Settlement % from decimal to whole number, then create a Paystack subaccount for each row using Business Name, resolved bank code, padded account number, and converted percentage — write the returned code to Subaccount Code.
Creating all 30 subaccounts in one prompt means your vendors are ready for their first payout run — not waiting in a queue while you work through the dashboard form by form.
Try It
Open the Excel workbook where your vendor onboarding data lives, then Get the 7-day free trial of SheetXAI and ask it to create your Paystack subaccounts in bulk. For related workflows, see how to validate bank accounts before creating subaccounts, or how to bulk-create transfer recipients for a payout run.