cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

I have enabled Positive Pay with our bank. Is there a way to generate a CSV file with check payment details for upload to the bank?

File would include check #, $ amount, check date and Payee name on the check.

10 Comments
QuickBooks Team

Hello there, randerson. I can definitely help you with im...

Hello there, randerson.

I can definitely help you with import your transactions using a CSV file.

When importing a CSV file, the accepted file formats are the 3 and 4 column formats. The 3 column includes the Date, Description and Amount. On the other hand, the 4 column format includes the Date, Description, Credit and Debit.

For more details, you may refer to this article: Import bank transactions from Excel CSV file to QuickBooks Online.

If you'd like to request more flexibility, I'd encourage you to send a message to our product development team requesting that more columns be added. This will make them aware of how you want the program to work. Here's how: http://feedback.qbo.intuit.com/.

If you hand with importing your transactions, just leave comment below. Enjoy your weekend.

Not applicable

i think the original question asked was, after you enter...

i think the original question asked was, after you enter in check details in your quickbooks register, can you export those details as a CSV file to later upload to your bank's website? I'm looking to confirm the same thing.
Not applicable

Yes, exactly right.  My question was about exporting a fi...

Yes, exactly right.  My question was about exporting a file rather than importing.
Not applicable

curious, did you ever get to the bottom of it, or how are...

curious, did you ever get to the bottom of it, or how are you uploading your check details to your bank?

i'm wondering if there is a more streamlined process than having to enter the details first in the qb register and second create a csv file to upload to the bank's website.

ive seen a check detail report in researching.. wondering if that might be a solution if it can be exported in excel format
Community Explorer **

I'm looking for the same thing. Any answers yet?

I'm looking for the same thing. Any answers yet?
Not applicable

Hi Libby, no I've not received an answer pertinent to my...

Hi Libby, no I've not received an answer pertinent to my question.
OIM

I am looking for this ability as well.  I'm thinking I am...

I am looking for this ability as well.  I'm thinking I am going to have to take a check register report and create a macro in Excel to get it in the proper format.  Would love to have a more streamlined way to get the information.
OIM

Anyone with an answer to this question?

Anyone with an answer to this question?
BRC
Established Community Backer ***

Re: I have enabled Positive Pay with our bank. Is there a way to generate a CSV file with check payment details for upload to the bank?

To create positive pay files from your QB Online company, use our BRC PositivePay file Creator - QB Online  app.  If your bank isn't listed, we may be able to add it for you.

Active Member

Re: Anyone with an answer to this question?

Run the Transaction report for the account and date range and export to excel using just the fields Date, Num, Credit, Name. (I memorized this report)

Eliminate the non-check transactions (I sort by NUM and delete the rows I don't need)

Run the Vendor Contact List report and Customize Report with just the fields "Vendor" and "Print on Check as"

Use VLOOKUP to get Payee (=vlookup(A2,[Payees.xlsx]Sheet1!$A:$D,4,0)

Convert formulas to values

Complete your Positive Pay file.