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 which helps us to create/design a tailored Account payable ledger.
Click here to Download Accounts Payable Excel Template.
Click here to Download All Accounting Excel Templates for Rs 199.
Let me share the basic of how I created this template.
Template Content
Row 1 = Enter Company/Business Name. Cells A1 to AD1. Merged cells.
Row 2 = Heading of sheet. Cells B2 to BD2. Merged cells. Headings can put as Accounts Payable Ledger or Creditors Ledger.
Row 3 = Multiple headings as numbered below
- Sub heading for Current Date in A3.
- Next cell B3 which will reflect the current date of system using the formula =TODAY(). 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 till date. The cell next to it reflects total of column F which is the balance of each supplier. Formula applied here is =SUM(F5:F23).
Row 4 = This row consist of sub headings for data input. For example see 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 which automatically calculates number of 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 comments below and I will be more than happy to help you.
Niaz Ahmed says
November 23, 2016 at 2:53 pmgood
Fahim Lashkaria says
November 30, 2016 at 3:21 amThanks Niaz
Kheta Ram says
June 28, 2017 at 6:21 amWe want to Excel format for uploading GST sales
Fahim Lashkaria says
June 28, 2017 at 6:30 amKheta Ram jee, we are working on it and will soon upload it on our website.
mansoor says
December 11, 2017 at 12:42 pmdear sir how i can how my Payable
and i can create. please help me
best regards
Fahim Lashkaria says
December 12, 2017 at 10:43 amCan’t understand your query. Please write in a language which I can understand.
SUNNY says
January 18, 2018 at 3:39 pmSIR how i am cell increase
Fahim Lashkaria says
January 18, 2018 at 5:41 pmRight-click the mouse. Select Insert from the menu. Select entire row. Click OK.
Rohini says
July 22, 2018 at 5:04 pmWhile downloading formates error occured. No excel sheets downloaded
Kindly do needful.
Rohini says
July 22, 2018 at 5:07 pmWhile downloading excel sheets error seen
How can we download excel formates. Kindly guide
Fahim Lashkaria says
July 23, 2018 at 11:15 amThe link is working perfectly. It might be an issue with your internet connection or firewall. Please kindly try again.
Arun Kumar says
August 24, 2018 at 3:17 amYou are really doing a great service, not just to the people but to the whole nation. Thank you very much sir
Fahim Lashkaria says
August 24, 2018 at 10:37 amThank You, Arun, for the appreciation. Your words mean a lot to us. Glad to hear that you liked it.
Ifey says
October 4, 2018 at 2:58 amGreat work. Thanks for this simply powerful site, helping to equip ieofosme startups
Ifey says
October 4, 2018 at 2:58 amGreat work. Thanks for this simply powerful site, helping to equip ieofosme startups
Fahim Lashkaria says
October 6, 2018 at 5:35 amThanks for the appreciation
Ifey says
October 4, 2018 at 12:25 pmGreat work. Thanks for this simply powerful site, helping to equip SME startups
Fahim Lashkaria says
October 6, 2018 at 5:35 amThanks for the appreciation
Shakir Ali says
February 5, 2019 at 5:10 pmThat’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.
anil says
February 9, 2019 at 6:09 pmfor tds calculation any formate
Fahim Lashkaria says
February 11, 2019 at 11:49 amNo dear. Not posted yet. Have noted and will soon be posted on the website. Thanks
mei says
April 11, 2019 at 9:53 pmhi
thank you for the template.
how do i add more lines to the template in blue and white ?
Fahim Lashkaria says
April 12, 2019 at 11:05 amuse insert function to add more lines.
Abel says
July 18, 2019 at 9:56 pmDear Sir,
your work is indeed appreciated.
How can one change the currency of the Accounts Payable template.
Thank you for such a marvelous work.
Fahim Lashkaria says
July 19, 2019 at 3:40 pmThanks 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.