Account Receivable Worksheet

Reviewed & updated by Updated Originally published

An account receivable worksheet is a document that records all the amounts a company is owed by its customers. In simple terms, it shows the amounts customers have not yet paid for the products or services the company provided. Invoices are issued to customers and recorded by the company, but they remain unpaid until the customer pays.

An account receivable worksheet is a helpful tool for tracking the outstanding bills owed by customers and making sure that no bill goes past its due date. Invoices are created when a business sells products or services to customers. Customers are expected to pay each invoice within the agreed time, either in one payment or in several installments.

Create your free worksheet below:

Account Receivable Worksheet

Enter your unpaid and part-paid customer invoices. The balance, days overdue and aging buckets are worked out for you.

Worksheet Details

Days overdue are counted from the as-of date. An invoice with no due date is due on its invoice date plus the default payment terms.

Invoices
Add Many at Once

Write the date as YYYY-MM-DD and the amounts without thousands commas. Lines pasted from Excel (tab separated) or separated by semicolons also work, and then a customer name may contain commas. Paid is optional. Up to 60 invoices.

What to Show

The filter applies to the preview and the printout. The Excel file always contains every invoice.

Page & Style

Portrait hides the invoice date, amount and paid columns. The balance and aging columns stay.

Live Page Preview

Businesses track the outstanding invoices of every customer to make sure that none becomes overdue and that payments are collected within the agreed time.

Every business has its own policies and procedures for dealing with customers. Payment terms differ from one business to another. Some businesses require payment immediately after the purchase, while others allow customers to pay within a set number of days. An account receivable worksheet keeps the business aware of the money it is still owed by every customer and helps maintain a steady cash inflow.

What to Include in the Worksheet?

The contents of an account receivable worksheet depend on the policies of the company that maintains it. They are usually the following:

  • Customer information: the customer’s name, and other details such as an account number or contact information if the business needs them.
  • Invoice details: the invoice number, the invoice date, the due date, the amount of the invoice, and any amount already paid.
  • Balance: the amount still owed on each invoice.
  • Payment status: the status of each invoice, which is usually paid, current (not yet due) or overdue.
  • Aging: the number of days an invoice is overdue, and which time group it falls in, such as 1 to 30 days or over 90 days.

The worksheet is made up of columns, where each column holds one of the details above, and the data is filled in according to the sales made. The columns can be customized to include more information about the customer or the sale.

An Easy Tool

An account receivable worksheet is important in managing a business because it makes cash flow easier to control. Its importance can be seen in the following points:

  • It keeps an organized record of every invoice for every customer, and it can hold a large amount of data that is updated regularly.
  • The business can act on overdue payments, for example by sending reminders or following up with the customers concerned.
  • Instead of using savings, businesses can rely on expected payments for future investments and production.
  • It helps the business keep going during slow seasons.

With this account receivable worksheet, you can enter your invoices and see the balance, the days overdue and the aging group of each one worked out for you. The worksheet also shows a summary for each customer. You can print it, save it as a PDF, or download it as an Excel file.

Account Receivable worksheet template
Account Receivable worksheet template