Need a detail report of Customer Deposits as of a specific date with job #s

I need to be able to print a report showing the detail of what makes up the total customer deposits at any given date (along with the end total which ties to the balance sheet), and I need this report to also show the job #s that the deposit is for. Currently, I preview an AR Aging Report, copy and paste it to Excel, sort by description and total the Customer Deposits, then manually look up each one and add the job #s to the spreadsheet. This is a report that our external auditors ask for each year.