cancel
Showing results for 
Search instead for 
Did you mean: 
stomasko
Level 2

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?

 
10 Comments 10
Angelyn_T
QuickBooks Team

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:

 

 

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

stomasko
Level 2

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?

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

Tori B
QuickBooks Team

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?

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!

 

 

 

BigRedConsulting
Community Champion

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?

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.

kbrennan@58found
Level 2

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?

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]

Fiat Lux - ASIA
Level 15

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?

kbrennan@58found 

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

AbegailS_
QuickBooks Team

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?

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. 

kbrennan@58found
Level 2

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?

Quickbooks Online.

 

kbrennan@58found
Level 2

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?

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?

BigRedConsulting
Community Champion

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?

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  

Need to get in touch?

Contact us