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.