Account Payable Template is a ready-to-use excel template easily to record your payable invoices all in one sheet. Just download the template and start using it entering by your company details.
Furthermore, it consists of a payment section that lets you know the amount outstanding to pay to that supplier against each invoice.
What is Accounts Payable?
As per Wiki
Accounts payable is money owed by a business to its suppliers shown as a liability on a company’s balance sheet. It is distinct from notes payable liabilities, which are debts created by formal legal instrument documents.
Or in very simple terms accounts payable ledger consists of the list of suppliers along with details like invoice number, date of invoice, date wise payments made and outstanding balance.
Excel is a powerful tool that helps us to create/design a tailored Account payable ledger.
Click here to Download the Accounts Payable Excel Template.
Click here to Download All Accounting Excel Templates for Rs 199.
In some companies, the payment cycle is too long and such bills are outstanding for longer periods. This is called aging in accounting. You can download and use ready-to-use Accounts Payable Template With Aging.
You can download other accounting templates like Cash Book, Petty Cash Book, and Purchase Return Book.
Let me share the basics of how I created this template.
Template Content
Row 1 = Enter Company/Business Name. Cells A1 to AD1. Merged cells.
Row 2 = Heading of the sheet. Cells B2 to BD2. Merged cells. Headings can put as Accounts Payable Ledger or Creditors Ledger.
Row 3 = Multiple headings as numbered below
- The subheading for the Current Date in A3.
- Next cell B3 will reflect the current date of the system using the formula =TODAY(). The date will automatically change according to the system date. You don’t need to change it every time and this saves your time.
- The next column for Total Due to date. The cell next to it reflects the total of column F which is the balance of each supplier. The formula applied here is =SUM(F5: F23).
Row 4 = This row consists of subheadings for data input. For example, see the table below:
Date, Invoice number, Supplier name, Amount of Bill, payment 1 and payment 2 and their respective date are details to be put while entering data.
For the Due date, you can set a function that automatically calculates several days for you and will show the exact date of payment. For this you will set the function as shown below:
= cell address which contains date + Number of days for allowed.
Here in our sheet, it is 45 days. So the formula entered is =A5+45. Copy this to all the cells below this cell, this will apply the same settings to all cells below.
Balance Amount here is calculated by deducting the total amount of bills – Sum(Payment1+payment2) etc. In this template formula used is =D5-SUM(H5+J5+L5+N5+P5+R5+T5+V5+X5+Z5+AB5+AD5).
If you have any queries or questions, share them in the comments below and I will be more than happy to help you.
good
Thanks Niaz
We want to Excel format for uploading GST sales
Kheta Ram jee, we are working on it and will soon upload it on our website.
dear sir how i can how my Payable
and i can create. please help me
best regards
Can’t understand your query. Please write in a language which I can understand.
SIR how i am cell increase
Right-click the mouse. Select Insert from the menu. Select entire row. Click OK.
While downloading formates error occured. No excel sheets downloaded
Kindly do needful.
While downloading excel sheets error seen
How can we download excel formates. Kindly guide
The link is working perfectly. It might be an issue with your internet connection or firewall. Please kindly try again.
You are really doing a great service, not just to the people but to the whole nation. Thank you very much sir
Thank You, Arun, for the appreciation. Your words mean a lot to us. Glad to hear that you liked it.
Great work. Thanks for this simply powerful site, helping to equip ieofosme startups
Great work. Thanks for this simply powerful site, helping to equip ieofosme startups
Thanks for the appreciation
Great work. Thanks for this simply powerful site, helping to equip SME startups
Thanks for the appreciation
That’s pretty straightforward payables template for starters and both professionals. I find excel sheet come in handy due to quick access to info without having to load web pages of online accounting software that I have been using.
Great work sir. Stay blessed.
for tds calculation any formate
No dear. Not posted yet. Have noted and will soon be posted on the website. Thanks
hi
thank you for the template.
how do i add more lines to the template in blue and white ?
use insert function to add more lines.
Dear Sir,
your work is indeed appreciated.
How can one change the currency of the Accounts Payable template.
Thank you for such a marvelous work.
Thanks for the appreciation. Glad to know it was helpful to you. To change the currency select the cell in which you want to change. Right-click on the mouse. Select “Format Cells”. Under “Number” tab select the third option “Currency”. ON the right side select your desired currency and format.
Hello,
How are you sir. Hope you are good and happy. Sir my question is when supplier 1 three invoices in a month how to find total amount.
You can do it by inserting a table and then by selecting the name of the supplier you can know the number of total invoices pending. The second and easy way is make an individual sheet for each supplier and at the end of the make a summary sheet for each supplier. We have another account payable template with aging in tables are already inserted and you can use the same for generating supplier wise report. Click the link below:
https://exceldatapro.com/accounts-payable-template-aging/
Sir,
Kindly explain the below mentioned formula and how I can update daily basis?
=VLOOKUP($N1,Refresh!$A$1:$X$10000,3,FALSE)
Thank u
Aji
Vlookup the value only in column N viz; N1, N2, … in the sheet named Refresh in table range A1 in the whole sheet and display the value in the third column with an exact match. This is the explanation of the formula.
I cannot tell how you can update on a daily basis unless what purpose it is used and what is the data. Thanks