Enter your idea

I would like to know if it is possible to download a report of customers who currently have an outstanding balance that also includes the Financial Details fields entered on each customer record, with the individual outstanding invoices listed separately.

My goal is to import this information into my direct debit system (AutoPay), so I need a report that combines:

Customer name

Individual invoice numbers and amounts outstanding (listed separately rather than as a total balance)

Financial details (e.g., bank/direct debit information stored in the customer record)

Could you please advise:

Whether an existing report in Xero can provide this information

If not, whether there is a recommended workaround (such as a custom report, export, or integration)

Any guidance on best practice for exporting customer balances and invoices for use with a direct debit system like AutoPay

We bank with NAB and all of our doctors are wanting to be directly credited from their bank accounts. It would be great to be able to download an aba file in xero to load straight into the bank account

This has been an idea for multiple years. Even MYOB offers it! Is it really that hard to program it given that it is a basic text file that can be created on Notepad!

This would be great as our bank only accepts MT9 files to be uploaded. This would be a game changer if you can make it work!

I do 100s of these and currently can't process through xero at all

I would find this very useful as I set up a monthly direct debit for 25+ invoices

Yes please. Also functionality to support Maximum Amount allowed for Direct Debit for each Customer. Clients in financial difficulties due to increasing living and day to day costs.

This would be a fantastic feature that other finance packages have. The ability to export an API file for direct debits is important for my business. Saves me having to manually enter them every month.

NAB through its NAB Connect platform is capable of processing a bank file for bulk direct debits and we have customers which wish to use this service however Xero is at the moment unable to create the file.

Our bank (Commonwealth Bank of Australia) states it will accept bulk entries for direct credit and direct debits but Xero only allows for ABA files for direct credit. Our business model is for all clients to be on (variable, depending on services used), direct debit. It would be so efficient if we could do this via Xero with our bank.

I’d also like to be able to create an aba file for a receipt batch for loading into bank as a direct debit for bulk customer payments. Rather than having to double handle these by processing the receipts in Xero then manually creating multiple, up to 50+ entries, in the banking software individually. Other accounting software products have this feature. Thanks

Export a file that collates all invoices for each contact, to be uploaded to your bank to run customer direct debits. The same as you can do for bill payments. We currently use UCollect for $360pa, if anyone has any other ideas for this simple task -while Xero is working on building it ;) ...I'd love to hear them, TIA.