Skip to main content
SpireSlip

Your bank's file layout

Every bank's bulk payment upload expects its own file: its own column headings, in its own order, with the amount and bank code written its own way. You set your bank's layout up once in SpireSlip, copying the sample file your bank gives you, and then download the bank payment schedule in that layout for every run.

Setting up your bank's layout

  1. Ask your bank for its bulk payment sample file (Excel or CSV) and open it.
  2. In SpireSlip, open Settings, then Bank file layouts, and press New layout. You can also start from the bank payment schedule page with Build it column by column.
  3. Choose Excel (.xlsx) or CSV, and whether the first row holds the headings. For CSV, choose the separator and line ending your bank uses.
  4. Choose how the bank is identified (the six-digit NIP code, the three-digit CBN code, or the bank name), how the amount is written, and the narration rule.
  5. Add one column for each column in your bank's sample, in the same order. For each, choose what it holds and type the heading exactly as the sample shows it. Use Up and Down to change the order.
  6. Compare the preview under the editor with your bank's sample. The preview uses made-up staff, never your data.
  7. Press Save layout.

If your layout has a surname column or an other names column, you must choose how names are split: the surname is the last word, or the surname is the first word. Names with more than two parts are split by this rule, so check the preview. The name your bank returned when the account was verified is never split.

The first-use check

The first time you download with a new or changed layout, the bank payment schedule page shows the first payment of the real run in your layout, with account numbers masked to their last four digits, and says in words what each column holds. Tick I have checked this against my bank's sample to download. Any change to the layout asks for the check again. Upload a file with one staff member first, and check it with your bank before you upload everyone.

Each layout shows Not yet confirmed by a real upload until your bank has accepted a file from it.

Ready-made layouts

On the bank payment schedule page, Use a ready-made layout instead lists the layouts SpireSlip provides: the SpireSlip standard file (CSV or Excel) and the Providus bulk transfer template. A ready-made layout marked Not confirmed by a real upload yet also asks for the first-use check once. Use my bank's layout takes you back to your own layout.

Example: Globus Bank bulk upload

This follows the sample file Globus Bank gives for bulk payments. It has not yet been confirmed by a real upload, so test it with one person first: pay one person through Globus with this file, and only then pay everyone.

  1. Open Settings, then Bank file layouts, and press New layout.
  2. Layout name: Globus bulk upload. File type: Excel (.xlsx). Sheet name: SampleFile. Tick The first row holds the column headings.
  3. How the bank is identified: the three-digit CBN code. How the amount is written: whole naira only. Leave the narration limit at 30, the narration case as typed, the narration characters as letters, digits and spaces, and the reference limit empty.
  4. Press + Add column six times and set the columns in this order, typing each heading exactly as shown:
    • Account name, heading BeneficiaryName
    • Bank code, heading BankCode
    • Account number, heading AccountNo
    • Amount, heading Amount
    • Narration, heading Narration
    • Blank column, heading RefNumber
  5. Compare the preview with your Globus sample, then press Save layout.
  6. To pay a run, open the approved run, choose the bank payment schedule, pick the Globus bulk upload layout, type the narration (for example, Salary November 2026), enter your password and download. Upload the file on Globus's bulk payment screen.

Each person's own bank's three-digit code goes in BankCode, so staff who bank elsewhere get their own bank's code, not Globus's. Amounts are whole naira: if anyone's pay has kobo, no file is produced and those people are listed. A person whose bank has no confirmed three-digit code is left out of the file and listed, so you can pay them another way. RefNumber is left empty.

When a payment does not fit the layout

Nothing is ever rounded or cut to fit. If an amount has kobo and your layout takes whole naira only, or a payment reference is longer than your layout allows, or your layout needs the name the bank returned and an account has not been verified yet, the page lists who and why, and no file is produced until it is fixed or the layout is changed. If your layout takes whole naira only, ask your bank whether its file accepts kobo.

What a layout will not do

  • It does not tell you that your bank will accept the file. Upload a file with one staff member first and check it with your bank.
  • It never rounds an amount or cuts a name, narration or reference to fit. Anything that does not fit is listed by name, and no file is produced until it is fixed or the layout is changed.
  • It uses one debit account for the whole file, not one per staff member.
  • It does not add a total or row-count line at the end of the file, a second sheet, or a column worked out from other columns.
  • It writes Excel (.xlsx) or CSV only. If your bank's sample is an older .xls file, open it and save it as .xlsx.

Who can do what

The account owner and admins can create, edit and archive layouts. The account owner and admins can choose a layout and download the bank payment schedule, entering their password each time. A layout's debit account is stored encrypted and shown only as its last four digits.