Simple Positive Pay Report to Provide Our Bank for Printed Checks Only
We've had an unacceptable increase in the number of printed checks that are being taken from our vendor's mail or somewhere in transit followed by fraudulent attempts to cash them by unauthorized people.
Our bank has suggested that we adopt the process and procedure referred to as Positive Pay, where checks are matched to our pre-authorization of payee names, check numbers, dates, and amounts.
A large number of vendor payments are made electronically and do not need to be included in this added security process. The recommended method of later recording the payments made elsewhere electronically into QuickBooks Desktop Enterprise Suite is to create or pay a bill in QuickBooks and then replace the check number with a description acronym like EFT or ACH.
That makes it hard to segregate printed checks and electronic payments when attempting to filter a report by payment type(s).
Does anyone have a recommendation on how we might address this?
Secondarily, does anyone have a simple Positive Pay report format that we can use to export to Excel and send to our bank with just the Date, Check Number, Payee Name, and Amount listed for a given period?
Thank you.