Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Choosing a provider

Accept a bank payment-file export before relying on it for a payment run

Verify the bank's exact format, field mapping, authorization boundary and rejection handling without treating a successful file download as a completed payment.

By Institution5 minute readPublished View sources
In this guide

Get the bank's actual file requirement

A software proposal that promises bank-file export needs to identify the bank, account arrangement, payment method and exact format it supports. Similar format names can still involve different versions or bank-specific requirements. Obtain the current specification through the company's established banking contact before accepting the implementation scope.

Record the sending entity, funding account and intended payment types. A domestic supplier-payment file may not cover payroll, cross-border transfers or another currency. The software and bank should agree on the specific service the company has arranged to use.

Business Central's documentation describes exporting payment-journal data to a file for upload to the bank and using a data-exchange definition for formats not provided directly. That illustrates two separate questions: whether the accounting product can generate a file and whether the required bank format has actually been configured.

Identify the parties responsible for configuration and acceptance. The implementer prepares the output, the bank confirms its processing requirements and the company approves the business workflow. None of those roles should be left implicit because the feature appears on a product comparison sheet.

References: Microsoft: Make payments using a bank file

Map the fields to controlled source records

Have the implementer explain the source of each important field, including beneficiary, account, amount, currency, requested date and payment reference. Use the bank's specification to identify required identifiers and constraints. Avoid building the mapping from a sample file whose purpose or version is uncertain.

Test leading zeros, long references and permitted characters with synthetic values. Determine how the exporter handles a value that exceeds the bank's limit. Silent truncation may remove the information a supplier needs to identify a payment, so the company should know what is shortened and where the complete record remains.

Check dates and amounts in the raw output using a safe inspection method that preserves the file. Opening and resaving a structured file in a spreadsheet can alter formatting. The acceptance record should distinguish the original generated file from any viewing copy.

Verify that the approved vendor record supplies the payment destination used in the file. A mapping to an old bank field or an unreviewed alternate account can produce a technically valid file with the wrong business result. Include a controlled example of a pending bank-detail change.

Use the bank's supported testing route

Ask the bank which validation or test process is available and what evidence it returns. Use that route with approved synthetic or test records. Do not send an uncontrolled production batch merely to find out whether the format works.

Agree the expected record count and totals before validation. For a hypothetical three-item test containing $125, $275 and $600 in one currency, the control total is $1,000. Confirm the generated file and the bank's validation result both represent those three items once.

Include a deliberately invalid test record where the bank's process permits it. Observe the error message, affected reference and whether the entire file or only one item is rejected. The finance team needs enough information to correct the issue without resubmitting valid items unnecessarily.

Record limitations of the test environment. A format validation may not establish account funding, production authorization or settlement behavior. Identify the bounded checks still needed during an authorized live rollout and assign their owners before the first real payment run.

Preserve authorization between export and submission

Define who prepares the payment proposal, who approves it, who generates the file and who submits or releases it at the bank. The accounting application and banking portal may enforce different stages. Make the full sequence visible in the operating procedure.

Ask what happens if someone edits the proposal after approval or regenerates the file. The approver should be able to identify the version that will be submitted. A prior approval should not be assumed to cover later changes unless the company's process explicitly reviews them.

Protect the generated file through the approved storage and transfer process. It can contain sensitive account information and instructions that could move funds. Restrict access and preserve enough evidence to connect the submitted file to the approved batch without placing the contents in broad email threads.

Check the bank-side review available before release. The authorized person should be able to compare the relevant count, total, funding account and date with the approved record. A filename alone is a weak basis for deciding that the correct batch was uploaded.

Test rejection, resubmission and status return

A downloaded file, an uploaded file, an accepted batch and settled payments are different states. Ask the implementer to show how the accounting workflow records each stage it can observe and how the team obtains the remaining information from the bank.

Use a safe test to demonstrate a rejected item and the intended correction. Identify whether the system creates a new payment reference, changes the original record or requires another documented action. Keep the relationship clear so the reviewer can see why the item was submitted again.

Ask how duplicate submissions are prevented or detected at each relevant layer. Do not rely on one platform's duplicate check without understanding its scope. The company needs an operational record of what was submitted and which items still require action.

Trace the final bank result into payment application and reconciliation. An item rejected after initial acceptance should not remain indefinitely marked as settled. The team must be able to identify the supplier obligation still open and the evidence supporting any corrective step.

Retain the format decision and maintenance owner

Keep the specification version, mapping, sample controls and bank acceptance evidence with the implementation record. Document any bank-specific extension or conversion service and its cost. Name the person responsible for learning about format changes and arranging a targeted retest.

Include a new bank account or payment type in the change process rather than assuming the existing export covers it. The relevant account setup, permissions and bank service may need separate verification.

Accept the feature when the company can generate the right file and operate the complete approval and status workflow. The evidence should connect an approved obligation to a traceable bank outcome, with a controlled path for exceptions.

Sources

Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.

Related reading

Need help with this work?

General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.