We've included a free downloadable accounts receivable Excel template in this piece. If you prefer, you can also use it in Google Sheets.Download this Microsoft Excel accounts receivable template to help your team collect payments in a smooth and timely manner. Our free Excel template organizes customer invoices, payments, aging reports, and more to inform projections and business decisions. Accountants use Excel all the time. Learn how to forecast accounts receivable with our stepbystep guide. You can track net revenue based on the account receivable money that you actually receive and the expenses you actually paid out.