Accounts Receivable Ledger

Use this free accounts receivable ledger in Excel to enter all your business sales invoices on account and to track payments made against them.

This ledger is not used for sales invoices that your customer pays for right away. It is only for those customers whom you have approved to have an account with you, allowing them to pay their bills in the future - like 7 days or two weeks or a month down the line.

GET FREE UPDATES
Enter your email address and name below and click on submit. You will also get 
our free eBook "Bookkeeping Forms and Templates". 

Email address

First name

Accounts Receivable Ledger Download

Tap the download button which will import a copy of the accounts receivable ledger to your computer. 

Below is a screenshot of the what the ledger looks like and further down are some explanations of how to use it.

Accounts Receivable Ledger
First Five Columns

After downloading the document and saving it to your computer you can enter your business name into the cell that says [enter your business name here] - just overtype the wording.

You can see there are two rows of data already in the spreadsheet. These are just examples for you to look at and you can easily overtype them to get rid of them.  Now you can enter your own information.

A Column - Enter the date of the invoice

B Column - Type in the invoice number

C Column - This is where you enter your customer name

D Column - You can input the total amount of the invoice

E Column - The date you expect your client to pay

Accounts Receivable Ledger
Remaining Columns Explained

The total of 10,620 heads up the F Column and is the total of all invoices that are due for payment. This column has formulas in it so it is very important that you do not type anything into the cells in this column because you will end up removing the formulas.

The Current Date is automatically set by Excel using the date setting on your computer.

Accounts Receivable Ledger Payments Columns

F Column - The balance due amounts are automatically calculated by taking the sum of the payment amounts away from the total invoice amount found in Column D.

G to R Columns - Every time your customer makes a payment you will enter the payment amount into the next available column - so if H and I already had payments entered in you would enter the payment into column J.

Column G - Red Triangle - If you are familiar with Excel you will know that the red triangle indicates a comment. You can insert, edit or delete comments by clicking your right mouse button. This is great for entering the date a payment was received so you can easily track how fast the customer is paying off their invoice.

Accounts Receivable Ledger
How to Use from Month to Month

If the month is May and you are issuing invoices to customer all through May then you should save this ledger into your computer calling it something like Accounts Receivable - May 2015.

Once May is finished and June comes around, open up a new spreadsheet and call it Accounts Receivable - June 2015.

For those invoices that have not been paid by the end of May, simply copy the rows those invoices are in from May and paste them into June.

Accounts Receivable Ledger
Notes Tab

In your Excel ledger at the bottom (see screenshot below) you will see one tab named Debtors, this is where the above spreadsheet is stored.

The other tab is called Notes and if you click into this you will see the spreadsheet detailed below. Once again, there is data entered here as an exampe for you to view only. You can overtype the detail and enter with your own.

Accounts Receivable Ledger Notes Tab

This page is a great place to record what your clients have said when you have called them about any of their overdue payments. Take a look at our Accounts Receivable Collections page that explains in more detail how to collect overdue payments from your customers.

Please use the contact form if you have any questions about this receivables ledger.

You may also like to see Accounts Receivable Procedures for more information on how to initiate customer accounts and maintaining this system.


You are here:

Accounts Receivable Ledger





Facebook Comments

Have your say about what you just read!
Leave me a comment in the box below.

Recent Articles

  1. Sales Register Template and Example

    Nov 12, 16 05:00 AM

    Sales register template and example for using with your manual bookkeeping system

    Read More

  2. Accounts Receivable Definition Plus Free Forms

    Nov 08, 16 07:06 PM

    Accounts Receivable Definition plus Free Forms You Can Use For Your Accounts Receivable System

    Read More

  3. Free Week Long Online Seminar

    Oct 14, 16 12:16 AM

    Putting time in to your online business but not seeing the results you want? Between 24-28 October join 10,000 like-minded women entrepreneurs for the free virtual summit guaranteed to make your incon…

    Read More

Back to Top : Accounts Receivable Ledger