How to Create an Accounts Receivable List
An accounts receivable list is a compilation of all accounts a company sells goods or services to on account. When a company sells on account, it allows customers to receive goods and services now but pay for them later. This list is also called an accounts receivable ledger. It contains the names of all accounts, account numbers for each and each account’s current balance amount. The bottom of the list contains a total amount that reflects all money that is owed to the company.
Assign account numbers to each account. Every person or business you sell goods or services to on account should have an account number. The numbers used vary by company and can be letters, numbers or a combination of both.
Label the list. Write “Accounts Receivable List” on the top of the document. If your company calls this document a different name, write in the appropriate title. Date the list underneath the title. This list will reflect the balances of all accounts receivable accounts on the date it is created.
List each account in order of account number. The order the accounts are listed depend on the account numbers your business uses. If they are numerical numbers, place them in order from lowest to highest. If the numbers contain letters, list them in alphabetical order. Place these numbers in the left-hand column of the list.
Write in the account name. Next to each account number, write in the customer’s name.
Fill in the balances. The next column is used for the balance information. Write in each customer’s balance as of today’s date in the next column. After all amounts are written, calculate a total of all balances. This represents the total amount of money owed to you by your customers.
Create an aged-analysis report. Often times, accounts receivable lists are created by separating the balances by due dates. To create this, complete the first four steps of this process. After that, write in due dates using the next few columns. Label the first column “Past Due.” The next columns contain labels such as “Due within 30 days,” “31 - 60 days,” “61 - 90 days,” and “over 90 days.”
Fill in amounts. For each customer, determine when the amount owed is due. Some customers may have several different categories of amounts. For example, if Sam Jones owes $1,000 for three different invoices with amounts of $200, $300 and $500. If each amount is due at different times, the amounts may be listed in three different categories.
Total it out. At the bottom of the list, total each category. This offers a breakdown for the company showing when to expect certain amounts of money.