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:
slwhagenhoff
Level 2

Reply to message

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!

 

 

 

 

 

 

 

Need to get in touch?

Contact us