What Report to Run to View Receivables by Date

Go to Reports, under the Accounting section select the Receivables Listing and create it in Excel.

You can modify the columns and rows based on the date range you want to calculate the total, to date, receivables for.