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.
