Welcome to the Community, ESA. I've come to make sure you'll able to export supplier bill payments to your bank.
With QuickBooks Online, we can only export a report to an Excel file that includes a complete list of transactions of the bill payments made for your suppliers. However, you'll want to consider reaching out to your financial institution about the column formats they wanted for the CSV files. From there, you can modify and add the data entered from the exported report. Also, to help you import these transactions.
- Go to Reports from the left menu bar.
- Enter Transaction List by Supplier report.
- Edit the Report period, and click Customise.
- Under the Filter dropdown, select Transaction type and choose Bill, Bill Payment (Cheque), and Bill Payments (Credit Card).
- Modify and review necessary details. Then, click Run Report.
- Click on the Export icon to download the report to an Excel file.
- Select Export to Excel to save in your local drive.
Once done, modify the report to the preferred column format from your bank and import them without any error.
For future reference, you can add specific data and other customization settings to your reports: Customise reports in QuickBooks Online.
You're always welcome to get back to us if you have additional questions about exporting payment transactions. We're more than willing to assist you further. Take care!
