cancel
Showing results for 
Search instead for 
Did you mean: 
rweber
Level 1

We have QuickBooks Desktop Pro. How do we generate a list of checks issued in a given period in a CSV format to upload to our bank for Positive Pay verification?

 
Solved
Best answer September 30, 2020

Best Answers
BigRedConsulting
Community Champion

We have QuickBooks Desktop Pro. How do we generate a list of checks issued in a given period in a CSV format to upload to our bank for Positive Pay verification?

To create positive pay files directly from your QuickBooks Desktop company file, use our BRC PositivePay file Creator - QB Desktop  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
JaneD
Moderator

We have QuickBooks Desktop Pro. How do we generate a list of checks issued in a given period in a CSV format to upload to our bank for Positive Pay verification?

Hi rweber,

 

You can import bank transactions into QuickBooks Desktop. From there, checks issued will be uploaded and generated in your register. 

 

Beforehand, install the QuickBooks Import Excel and CSV toolkit. This toolkit contains a manual guide. I'll show you how.

 

  1. Open the file download window for the toolkit and then select Save.
  2. Go to your Windows Desktop and select Save.
  3. Double-click QuickBooks_Import_Excel_and_CSV.exe on your Windows desktop to open the WinZip Self-Extractor window.
  4. Choose Browse, select the folder where you want to install the toolkit (such as your Desktop) and click on OK.
  5. Select Unzip to extract the contents and select Close to close the WinZip Self-Extractor window.
  6. Open the QuickBooks Import Excel and CSV folder from the location you selected in step 4.

Then, follow the steps in in this article to import the CSV file: Import/export CSV files. This link provides other data types you can import into QuickBooks. 

 

You may want to check this link in case you want to connect your bank account with QuickBooks: Get started with Bank Feeds for QuickBooks Desktop. This helps speed up you work as this feature automatically downloads your transactions into the system.

 

Leave a comment below if you have any other concerns. We'll be here to keep helping. Stay safe and have a good day.

Juice
Level 1

We have QuickBooks Desktop Pro. How do we generate a list of checks issued in a given period in a CSV format to upload to our bank for Positive Pay verification?

This is my issue as well...but i cannot find the QuickBooks Import Excel and CSV toolkit.

I have Desktop Pro 2020 and for the life of me i cannot find any reference to a "File Download"

Is it in the program or do you have to go a website to get ? 

Adrian_A
Moderator

We have QuickBooks Desktop Pro. How do we generate a list of checks issued in a given period in a CSV format to upload to our bank for Positive Pay verification?

You'll have to download the tool kit file, Juice.

 

This file will automatically route you to the QuickBooks_Import_Excel_and CSV.exe window. Once downloaded, you'll have to choose which folder you'd want it to be saved. Let me guide you with these details:

 

  1. Download the toolkit.
  2. In the WinZip Self-Extractor window, click Browse.
  3. Choose where you want to save the file.
  4. Click OK.
  5. Select Unzip, and then OK.
  6. Click Close.

 

You can also use these screenshots as your visual guide:

 

 

 

Feel free to browse these articles on what data are to be exported and imported:

 

 

You always have me if you have questions when exporting or importing the data.

BigRedConsulting
Community Champion

We have QuickBooks Desktop Pro. How do we generate a list of checks issued in a given period in a CSV format to upload to our bank for Positive Pay verification?

To create positive pay files directly from your QuickBooks Desktop company file, use our BRC PositivePay file Creator - QB Desktop  app.  It supports well over 100 bank file formats and you can create your own custom file formats as well, both CSV ad TXT.

Need to get in touch?

Contact us