Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowThis 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!