Companies create a schedule of accounts receivable as a way of monitoring the amounts and due dates of customers with credit accounts. Accounts receivable refers to accounts to which a company offers credit. These customers make purchases from the company and pay the bills at a later date. Most schedules of accounts receivable are designed as aging schedules. An aging schedule lists each customer’s name, balance and a breakdown showing if the amounts are current or past due.
Open a spreadsheet program. The easiest way to create a schedule of accounts receivable is by using a spreadsheet document. Name the document and save it.
Prepare the heading. The top of the document should include the title of the report such as “Accounts Receivable Aging Schedule.” Under the title, type in the name of the company and below that, include the date of the schedule.
Enter column titles. A schedule of accounts receivable typically contains six columns. From left to right, the column titles are: "Customer Name," "Total Accounts Receivable," "Current," "1-30 Days Past Due," "31-60 Days Past Due" and "Over 60 Days Past Due."
Obtain the current accounts receivable ledger. This ledger is a subsidiary ledger containing all accounts receivable accounts and transactions. It includes all charges made to accounts, all payments, current balances of each account and due date information.
Transfer the details of the accounts. From the accounts receivable ledger, begin with the first customer by entering the customer’s name into the spreadsheet and the total amount owed. Separate the total amount owed by placing amounts in the correct categories. For example, if Sue’s Catering owes a total of $500, place this amount under “Total Accounts Receivable.” Of that amount, $100 is currently due and $400 is 45 days past due. The $100 is placed in the column labeled “Current” and the $400 is placed in the column labeled “31-60 Days Past Due.”
Repeat this step for all accounts receivable accounts. After all accounts are filled out into the spreadsheet, calculate totals for each column. The column labeled “Total Accounts Receivable” should be equal to the combined total of the other four columns. Place the totals for each column on the bottom row of the spreadsheet.