Accounts Receivable Aging Template



On the balance sheet, you will have account payable as a part as the liability. Otherwise, there will be account receivable which is included in the asset. If the payable shows the suppliers list you owe to, the receivable is a list of customers who have debt. When ordering the products, they may give you down payment and still have some funds unpaid. Creating the table of aging of accounts receivable will give you a clearer view about this concern.

Accounts Receivable Aging Template for Excel

Accounts Receivable Aging Template

Alike the account payable, in displaying the customers’ receivable, you can also use MS Excel as you can download below. It is a table with 9 columns. The labels are the same as the owe listing. There are the Date, Invoice Number, Account Name, Account Number, Description, 30 Days, 60 Days, 90+ Days and Total. After this table is made, you are ready to fill it. Check each account receivable of your customers or clients and list the credit one by one. This table will record all of them. You will know the customer who makes late payment for his debt.

[wpdm_file id=70]

On the balance sheet, you will have account payable as a part as the liability. Otherwise, there will be account receivable which is included in the asset. If the payable shows the suppliers list you owe to, the receivable is a list of customers who have debt. When ordering the products, they may give you down payment and still have some funds unpaid. Creating the table of aging of accounts receivable will give you a clearer view about this concern.

 

Alike the account payable, in displaying the customers’ receivable, you can also use MS Excel. It is a table with 9 columns. The labels are the same as the owe listing. There are the Date, Invoice Number, Account Name, Account Number, Description, 30 Days, 60 Days, 90+ Days and Total. After this table is made, you are ready to fill it. Check each account receivable of your customers or clients and list the credit one by one. This table will record all of them. You will know the customer who makes late payment for his debt.

Other useful templates...