Download free templates in Excel and Google Sheets formats, and learn how to create a cash flow forecast. This spreadsheet walks you through the process of developing an integrated set of financial projections. 6.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. It is the Inter Company Loan Matrix that allows you to build the relationships between these companies and the relevant accounts. Accounts Payable Invoice. And remitted to the owners from accounts receivable and accounts payable, respectively.