I Built Banking Accounting & Analytics with Claude AI | FinTech Application

0:00that we would work upon accounting module then reports analytics and administration. So if I show you the accounting module so it is having the mock data right you could see this GL mapping if I click on mock data watch uh preview the mock data and these are the mock data. So our target and our goal is to work open accounting reports analytics and administration module to have the real uh database connectivity and uh re you know convert into mock convert from mock to uh real applications. Okay. So for that I had you know generated I had asked you know charge to write the prompt and that

0:35prompt has been written properly and same prompt what I did it I just put it here. This uh is the you know same prompt prompt and what the claude has done claude has generated the you know zip file. Claude has you know generated the zip file. So let's download and it is having the codes. Okay. A texture w texture wise code is there. So we are supposed

0:57to download and let's open in this one. So if I open then you would find part 10 delivery and here is the database src and uh server. So first let's execute the database script. Okay. So directly open it and these are the database script. So what we are supposed to do just execute it. So okay let's uh you know deploy the codes at the server locations. So this is the server src and let's copy everything here in this manner. Not app. Leave the app and then

1:27our code is here. Source code is here. So what we are supposed to do? We need to go to the server src and then we have the files here. So let's replace them. Okay. Replace and see it is replaced. Similarly we let's execute this code as well. Copy and paste here. This is the app. Okay. Let me open the app file. So this is app file. Okay. Let me copy and paste it. Done. Now, now let's go back and use this src folder. Okay, this is the SR

2:03src. So, it is having lib and pages. Okay, so we are going to deploy this one lib and pages. Okay, so src lib and pages library and pages. So, this is deployed. Everything is deployed here. We are supposed to do let's let's say restart. Okay, before that we got one error, right? So this is the error which we got it. So let's copy this entire

2:27thing and let's put it on cloud. Okay. So cloud will do the analysis and we'll let you know that if it is any error is there any error or not. Okay. If it is there then what the cloud will do? Cloud will do the analysis and cloud will provide you the revised script. Okay. If it is not then cloud will let you know that there's no uh issue. So we found certain uh you know error here. So that's why uh we have given now I think what happened the new five columns principle interest penalty charge amount were added successfully that's confirmed by the first line only the transition

3:00check constraint failed to attach okay so uh the the fix runs the SMS safe non-destructive okay so we have to we have to use this one we have to just copy and let's go to new scripted new paste it not not save A and execute this is done now let's go down here it is select so let's use the you know select and let's check it out this one this done okay so uh I think now everything is in set everything is in place and there's no error now what we are supposed to do let's restart the server so Okay. And run this one. And again, let's

3:52run this one. Let's uh terminate and run it. Now we have to check whether applications are up or not. Okay. So I think if I click here, so it is getting up, right? You could see this. Now here you do not find the mock data, right? Everything has been you know revoked. There's no mock data. If I click accounting configuration, GL mapping, voucher preview. If I click on reports, so customer reports. Okay. So these are the actual uh data which we saved at the time of customer creation. So these are the data which we saved. Right? Then we have the report. So this is the report

4:27for Romesh loan report. It is closed. Right? So again disbbursement. So we perform the disbbursement for Rakkesh Kumar. Collection report. So we can download the you know uh data for Rakkesh Kumar. NPA report. There's no NP loans. So that's why there's no NPA. DPD there's no DPD. Settlement is not there. uh accounting report is not there. Now if I go for executive reports so we have total uh four customers one is total loan and this is the loan amount this was the loan amount and total collection 1.0 0 L okay lakhs product [snorts] analysis so loan against property it was utilized branch these are the branch

5:04which we have used Bangalore and all that okay then this is the collection analytics NPA dashboard there's no NPA as of now then if I go for users so we find sudhirkumar this is the data which we saved from front end so that's why it is there we'll work upon this as well okay rows so these are the rows which are available permission permions. So there's no permissions as of now current uh workflow then audit and so these are the data okay system upload and all that. So what were the activities we have performed? It is being recorded for foreclosure part payment loan uh residual ROI change these are the

5:42activities which we have performed right then we have settings. So now we are going to perform certain activities here. So if I say accounting configurations new GL account okay so GL code. So if I say GL101 GL name uh loan booking right so asset create GL type done this is created GL mapping so new mapping we can click loan booking is there loan booking debit GL then credit GL so what what would be the credit GL so data so we need to configure so we can create here GL like you know GL 2001 GL name uh loan on booking credit like you know sample we are

6:28providing here uh it's not like that uh we are doing anything here create GL so okay so here if we click uh GL mapping so what will happen loan booking and debit is this credit is this right dead testing okay and create mapping so this is done sample right now watcher preview so we can uh go for the watcher preview at the time of loan booking it would be triggered as of now the loan is uh uh closed so there's no watch or preview uh accounting events so uh we can find uh events like you know is then pending and vouch and all that okay if it is filled

7:06so that can that can be seen customer report is there so if we have to export we can export in excel we can export in excel see this this data is generated export in PDF also we can do it and this is also working fine okay Similarly we can say loan report. So loan report we can download. Disbburment report also we can download. Then we have collection reports also we can download. And PA data is not available. Executive reports as I showed you. So now it is working perfectly fine. If I have to create new user. So if I say Rakkesh uh Kumar and then first name employee

7:45code. So it would be sorry first name this would be this employee code let's make it this one username Rakkesh Rakkesh at the rategmail.com mobile number we can say right branch we can choose the branch head office role super admin we can say super admin create user so this is created an active one Okay, this is also done. So similarly we can say roles and now we have to assign the roles new uh role we can create like know branch manager and all that. So this is already created you could see this. So no need to create anything uh new save permissions. So like so new workflow if

8:33we have to define the approval or settlement and all that. So approval. So whatever the uh workflow if you want to define we can define here. U name we can mention and step one and step two and then that that you can add more steps as well here likewise. Okay. So that is also available here. Then we have the

8:52audit which is already being saved. Settings we have like you know save and all that. Okay. So NP dashboard threshold is 90. Uh so this is saved. Okay. So we are done with you know accounting reports module and analytics modules and administrations modules. Now certain things are left like know if I go to you know master so these are the data which are still uh the you know the uh mock data so we can save as a correct

9:21data and also this is okay no problem. GL masters are masters are also there. Then we have the products. So I think these are the products which are already saved. Okay. But we have to save those data in database. Okay. So next time what we will do we will work upon these two left modules like know masters and product management. So I'll share the

9:40prompt and also you uh work upon them. So that's all about it and uh thank you very much. Thanks for watching.