Empower Your Business with Personal Contact Management Software in Loan Agreements

How to create outlook signature

hello and welcome to another demo video with skin tech coding Clinic so in this video I'm going to walk you through step by step how this amazing mini banking system we have developed using Microsoft Excel and VBA programming I'm going to show you how the system works step by step I'm going to show you all the features in the system and how each and every functionality of that system runs okay so that is that about this video now let's quickly delve right into that foreign welcome back once again so now if you have just discovered this channel for the first time consider subscribing to the channel you press the Bell icon so that I get notified anytime we drop videos like this okay so now let's look into the system so to start with we need to log into the system phase you need to log in by clicking on this button here then we enter our login credentials okay then we go so quickly we are logged into that system so now let's go through each and every sections of the system so to start with if I would want to display the various toolbars as well as all the Microsoft ribbon I would have to click on this and then I'll have that displayed okay that is that so let's look into each and every sections from the system so we'll start with if I would want to get an account number I'll assign account number to a customer I would have to click click on this and then quickly I'll be navigated to this panel where I can fetch any of this account number here then assign it to the customer there is also another option of how we can Generate random or unique account numbers for each and every customer so let's go back moving forward if I want to reset my password I'll just have to click on this and then here you can see this is the username admit and this is the password so if I should go ahead and change this that will become the new user name as well as the password okay let's go back also I can equally sign out your log out from here click on this if you say no nothing happens like click on this AC yes and then you are logged out then I will just have to log in once again I'm back okay so basically that is that now let's go into the accounts database whenever we create accounts where are all the details going to be so click on this and we have all the details here we have the account number the accounts name the address the phone number the email address the date of birth agenda as well as the date okay let's also look at the transactions database whenever we execute some transactions in the system where does all these details get get into so we click on this and we have all the details we have the transaction number the accounts number on which the transaction has taken effect you have the date of transaction we have the purpose of the transaction as well as the transaction is it withdrawal or deposit to keep track of all these things here also before a user or a customer uh orbit before we create an account for a customer the customer has to fill a form so you have the account from here so your customer has to filler form and then add the passport picture here so we use these details to create new accounts for the customer so we can just print this from here as we click on this we can just give it a name and then we print it so let me just give it a name like ACC frm for short I want to leave it on the desktop and click on Save okay so once I let's finish once I minimize this and then we have this let's just double click this you can see we have the account from here and that is that moving forward let's quickly go home once again we also have deposit form okay if a customer wants to deposit funds into his or her account we use this form for that so we have it here as well so we can see the years I have to fill in this and then use it to deposit your files into your account you can call it print that from here as well as check it again you can just name it Depot frml for short and then we just go ahead and save it on the desktop so quickly we should go here and then get it up and running so you can see that as well from here there we go moving forward let's quickly navigate to we also have the withdrawal sheet if you want to withdraw funds from your accounts we have that here so you can see that as well here so when we enter the customer's account number here then we have the customers name appear on the withdrawal sheet as well as the accounts numbers which we can then go ahead and print for the customer to use in withdrawal of files so we can call it with frm for short then we save it on the desktop so let's look at how it also looks like so there we go we have this as well here so that is that I'll show you how all those things work as we move along let's go back home so we also have the loan forms okay someone comes to apply for loan the personal house for filler form so they have the loan forms from here which we can equally print from here I don't want to go into that again you already seen me doing that already so let's go home and we also have the known data base okay the loan details on I'm going to capture where as all these details go they have the database for us so this is why all those things are kept so we can refer to them and use them for whatever Vehicles we intend to and we also have loan deductions whenever we do transactions on loan deductions where that's all these details get stored is here so there you go for that as well you can quickly navigate and come back home okay and here we also have this dashboard where we can go ahead and create an account from here also do transactions from here and also print statement from here as well and to create an account we have this button here you can also click on this you enter the Account Details then you go ahead and create an account we also have transactions okay the person wants to withdraw the person wants to deposit we use this form for transactions and then loan if we want to capture loan details we use this form to capture loan details as well and then deductions of loan that is also here you takes effect from here as well so basically that is that now let's start with the accounts creation Now to create an account for a customer for the first time you can equally just click on this dashboard group then you start from here as well and then go ahead and create an account you can equally use this button as well so let's use here so here we can just click on this button here to generate the accounts number for the customer so once I click on this you have the account number generated you can just keep clicking you should have random account numbers generated okay so we can use this as our account number then we assign a name to it let's say the name is amayao for short okay and then the address maybe on my streets and then the phone number let me use my phone number zero five four two five my zero eight like four in the email address maybe dot com and then the date of death they will click the calendar and they'll get a date of birth and then date on which the account has been created you choose that date as well then the gender is female so we go ahead and grab the passport picture for Amma from here let me just go this way and then grab it from here go to my database and then let's go to um passport pictures so I can just go ahead and grab this picture for armor and then the signature I can upload the signature from here and go back and within that Apple writing from here and then choose this as well so this is Amazo so we are done entering we can just go ahead and then see if I would want to copy this account number because I'll be using it for searching of this same data so I've just copied it now I can then go ahead and save these details here that will save it so you can see that the total number of customers initial it was three but now it is full so now let's go ahead and search for these details and sorry click inside and paste the account number once you click on search you have this return supposing you would want to change something here after searching the details you can just go and let's assume that the address is how much treat number four so number four you can change that as well so once you are done with that then whatever changes you want to change you can do that from here once you either click on updates and then quickly you will have that updated so now if we should go ahead and search for hair again you see that the update has taken effect okay so basically that is that now let's move forward now that we are done creating an account for Amal then there is the need we deposit funds into our Mass account for the first time so I've just copied this account number again so I'll close this then I'll then go to transactions okay but before then we can then go to the database and see how as details so you can see we have a my ER from here our street number four in the phone number you see I'm at home.com then the date on date of birth is here then female and then date on which the account is created and all that so you can see that everything is here up and running so we can then move at home then let's deposit funds into amma's account so to do that you can then come to this transaction button which we can equally get from here as well so you click on that okay so to do that you would have to go ahead and then paste or enter amma's account number from here with the space start here then you proceed now what I would want you to know is let me copy this once again from here and show you something if I should just go ahead and change something here and proceed you can see that it tells me the account number doesn't exist because we don't in our database we don't have this particular accounts number inside of our database so it will clear everything we would have to enter the account number that exists inside the database so this is also how other form of detecting non-existing accounts into their system so as we are going to deposit to make sure you toggle it to deposit if it's withdrawal basically deposit like this so the purpose is what deposit so we just enter the papers we just deposit and then the amounts let's assume that you would want to deposit 50 000 Ghana cedis into inside the account so once we are done we just go ahead and click on Save okay now we have that saved so now if we should go ahead and enter the account number here once again and proceed you see that now the account balance is now 50 000 so basically that is that then the purpose is what deposits so let me just enter that then the amount is worth 50 000. the effect there we go fifty thousand shots one two three so once we are done with that after deposit would want to send our message to confirm that we have just deposited this amount inside here or into her account so to do that we click on send deposit message if it is withdrawal they will click on send withdrawal in this case we are going to be sending deposit message so we just click on send deposit so you click on this and there we go from here you can then go ahead and close this one so here we are going to send deposit message to Amma from here so to do that what we are going to do is to get our message from here so we click on this so on this interface here just click on copy message and this copies the message for you so once we are done copying the message I'll just click on done and I'll come back here then from here what I'm going to do is just to click on this particular tab here which I'll be showing you how to have this running inside your Excel so I can use that to send messages box messages and all that okay so once we click on this we have options here to send message to Alma for the transaction which is all about deposit or funds so here we click on send message and then click on compose message so I'll then choose my sender ID so you can request for sender ID from that particular website which I'll be showing you how to do that I already recorded a video on how to apply for sender ID on this particular website and I'll leave the link in the video description below you can just check that out and then you should be good to go I use that site to register for all or apply for all these sender IDs that I use for my tutorials and other stuff so I guess why they choose ktcc as my sender ID and from there then go ahead and proceed and then paste the message I copied from there now once I'm done with it I'll just click on personalize and then from there you can see that the variables are signed inside the messages inside the message are all displayed here so the next thing I'll do is just to click on next so from here then I'll just click on ADD then I'll choose from this particular sheet the details I'm going to send messages or the message to is from this particular sheet so I just choose from sheet so once that happens then I would want to choose as yeah get the various columns which holds each and every digital they have the name column we have the phone number column account number column this is what I've discriminated here to guide you on which to choose for which column with the phone number color we have column B so you just double click here and you should have column B you choose that then the name column is column A just double click here and then you have column A for name the account number is in column C just go ahead and choose column C then the amount is in column words column F which is column f for that then the purpose is column e then you just write it into column e for that and then the date is in column D you can just buy it into column D for that and then the balance is in column G the engage choose column G as well for that so once you are confident with all these things you just click on OK and you should have this up and running now there we go it says one unique destinations have been added so once you click on OK so from here we can then go ahead and send message here I use my own phone number then I'll be showing you how this message is going to be displayed on my phone so let's look at the details the name is Amma yeah then the phone number here then account number is here in the purpose is deposit and then the date on which the transaction has done the 7th February 2023 and then the amount is five thousand and the balance is five thousand take note of that so once I click on send I have the message sent quickly so you can see that it says message dispatched now I'll be showing you how that message looks like from I've just received the notification on my phone now let's go straight to my phone to see how this message looks like now here I am on my phone let me just tap my messages then quickly we just open this now and then you can see it says what hi am I out the account number six zero six zero zero one three one zero five six five has been credited with an amount of what five thousand or fifty thousand Ghana cedis description is deposit and then the date is 7 February 2023 and then the balance is 50 000 so that is that for the message that is um the message the transaction message or the deposit message received so that is that thank you all right so now we are back and we also got message that Amma has just received on the transaction that is the deposit to once the message is sent or is dispatched you can then go ahead and delete this particular sheet because it is of no news Okay so that is that so now we can then go back home so as it stands now in amma's account she has 50 000 carat cities so now let's do some transactions again that is on withdrawals okay so to do that let's click on transactions once again so once we do that now what we are going to do is to withdraw funds so we go to click on this button to trouble to withdrawal then we have amass account number here but for now the account number so let me just grab that from here let me go to account database and wrap Amazon account number from here and just select this copy this and then Blue Room then go to transaction again so withdrawal so you click on this then the paste numbers account number from here and then click on purpose so solar people is what withdrawal so I'll just enter that drawer so the amount I would want to withdraw from it is worth ten thousand they say 10 000 right one two three so there we go so once I'm done with that I'll just go ahead and click on Save and then it should be good to go so now if I should select here and then enter a mass account number once again and proceed you can see that the balance is now left in Port 40 000 so and then because we just withdrew how much that is ten thousand because was what we draw out so we we grow well and then amounts to draw was worth ten thousand so once we add that we can just go ahead and click on this and since send withdrawal message after that when we can we need to fill in all these details so that we can move these details sending off the withdrawal message so once you do that click on send withdrawal message and there you go boom show you right here you can then go ahead and send withdrawal message once again so similar to what with this or you saw me doing or we did when we sense that deposit message so yeah the same is going to happen here so we go to get message you copy message click on done so we come here let's first of all adjust this to get this particular page up and running here so that we can use this so we could then come here and go to compose message so here we choose our sender ID ktcc we'll paste the message and we then go ahead and click on next so we click on personalize then click on next you will just add them from sheets I won't do this so I can see the withdrawal message as was very important so now let's go ahead and match the various columns to each and every details that way so the phone number has the column B then the name pulls the column A account number all the column C sorry accountable with the column C then amount towards column F so we choose that as well column F4 amounts purpose purpose rules column e so we grab that from here dates the date to whose column D they will grab that from here then the balance rules column G then we grab that from here as well so once we are done with all this what we are going to do right now is just to click on okay and everything should be up and running you know all right there we go it says one unique destinations have been added so click on OK so from here what we're going to do right now just to click on send and then we should have the message quickly sent and then it's also dispatched you can I've just received it let me show you how it looks so let me just delete this from here so no use now let's switch straight back to my phone and let's see how the withdrawal message looks like all right so now here I am on my phone again let me disturb this once again let me open this as well so now you can see it says hi yeah or high am I yeah your account number six zero six zero six zero zero one three one zero five six five has been debited with an amount of 10 000 series description is withdrawal dates 7 February 2023 balance is forty thousand so basically that is that about the withdrawal message as well thank you all right so now we just saw how those messages are sent and received so basically that is that so now let's quickly go back home so now the next thing we are going to look at is how we can check how much Yao's statements account statement okay so now let's click on this to get here account number is very useful we're going to use that to grab the statement so let me just copy this and let's go back home so to get the statement up and running you would have to click on this dashboard group so in here just go ahead and enter the account number then the dates range from when to when you want to generate the statement for we then go ahead and then click on the calendar to choose so I want to say first February towards to the last month of last day of February that is in first 28 so once I'm done let's go ahead and click on search so I have my account statement generated you know the transactions we just did on our house account isn't all that much it's about one deposit use of 50 000 and then and the other house we draw out which was the ten thousand if you remaining you will see that all those things will be displayed quarterly so this is why we have the name also so how do we print the statement to do that as a sample click on statement there so let's just give it a name for short armor St I'm a statement so we can just save it on the desktop so we should have things happen so we can then go ahead and close this and then minimize this so we have this appearance once you close this we open this so you should see our statement you can see amma's account number the start date of the statements and then the end date you will have the account number here and then the account balance is so here for a thousand the deposit was here then withdrawal the purpose was withdrawal so we can see all that the dates and everything is just here up and running without any problem without any stress so that is not about the statement as well so now I think and the next thing we are going to look at is how to work on loans how we can apply and have our loans approved and get things up and running so let's check on that all right so now to work with loans first of all as usual the applicant has to fill the loan forms so how do we do that we print out this form for the applicant to fill and then go through the form details once we have things up and running we can then approve the law so once the loan is approved you can then go ahead and use the form data to capture the data into our loan database by clicking on this so we have that so every load should have a loan ID so to do that we click on this to generate loan ID you can just click and then generate unique loan ID okay so let me just draft this down here we have four sorry sorry four two three zero five one nine has a known ID so now the full name is Amma yeah okay let's assume she's the same person applying for a loan again in the lead of that you can just choose anything there at all gender is female then the email is Amal apps home right to home.com and then the address is Amma Street's amount Street four something like that or five five four and the phone number that means my phone number zero five four two five nine zero eight five four then the loan amount let's say you won't apply for 20 000 Ghana cities 20 000 then the number of months let's say 48 months then the interest which is let's say 16 then once we are done what we need to do is a start date the dates which Emma would want the loan deduction to start so we can click on this calendar and have that maybe she would want this deduction to start from first March so we choose first batch to have that okay so once we are done entering these details from here to this level we can then go ahead and click on calculate and this will calculate the loan for us we click on calculate so now we have monthly payment so what it means is that she has to pay five six points 81 as the monthly payments then the total payments the amounts together with the interests makes it worth 27 2006 167 then the interest rate is what 16 points 0 0 then the start dates for the introduction is what first March 2023 then they end it and the loan end is what the first March 2027. so once we are done we'll have to enter amma's account number from here so we need to enter that as well from here which I didn't keep track of should have done that earlier so um I need to get this up and running so let me see if I can just get this um it can't be gotten here so we'll update that later so let's quickly go ahead and let's get her picture and click on this let's go this way and let's go to passport images so let's use this one for here as well and has signature from here and just come back here and wrap the signator like this from there as well so there we go so once we are done we can then go ahead and save it but like I said we'll come back and then update her account number from here so let's go ahead and click on ADD C okay it says what we should enter account number meaning that we would have to still enter the account number very crucial so now it wouldn't work for us we needed the account number to be able to proceed so now let's close this and start all over again let's grab her account number from here so let's copy this foreign copy this so we can then prepare to go back home and to add Loan Data and we have to start all over again so let's just paste this thing inside here so now let's generate the loan ID once again okay now you just change the load ID from here which is now four to three zero four two three zero four two eight equal to three zero four two eight there we go as a loan ID so the full name is the shorts in the date of birth then we choose that as well gender is female email um then the address on my streets number four number zero five four two five nine zero eight five four and the loan amount is twenty thousand then the month is 14 each month enter that as well and interest is 60. so once we are done the reduction starts from first March so we choose that first match then once we are setting this wire then click on calculate so we have this up and running everything is correct so as it is so then why they choose a picture from here then grab this so we choose a picture of this now we have this then date signature's wall and grab that from here to see glitches we choose this for her and from there we can then go ahead and save then add C in case there we go so now if we want to search for head we just set by the loan ID which is what for two three zeros that is four two three zero Then Fall to it or it's once we and I just click on set it should have a data written and she will want to do some editing or changes so you can do that and then we save it and then click on update and it should be good to go so now we are done so now the next two we are going to do is this now what we need to do right now is there to update the amounts inside of the known deductions database so to do that you go to loan deductions here and click on this so now what we need to do is to deposit the amount she has to pay but before that let's go back and then confirm the amount she has to pay let's click on this let's just enter the ID here the total amount she has to pay for all okay let's enter the ID the loan ID is four two three zero four two three zero then four to eight so once we either click on search so the total amount she has today is willing to keep track of that 270 sorry 272 27206.67 so that is the total amount she has to be so we could then go back and then add that here so now sorry let me go back and then add that inside the loan deduction so here we go ahead and enter here is loan ID which is what four two three zero and then four to eight so once we are done with that we want to deposit all the amounts he has to be the interest together with the loan amount is to enter the purpose here we say what yo total loan amounts to pay so once we are then enter that amount images what's 272 272 0 6 2 7 2 0 6.67 so once we are done we then go ahead and click on Save and then we have that saved as well so now you can see that the loan amount so the loan balance is what 0.00 then the loan amount paid is also what zero point zero zero so now when we enter her loan ID here you see some changes here but before we do that let's make sure that for now let's assume that for the first month the first match has reached and we want to do deductions okay we want to deduct the first deduction so we just go ahead and just click on this and start the loan direction from here so now we enter the loan ID which is four two three zero fall through sorry four two three zero and then four to eight so once we proceed here you can see that is what we have the total amounts she has to be 27 000 206.67 okay so now the purpose is what so kind of quality loan deduction for the amount of March 2023 so once we are done with the amount she has to pay each month is 566.81 so once we enter that then we just go ahead and click on save for the first deduction so now let's check something let's enter a loan ID here once again so 4230 and unfortunate so once we proceed here you can see that the amount yeah speed so far is five success Point 81 that is the first month now the loan balance is 26 000 639.86 so you can see that everything is up and running from here so we have just deducted the first months and then we have updated that inside the loan deductions database so now we need to go and then deduct that from how much accounts okay so this is to keep track of each and every one deduction so now let's go to the account and do the deduction so all this so now we'll go to transaction so to do that we need her account number for that so come here then we'll grab that phone number from weapon to C to copy this now we can go home we will come to transaction here so what we are going to do is just to toggle with drawer we want to throw an amount from Amazon's account okay and that is about the loan deduction so we then go ahead and please account number here and we proceed you can see for now she still has the 40 000 inside so here with this absolutely know that that is a long deduction for the months of much we need to Enclave so once we add another amount we are going to withdraw is what five sorry five six six points eighty one so once we are done with that we just go ahead and click on save and transaction is now safe for the withdrawal so now if we should enter the account number here again and then proceed you can see that now the balance has now remained 3943 because we've just deducted something so here we didn't go ahead and then add the people's loan deduction for the months post match we need 23 so once we are the amount is worth five so six points eighty one so once we want to send what withdrawal message for for her to see the message that the loan deduction for the month of March has been done so we do that by clicking on send withdrawal guessing room so there we go so here we can then go ahead and send a withdrawal message from here as we've been doing okay so we will still go ahead and do that right so that we confirm and make sure that everything is still up and running but then I did I think with what you already saw we can equally assume that sending a message is not an issue but let's do that so click on send message so copy this then done you then come here send SMS compose we choose our sender ID from here then we paste the message from here now we click on personalize so from here and next thing we want to do is go ahead and click on next then we choose the various column now from sheets now we pick the various columns from here let's see this okay let's um let's cancel this for now let's move this thing this will give this shells to wrap the effects so let's add here from sheet sorry get started just from sheets over here so now let's move up the columns the phone number is in column works column B then the name is on quality and account number is in column C then the amount is in column f when the purpose is when the date is in column d then the balance is in column G okay so once we are now that I just click on OK so now you can see it says one unique destinations have been added so as we click on OK so from there just go ahead and click on send and then we have the message sent so now we can then go ahead and delete this particular sheet I've just received the message so now let's quickly move straight to my phone and let's see how this message to looks like now there we go on my phone so now let's open this and let's see the message so receive from here which says what hi amayal account number 606001310565 has been debated with an amount of five success point eight one description loan deduction for the month of March 2023 dates 7 February 2023 balanced 39 433.19 so basically that is the message thank you good and I hope we saw that message out there so finally the last time we're going to look at this list we go home now let's go back and check amma's statement once again to confirm the newly the new transactions you've just made to see whether it will reflect so let's grab the account number from here so we just copy this from here controls if the copy list then click and navigate to Home click dashboard replace the account number inside here they will choose the date range from first February to 28th February now we click on search so you can see that the third transaction which is a loan deduction has also um taken effects the withdrawal is 56.81 and so now let's print the statement yeah click on this and then we have it printed so let's name it and my elf shot so we have that so desktop save it then so we can then go ahead and close this and then minimize this for now let's open this boom so there we go we have the statement up and running the election for the month of March 56.81 now this is the balance there we go so you can see that everything is now up and running and without any problem without any stress now currently we are organizing a very powerful training on how to develop this amazing system I'll leave the WhatsApp and then the telegram channels Link in the video description below you can just send that out and then you can join the training okay and also if you want to purchase the application I will leave the link to that currently we are running some powerful discount so you can just take advantage and then buy it at low cost and then you can be able to use it you can use it as a project work in your school if you want it that way it's very very cheap for you to afford so basically that is that if you like the video don't forget to smash the like button subscribe to the channel press the Bell icon so that get notified anytime we upload new videos like this so till our next series of videos thank you so much and bye for now