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?

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.

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.

Yes, there's a way.

Use our BRC PositivePay file Creator - QB Desktop  to create your positive pay files. It will automatically get the Print As name from the vendor records.

It includes support for over 160 bank file formats, the ability to add custom user-defined formats.

Also we add new banks on a regular basis on request. If you're bank is not on the list, we can add it for you using the bank's file format requirements.

We just launched a new service for this exact issue. https://getpositivepay.com/.

Take a look and pre-register to get early access.

It is possible to create a custom report in QuickBooks Online.

> go to Reports

> go to the search box (Find report by name) and enter Check detail 

> click Customize button

> Report period > change per your needs (daily, weekly)

> Columns (choose the columns your bank needs); I needed:

          DATE   ACCOUNT   NUM   AMOUNT  NAME

> Filter

> Transaction Type > select Check and Billpayment (check)

> Cleared > select Uncleared

> Account > select the accounts you write checks from

> Header > Report title > Check Detail - Positive Pay Report

Let me know if that works for you. We should not have to go outside the software for such a critical report!

Spoke to QB rep, they do not offer "Print name on check as" at all.  I have made a submission with product support to please make this available.  The only way around it is to make a label under the tab Additional Info, then use this label in our reports, very annoying to have to enter Print name on check as twice