Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
waldo22
Level 1

Reply to message

I have discovered a way to create a "Positive Pay" report from Quickbooks Desktop - mostly.  It does everything you need except that it uses the "Vendor Name" field instead of the "Print Name on Check" field.  If you have to have the Print on Check field, you'll need to use @BigRedConsulting 's solution.

 

Here goes:

  • Go to "Reports -> Banking -> Missing Checks"
  • Choose the bank account that you are creating the report for
  • Go to "Customize Report" at the top left
    • under "Display" tab, choose "Date", "Num", "Name", and "Amount".  Uncheck everything else.
    • under "Filters" tab, choose "Cleared: No"
      • if you see electronic checks or ACHes mixed in with checks, add a filter for "number" between 1 and 100,000 or something that matches the range you'll be writing checks in
      • if you see deposits, add a filter for "Amount" <= 0
    • under "Header/Footer" tab, uncheck everything
    • click "OK" to save your choices.
  • Click "Memorize" and call the report "Positive Pay" or something helpful to you so you can use it from now on by going to "Reports -> Memorized Reports"
  • Click the "Excel" button and export to .csv

 

When you write checks, go to your memorized report and run it for the day you just wrote them for

 

Again, this will get you most of what you need, but if you need the name printed on the check instead of the vendor name, you'll need to change those fields by hand, our buy @BigRedConsulting 's Positive Pay creator here:
https://bigredconsulting.com/products/positivepay-file-creator-for-quickbooks/

Need to get in touch?

Contact us