Effortlessly Create a Consultancy Bill Format in Word for Banking

Consultancy bill format in word for Banking

[Music] hello and uh welcome to another Nolan Business Solutions webinar um David here and today we're focusing on net suite and specifically the nol and Business Solutions Advanced bank reconciliation module for net feet um fully accredited um it's built on within the netsuite platform um so it's not actually interfacing in it's running within the system today uh we're focusing on a specific area really of the of the system uh which is the reconciliation tools that just make it easier for you to um automate the uh reconciliation process speed up time free staff etc etc so without further Ado I'm just going to skip straight over into um AB into net suite and here we have the the main net the main AVR menu so we have a lot of setup um today as I say we're going to be focusing on auto match and aluto generation rules um and how they have uh are reflected within um reconciliation so if we go into reconcile I'm going to go I'll pick my um bank account and here we have the main reconciliation window I'm working back in March and we can see here we have the the details of the status from within um net Suite so this this is and we can check that the balance that we have extracted from netw Suite matches with what's in netw Suite what we've got in from the bank we can adjust the filters the moment we're displaying unmatched transactions you see the side by side so it's nice and easy to compare and have a look um I can and we'll see later I can look just at those that are matched or all and if um obviously this is a relatively small amount of data but um should you be dealing with a load of transactions or whatever then you can apply quite intensive filters both on the GL side and on the back on the bank um looking here we've got um some fairly obvious matches so we can see the harro's group here the dates are all the same it's matching on the name and it's a bill payment for the same amount we can see that five live is a payment to us that matches directly and we can see that four piece is a single payment so if I scroll up and click auto match now and that's just going to fire off a rule which essentially says if if I've got a payment in or a payment out the customer or vendor matches and the amount matches then I just want you to automatically match it don't want to have to do anything else so you can see here but it's looked at the eight records on the um bank statement three of those have been matched so now we go back into the bank statement but you can see here that it's um it's matched £ 4541 and when it completes refreshing um here we can see the the the other side has has lost the others as well changing this changing this to matched you can see here now that these are the three transactions they've gone through they've been matched uh they've got their own match IDs um and easy to follow so if I go back to unmatched again what we can also do is match manually um so for instance here I've got two payment transactions on one for all over here from the bank they both come through in one line so I can match match those and click match and again where I have two transactions on the bank side but only one transaction on the net site site I can do the same thing so I can match um one to many in um both directions so I can um then do finally um here I've got a payment um which I've recorded at 9120 the bank has taken £20 interest off it so if I click here and go create GL transaction I can then type in um my account to go against it so I'll go into non operating expense I'll put in a debit for12 I can put in a memo um and if I submit that transaction that will then take me back to the to the reconciliation screen it will have matched them up um it's created the transaction brought it into ABR and matched it up so that's sort of autom matching um and manual matching how you can create transactions manually Etc we then get into um the autogeneration templates so and what I have here um if I come into the setup and I go into generate templates and I can now go in here to the bank charges interest earned so what I'm saying here is that first of all I'm I'm I'm this is these these autogeneration rules or bank accounts specifics so this is the account that I'm dealing with I'm using approvals here so I want it automatically approved but what I'm saying is if a transaction type um charge comes in the statement text matches exactly with the word Bank charge that's in exactly then I want to automatically create a journal entry I want the nominal account to be interest expense and I want the memo to be Bank charges so if we look at the file that I actually imported um you can see I've imported as charge I've imported this as a reference of Bank charge and so if I now um click autogenerate and my process is created and one record's being processed so now I go back to the reconciliation screen I've got no outstanding transactions you can see here that um 48455 is matched again I can see it up here I can display those transactions if I want and if I want to design this off then I could um click the reconcile button that will effectively draw a line under the marker for that statement and generate me an account um control account um report moving on to another bank account um here we have the Metro Bank so what I've brought in from the Metro Bank is slightly different so this is the file that I imported what I'm actually doing here is I'm picking up the customer reference um from the payment reference I'm just picking up these um this particular segment I've achieved that because when I'm in my um in my input format I've said that the reference I'm picking it up from field six but actually I only want um the characters from 23 to 29 so it's possible to extract from a field in order to get exactly what you want to get a precise match going back into the reconciliation here we can see the um things the the the payments received uh actually there isn't anything in next week to match this because um this is where we are really just receiving the information externally first so what I want to do is to just create a payment record um for these which will go in um against this account Amazon 2 uh to which I can then um create whatever I want to match them against um within my accounts so looking at the um the auto generation template for this one here um again well I've not approved it this time but here again this time we're we're going to create a payment um the anomal accounts going to be accounts receivable and my transaction memo is actually going to be made up dynamically so um I'm saying that the The Entity ID which is going to relate to customers it's going to be picked up from the reference I put a sample reference in here of which is what we've got screen just gives me a chance to actually check that uh this is really as much of a testing as anything else but then I can see that it's actually founded that that's valid um and it's going to pick up the reference um down here it's payment from Amazon 2 received on 12 of the 6th um so going back to recile statement now I click on autogenerate again process is fired off three records have been processed again we can see there's nothing left to um process everything's been matched and if I go and have a look at the match transactions you can see how it's generated payment from Amazon um recorded on the 15th of the 3 um and matched over here on both sides so that's um one type of of of um payment posting um if I have a look here now at another bank account again we can see that we've got um two payments come in here uh for nine ladies dancing now out in fact um if I just looking at the register um we can see that here we do have two invoices we haven't actually recorded any payments against these these two invoices but unlike the Amazon uh payments that came in against which there was nothing to match here we actually have payments and so we're going to look to allocate those automatically so if I go back to the autogeneration templates and go to the auto aloc again it's a posting type of payment again going to the accounts receivable the transaction mem that I going to want is to be um is payment from from ladies but what I've ticked here is auto allocation and what this is doing as opposed to the the the the Metro Bank example where I was actually dynamically picking up the account um from the reference field I'm actually set this up because nine ladies dancing is is an account that I you know I do a lot of transactions with and I basically just want it auto allocated um for me so I'm saying match by amount but I can do it you know oldest or newest or match on reference um and obviously we've already seen how I can do it dynamically let's say this time we're we're we're specific this generation template specific to this account of course I can fill in Department class location if I wish to to include them in my transaction if I go back here now then I click all to generate again process is fired off back into the bank reconciliation again everything's been matched and again we can have a look at the match and we can see that there's the mem that I wanted and um they've automatically been matched um that doesn't have to be manual um in in the way that I've just shown you um whether you're um importing automatic basically um using our statement direct uh tool to download directly from Banks uh or whether you are downloading manually and importing you can string um a lot of these jobs together um if I come in and have a look at the reconciliation wizard um you can see that actually I've got I can record against multiple bank accounts and I can then import report extract auto match or autogenerate for all the selected accounts working automatically so it can be bad stuff I've been showing you on an individual basis um in order to explain um thank you very much for uh watching this I do apologize um for the rather dodgy connection that I seem to have endered up with um and um if um if you want any further information um please uh you can visit no and businesssolutions contact sales at no business solutions.com or phone 01252 81 663 thank you very much for attending [Music] goodbye