Effortlessly Manage Your Finances with a Bill Ledger Template for Personnel

Bill ledger template for Personnel

In this video we will know how to create a customer ledger inside the alphabet first we give a little overview here how this sheth will work Here we have created a customer summary seat inside which we have scolded our customer's name here His balance is coming here, whether the account is debited or edited, he was surprised here that if we click on them then we will reach that place and by going there we can see that state in detail If we want to add a new party here, then simply we will add the serial number here, as soon as we add this serial number , the formatting of the table will be done automatically like we have to see their ranger here in detail then we will click here You will reach above that state, now here you see the name of the party, the total of the debit amount is here, the total of tomatoes will start here, whatever our balance is, the child's complaint account is debited or edited here, it will appear here As this balance is updated here, that balance will also be updated on the seat with summary. If we have to go back to the struggle children, then here we have created a button why as soon as we click on this button, we will reach the seats of the summary , let's talk about how we will make it first. We give the heading to the page Customer Summary, so here we take the serial number customer is the debit or credit of the following account balance and the details after formatting it, will select it, will increase the emerge center size, this is and change such color Let's select a table range that after that we will press control page here this option my table headers this option will be ticked why will you press ok from here you can change the formatting of this table i do software here I have been that these factors that we do not need, then we will remove them, here we will press control shift process, the features that will be removed, this customers America format is ready for us, now we will prepare different rangers for customers like our The first customer is Shree Enterprises here Let us add the shatter and make it medium from Shree Enterprises that we will start writing this serial number date this particular debit credit balance and debit or credit now we debit exactly inside we liquid inside We have balance here and I will make the final debit or credit, here we will write the name , we will also pepper them, here we will see the name of our customer that we will select them and center their alignment and their turn color change of welding that we can take them select turn Change in table format these Rens control Prsti Press Mai table headers it seem option it will press on your clear we table style here If we don't need these feeders, we remove them too, here we will press control plus and this feature will be removed, now here we need debit card total and here we need credit total, here we will support a simple for is Equal and this range will be selected, the same village will also be here. Even if formal you will raise this is the equation and we will select this range were to find the closing balance here we will put the form is equal debit amount - credit amount whatever our closing balance will start from here of here If we want to see this as debit or credit ing to a closing balance, then we will put the formula for it, this absolutely difficult will select this cell that if the amount is less than zero within this year then it will show to us credit and If it is more than zero then show it Debit will select soldiers this type of festival Akho Ma Quotation Mark Open President Quotation Mark Lose Cover Will open Quotation mark from back Will Debit Quotation Marks Close bracket and press Enter that here As it will be debit or credit it will show us this formula, copy and paste it here, let's go to the serial number, we will type the serial number here, now that how will pass the entry, he may know that you have This is the party's opening balance and It may not be any political, if you have any party's opening balance, then here we will type opening balance this a. If the opening balance is debit then we will put it in debit, if there is credit then we will put it in credit, after that to remove the balance For Urmila will put in the first letter of the balance we will support for Debit - Credit the that in her next selfie inside we will put for disbalance plus debit - credit will it be whatever you have opening balance or any you pass entry You will either enter the balance, you will put it as a credit, if the balance comes on the debit side then here the balance will look like normal and here it will be debited that if this same amount is discarded then here the balance will show in negative and here credit to yes Will show now here we will insert a shape, go inside this hole whatever shape you like, now it can stay that happened that first I change the name of this sheet, now the powers will come on it if right click on it Click on the option link here. The comment will select this option and here we will select the summary item and press above OK, now why we click on it, then we will reach the areas of summary that we have made this for one of our customers, this is how we We will create our other customer care like our other customer is targus traders in colors we will come here to create after coming here right click on mouth and copy option why will it select muttu end option after that here But the option is tick next to the creator of this option and click on ok why a copy of this shade will be prepared from here we will change its name that here 20 someone changes and if any entry we have entered here But if it is curry, then we will change it by removing it, in this way we will create all our razors, here it is a matter of mystery creation that now here we want that whatever balance we have for all the customers, it should start here, so for that What will we do let's know like here we need balance of Shree Enterprises Here we will support the formula is equal, after that the pimples of Mr. Enterprises will go here , select the closing balance and press enter, whatever balance is there, it will come here, the same will be done for them as well , it happened that here we have The balance has arrived, now we need to do debit and credit here, then here we will apply the form this equal it's president, if the amount is less than zero within this year, then show us the credit, otherwise show the debit, this formula we Post here village we will click on this vada too that if we click here then we reach it here i clicked hair fall happened that now i will right click here here option link will click on it The name of the customer whose account you ring, you will see it here, we will select it here and click on OK and above, so that we will link everyone like this, now after ringing, when we click here, we will say that hey If we reach the places, then we can create the eye of our customer in such a way that we can maintain them. Why this video is all thanks for watching