We need an out of the box "Check Register" available in the Accounts Payable module to run a listing of checks issued and filtered on date range and check number. There currently is a CHECK DETAILS under bank reports but it does not allow filtering by check number. We need to be able to total by the different ranges of types. Then it also doesn't print to excel in a neat single line format in excel to allow users to use the data in other manners. I had our partner add the filter for check number to the standard report but when you choose the send to excel option, the formatting of the lines and sizes of columns doesn't work. It should output like when you print the accounts receivable summary to excel. Our partner estimated 8+ hours to make this happen.

A check register should be a standard report. Not everyone utilized the bank reconciliation forms and we need to be able to compare to bank outputs and total for batching.