Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
steven-smith
Level 1

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?

 
Solved
Best answer September 30, 2020

Best Answers
BigRedConsulting
Community Champion

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?

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.

View solution in original post

4 Comments 4
Jovychris_A
Moderator

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?

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)
    1.PNG
  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
Community Champion

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?

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.

NJStacey
Level 1

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?

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
Community Champion

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?

@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!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us