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

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.

Solved
Best answer September 13, 2023

Best Answers
BigRedConsulting
Community Champion

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?

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.

View solution in original post

36 Comments 36
SophiaAnnL
Moderator

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.

christa-d-bass
Level 1

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?

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.
randerson
Level 2

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?

Yes, exactly right.  My question was about exporting a file rather than importing.
christa-d-bass
Level 1

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?

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
libbya
Level 1

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?

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

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?

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

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?

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.
andy5
Level 1

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?

Anyone with an answer to this question?
Anonymous
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?

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.

HB at CSG
Level 1

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?

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.

slwhagenhoff
Level 2

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?

This is my solution, a work around, but works for my banks

Run Reports/Banking/Missing Checks

Select the bank account

With the customize tab at the top

                  On the Display tab - Select only the columns Date, Num, Name, Amount

                   On the Header/Footer tab - unCheck all boxes

                    Select OK to refresh report

Export to Excel, choosing to create a .csv file and choose location to save this report

 

For my bank I had to then open this .csv file in Notepad and remove the first header line and the 3 commas on the second line.  This will depend on your banks file definitions.  My bank allows me to set up the Positive Pay file definitions.  Also, some banks may require certain pieces of information in designated columns.  When this happens, create your Missing Check report and customize to your banks requirements.  This could be exported into excel if additional columns need added.  This excel file could then be saved as a .csv file.

 

Hope this helps!

 

 

 

 

 

 

 

slwhagenhoff
Level 2

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?

This is my solution, a work around, but works for my banks

Run Reports/Banking/Missing Checks

Select the bank account

With the customize tab at the top

                  On the Display tab - Select only the columns Date, Num, Name, Amount

                   On the Header/Footer tab - unCheck all boxes

                    Select OK to refresh report

Export to Excel, choosing to create a .csv file and choose location to save this report

 

For my bank I had to then open this .csv file in Notepad and remove the first header line and the 3 commas on the second line.  This will depend on your banks file definitions.  My bank allows me to set up the Positive Pay file definitions.  Also, some banks may require certain pieces of information in designated columns.  When this happens, create your Missing Check report and customize to your banks requirements.  This could be exported into excel if additional columns need added.  This excel file could then be saved as a .csv file.

 

Hope this helps!

 

 

slwhagenhoff
Level 2

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?

This is my solution, a work around, but works for my banks
Run Reports/Banking/Missing Checks
Select the bank account
With the customize tab at the top
On the Display tab - Select only the columns Date, Num, Name, Amount
On the Header/Footer tab - unCheck all boxes
Select OK to refresh report
Export to Excel, choosing to create a .csv file and choose location to save this report

For my bank I had to then open this .csv file in Notepad and remove the first header line and the 3 commas on the second line. This will depend on your banks file definitions. My bank allows me to set up the Positive Pay file definitions. Also, some banks may require certain pieces of information in designated columns. When this happens, create your Missing Check report and customize to your banks requirements. This could be exported into excel if additional columns need added. This excel file could then be saved as a .csv file.

Hope this helps!

JasroV
QuickBooks Team

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?

Hi there, @slwhagenhoff.

 

I appreciate you for sharing the details you've done to resolve this. The workaround you've provided can help other users who've also experienced this issue.

 

Having users like you who shared their knowledge to help other users here in the Community is much appreciated.

 

In case you need help with your QuickBooks Online (QBO) account, don't hesitate to leave a comment below. The Community is always here to help.

B Funk
Level 1

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 - Just wondering if anyone has solution for QBO?  These all appear to be for desktop version.  

RaymondJayO
Moderator

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?

Yes, there's a solution for QBO, @B Funk

 

You can run and customize the Check Detail report and export it to Excel. Let me guide you how. 

  1. Go to Reports from the left menu. 
  2. Enter Check Detail in the Search box. 
  3. Set the Report period
  4. Click the Settings (Gear) icon. 
  5. Check the Date, Amount, Name and Num boxes. 
  6. Choose Run report
  7. Export the report to Excel.

 

The screenshot below shows you the third to sixth steps. 

ExportCheckDetailReport.PNG

 

Once done, you can save the Excel format to a .CSV file. Then, add columns to enter the Positive Pay information. After that, you can upload the file to your bank. 

 

Customizing reports helps you get the information that you need for your business. Also, memorizing reports lets you save them with their current customization settings. For detailed steps on how to customize and memorize them, visit these two articles below:

 

 

I'm here anytime you have other concerns. Have a great day, @B Funk

B Funk
Level 1

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?

Thanks for this info, I appreciate it.  Is there any way to get rid of the "subtotal" and blank line right out of the report or is that just going to be a formatting process each time I run the file?  Also the check number coming in as a negative that will need to be reversed.  Thanks again.

JaneD
Moderator

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?

Hi there, B Funk.

 

The Subtotal that you may referring to is the second line item that affects your expense account in QuickBooks Online (QBO). You can add the Account column on the report, so you'll know what accounts affected by the debit and credit.

 

Just follow the steps above and ensure to select the Account column. Then, run the report again to save the changes.Account column.PNG

 

I've also added a screenshot of the sample report. Report.PNG

 

The following article will provide more information: How accounts are affected by debits and credits.

 

This means, the negative value affects your bank account. While the positive ones affect the expense account. 

 

However, the option to remove the blank line right out of the report is currently unavailable.

 

We are always looking for ways to make QBO beneficial to your business. I'll pass your input along to our product developers. They'll be able to review and may implement this in the future updates.

 

In the meantime, you can visit our blogs to stay current on all the QuickBooks news and announcements. 

 

Here are the links for your reference:

If I hear any changes, I'll notify you in this thread.

 

Keep me posted if you have any follow-up questions. I'm always here to help. Take care and have a great day.

KMO
Level 1

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?

Is there anyway to produce the check report with the field "Print on Check As"?  This would solve many of our positive pay issues

RCV
QuickBooks Team
QuickBooks Team

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?

Great to have you here, KMO.

 

The option to produce a check report with the Print on Check As is unavailable in QuickBooks Online (QBO). However, if you'll want to show the check print status, we can add the Check Printed column.

 

Here's how:

 

  1. In the Check Detail report, click the Customize button.
  2. Hit Rows/Columns and tick Change columns.
  3. Place a checkmark for Check Printed.
  4. Tap Run report.

If the option provided doesn't work on your business, just export the report to Excel. Then, customize it to come up with the field you need.

 

Here's how:

 

  1. Click the Export icon drop-down.
  2. Choose Export to Excel.
  3. Open the Excel file and add the manually add the Print on Check As field.

To learn more about managing your checks report, please check out these reports:

 

Fill me in if you need a hand with preparing your year-end report or any QBO related. I'm always here to help.

Laurie2911
Level 1

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?

How do you get the numbers not to be negatives?

 

Laurie2911
Level 1

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?

How do you get the numbers in the csv file to not be negative?

JessT
Moderator

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?

Hi there, Laurie.


The data on your CSV is from your bank. We have no control whether they provide amounts in one column, combines the negative and positive amounts, or in two columns, separating the debits and credits. The good news is we have a way to upload your transactions for both setups. I'm happy to show you how.

 

We only need the basic data of your transactions in the CSV file; the date, description, and amount (in 1 column or in 2 columns). 
 

 

When you reach on the page to map your transactions, just select the corresponding columns in the fields indicated. Here's a sample for both setups:

 

 

After uploading, you can manage your transactions and add them to our bank register.

 

We'll always be helping you with online banking and other processes in QuickBooks. Just comment below.

Fiat Lux - ASIA
Level 15

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?

@KMO 

Utilize the exporter tool to get the data in XLS format

https://transactionpro.grsm.io/qbo

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

You can see it as one of the available field 

RefNumberBankAccountVendorPrintOnCheckNameTxnDateLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteToBePrintedCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101CheckingJoe's Coffee 01/10/2020 12 Main StreetSuite 102  AlbanyNY12345  N  General SuppliesGeneral Supplies85.21           
102CheckingCostco 01/10/2020 PO Box 1000   DallasTX28456  N  General SuppliesGeneral Supplies125           
103CheckingProperty Mgmt Assoc 01/10/2020 PO Box 1800   AlbanyNY12345 Mar 2011 RentN  RentRent1000           

Need to get in touch?

Contact us