Skip to main content
March 13, 2020
Solved

A have positive pay set up with our bank. Is there a way for me to transfer my check run information in a .csv ( comma delimited) format out of QBO to the bank?

  • March 13, 2020
  • 2 replies
  • 0 views
Original commenter did not share additional details
Best answer by BigRedConsulting

To create positive pay files using data from your QuickBooks Online company, use our BRC PositivePay file Creator - QB Online  app.  It supports well over 100 bank file formats and you can create your own custom file formats as well, both CSV ad TXT.

2 replies

March 13, 2020

Thanks for posting to the Community, @steven-smith.
 

Yes, there's a way to transfer your check run information in a CSV file format out from QBO.

 

Let me show you how:

  1. Go to the Expenses menu and then select Expenses.
  2. Click the Filter drop-down list.
  3. Choose Check on the Type of transaction.
  4. Hit Apply.
  5. Click Export to Excel and then open the exported file.
    You should see something like this. This is a .xls file type format. We can now proceed to convert it as a comma delimited file (.CSV)
  6. Go to the File menu and then select Save as.
  7. Change Save as type to comma delimited.

There you have an output of the checks in a CSV format.

I'll add this article as your reference on how to export customer information from QBO: Export customer data to Excel.

 

You can also check this help page for more ways to export data from QBO: Export data and information from QuickBooks Online.

 

Please feel free to leave a message to this post if you need further assistance. I'll be happy to help. Take care!

BigRedConsulting
September 30, 2020

To create positive pay files using data from your QuickBooks Online company, use our BRC PositivePay file Creator - QB Online  app.  It supports well over 100 bank file formats and you can create your own custom file formats as well, both CSV ad TXT.

September 10, 2024

Is there a FREE way to get the files out in a specific .csv format without paying an additional $30-$65 per month fee for your BRC Positive Pay file creator? We're a public library with limited funds. We already pay to use QuickBooks. Now the bank is requiring us to use Positive Pay. How can we do this within the platform we already subscribe to?

BigRedConsulting
March 19, 2025

@NJStacey 

Well, yes in a way: You can create the file your bank needs yourself in a text editor.

 

Notably, the current price for our BRC PositivePay file Creator - QB Desktop and BRC PositivePay file Creator - QB Online products is $99 for the first year and $89 for each year after that - about $8 a month.  It might go up over time with inflation, but not to $65 a month!