Collaborate on Ms Excel Bill Sheet for Accounting with Ease Using airSlate SignNow

Ms excel bill sheet for Accounting

hello and welcome to my Ellison I am your guru and in this accounting series part 2 video I'll teach you how to prepare an Accounts Payable ledger in the previous video we had learned how to create a petty cash register now in this one we will learn how to create an Accounts Payable ledger now accounts payable ledger is a statement containing the list of all the vendors and their invoices and the amount due to those vendors and the details of the payments we have done to them alright so this will tell you as of today total amount that your company owes to all the vendors and the amount it owes to a specific vendor per invoice alright now if this in what if this vendor has given one invoice for $25,000 then the amount balance for this vendor for this inverse is $24,000 because we have paid five hundred dollars here and five hundred dollars here so this is a ledger Varian you can have part payments also for vendors and in case this vendor sends another invoice alright say let's say today again it says anna sends another invoice invoice number seven eight nine and the vendor name is ABC same vendor and the invoice amount is fifty thousand and then the due date can be say this date plus is equal to this date plus say fifty days credit so 10th August so balance amount is showing us fifty thousand for this invoice now if I make say a payment today only for let me change the format so that it looks nice I make a payment for say ten thousand see then the ballet for this vendor for this invoice is 40,000 balance due and the overall balance is one lakh twenty eight thousand two hundred dollars for the total offenders of our company so how do we create it I will tell you in this sheet okay let me explain so here in will mention the business name and then the company's name that is our company's name and the name of this ledger is accounts payable ledger over here we will have the today's date which will be shown over here automatically I've used a formula I tell you all this how to do this then totaled you as of today which says that totality of the company is as much then here we will enter the dates of each invoice and the invoice number and the vendors name if a vendor sends you two times three times then every time that vendors name will be mentioned over here then the amount of the invoice will be mentioned over here and the due date to you can either enter the due date directly or if you have a line of credit like somebody gives you 50 days of advance in this case how I did it is equal to date of invoice plus 50 so the due date will be 10th August here we will have the balance amount which we will calculate after we have understood this section so if you are making part payments or a single payment totally up to you this sheet can help you over here we will mention the amount of first payment and that date of that payment and then the date of the second payment and the amount of that payment and so on and so forth if you want to extend it you can extend it here also for payment three four five all right then over here what I have done SK I have got the difference of the amount of the invoice minus the total amount paid I will show you how and then over here I show the total due now I have simply written business name over here alright and I have merged in center these cells then I mentioned my company's name over here and in center these cells from here then I have written accounts payable ledger today's date by the way if you want to download this template you can go to my a lesson dot o-r-g and on this site when you go here is my side you can see a lot of videos alright and in the Downloads file section you will be able to find a lot of files to download all right we also sell our courses which you can buy from our site or you can call our telephone number mention on the website to buy our complete extra courses now over here I have mentioned today's date and then I have used a formula is equal to today so automatically sorry is equal to today bracket open bracket close so automatically whenever you open the file the date will be changed to current dates then over here I've mentioned total do as of today and here I will do some calculation now over here I'll mention a date say 15 Jan and the invoice number is 1 to 3 when the number is ABC when the name is ABC invoice amount is 50,000 all right over here what I did was I went to this section and Gavita format all right a dollar format if I want to give a currency format of a different country then I can do that also I could make it say euros and then the due date you can either type it in or if you have a credit system where in the due date will be 30 days after the date of invoice so I will do is equal to this date plus 30 so it will be due on 14 February now we can make the payments entry over here say for example on 18 Jan I make a payment of $500 so let's make this also dollar so that everything is ok all right and then on 25th Jan I make another payment of say $8,000 and then on 2nd February I make another payment of the final payment or say another payment or let's assume that so these are the two payments that I made so now the balance due should be is equal to this amount which is the total amount of the invoice minus some of this cell which is payment one and this cell comma and this cell and close the bracket so the amount you for this invoice is forty one thousand five hundred dollars now we can copy this formula alright and ctrl C select the bottom area to a right click go to pay special and formulas only so the formula is copied as soon as you keep on making entries this will be showing over here so let's make another entry see another invoice for Apple and this is for $25,000 the due date is 15 days from now plus 50 all right and today only I make one payment to this person all right and like copying the format from here I make a payment for $15,000 all right that's it now it says automatically that ten thousand is due correct now over here the total amount you for the company for my a lesson taught or D should be is equal to sum and the total of this column so overall the company my lesson taught over G was fifty one thousand five hundred dollars is in this cool simple for another invoice from ABC computers you can add it over here and then you will see the total amount you're decreasing ing to the payments you have made isn't this simple so this is how we make a Accounts Payable ledger well I hope you liked this video if you do please click on the thumbs up sign and to share it with your friends so that it can help others and please subscribe to the channel so that whenever there is a new video out you will come to know and I'll also feel happy that you have subscribed to me well until the next video now this is your guru signing off for the day have a wonderful day ahead happy learning