Is there a way to create a positive pay file in a format that the bank needs, so no manipulation of the csv file would need to be done?

Hello, @stomasko.

You can manually create or enter your bank transactions to QuickBooks  so you don't need to prepare an Excel CSV file for them.

You can record a transaction from the Plus (+) icon or in the register. To record a transaction from the Plus (+) icon, select what transaction you want to enter from the (+) New icon.

To enter a transaction from the register:

1. Tap on Chart of Accounts from Accounting at the left pane.
2. Look for your bank account from the result, then click on View Register under Action.
3. From your bank register, click on the drop-down arrow at the left side so you can add the transaction you want.

I'm adding these articles as your reference when entering transactions in QuickBooks Online:

• Video tutorials for QuickBooks Online
• Record transactions using New

Let me know if you have any other questions. I'm a post away to help. Have a good day!

The file needs to be created in QB then sent to the bank.

Hey there, @stomasko. 

Thanks for reaching out to the Community. I hope your day is going great. 

As of right now, there isn't a way that you can create a file within QuickBooks Online. The only option would be to export the data out to a CSV file and make adjustments to the CSV. You could then send your CSV file to the bank. Below I've included the steps for exporting your bank register.

1. Open the Accounting menu.

2. Choose Chart of Accounts. 

3. Pick the correct account and click View register. 

4. Select the export icon at the top, next to the print icon. 

5. Your file will automatically download. 

That's all there is to it. Please let me know if there is anything that I could assist you with further. You can always reach out to the Community or me anytime you find you need help. Take care!

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.

Hi!  Since our accounting recently was attacked by fraud we are in need of getting positive pay information to our bank.  We only need to send them a CSV file to map.  The issue I am currently having is exporting the field "name to print on checks".  How can I pull that information?  I only need Date, name printed on check, check number and the amount.  The bank has name verification so it must be exact.  Can you help me locate that information?

Karen Brennan

[email address removed]

kbrennan@58found 

Are you using QB Online or QB Desktop. You need an exporter tool to do so.

Hi there, kbrennan@58found.
 

I understand the importance of  adding a file for a name to print on a check.

Right now, adding a signature to checks is available in QuickBooks Desktop and this feature isn't available yet in QuickBooks Online (QBO). I think this is a great idea and it would help many customer if we have this option in QBO. 

Feel free to submit feedback on this matter, as it helps us improve our product.

Here’s how:

1. Go to the Gear section.
2. Select Feedback
3. Enter your feedback and suggestions for us.
4. Click Next.
5. Choose Feedback for the category.
6. Click Send Message.

Your recommendation will be sent straight to our developers. They are the ones who will consider it when they implement future QuickBooks features.

You can also use this link to offer your suggestions: Customer Feedback for QuickBooks Online

As an alternative you can add a name to print on check on the vendor's profile. 

Here's how:

1. On the left pane, select Expenses.
2. At the top left, select the Vendors tab.
3. Find and click the vendor's name.
4. At the top right, click Edit.
5. On the Print on check as field, make sure to uncheck the Use display name box and enter the company name.
6. Click Save.

To know more about printing checks in QuickBooks Online, please read this article for more information: Print Checks in QuickBooks Online.

Drop me a comment below if you have any other questions about printing checks in QuickBooks Online. I'll be happy to help you out. 

Quickbooks Online.

I had our IT guy download the Trial of BRC but I haven't been able to get it running.  Does that software pull the "name to print on checks" into the file to build the positive pay for the bank?

Yes, the BRC PositivePay file Creator - QB Desktop does pull the Print As name for the positive pay files it creates.

If you have any issues installing or using it, even in its free trial mode, our support will help. Send questions or any issues you need help with using this page: BRC Support Request