That's where a detailed AR template comes in. It records and tracks all customer invoice information, improves organization, and simplifies financial reporting.Elevate your financial processes with our Excel-based Accounts Receivable Template. Summarizing total outstanding AR amounts; Forecasting future cash flow based on payment history. Use the Accounts Receivable Configuration form to specify ledger headings, invoice mapping accounts, and AR mapping accounts. FUND ACCOUNTING - The system should allow for the maintenance of user-defined control accounts linked to subsidiary ledgers (i.e. , accounts receivable, accounts. FUND ACCOUNTING - The system should allow for the maintenance of user-defined control accounts linked to subsidiary ledgers (i.e. , accounts receivable, accounts. Crystal Reports and Harris reports are used to populate an Excel spreadsheet that tracks check amount and fund.