How Can I Sign North Carolina Banking PDF

How can i industry sign banking north carolina pdf computer

okay can do that yeah my name is Kody leach I think I've seen most you guys at several meet ups before this I am a certified public accountant in the state of North Carolina I think you guys know them as Chartered Accountants North Carolina requires me to tell you that I was chartered in North Carolina otherwise I can lose my license I do fractional CFO work and financial like function consulting so right now I'm actually working with our fair city council helping them with their finance processes the excellent ones that are getting better so this is kind of a rough agenda so I guess the first thing that I should mention for this is I am NOT a programmer I am an accountant who got frustrated when I worked in public accounting about how they would say we automate we automate you automate but what I found is instead we outsourced to India and then worked lots of hours which was unfortunate and so when I finally quit working for one of the big accounting firms I decided to try to learn Python because the people that were probably the most important people and the companies I worked for were the people in the systems team so I what I found is we would do analyses of companies and we did my favorite analysis was just key person risk and so the people that you would think if they like got hit by a bus tomorrow would like the company with stopped functioning so people like the c-suite like the CFO the CEO but people who were constantly way above their pay grade was the systems admin because he was the guy that was managing all the databases and whatever so you lose him you lose your ability to be a public company and report and manage your whole business so anyways I looked at those guys like I want to understand what the heck they're doing because when I'm a CFO one day I need to have a talk conversation with them but anyways so I'm gonna go through kind of the problem that I ran into and why I wanted to learn Python ultimately the goal of what I'm trying to accomplish and kind of the roadblocks and the solutions and it's a very simple script it's actually the first one that I wrote and I know that we've had lots of presentations up here of people with really complex ones are like just happen this one's like for the the novices out there like a very easy stepping stone into the Python world that just solved the problem that I was running into and I'm gonna try to run the scripts we'll see how that goes and then there's also questions which I experts in here probably know the answers to and then feedback for anything I can improve which I guarantee you there's a lot all right so the problem number one so when we before I got to New Zealand my wife and I were traveling through Southeast Asia for six months and so we decided to put up our house for rent so we hired a property management company and they provide statements to us every month and money gets deposit account we pay the mortgage all these transactions go on in the background and I am a real jag loon so I got lazy and I'd be traveling and I don't want to go on my laptop while I'm trying to like scooter through Southeast Asia so you had two problems one we had the house and then I am kind of a lazy guy and ultimately the goal was to have functioning financial statements for this thing because I am a CPA so I want income statement I want a cash flow statement I don't really care as much about a balance sheet but retained earnings statement so before this any makes any kind of sense it's probably worth going through like the basic statements so your income statements everything everyone knows about revenues minus expenses is net income which you're gonna use probably your taxes and then cash flow which is how do my cash begin how do my cash end and what happened in between and then your balance sheets just a list of all the stuff that you have and then your retained earnings is going to be basically like how much should I put in and how much have I gotten out in any giving period yeah this is actually tutor this stuff this is one of my tutoring slides so you guys got it for free okay so like I said the biggest problems I ran into were that I was in Southeast Asia so I have this like really crappy laptop from 2007 it's a solid-state drive I can't put anything on it anymore it actually does not it doesn't even run without a charger and so I needed to run a Python script to manage all this stuff and I had to be in the cloud because it can't store any files and then I also so I needed to put it on Google sheets so I had to figure out how to run put this thing into the cloud onto Google sheets and then I all this stuff comes through on bank statements that come from the banks that we have back home and they also come from the mortgage company and then also from the property management company and so those come in I got to read them and so I picked up a library called PDF Reader and then probably the biggest thing is this was my first attempt at solving a problem with Python so I think I took the free course on code Academy and I think it took maybe like 30 hours to start and then I realized as soon as I went to go code this that that wasn't helpful for self my problem at all so what I ended up doing was having at Google pretty much everything so for all of you aspiring Python programmers watching YouTube videos is literally the like find a problem you need to solve and just Google it is literally the answer to it and luckily people are very kind that they post YouTube videos of how to do things and maybe one day I'll be one of those people I guess if you put this on YouTube maybe but yeah so when I was running into this I basically had to learn how to do authentication with Google Drive so that's a process that I could Google in order to put this all into a Google sheet and then I also ran into the problem where I needed to read the PDFs and so I've found this library by literally googling how to read a PDF and then found someone that was able to show me how to code it all right so that's the script and all of its glory it is short and sweet and I'm sure could be improved all right is this a laser pointer can anyone can you guys actually see that or should I pull it up to make it bigger and we can go through it line by line like Danny wanted me to do I didn't know really though can you see it cuz I can also just pull it up and make it bigger all right perfect it means you guys can assume it's all right I is that better so the first thing you can tell is that I actually have it in a really default IDE so this is like notepad plus I think we rerun it an idle that's a default at least has colors which I thought was pretty nice it helps you understand what's going on but there's like no lines anyway so as you can see the main things in here are I'm pulling GS spread which is a library that lets you interact with Google Spreadsheets and then PI PD f2 which allows you to basically like just pull data from PDF files I guess turn them into text I actually don't actually I don't even write use classes to get to what I need to do I just use a library so anyone use to solve a problem you actually only that could that much but effectively the first thing I do is I authorize to go to Google sheets so Google sheets has an authorization and there's like a credential file that you have to have and it just reads that to make sure that it's actually you trying to post and then the next thing that happens is I find the workbook to get all of the data so I have it set FY 19 income statement which is just a Google spreadsheet that looks like that so all that does is basically tell me what spreadsheet I'm gonna go add to so every year I can just move it to the next one and then what I end up having to give it is the only piece of data I need to give it is what month am i trying to close so yeah ten like for example ten would be October so a period ten this is the tenth month out of the year and then what that does is it calculates it gives me an input I give it to it and then it calculates the close month and it's plus one because everything and the spreadsheets scooted over by one and then what it does next is it uses PDF to basically read my bank statement and then that basically will then pull my cash balance and my interest so every month there's like a small cash balance that gets interest it's like 75 cents so a dollar and New Zealand Dollars yeah so big money there and then ending cash balance so how much cash is sitting in the bank account after money comes in for rent and money goes out for mortgage I'm at least proud because I think putting these little hashtags in there is proper proper formatting for putting in code anyway so it finds the cash balance so that's the reading of the bank statement so that's the only two pieces of data that I asked for from my bank statement and then I go to my mortgage statement which pulls the interest for the mortgage and then also pulls the mortgage balance the mortgage interest helps me actually felt my income statement for all my expenses and then the mortgage balances so I can do an equity calculation at the end and then then notice all the data that actually pulls the end of it so then the next thing it does is literally just goes through the Google Doc and updates the row associated with it plus a the the column that I chose from putting in my data for the what month I'm trying to close and it just does that for all of those expend all of those items and trying to get to that point was uh was painful to say the least it alright so now we're going to attempt to actually run the thing and see if it works so what its gonna actually end up doing is I have to pull down the bank statements manually and so I try to figure how to do that American Bank entities are very sensitive about trying to automatically log into an account employ data so if anyone hasn't work around that be helpful cuz that takes it like five minutes or so anyway so I'm trying to close it'll be October so I'm gonna give it ten and then it'll take a second and then I guess when there's three little things show up that usually means that it's done but what I'll end up happening is you'll see everything that I had highlighted in green Wilhite will fill in so at this point it goes through and has updated everything in green so the interests so this month was a big ol seventy-five cents the mortgage insurance interest which changes depending on the how much we decide to put towards it every month and then ultimately recalculates it so it's just easier to pull it from the bank statement and then probably my favorite part is that's the income statement so I'll have this already for when taxes come around which is easier if you already have the information and then probably the best part is it does cash flow so it basically calculates all the cash items there and then takes the beginning balance from the previous month adds the cash that has changed and then I have it actually pulling from the bank statement so I can do my cash reconciliation so if that's off then it means I need to go actually look at something else so there can be other expenses of like the the renter's you know break my washing machine like they did last month being a landlord is not nearly as cool as I thought it was gonna be it's actually it's actually quite stressful we had our neighbor wanted to cut down a tree and it's gonna cost seven thousand dollars to cut down a tree inside to convince him not to do that because I didn't have any you have it anyways so then the last thing it does is fills out the current mortgage balance which is slowly amortized over the life of the mortgage and so then I just have a calculating what my return on equity is based on the beginning balance with how much I've made and right now it's projected out knowing that there's two months left in the year or something could go wrong and probably will yeah so that I mean it's something that was taking me about an hour hour and a half while traveling where I wasn't I wasn't able to really find a plug most of the time to something that takes I don't know maybe 10 minutes or so between downloading the bank statements and then running the actual script which is quite cool all right that's pretty much it I told you is really short and simple but I'm hoping it's a little bit of an inspiration for anyone that's wants to get up here and present because I know some of the stuff that gets up here is pretty nerve-wracking and doesn't understand what's going on the other thing too is feedback too so like my understand is there something that you can do with to like run it within that by itself without having to pull up idle and then run it manually but maybe I'll get to that