Can i document type e sign 12 month income statement mississippi
the webinar today very excited to be able to present this to you as Scott mentioned I'm Joanna Schultz and with me is jacques neau Jacques is actually the person that developed and invented this excel add-in so he has the most expertise and that's why he'll be tackling some of your questions as we go we're both with the company called financial statement masters and I'll be showing you today the Excel add-in called Excel FSM and first let me tell you a little bit about it so you have some background before we start to look at it because it's an excel add-in it obviously integrates into Excel and it's very simple to use in fact I think at the end of today's session you'll have a full training on how to use excel FSM and you'll be able to use every feature it's also based on a patented method I think we have a couple patents based on it and it's designed for you to be able to build and update your financial reports and it works for any type of business organization because after all you're using Excel and you're used to that flexibility and customization to do anything you want to do in Excel but it also allows you to work with accounting data so the accounting data out of your accounting software and it doesn't matter what accounting software it is you'll be able to have Excel fsm read any software and then use that data within Excel which is the main point of the add-in so it also adds to excel the concepts we have in accounting debits and credits as of dates account groupings financial statement items you will see those throughout today's presentation and I think you'll be able to imagine how you might use some of those in your daily practice whether you're creating financial statements which is what I'm going to do with you today or some of your own custom monthly financial reports it can be used for either one so what we like to say is that Excel FSM takes Microsoft Excel which is used by you and your clients and everyone everywhere and turns it into an automated financial statement generator and a powerful trial balance program so I'm going to try to show you how it does all of that today and I'm just going to ask that you sit back and watch there's no reason to try to replicate what I'm doing I did want to give you my contact information and I'll repeat that again at the end so it's there on your screen for if you have any questions we don't get to afterwards our website is there as well and then just as a quick overview we'll probably return to this there's Excel FSN and then there's also word FSM which gives you all the same functionality but in word so I just wanted to mention that that exists as well and we have several different modules within the add-in there's ones that allow you to read QuickBooks directly whether the desktop or online version there's a module that lets you deal with consolidated financial statements and handles parents and subsidiaries very smoothly working papers for those of you that are auditors and we'll look at some of those today and then general ledger drill down is probably my favorite function within the add-in so we'll definitely take a look at that so to get started here we are in Excel I have a workbook open and it's called FSM GLD d12 31 2014 this is actually how Excel FSM names your file so it's going to save this file for us and then as we move it to the next year it will save next year's file for us with a similar name it does that automatically now because I have Excel FSM installed I have this additional tab on my ribbon and this is described as all the commands that we'll be able to do the most important one is read trial balance the first thing we always have to do is access our accounting data and that we do through the reread trial balance command then the charge of accounts gives us access to our chart of accounts that's pretty obvious we are actually able to make adjusting journal entries with this software and we then have a section here on report building balance variation gives us the ability to change the period of whatever balance we have showing we have suggested item titles which just saves us a bit of typing time item balance that we'll spend the most time on and that is where we select the balance we want to show up in our worksheet there's also a button that's going to fill in the as of date for us the enterprise name and in our example here the enterprise name is GL DB and total which we use instead of some report presentation there's also some options here and there things that we can turn on and off we can look at see some details we can make the financials comparative we can see unadjusted balances if we want or by default adjusted balances and then we can round lastly we'll look at working papers which includes a trial balance of in Excel or a full GL in Excel automatically created lead sheet and grouped account sheets all of which update with any changes we make so let's start by first reading some trial balance data and I'm going to select without transactions because we're just reading the trial balance no general ledger data I'm going to pick this trial balance for 2014 that I have exported out of my accounting system into any format that Excel can read so to the little click to select it and now it's been pulled into Excel part of the way but first we need to verify some information so that everything is labeled correctly the name of our enterprise in this case it's correct an orange filled in GL DD the as of date for this trial balance we saw from the the name of the file is 1231 2014 so that is correct already and then we need to tell Excel what what are the columns what do they mean column a in this case over here here is our account number so we've indicated that here the account title is in column B and our debits and credits are in C and D so we fill that in so that the debits and credits are properly understood within the workbook I'm going to click OK now it's getting imported the rest of the way and when it's finished it creates this printout sheet that just tells me that everything got in there correctly so I could if I wanted to print this out or save it I don't think we really need it for anything in our exercise today so I'm just going to go ahead and delete it and now that we've pulled in the trial balance we can start creating some financial statements so I've used the icon here for the enterprise name to put the enterprise name there this is a balance sheet and I'm going to use this date button to fill in the date and it picks 2014 because that is the trial balance that we read if this could be in any format I happen to have this formatted into a custom format year year year year obviously in other places we would change the format to say 12/31/14 okay so we'll start with some assets due to many S's there I was telling Jacques the other day there's nothing like typing with a thousand people standing over your shoulder makes it very difficult okay for cash we want to put in our cash balance so item balance that button I talked about before this has a lot of functionality in it I'm going to click on item balance and I'm going to get this window here which I can move to wherever is convenient for me and I'm going to make it a little bit bigger and then I'm going to click keep position and size so now each time this window opens it will open right there and expand it to how I want it expanded on the right side are all the ungrouped accounts and right now that's all the accounts we haven't grouped anything on the left is where we're going to be moving accounts to to create groups out of them that will represent in our case here financial statement line items so it might be helpful for us to see our account balances sometimes if we're trying to group things it helps us to recognize which account is which so I'm going to click on that and now I have my account balances just as a reference over here where it says cents that's where it's going to show me whether by default the grouped accounts are debit or credit accounts and I if I need to we can actually change that because sometimes you might want something added or subtracted and you want to flip-flop it so that's an option for us as well list all accounts over here this is you can click on that if you want to bring all the accounts that you've already grouped back onto your screen to perhaps use them again if you're working on a worksheet where you want to use the same accounts perhaps in a grouping in one place and a different grouping in another place so that's that's something we we won't demonstrate today but just know that that is an option as you think about some more complicated financial reports that you probably create because what we're creating here right now is very simple balance sheet okay so I see that I have three cash accounts on top here so I had a sale of each one and click move and this can be in any order the order completely doesn't matter so I pick move one of these back and change my mind and move it back again it's very flexible until I get the right answer and the whole time I make those changes my cell d12 is changing so let me show you that again if I remove savings right away it shows me the balance without savings by move savings back there's my complete cash balance okay so let's move on to short-term deposits again I'm going to click on item bowel once and I have a couple short term deposit accounts account 12,000 and account 18700 so I clicked move to get them to group together as soon as I did that my balance showed up next I can show you the suggested item title so I'm going to click on that and what I get is a list of all of the account titles in this file some of which are helpful and happen to be the exact same title you're looking for so in this case we have the council's receivable I just double clicked on it and it saves me a little bit of typing on creating my report and I click off a head imbalance again I only have accounts receivable accounts well I'm going to move that over then I'm going to do the same with my prepaid expenses only one account there as well so that's easy and then my inventory now another way for me to access the item balance is with the right click so with the right click I get my context menu and I can pick suggested titles item balance or total right here at the bottom I'm going to pick item back on and I get that same window and I move my inventory account over to the left and now I have all of my current assets all of those accounts grouped into the proper financial statement light items so I'm ready to total up the current assets now I'm not going to use the sum function in Excel because on its own Excel doesn't understand debits or credits and doesn't always round how we like to round in accounting so I'm going to click on total and I see now on the right all of the line items I have grouped together but I can now further group them into a total so I'm going to is my shift key select them all move them all to the left and as soon as I do that my total shows up here in B 17 let's also do our deposits on rent and wages in Johanna I'm so sorry this I don't think is a great time to stop he but right now I think we should launch coal number one before we get to peg fogger in it i'm alois that's right great help for our audience thanks and this is which of the following do you use so I'm always curious about how many QuickBooks users we have out there so hopefully this will give us a sense of who's actually using QuickBooks and which version of it the software can read directly from the QuickBooks file so that's why we find that interesting all right we're at 94% I'm going to count down three two one it's last couple of responses and I'm going to share those results um close and share and join I don't know if you can see that 31 percent of our audience QuickBooks desktop 9% QBO 24 percent both and then 36 percent on neither interesting very spread out but there are quite a bit of QuickBooks users on this webinar so that's good you would all be able to take advantage of how instead of having to export anything out of your accounting software you can just point Excel FSM directly to your QuickBooks file okay thanks alright so we're going to now complete the balance of deposits on rent and wages on our balance sheet again I'm going to click on item balance either from the tab on my ribbon or right click on the context menu and I have a couple accounts to group here that creates my deposit bounces and then lastly let's also complete our fixed assets so we have all of our assets together right click is imbalance and using the shift key I'm going to select all of the fixed accounts and the accumulated depreciation account move that over into a group to count so now I'm going to total again click on total and I see everything that I have previously grouped so that's all the current assets and then the two we just did and we do want a total of everything there so I'm going to move that over and now we have a total for our assets I will actually spare you from watching me type the liabilities and the stockholders equity but I'll just show you that the same thing here we found a lot of accounts payable and accrued liabilities accounts that we grouped together so long term liabilities and then for retained earnings all that was left after we grouped everything else is the retained earnings account and all of the P&L accounts so we took all the revenues and expenses group them all together to get our retained earnings total for this year okay now we could probably round we can round at any point in time so I'm going to click the rounded button and as you can see our balances are now rounded and they still add up correctly this is a toggle like everything in this section here so I can turn this off by clicking it again and unwound my balances if I want to and I'm going to leave them rounded let me show you also this toggle here this is an interesting one so I'm going to click on any balance in this case cash and I'm going to click on details when I do that I can see the accounts that belong to this line item I can do that with any one of these or reason with all of them and then when I click on it again the details disappear so this could be useful if you just want to quickly check what did you include in this group or you could leave it showing for a final report if you'd like to have those details and again you just turn it on and off as you need it if we had made adjustments we could turn off turn on or off the adjusted balances so we could see unadjusted and then turn it back on to adjusted balances so everything in here affects how we show the financials we've created let's now create a statement of cash flows so what I'll do will be using all the balances on the balance feet so I'm going to copy the balance sheet over to another worksheet just so I have it how could I not come just so I have it handy when referring to those balances so here I've started a statement of cash flows just the format's and again I will pick the calendar icon there to get the date and then we can start with our operating activities so the way I'm going to do this I'm going to copy and paste the related formula for net income it will be retained earnings to each place on the statement of cash flows but when I do that because I've copied and pasted I'll have two cells with the same formula in it normally whatever I would do in one cell would affect the other cell as well but we don't want that in this case because we may change some groupings which we will in a statement of cash flows we may change the the presentation so that it subtracts or adds so I'm going to go to ice imbalance it still has everything I've done here but I'm going to click on new ID and what that's going to do is disconnect from the cell we have in the balance sheet so now if I make changes to this hundred thousand dollar balance it's not going to affect my balance sheet my balance sheet will stay in balance one of the changes that we'll be making as we go through this is to change to a credit balance everything on here we want to be a credit balance and that way we don't have to think about are we adding to the operating activities that income from operating activities are we subtracting from we don't even have
o think about it I could actually create this whole statement of cash flows and have no idea what I'm doing now I'm going to go and fill a few more of these changes in current assets and liabilities we're depreciation I'm going to copy and paste my fixed asset balance and then I'm going to double click on it and that's another way to take me back to my item balance window and right here I'm going to click on new ID because I'm about to make a change I don't want my fixed asset accounts in this balance and I just want accumulated depreciation so I'm going to move those out of the way back to ungrouped accounts again my balance sheet is fine it's going to keep all the fixed assets together because I've created a new ID and then I'm going to click on debit to change this to a credit balance so that it's adding back next we'll do our change in accounts receivables can copy/paste it over here if I hadn't copied my balance sheet for reference here I would just go to that worksheet double click new ID and change it to a credit balance let's do prepaid expenses find the related account copy paste of the formula over here double click new ID for this and change it to a credit balance every time inventory you know how to do this by now paste it new ID credit balance and then lastly our current liabilities now this time this will already be a credit balance so we don't need to change that we just have to assign a new ID now I need to total this up so again I'm going to use my total command by clicking on it rather than using some from Excel and I do want to total up everything here so I'm going to highlight it move it to the left and I have my total for the changes in current assets and libraries are sorry for all the operating activities now if I continued on I would do the same with the investing activities and the financing activities and I know what you're thinking you're thinking that is not a statement of cash flows well I do realize that so there's one more step we'll do to make it a statement of cash flows we're going to highlight everything here and we're going to change the periods this look reflects right now we copied everything from the balance sheet so it reflects 12/31/14 I can include select periods under balance variation and I don't want just 12/31/14 I want the difference so I'm going to select the range of 12 31 13 and 12/31/14 when I click OK now I have a real statement of cash flows so I don't really need this over here anymore I could get rid of that maybe hide some of those zero bounces so what you may have noticed oh and it does reconcile your Excel can tell us that the increase in cash and cash equivalents plus the beginning balance of cash is in fact fifty two thousand one hundred ninety one dollars so I could have created this entire thing never having learned how to create a statement of cash flows because there's the process there that Excel FSM allows us to use that's entirely logical and we get to the same answer as if we had just created this from scratch either in a special worksheet or on a piece of paper however we normally do it okay so one other thing we can do is around it so let's do that and now let's switch back over to the balance sheet this would probably be a good time for our next poll perfect morphs now and then where do you work so they were curious about the ten days of this webinar for how many of you are in a small CPA firm or in a large business a large enterprise how many of you are sole proprietors just interesting for me to know two more people that still need to get their vote in I will count down now three two one okay so about half of you are working at a small organization a company or firm and then the rest is split between a large organization or sole proprietorship very interesting okay and back over on the balance sheet we created and this now I'm going to switch it over to a comparative balance sheet and this is my favorite button in Excel FSM the comparative button so in order to create comparative financial statements this is very complicated so please watch carefully I'm going to click the button there's only one prior period in my files I'm going to click OK and there's my comparative financials I think just for presentation I'm going to add another column here get rid of borders in fact we can even where is a grid line see what this would look like it's kind of a final report so very easy to do it's another one of those toggle buttons I can turn comparative on or off I could have had more prior periods in there to include and it would give me that option so now let's say 12/31/14 is over it's now past 12:30 1:15 so I want to update this financial report I worked on last year what I'm going to do is read my new trial balance so I'm going to click on read' trial balance and this time let's do this with transaction so we're going to read both the trial balance and the entire general ledger so I'm going to pick my 2015 trial balance again I just exported this out of my accounting software into one of the many formats Excel can read my enterprise name is the same but I need to update the year end date oh that is not right okay now Excel speaking upset with me there we go I didn't have my number lock on okay and then let's double check that this new trial balance is in the same format I still have my account number and column a my account name or title and column B and then my debits and credits in C and G so all of that to remain the same I'm going to click OK and now it's asking me to select another file because we also want to pull the general ledger in I'm going to pick my 2015 general ledger and it's the same thing I just exported this side of myself my accounting software so the general ledger is a bit more complicated for Excel to read so we need to fill in these fields here to explain what's what the general ledger from date or beginning date would be January 4th 2015 January 1st 2015 in our first transaction row let's see that would be Row 3 right here where we have a reference of 242 in the description and then an amount the account description column let's actually column a because that's where I see the account we're dealing with is checking the number of rows above this first transaction is 1 if we exclude the headers just the title of the account and [Music] for the ending balance the debits and the credits are both in column G so I'm going to indicate that by putting G in both debit and credit and then we need to specify what each column stands for the transaction date that's easy it's labeled date so that's column B and the transaction document must be this reference here and column C the allocation account is labeled for us in column E and then for each transaction both are debits and credits are in one column column F there is one field on here we haven't accounted for the description I think that would be useful so we'll add that here okay we're done labeling it in the click okay and now the general ledger is going to be imported the same way with the trial balances okay so everything was pulled in and now Excel is telling us Excel FSM really that one new account was added to the chart of accounts because it can compare it to last year's trial balance I'm going to click OK and I noticing the new account it always brings it to the very top of the chart of accounts so that it calls attention to it and it might help us in some of the groupings so if other income is the new account I'm going to close that I have a trial balance printout again we're not going to use that for anything right now so I'm going to just delete that and my balance sheet has automatically updated now I want you to notice on top here we have a new file name just with a different year s so what Excel FSM automatically does it has saved our 12/31/14 file and put it in the same folder as where it created this new 1231 15 file so that's done automatically we have a record of what we did last year so that we don't lose that and then now we have this updated file and the updated file we now have 2015 and 2014 as our prior period which is what we'd want but our balance sheet does not balance the reason for that is we have one account we haven't dealt with so I'll just double click on retained earnings and the only account I haven't grouped is the new one so that's the only one hanging out here all by itself I'm just going to pull it into retained earnings and now my balance sheet balances I need to do the same thing for the statement of cash flows because remember we disconnected the formulas so change I make it a balance sheets not automatically going to happen over here I'm going to go to my net income and see the same thing other income our new account is the only one that's listed as ungrouped so I'm going to move it over now it's grouped together and now our statement of cash flows is correct let me show you another way to create comparative columns or financials I'm going to just copy the entire column and paste it right here and now I'm going to use the balance variation again to change the period that this reflects so I'm going to click on select periods and rather than the difference between 2015 and 2014 I want the difference between 2014 and 2013 and then we should recognize these numbers as the statement of cash flow as we created earlier there's one other way the movie can use that balance variation button I'm going to copy this beginning balance from the current year oops I just copied the whole thing again let's quickly undo that I meant to copy this one show and that is going to be my ending balance for thanks give me 12/31/14 and I'm going to copy it again right here for the beginning balance that's obviously not the beginning balance but here's where I can use balance variation again I'm going to just select a different period for that number and what I want is the beginning balance or the ending balance of 2013 and when I click on that now that same formula updated for the year that I want so that's very flexible you can use balance variation anywhere in your workbook and reuse the work you've done in a prior period for a current period ok let's see this might be a good time for another poll because we're going to switch back over the balance sheet again all right Joe it only walks them down this is are you at a public accounting yes or no that's an easy one so I figured those of you in public accounting this would be a great way to create some financials or some other work papers for your clients since they already use Excel so you can go back and forth very easily and then those of you and Industry probably have quite a few custom reports that you use every month where you could be automating those processes ok I will give you a few more votes here to get up to about 95% right now almost what about 50/50 I'm gonna count down three two one I'll share that with you okay about half and half good to know all right we're back on the balance sheet so I can show you something in this new year in 2015 you'll recall the details button I'm going to click that on cash again and now I get the details of my current year and prior year cash but remember we imported the entire GL so we have much more detail here available to us I'm going to double click unchecking and what I get when I do that is all of the checking transactions from the beginning of the year to the end of the year and then I can dive deeper if I want to maybe I notice this transaction that needs me to further investigate it double click on that and now I have the transaction detail for this transaction from here I can go to that back to that same account but we were looking at checking or I can pick another account so I'm just double clicked on federal withholding and now I have the balance detail of federal withholding from the very beginning of the year to the end of the years so this could be very powerful if you are either looking into what's in a balance or needing some details to support some things for any one of these I'm going to go back to checking here we can generate a printout sheet so I'm going to click on that so you can see what that looks like so my balance sheet and eye state net cash flows stay in place but a new worksheet will appear and this is quite a big one because it has all the details of checking for the whole year and I could point out this GL button here does exactly the same thing as what we just did it just does it for all the accounts so I have the checking balance sorry the checking all the bounces here and since this now in Excel format in a worksheet I can do whatever I want with this all the normal Excel functions so maybe maybe I want to sort from largest to smallest so we can do that okay just sort what's sort on the I do not have headers so let's sort on column H the credits largest to smallest so for those of you in public accounting whatever account this is checking or ap or anything we could take the top 20 or however many transactions it is for your firm to test and then the remainder balance is we could very easily sample from here using excels random function and create a sample to test as well and the entire time having access to even further details if we wanted so I'm going to go back to the bottom here and if I click on unadjusted balance as a 12 31 15 there I get my GL detail in its original format again so I can dive deeper if I want to I'm going to go ahead and close that and let's take a look at the working papers functionality I'm going to create the trial balance by clicking on trial bow on so except it reminded me I need to go back to my balance sheet and close the details okay let's try that again we'll pick one prior period and click on create so this is going to create for us a worksheet but it's a fully dynamic worksheet whatever changes we make in our workbook they're going to be reflected on here of for example that other income account remember the new one here it is hanging out on top where it doesn't belong so let's fix that I'm going to go to my chart of accounts I'm going to take other income and just drag it down to the bottom where it should be right above interest income close as soon as I click close I don't know if you saw that but the trial balance immediately updated and moved that account on the trouble balance so if we scroll down it should be right here at the bottom in row 83 oh sorry 82 this worksheet is also dynamic in other ways if I double click on the checking balance again I have access to my GL detail so I can do that from my trial balance worksheet and it's set up to show my unadjusted balance any adjustments I've made the adjusted trial balance and then where this ties in to the balance sheet so for cash remember we group that into cell d12 it tells us that and it even tells us the sequence of the accounts when we groups them when we moved that cash account I want to I'm sorry that other income account I want to point out that on the balance sheet nothing changed because the groupings not the account numbers is what drives each of these a financial statement line items so it doesn't matter that in the chart of accounts I've now moved where other income shows up in our groupings everything stayed the same our balance sheet stay the same because the account numbers don't really matter for how we group the data together okay maybe let me also show you the adjusting entries because they should show up on our workbook here they're very easy to do and then a click on adjusting entries and insert to create a new one so it's automatically going to number this entry number one and I need to just select an account let's do checking let's debit it for let's say ten thousand dollars so we notice the difference next line again it's just asking me to pick the account and then the amount and I could continue next line if this is a longer journal entry where I can click who pay if I want to I can enter in our Chanel comment when I click close the trial balance is thinking it should put that adjustment right under adjustments I'm not sure why it's still thinking about that of course every other time I've done this what happens is the adjustment shows up here I am not sure why it didn't this time make sure the adjustment is here it is well of course the one time I show it to yo
it does not work but normally what happens is we get unadjusted the adjustment shows up right there and then we fill it up to adjust the trial balance and from all of this we can still access any of those details and wondering why all this is grayed out as well okay here we go go back to balance sheet let's look at lead sheets which is another working paper please get automatically created so let's look at cash because that's the account we've been working with I'm going to click on create and this now shows me d12 where this is coming from on the balance sheet all the accounts that make up that grouping and their balances so I could do my tick marks over here or any comments I want to down here and I could have selected all the lead sheets and they would all be automatically created then also from the balance sheet we have grouped account sheets I'm going to click on checking and here's that journal entry I made this is looking at the data in a different way it's just the checking account but it shows me my unadjusted balance my adjustment and how I got to be adjusted balance I should also point out that when we made that adjusting entry we weren't on the balance sheet but it automatically updated as well and now I'm like - and my AR balances are different by ten thousand dollars than when we started out let's do another poll as we're running short on time and I want to allow for a couple questions at the end Roger and I have watched poll for and this question we're just curious about what what your thoughts are on the information I presented so far mr. will depend largely on what you do on a day to day basis or month-to-month basis in your role at your company all right as we're rounding the bend here we're going to close this one down here soon we need to ensure everyone gets out on time and we have our responses and it looks like about 70 70 percent or so I indicated something other than CPE which is wonderful it may be helpful I'm not sure and I learned about new solution so that's great it's great background CPE is good too so I am now on our website I want to call to your attention if you go to our website Excel FSM comm can you go to the Excel FSM area there is a section called tutorials and here's where you can find many more examples and instructional videos on doing some things I did today like importing a trial balance but it shows you how to do that with QuickBooks building a statement of cash flows preparing consolidated financials there is a lot it just keeps growing various examples of reports you might create and how to do that also if you go to the downloads this is where you can obviously download the software but the important thing is there's a 30-day free trial it's just not going to ask you for your credit card it's not going to require any information from you but it lets you have a full version of the software for 30 days so I wanted to point out those two things for you and now we have a couple minutes Jacques have there been any pattern and the questions coming in anything that we should answer for people Jacques it might still be on mute we may have lost shock there let me take a look at the questions here okay I'm on you know oh okay any any pattern and the questions is there a question or two that we need to answer for everybody yes wanna wanna has been after few times is does it work with my accounting software like sage in fact accounting CAF in honor so the answer is yes Excel FFM is universal and it will work with any accounting software okay good to know we're going to try to answer any questions we didn't get to a little bit afterwards and you can feel free to email us to get more information and get more questions answered so I want to get you out of here on time I'm just again pulling up this slide to remind you that there's Excel FSM and perhaps we'll do a webinar on word FSM at some point in time and there's the various flavors there for you to explore for excel FSM hoping this has been helpful to you I hope you'll check out via the website and the software and download the demo and see or the bring version and see what it could do for you Joanna thank you very very much and before we head out of here I want to go through some closing comments here and make sure everyone knows exactly what to expect but while I'm doing that if you could do us a favor and put your comments into the question panel we know we had a poll about where the value for you was within the session but if you can jot a note and let us know what you thought your feedback is really really important to us especially as we look at scheduling additional dates and topics so please let us know and on that note we really would appreciate if you fill out the evaluation as a matter of fact for CPE you need to but the numeric responses are what are required and the written responses are really up to you and we hope that you that you do that for us there's a lot of preparation that goes into every webinar and writing a sentence or two about your experience today is extraordinarily helpful to everybody and so we certainly hope that you'll do that you'll find the link to the evaluation in your account and also as part of the post webinar email that we sent and on that note you will find a link to the landing page that we're looking at right now on the website our W I'm sorry where's a moment ago on the website and I shot you the link for that as well through the chat panel and hopefully he'll be able to follow that through and take advantage of this time-saving solution so we will work now and getting CPE issued and getting today's recording and posting it to the site and a lot of other things to work on - we have classes that are transitioning right now as a matter of fact and we have classes going throughout the day many of which are also filling up beyond the thousand person capacity they'll have to potentially close out if we get too many sign up so I'm just basically suggesting that if there are courses that are of interest to you today and really throughout the month that you sign up as soon as possible given that we're going to have to start capping attendance on incredible demand which is been a lot of fun so I hope you enjoyed the session and wow you guys wrote a lot of comments about today's experience and we've posted many of them thank you for doing that Nathan and this is great so we're going to keep an eye out for all these questions and you si have joined us information if you your question did not get answered and you're looking for a quick response so thanks everyone thanks Joanna thanks Jacques we'll talk to you soon yeah thanks
