Download Accounts Receivable Ledger Free Excel Template

Filter by Categories
Select all
Business Statements
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Invoice/ Bill
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
Filter by File Types

Download accounts receivable ledger format in Excel and Spreadsheet. You can use this template to Record date wise invoice and their respective payments.

The template shows invoice outstanding as well as total outstanding at given point of time.  This template is also useful in managing customer invoices and payments.

Check out account receivable report with ageing analysis in excel by Excel Downloads.

Understanding Trade Receivable

Accounts receivable or trade receivable is a legally enforceable claim for payment held by a business for goods supplied or services rendered that customers have ordered but not paid for.

These are generally in the form of invoices raised by the business and delivered to customer for payment within an agreed time frame.

In simple terms, accounts receivable ledger consists of list of debtors to whom we have rendered a service or supplied goods. Moreover with details like invoice number, date of invoice, date wise payments received and outstanding receivables from a particular client or all in general.

Role of Accounts Receivable department

Accounts receivable department is an important department in any organization. It handles the following functions:

  1. Firstly, issue proper invoice against goods or services rendered.
  2. Secondly, record invoices in the respective customer account.
  3. Thirdly, Match the prices with Purchase order or Delivery Challan.
  4. Furthermore, Report mismatch if any or issue debit/credit note against it.
  5. Ensure timely collection of payment against invoices as per payment terms or contracts.
  6. Prepare the list of outstanding invoices that are due since long.
  7. Report settle invoices against all collection done.
  8. Reconcile invoices and payments statements between company and customer.

In addition to the above, this department also verifies purchases and prepares aging analysis reports apart from customer management.

What is a Receivable Process ?

Receivable process comes under revenue and revenue recognition business process. Typically, it is a four step process –

  • Establishing the credit practices.
  • Invoicing the customers.
  • Tracking the Accounts Receivable.
  • Accounting for Accounts Receivable.

Also, this department coordinates with the Sales department to ensure smooth collection of payments as well as saving the company from bad debts or long outstanding.

Journal entries for accounts receivable

With this template, just insert your company name at the top of the template. Start using the template. Additionally, you can record payments and also get the invoice-wise outstanding and total accounts receivable outstanding.

Furthermore, it consists of multiple payment columns against each invoice so that you can also record part payments against invoices. Now let us understand some basic accounting concepts and journal entries associated with accounts receivable and sales –

Journal Entries for Sales

  • Account Receivable A/C – Debit
  • To Sales A/C – Credit

Journal Entries For Payments Received

  • Cash or Bank A/C – Debit
  • Account Receivable A/C – Credit

Journal Entries For Payments Received With Discounts

  • Cash or Bank A/C – Debit
  • Sales Discount A/C – Debit
  • Account Receivable A/C – Credit

The total of both credit amounts must be equal to the debit amount.

Journal Entries For Sales Return

  • Sales Return A/C – Debit
  • Accounts Receivable A/C – Credit

Download and Use Accounts receivable ledger Excel template

To use this free accounts receivable ledger format in excel, you should have Microsoft Office/ Microsoft Excel installed in your system.

After installing Excel or Spreadsheet, download the zip file of this template, extract the template using WinRAR or 7Zip decompressing software.

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click the button below to Download Accounts Receivable Ledger Excel Template

By Downloading this Free Excel Template, it is implied that you comply with Download Instructions

Download Instructions

If the excel templates can not be downloaded, Leave us a feedback at We will solve the related problems/ query for you as soon as possible. All Excel templates and dashboards and tools are sole property of As a User, you can download and use the excel templates, dashboards and calculators for personal and business use with no payment i.e. for free. But without permission, you can not distribute it on the Internet website or any other online or offline medium !

Without permission granted from us/ management team of, use of these excel templates and dashboards is not allowed. However, if you want to share this templates and dashboards with your friends and peers, we have provided sharing option in various social media and platform via which you can share our content.

We hope that you can get our help in making your personal and business activities easier with the use of free excel templates and dashboards, and at the same time, support the construction of our website by considering our efforts and aforesaid instructions.