Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
R
randerson
October 16, 2018
Question

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?

  • October 16, 2018
  • 40 replies
  • 101 views

File would include check #, $ amount, check date and Payee name on the check.

40 replies

SophiaAnnL
SophiaAnnL
Level 5
October 16, 2018

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.

L
lindak1119
Level 7
October 16, 2018
Anyone with an answer to this question?
Fiat Lux - ASIA
Fiat Lux - ASIA
Level 14
February 20, 2020

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


@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           
A
Anonymous
January 10, 2019

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.

BigRedConsulting
BigRedConsulting
Level 15
September 13, 2023

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.

    M
    MattL
    December 11, 2023

    Do you have a video link for your product? How does your product compare to the positive pay from Treasury software?

    BigRedConsulting
    BigRedConsulting
    Level 15
    December 11, 2023

    We don't have a video link. However, you can try the BRC PositivePay file Creator - QB Desktop  and/or the BRC PositivePay file Creator - QB Online in trial mode for 30 days to see how it works for you. The trial is fully functional and there is no charge or registration needed to start the trial. Just download and install to start the trial.

     

    I have not used the Treasury positive pay product and so don't know exactly how the tools compare. I did review their site and it appears that both tools do basically the same thing.

    D
    DGrigg
    September 20, 2023

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

     

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

    FOYVLeslie
    FOYVLeslie
    October 30, 2023

    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!

    Morgan_B
    Morgan_BQuickBooks Team
    QuickBooks Team
    October 30, 2023

    Thank you for sharing this info, FOYVLeslie.

     

    Fellow QuickBooks users helping out by sharing their first-hand experiences and product knowledge is one of the best things about the Community. Take care!

    J
    jJillHRFD
    February 7, 2025

    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

    J
    jJillHRFD
    April 15, 2025

    thank you & I have done this...

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement