Skip to content
← For small businesses

Enter your idea

For small businesses: Business features

Categories

(thinking…)

Batch Payments: Customise CSV batch file

The ability to customize a csv output file to be able to import into a banking system.

2 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

AdminXero Team (Admin, Xero) shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Yvonne Boasman commented  ·   ·  Report

    This is most definitely a requirement and needs to be addressed

  • Anna Irla-Pietras commented  ·   ·  Report

    Please please make it possible to customise the batch file template!!!

  • Conrad Jacobson commented  ·   ·  Report

    It's just absurd that Xero doesn't fix this. They could add this facility in no time. None of the banks we use can import the batch files created by Xero and their payroll exports use a different format again. It's just obstinate idiocy!

  • Jane Toh commented  ·   ·  Report

    yes DBS needs this customize file for batch payment

  • Peter Edmondson commented  ·   ·  Report

    Revolut also does not accept the standard Xero CSV batch file format. The ability to alter the CSV template for each bank (similar to how you can upload a customised invoice template) would save so much time.

  • Christopher Bunting commented  ·   ·  Report

    We use two different banks in the UK (Danske Bank and Starling Bank) and neither of them accept the default Xero batch payment file. This just seems like a really customer-friendly feature, especially for the shorthanded organisation.

  • Steve Dixon commented  ·   ·  Report

    I would also like to see this ASAP. Customising the CSV, should be a priority to Xero. Lloyds Bank don't accept the current CSV file from Xero to make supplier batch payments.

  • Viktor Sogojeva commented  ·   ·  Report

    CSV for Natwest works with this format.

    Amount Sort code Account Supplier Julian Date Narrative Reference

  • Viktor Sogojeva commented  ·   ·  Report

    Customising the CSV, should be a priority to Xero. Bank don't accept the current CSV file from Xero to make supplier batch payments.

  • Michal Porebski commented  ·   ·  Report

    It doesnt have to be in csv, just excel file would be enough.... What Xero offer is cannot be maned as batch file...
    I´ve worked with many other accounting SW and when there was no possibility to change batch file, they at least let me create one as report with export to excel so it was easy to customize and work with that before changing to csv...

  • Melissa Dawe commented  ·   ·  Report

    The issue that I see, no matter which US Bank we use, is that the CSV file export from Xero does not split the routing and account in two columns. All banks require this split it seems. along with having some other fields (customizable would be ideal). I imagine it wouldn't be too much to dev on Xero's end.
    More importantly, an export from Xero in Nacha file format (txt) would be the main thing we all need. Given the Aus version of Xero already has this equivalent in an ABA file, I can't see that a NACHA file would be that hard to dev out on the US side for Xero either. But then, I am no developer!

  • Frederik Jacobs commented  ·   ·  Report

    It seems absolutely essential to have the ability to customise the CSV layout and format generated for batch payments. Each bank has different default templates which it requires to accept and allows for an efficient payment run while minimising the potential for errors.

  • Siyanda Bokwe commented  ·   ·  Report

    Good day,

    We are struggling to import batch payments into any banking system. The template is too generic and adds up taking time to adjust it and make a batch payment.