Sign North Carolina Banking Profit And Loss Statement Computer

Industry sign banking north carolina profit and loss statement computer

hi this microphone point software thanks for checking us out we're going to look at a short video on in-place drill down financial statements we're gonna have a second video to keep things short that will show the same type of thing with a labor report a few things to note on the tools and techniques that we're going to use we can print a financial statement for virtually any period where you have data we can print one for 24 months back we can print one for 24 years back as long as the dad is there no limitations there whatsoever we can also cross fiscal years if you want to say your calendar your end but you want to financial that runs from October through March not a problem we can do that I'll show you how to drill down to transactions on those statements and we've got a couple other bells and whistles we're going to show you just something that we were asked to do recently that we've included here we're going to show where when you when you have a transaction that you've drilled down to on that financial statement you can drill down to the batch detail sometimes in accounting that's important and we're also going to show you and I had tymber skan involved in in this example where the way they hold their data we can drill down to the invoice the actual accounts payable invoice right from the financial statement so how much time and cost savings is there with that anyway getting or going here you can see I've got a desktop here drill down fit a desktop icon rather drill down financial when I double click that see what's happening when I double click that thing I come to a range screen now I designed what this looks like we're not we're not limited or restrained at all are constrained by the viewer and what it provides us we can decide what is on this screen so I said let me see the company number the description and the current month a lot of companies struggle to remember what month are in so I just threw that on here you can see it remembers my last choice previously had company 21 I selected I could say no this time I want company 10 or go back to 21 which is what I'll do then I hit okay and here is our date prompt again no limitations whatsoever on your data let's see the sample data is back in 2010 so I'm gonna run this as of May 31st 2010 expand that just a bit and you can see we have a financial statement for the Timberline sample data now I went ahead and grouped on the on the account types income cost and expense with those subtotals and that income at the bottom of course we can do any grouping that you require and map to to the way that your financial statements do the grouping and listing now so you can see I included the account number for reference and a little plus sign I'll come back to the description and then the current month balance and the year-to-date balance all right now let's say you were going down this and you saw that subcontractors seemed seemed too high for this month it's in fact it's it's 50 percent or more of the year-to-date balance you said well what's happening there I want to see why we've paid so many subcontractors in in May we can expand that by hitting this plus sign you'll see when I do that I expand that sub contract down to the transactions below it if I click it again it contracts back and I'm back to my financial statement I can look at another account but going back to sub contracts and I'm going to minimize this just a bit for demonstration purposes when I expand that you can see I come to the transactions that make up these balances so you can see the 49 805 and the current month he's broken down to these transactions that hit that account and here's that total and the 97 is made up of these year-to-date transactions with that total now some companies don't want to see here to date they just want current month that's totally fine we can we can modify this to what you want and we can also choose the columns of information that you want to see here so let's to say that a 1 electric company looks suspicious and you wanted to see what was in that 14 alright now again I did this in conjunction with tymber skan and the way the Det is held there I was able to do a link that would basically launch or expose that ap invoice isn't that just cool now in my data act what a copy of a lobby of a invoice from my law firm my comfort law firm I got a speeding ticket when I had my motorcycle up in New York - it took a long time so I grew my bike but my wife doesn't know about this I'm not the smartest guy in the world so anyway very very cool flexibility I think about month under year-end where your accounting staff is having to pull invoices or your auditors are having to pull invoices and then they're having to be refiled how much time in cost is there with that effort coming from a public accounting background I was a partner to CPA firm for a number of years I I get it we can save a lot of money with this functionality I also included in this I drill down to the batch sometimes in accounting you want to click and you want to see and everything that makes up that batch of information so I included the account the date transaction description debit and credit I also put in the job and some reference information in this case it's the vendor ID and the the invoice number sometimes it's very handy and of course we can go back to our income statement and I can decide to to look at other accounts if that's what I want to keep doing so I hope this was helpful again my name is Mike with OnPoint software if you have any questions we can be reached at four one seven five eight one seventy seven hundred and we have tons of videos and free tutorials available on our website on point - software comm it's down here for your reference if you want to see some more how-tos and information about taking timberland to the next level please visit us if you have questions at any time please give us a call thanks for watching have a great day