Welcome to this tech talk on remote water monitoring. Our speaker today is Mike Hayes from Intuit. I've spent 15 years in AG services and in AG industries prior to his life at Intuit. He focuses most of his energy on communication equipment for remote networks and the implementation of monitoring and automation systems supported by this network. We welcome Mike. Thanks Mike. Thanks Davey for the opportunity to talk. And I suppose for us any opportunity to give people an insight into not just what our business does but also what other stuff is available out there that people may not be aware of. Here we are. We're a little business based in the southeast of South Australia down at Naracor but cover pretty much all of South Australia and anywhere else people wish to go. And the main drive of our business is to fill the gaps where the bigger players don't operate. I.e. there's no point us going to do something in Mount Gambia or Adelaide or anywhere like that because they have a multitude of ways to connect and distances aren't normally an issue for them so whether it be our telemetry work or internet related gear is really about filling gaps that most people are aware causes submission in regional South Australia. Myself and my brother, Dan's been probably doing it for about three years longer than me. I've been going for about seven or eight years and along with our staff in other parts of what we do it keeps us all busy I can assure you of that. So we'll get presentation underway. Big questions first. Just so you don't have to wait until the end, what does it cost? I normally try and cover this first and that's largely because people inadvertently all sit there and go well that's all great but how much is it going to cost me? So really if you're doing our type of network we do other types which go through telephone and through hotels for an optis network or satellite and those types of things but it doesn't really operate in the core of what we're trying to achieve which we'll go through a bit later on. So essentially if you had 10 water points, one repeater and a homestead to give you 12 locations and it's about three and a half to four grand per location so it's going to be about 36 to 48 grand to do that type of set up and the economics of that really comes back to labour replacement and how it could be you can get a return on I'm sure plenty of people have seen calculations of driving around time saves and all those sort of things. Each one is different and everyone has the opportunity to do those calculations on their own. So for us it's not a situation where it's cheap but it needs to be cost effective. So our system is based on the type of systems that we install based on the premise that when things go bad you don't want to get any bills. I.e. if you've had to de-stock and you've had to shut things down then you don't want a situation where you're going to have to continue to pay for monitoring or automation when you've got no livestock there or if you don't have any crops in the ground. So what do you actually get for your money? You don't get any monthly charges. You don't get any internal internet costs and you don't get the internet bills. All of our equipment works internally so that you have your own network and that's how you get around all the ongoing costs. Plus it doesn't put any limits on what you want to be able to do on it. That's entirely up to you. Where we really do differ is that if you own your own network or type of network that we put in you don't have any bandwidth limitations for that price. I.e. we have plenty of networks that will have five cameras on them and on the same type of networks we can run 150 cameras. No extra cost per month. No extra equipment required. It's just what you decide to put on. Steady tight for us in those examples I was just showing is where you do have a camera on a trough and a camera on the tank. So the reason for the variation in pricing between 3.0 and 4.0 brand is what you decide to put on. Whether you wish to have two cameras or three cameras or four cameras or whether you want to have Wi-Fi calling from a tank or whatnot and we'll cover all that more in depth with you later on. And that was what I just discussed. Motivation. People install this type of technology. Essentially we're in the labour replacement industry. It's a funny thing where we can go around and oh we do it for this reason we do it for that reason. I'm sure there's plenty of people out there that really like to have a situation where you have another couple of people on farm to help you out. But there's one reason that we don't. And that's because labour is expensive and coupled with hard to get. So really in terms of all of the things that monitoring and automation is today's world it's difficult to afford to have full-time staff on farm. And therefore we're looking for ways to not have the people on farm but and to be able to do more cost the same jobs more cost effectively. IE water monitoring. So option A we partner an employer to check a tank that 95% of the time didn't need any checking. Yep, thanks for driving along. Yep, thanks for driving the next one. Yep, thanks for driving the next one. But check the same tank and 100 others yourself while out late over and at the Bradman Bar believe it or not, that's actually a true example. People that do go to the cricket along with myself and keep an eye on things while they're away. Also if you happen to have a holiday anywhere else around the place you can still achieve the same thing. We're all started for us. Six years ago is probably more like seven years ago now. Think about it. I'm going to talk a little bit about it. I'm going to talk a little bit about it in a minute, which is about 60 K's west of Pimba. The owner Sam Ingalls is my brother's wife's first cousin and they are at Christmas dinner in Clare. They were talking about it and trying to come up with a way to try and stop all this driving around and paying people to drive around to do the same job. There's got to be a better way. So my brother did say that. Hang on, I've got a phone call that I thought was on what do you call it, airplane mode? That's right. I thought it was on airplane mode, obviously not. I did it to his retons then when we had to do those file trains. No, you're right. Just start again here. Start that section about where it all started. Yep, just go from there. So where it all started for us was where I'm in it. My brother Dan and I work with his wife, Kathy's. She's from the Mid North from Yacca and they are sitting in Clare at Christmas dinner and Sam, who's first cousin, said, we're a minute driving around checking tanks. There's got to be a better way than this. So my brother said, oh, that's all right. I'll get Mike on that. He'll know how to do it. I've got him for the first job. Pretty much that remains unchanged to this day. The original design and equipment that went in has pretty much remained unchanged. With one camera on a tank, one camera on a trough, they do have traps rather than conventional mustering for cattle. And since then there has been, I think we've got one, one, two, three, four pumps that get started along with a few other things that have been added on. These are the types of projects that we get asked to tackle. This is the Moorla-Watman just on the Strazliki track. And people ask us to do some things which on the surface seem to be not necessarily unachievable, a little bit more difficult, require a bit more thought. And that was to have a system that would cover the whole property. And that would be able to monitor waters, monitor stock, rain, keeping contact with others, being able to make phone calls, send texts. The next bullet point there where they're highlighted where it's, that was upgradeable, so that in three or four years' time, when equipment became redundant, that it'd be easy enough for it to be, and cheap enough for it to be upgraded. That it was easy to maintain away, not having to wait for someone to drive all the way from Adelaide or Melbourne or fly down from Brisbane or somewhere to fix it, that they'd be able to do it themselves, and that there wasn't any ongoing fees. I said, yep, that's all fine, leave it with me. So I thought about it for a couple of days, and came up with a couple of ideas, and yeah, it went from there. So all what has been going for a couple of years now, and we did actually achieve all of those things. The types of coverage, a lot of people go, well, that's all great, but I've got a very large property, or a remote property, or whatever else. This is a Mapabilica lino, which is halfway between Rockford Downs and Cooperpeedy. You can see the farm sizes on towards the top of the map, and yeah, we've successfully covered all of those little water points that go circled for me, and a few others since then. So the area and distances is not a problem for us. It does add cost, there's a little bit more work, but ultimately at the end of the day, you're trying to limit the labour and limit the driving as much as possible, and this is one way to do it. So what do we use this type of technology? Or how do we select the type of technology that we use? We try and use the same technology that you have at home. And the reason for that is that it uses the same technology that drives the internet. The same way that we're able to do this webinar is the same type of technology, computer technology, internet technology that we use around the world. It provides one platform for anything that is networkable, i.e. it doesn't matter whether it's a printer, if it's a computer screen, if it's a laptop, if it's a phone, that all of those things will work on these networks. And what it does is really allows us to move into the realm of mass-produced type products so that the price of this stuff becomes achievable. A lot of the types of things that we'll talk about a bit later on have been done in mining for 15 years, but where they were paying $30,000 to do a job, we're trying to do it for three. So using open source equipment is an important part of how we design our things. And once we've got all those things placed, it does actually provide a road for agriculture to move forward because it is the same type of technology as the rest of the internet. And as I've spoken about that, it does help to keep the price down dramatically and also the availability of equipment. This is the interface that we use. For one of the solutions that we have, this is one of the camera networks. You'll see on the right-hand side that you can click on each individual camera from a live view point of view or on the right-hand side where in the menu down the left-hand side, where it says live view, you can put eight or 10 or 15, 20 cameras to look at simultaneously. You can put a lot more cameras.  There's also a phone app that you can run with this. And from there, it depends what else you want to add on, pump start, those types of things. As I said, all our components are available as open source. We don't like being tied in, same as anyone else. If you see something really cool on eBay and you think, yeah, that's really going to suit what I want to do, you can leave it. As long as you can connect it with a blue computer cable or with Wi-Fi, it'll work. And what that allows us to do is use lots of production, lots of different suppliers to achieve the endpoint. And most of those parts, once we've got the network in, in between one to $200, the little radio that sits up at the top that's capable of talking 40 kilometers or further, there are $175, a little computer switch that everything gets plugged into inside the box. There are about $145, something like that last time I looked. The system runs on 12-volt, it's a 12-volt, 12 to 18-volt solar panel. And if need be, it can drive up to the lampers and put the jump leads on a little guy. It's nothing expensive in each individual component, i.e. if at all someone leaves their handbrake off and land cruiser and goes careering down the hill and crashes into one, then you only got to replace each individual component and not actually the $3,000 again. Why do we, why do we do cameras, not sensors? It's not that we don't do sensors, it's just what we believe as a sensor is a way to give a feedback loop. And with a camera, you can actually see what's going on. Seeing is believing. You can't get a false positive in this situation. You can't get a situation where a salt builds up around one of the sensors or sensor gets jammed or bird creates bird nest on the sensor because you'll see all of those things going on. As you can see, and this is the water flowing into the, into a tank. Our type of networks, you control what's going on. Let's us operate where you normally cannot. So this here was, was myself driving out of Billicolina. We've been up in the rocket range. Yes, we're actually allowed to be in there. We're on our way out. I was just trying to prevent anyone else going in. But we can actually operate where the others can't. And in some situation where NBN can't. IE, you can't get an NBN connection stuck on a water tank out in the middle of nowhere. There are some of the other people that provide the length through equipment, farm bot, eco-sat, those types of people. And they do operate in areas where we can't. But under those regimes, it operates against that philosophy of what we have, which is no ongoing cost. And that, for example, and that for us, we don't care what sort of bandwidth people want to pull through. If you want to pull 100 cameras through live feed, well, that's all right. Pull 100 cameras through live feed. The only ongoing cost would be if you wanted to go on a 12-month annual leave and you wanted to use all of your internet to try and pull 100 cameras through to Fiji. Unlikely to happen, I would suggest. What do the internal networks provide? It's multi-purpose platform for anything that's internet-enabled. As long as you can play that blue computer chord into it or you can use Wi-Fi, it'll work on this network. It's live access. It's not a pulse. It's not every 15 minutes. If you decide you want to start a pump, you click the button and the pump will start. There's no monthly SIM cards required. There's no licenses. No monthly support charges. You can repair and replace equipment yourself. With guidance, generally, when we set the networks up, we get people to help us so that they learn how the network operates and how to do maintenance and troubleshooting themselves. And as we just discussed, the average replacement is about $200 per component. The investment in networks is not just limited to the one purpose. That's an important difference. People are probably reasonably familiar with types of automation and not just agriculture in other industries. There's just a few of the other things that we've been asked to automate in the last couple of years. This following pump is one that's an hour-and-a-half round trip from the homestead. It's a Kuna. The pump has to be started every day over summer and runs for about eight or 10 hours. Unfortunately, in the past, once you left the pump, there was no real way to know that it was running. So this is the interface that we used to start stopping and running the pump itself. Just a simple click on the buttons on the right-hand side. You can click the Run button, click the Stop button, where you can run it for 12 hours. So when you use the Run 12 Hours button, the pump will run autonomously, i.e. if you lost an internet connection, well, sorry, if you lost a network connection or you didn't have access to it or whatever, it'll look after itself. The control is actually at the pump. And then the start motor is the crank. So this is actually the motor itself. So what you'll see in the middle of the screen there is the little linear actuator. I'll be quick, because it will start to pull in. And then you'll see a pigeon that starts to come down from the right-hand side. We'll see that as Mr Occhial is in safety, just checking out and making sure everything's okay. And then the motor will start. What you'll see shortly is once the motor has started that that actuator just below the fuel tank pushes in and pushes back out, sorry, then the motor will stop. These pumps, as I've just described, can be started and start from phone, computer, anywhere, anytime. Not only that, once you leave the site, you actually can check in at any point in time and check on that pump to make sure it's still running, hasn't run out of diesel, hasn't had some vermin get tangled in the belts and run the belts off. And then you can actually click on the tank and make sure the tank does have water running into it. So there's also an example here of some other types of scenarios where we have like cameras in tanks, water troughs, go traps, all those types of things. Wifi calling and internet repairs. On an Optus type sort of system, if people have got Optus since 80 bucks, get you 500 gig. This one here is in the Gawler Rangers. So it's a 30K link, and then a couple of Ks down to the homestead. Broadcast Wi-Fi around the station quarters, kids doing schoolwork, those types of things. School of the air and provides all residents with, not mobile phone in terms of a Telstra connection, but it does actually allow for Wi-Fi calling. So generally what we do is set the same Wi-Fi calling system up at each water tank, or if you want, if you look higher on top of that mast, you can see what looks like a piece of PVC. If you set up car kits, then you can do about a 15 kilometre, a little bit further, maybe 20 kilometre line of sight, and back to those repeaters. And then you can create a Wi-Fi hotspot in your vehicle, and then you can use that to use Wi-Fi calling. Works quite well. The first one I ever made was on a zangernabilic liner. It was quite good fun. It was late in the afternoon, over a couple of years, because I thought it might actually work, and it did. Some of those other concepts that we do use is a bit of a side point to telemetry, but it's some scale and scope of the gear. This is one of our internet networks, or our internet networks in the southeast. Another part of our business is actually delivering internet into people's houses, effectively in competition to NBN and Telstra and Optus. The only real reason to put this slide up is that we do actually know what we're doing. It's not a fly-by-night thing, and that it's actually backed by some guys that actually do really understand what we do and we've been doing it for a long time. We have a lot of fun doing it. For people in other parts, we do actually do some work with Beam out of the Barossa, and for people in the mid-north, that know Gorda Connect. Some of our back-end internet provision does actually come out of Adelaide. They're all little side points, but more just to give some confidence to people that haven't had a word of mouth referral that we do cover a reasonable amount of the state. The Red May and War Growth program is an initiative of primary industries in region South Australia and supported by Meet and Livestock Australia, the South Australian sheep and industry funds, and Sheep Connect South Australia.


Hello everyone! I hope you all are doing well. Artificial intelligence is gaining popularity day by day and the most fascinating is natural language processing, using which robots can understand the languages spoken by humans. Not only understand but also feel the emotions behind it. Isn't it amazing? In this video, we are going to try our hands-on on the latest NLP extension of picture blocks by making virtual doctor. You just need to tell your symptoms and he will tell you what caught you and what you should do next. Along with the NLP extension, there are a lot of new features added to the latest version of picture blocks. If you haven't downloaded it yet, you can download it from the link given in the description box below or the card above. Let's begin! Open picture blocks. First of all, let's add the doctor and the hospital's sprite and set up the stage. You can download these sprites from the link given in the description box. Once downloaded, you can place them as per your choice or like the type we have placed here. Next, add the NLP extension. NLP stands for natural language processing. This is the area of AI concerned with the interaction between computers and humans in natural language. The aim of this extension is to help computers understand language as well as we do.  For training, we will add data of symptoms for three diseases, that is COVID-19, malaria and diabetes, one by one. Go to the My Blocks palette and create a block named Data for COVID-19. To add data to the text classifier, we need the NLP extension. Take an add class block and place it below the hat block. In place of text, write the first symptom, dry cough and write COVID-19 as class. Let's add more symptoms to COVID-19 class. You can add as many as you may find. Only thing you need to do is just duplicate the block and write the symptoms you want to add. Now, similarly, add data for the other two diseases. We'll add three symptoms for each. Now, we need to train our text classifier. Create a block named Training. Take the training hat block and add a reset text classifier block below it. Add the data for COVID-19, data for malaria and data for diabetes tag blocks one after the other. Add a train text classifier block. Next, let's begin to write the script to make the virtual doctor say the name of the disease we have after we tell him our symptoms. Add a when flag clicked hat block. Drop the train data stack block below it. Let's make the doctor greet us. Add a save block. Write, hello, welcome to the virtual hospital. Next, we'll warn the doctors to ask the symptoms. Thus, from the sensing palette, add a ask and wait block. Write, how are you feeling today? Please tell me your symptoms. Here is when we will try the symptoms and the doctor will tell us the remedies for the same. Place enough block into the scripting area. Add an equal to block from the operator's palette. Inside the first space of the equal to block, drop a get class of block. In the second space, write COVID-19. Inside the get class of block, drop an answer block from the sensing palette. This will check the symptoms you enter and if they match with COVID class, the doctor will say out the disease as COVID-19. Into the if arm, place a save block and write you are infected with COVID-19. Now that we know the disease, the doctor will say the remedy for the same. Place a save block from the looks palette and write remedies into it. If you need to write more remedies, you can use another save block too. Similarly, we will do malaria and diabetes. Duplicate the if block and make the changes respectively. This, our script is complete. Press the green flag to start the script. Let's test and write the symptom as I am feeling breathless and have been experiencing fever. Yes, head got detected correctly. To escalate the project, instead of typing your symptoms, you can use speech recognition blocks to recognize your voice and then diagnosis. So this is all from my side. Now it's your turn to make this project. But don't forget to share this project with the Pictoblocks community on Facebook, which you can join from the link given in the description box below. If you like this project, give it a thumbs up and subscribe to Stempedia.  Bye bye.


QuickBooks Online 2023 bank feeds matching sales receipt to bank feed deposit. Get ready to start moving on up with QuickBooks Online 2023. Support accounting instruction by clicking the link below giving you a free month membership to all of the content on our website broken out by category further broken out by course. Each course then organized in a logical reasonable fashion making it much more easy to find what you need than can be done on a YouTube page. We also include added resources such as excel practice problems PDF files and more like QuickBooks backup files when applicable. So once again click the link below for a free month membership to our website and all the content on it. Here we are in our bank feeds practice file we started up in a prior presentation using the 30-day free trial. We also have open the free QuickBooks Online sample company if you want the two open at the same time we suggest using incognito or another browser. You can open incognito if using Google Chrome by selecting three dots up top in the browser and picking incognito window typing into the search engine QuickBooks Online test drive. We're using the sample company to compare the accounting view the one the bank feeds practice file is in and the business view the one the sample company is in. You can toggle between the two by going to the cog up top switching the view down below. We're now going to duplicate some tabs like we do every time to put reports in right clicking the tab up top to do it to duplicate it right clicking the tab up top to do it to duplicate it and then we're going to go to the tab to the middle the first duplicated tab that we duplicated from the first tab and then we're going to go to the reports open up that balance sheet report which is one of the favorites it's your favorite report too it is your favorite it's everyone's favorite okay and then in the business view by the way it's in the business overview reports on the left hand side and there you have the reports tab into the right we're going to go down to the reports again on the left this time the profit and loss the other favorite reports yes that's your favorite too everybody loves these two you might call it a different name they have different names like nicknames like an income statement oh one oh one two two twelve thirty one two two all the great stew they got lots of names so i'm going to go tap to the middle close up the handbooky change the range oh one oh one two two tab twelve thirty one two two tab uh twelve thirty one two two tab run it to refresh it let's go to the first tab open up the bank feeds because that's where we're working we're on the banking tab on the left hand side easily seen on the accounting view banking up top if you're in the business view then you're going to the bookkeeping on the left hand side which is not quite as intuitive for the bank feeds but still not bad then you got your transactions bank transactions okay that's the setup process we do every single time we're now looking at the revenue side of stuff down below i've sorted the detail of the bank feeds first by the bank detail and then by amounts so i've got my revenue stuff up top and we're now going to consider a situation where we have a sales receipt so if i hit the drop down remember there's a couple uh revenue forms we could use to record revenue the invoice now the sales receipt and then we could use a deposit form let's take a quick look at the flow chart to analyze the process so remember at the end of the day we expect to be getting cash at the end of the customer cycle that is however the cycle could be more or less complex depending on the industry if we're in gig work we might be able to wait till something clears the bank use the bank feeds to record revenue with the deposit form but that's not the natural full service system that QuickBooks is designed to use and we use we lose a little bit of detail such as sub ledgers for things like income by customer and income by item but that might be well worth it if you can do that then a step away from that still a cash based system but not a system where we can just simply depend on the bank to record the transaction would be a cash register situation for example in which case we would use a sales receipt and then the full accrual system would be one where we do the books first and then we have to make an invoice so last presentations we've been talking about the whole accrual process if you're in that kind of industry where the bank feeds fit in where we said they could fit into making an invoice trying to connect the bank feed to that receive payment trying to connect the bank feed to that or recording the deposit and just simply matching the bank feed to that and we could at the receive payment area record that as a deposit on our end and match the bank feed to that so we have a similar issue with a with a cash receipt or a cash register type of situation where we're going to get we're going to get sales that we're having at the point of sale so we're going to want to record them at the point of sale but usually if you're at a cash register at like a food truck or restaurant or something like that you can't simply wait until you finish the day's work and then deposit whatever cash you have or however the deposits are being made to the checking account wait till it clears the bank and then record it as revenue on your books using a deposit form with the bank feeds you can't really do that because you're losing a lot of internal controls if you're using a cash register what you're typically going to want to be able to do is record the receipts as you make them at that point of sale and then be able to double check say your cash sales to what you have in your cash register physically counting the cash comparing that to the cash sales to make sure that they tie out and then when you make the deposit into the checking account if the cash deposits you're going to deposit them as one lump sum if their credit card amounts then the credit card company is going to have to package them in some deal in some way typically and then put those into your checking account in some kind of format so that means we're usually going to use the sales receipt form even on a cash based system not simply a deposit form when we're recording the transaction so we can't do that by just waiting till something clears the bank and construct our books with the bank feeds then so then you typically have a situation with the sales receipts where you might get multiple sales during a day let's just take the cash for example and if you get multiple cash sales then you have this kind of situation where you can't really just deposit it into the checking account when you make the sale because you can imagine a situation why don't I just every time I make a sale I use the sales receipt to basically increase the checking account you could do that but it would only work if you've got if you got a separate amount that's going to hit the bank account for each sale that you make like if they were electronic transfers or something like that or you're receiving an actual check because then what you're going to need to do is check that to the bank statement in the form of a bank reconciliation or in the form of the bank feeds and that's going to be part of your internal controls but if you have a situation where you have multiple cash sales then you're going to have to put them into that clearing account which is undeposited funds or funds to be deposited and then deposit them into your checking account in QuickBooks and the same grouping the same format that is going to be used on the bank side of things so that you can reconcile possibly with the help or the use of the bank feeds so you've got that added step that's naturally almost always going to be there because if you're in a credit card situation you're usually going to have multiple sales that you have by credit card or in cash that you're going to want to verify the sales that you have to the recording of the sales receipts and you're going to want to deposit them into the bank in the same format as they're going to be grouped on the bank statement which is not the same format on a sale by sale basis typically because of the way the credit card company is going to work or because of the way you're going to group all the cash together and deposit it at one time not having separate like five dollar deposits as you deposit them into the checking account so let's see that in an example so I'm going to right click the tab up top and let's just imagine we're at a cash register now so in your mind we're at a cash register and so I'm going to say let's let's pick up let's pretend this one was cash receipts uh of of this one thousand uh three seventy eight oh five so I'm going to go okay let's go to the first time and I'm going to hit the plus button and we're going to go into a sales receipt sales receipt situation let's say this is customer customer number what are we on let's just say 10 customer 10 I skipped a few and so we're going to go boom customer 10 bam and let's say this happens on let's say uh 10 15 22 is where my numbers are at and then down here I'm going to say that we have it looks just like an invoice but now it's a sales receipt right so I'm going to say let's just say we had hours and I'm just going to try to match it out to here which is the 137 805 so I'm going to say okay 137 8.05 now I'm going to I'm going to imagine this one I deposit directly into the checking account this is not the way I think you're going to be able to do it most of the time because notice if this was like a cash sale again or a credit card sale then this dollar amount isn't necessarily what's actually going to hit the checking account because I'm going to group together multiple sales possibly or the credit card company will when I actually deposit them physically into my bank so I won't be able to to basically connect so so that means my bank's going to have a different grouping so I'm going to try to show the two methods that you could use though however so if you've got for example electronic transfers then maybe you could do it this way because that means it's going to hit the bank for this exact dollar amount but if it's cash or credit card you might have to use the undeposited funds so let's just imagine like the easy way first this is going to be an increase to the sales driven by the item down here and an increase to the checking account driven by this item let's go ahead and save and close it save and close and then if I go back to the balance sheet tab and we run it running and I go into the cash now it increased the checking account so if I go into the checking account with a sales receipt that's the other thing that be a little bit you might want to think about a little bit it's not a big deal that you have an increase to the checking account with a sales receipt but when you think about the increases to the checking account notice we have multiple things here now we've got the sales receipts the deposit and the payment forms so if I wanted to sort for example up top for the increases to this account I'd have to say filter transaction type I'd have to pick up three things there might be a payment form there might be a deposits that increase it of course and now we've got the sales receipt that could increase it so if I do that that's a little bit more tricky just for the filtering to kind of pick up those different kind of things that could all be increases to the checking account which you would not have if you used the clearing account method but that's not a big deal just something to kind of be aware of and then I'm going to go back on over and the other side is going to go into the revenue account on the other side of things running it we're in the service revenue boom service revenue services and then we've got our sales receipt sales receipt going into it and that looks good and because you're using the actual sales receipt and you're adding an item you do have the sub ledger reports now because now you're using a full service type of system so if I ran for for example subsidiary reports now if I right click on this and duplicate it and I'd said I want to run a report that's going to give me my sales by customer or my sales by item what I sold I can go to the reports on the left hand side and let's just say sales sales by customer so let's just do the summary sales by customer from I'm going to go from 0 1 0 1 2 2 to 12 3 1 2 2 or run it and so there we have that so now we've got our sales broken out by who we made the sales to and it adds up to that 2 9 4 3 0 5 so notice our total sales are this 9002 it's not tying out to total sales because most of these sales I made using a deposit form remember all these sales I used made it making a deposit form which isn't what QuickBooks is kind of designed to do that means you lose some of that detail but this one for example most of these are in place with an invoice or sales receipts the forms QuickBooks is designed to use and therefore you have this subsidiary report so if all your sales were made with invoices and sales receipts and you assigned a customer which you pretty much have to do if you're using those forms this report would basically tie out let's let's open another one just to see the sales by item so that's why usually on the income statement you wouldn't break out all of your income lines by customer like we did kind of here unless you're doing like gig work or something like that so let's go on over here and look at sales sales by product service let's do that one and go from 0 1 0 1 2 2 to 12 3 1 2 2 run it running so now we've got the actual things that we sold which once again ties out to the 2 2 9 4 3 here only the items where we actually used invoices and sales receipts are being picked up here if you used if you only recorded revenue with the forms designed to do so invoices and sales receipts and you assigned an item inventory or service item the thing you sold this would tie out to basically your total income over here and therefore you would only want usually your idea would be only to have a couple income line items and then all the detail would be broken out in the subsidiary reports unless you're recording with deposits okay let's go to the first tab or the second tab and say how do the bank feeds fit into this if I refresh this it might pick this one up now the dates are wrong because this date is actually before the one that I put in place so but let's try it let's refresh it actually did I do the Google or did I do Skillshare I can't even remember get your head in the game this is serious crying out loud I think I did this one it's still the dates before so it might not pick it up I might have to change the date but I'm going to go into it and see if I can match it and so there's the invoice so the invoice is actually I think I tied it out to 1378 this one so let's try this one and that one's way before so let's see if I can match that one and it doesn't give me anything to match it to I'll let's change the date up here and bring it up to the end of October that's when I entered there it is okay so there's the sales receipt now obviously you probably wouldn't have this big difference in the dates so it would find it if this sales receipt was closer in date I made the sales receipt actually after the deposit which is why QuickBooks wouldn't have picked it up you would think by by default if this was put in there before the date that deposit happened the correct time frame then you would think QuickBooks might pick it up and let's just test that out just for the fun of it if I go back on over here and I say let's say this happened let's just change the date on it to 81 and see if QuickBooks this date sale rate don't mix okay sales date is going to be okay let's do that I'm going to save it and close it hopefully I didn't mess anything up horribly and then I'm going to go back here I'm going to close this out and I'm going to refresh the screen refresh the screen with a refresh button and see if QuickBooks picks that up because it's basically a deposit now so yeah so now it matched it so now it found it so so there you go so it should kind of do that because you the sales receipt is kind of like a deposit form now when I match this when I actually hit match it's not going to do anything it's not going to record anything new because the deposit had already been made although it wasn't made with a deposit form it was made with the sales receipt so I'll match that out and boom that's one method that can be used now the next method that we'll take a look at is if I run this by amount again let's use this one and let's imagine that we have two sales receipts that come up to this amount of 1,015.25 so I'm going to go back to the first tab and I'm going to say we're going to say this is going to be another sales receipt and let's imagine this is going to be customer 10 and let's get the date right this time this is on 919 so let's say this happened on uh 090122 how about that and then down here let's say it's a cash sale but this time I'm going to put it into the clearing account I'm going to put it into the clearing account because they're cash sales and I expect to get multiple cash sales that I'm going to group together put into the bank at one time so if I put this directly into the checking account it won't match what's on the bank feed or bank statement for the bank reconciliation because so therefore I have to use this clearing account so let's say that this is going to be ours and let's just say this one is going to be a thousand and this is going to do the same thing it's going to increase but this time the clearing account and then the other side is going to go to revenue and I'm going to make another one here save and new and this is going to be to uh to the next one here let's say this is going to be to customer custom I'm just jumping up to 15 we're just going to make a leap a leap to 15 here because we got all the numbers in the world that we can choose from and let's make this cash too it's going to go into payments to deposit and let's go into my nose is really itchy stay focused stay focused okay 15 25 let's make this 15.25 15.25 15.25 right 15.25 yes okay so these two will add up to that deposit this will do the same thing for 15.25 let's save it and close it save and close so so now if I go to my balance sheet I'm going to say run it and if I go into my payments to deposit account going into it we're going to say now we've got the 15 and the 1000 which of course ties out to this amount but it's got two different dollar amounts that's why we had to use the clearing account so then I'm going to go back and then the other side went to the income statement so if I go to the income statement it's in of course let's run it to refresh it don't get ahead of yourself don't get ahead of yourself but I'm so slow I hate waiting for myself so you got to wait for yourself so it's going to be these two okay so there's those all right so then if I go back to the first tab then now we've got this amount in the payments to deposit so basically we're right here on the flow chart so if I was to do this internally then I can make the deposit so at the end of the day we're imagining we go to the bank physically deposit 1015.25 as one lump sum or you can imagine a credit card grouping the payments together for 1015.25 putting that into your bank account physically going into your bank account so that means on our side we have to transfer it from here to the checking account in that one lump sum so I could do that internally go into the first tab plus button and the bank feeds and then the bank feeds has this nice little widget thing up top where I can group my sales receipts and payments in the same way we did before so this this top grouping groups sales receipts and receive payments and so I could group those together and deposit them as 1015 if I record this deposit that way then my deposit would be recorded as a deposit increasing the checking account the other side decreasing that amount to be deposited the clearing account going back to zero and then I could basically just use my bank feeds to verify the deposit once again the bank feeds would not be doing anything new there they would just be double checking the deposit helping us out with the bank reconciliation or I could say okay maybe I'm going to try to well that's basically what I have to do you could try to say I'm going to try to wait till something clears the bank right you might say I'm going to try to wait till it clears the bank and then connect that to to the received payments and let's just take a look at that it's a little bit more difficult to do that though because now if I let's say I refresh this screen I'm going to say refresh the screen and see if it kind of picks anything up I doubt it will because it would be more difficult for it to do though so see here's the Skillshare right you're saying well why doesn't it match I've got that amount in in the payments to deposit but if I was to match it here I'd have to go to match find a match and then I'd have to check both of these off in order to match it so you could do it right like I could go in here and just check both of them off to match it but it's a lot more difficult because now you're trying to you're trying to see what cleared the bank you've got multiple items that cleared that I'm sorry one item that cleared the bank and multiple items on our side that you're trying to connect together in order to in order to fix it you're basically doing a bank reconciliation where your deposits don't match up on your books than the other books they match up in total but the amounts of the deposits aren't quite right so you're kind of forced to do it the other way really you're kind of forced to say okay I'm not going to record that I'm going to do you want to leave without saving yes you're kind of forced to record the deposit this way and then and then just match it to the bank feed so if I was to record the deposit this way save and close then I can go to my my checking account go into my checking account and so now I've got that deposit of the 1015 right here as one lump sum now instead of two and then I can go up top and my payments to deposits are back down to zero going into that but it's coming back out here with the two amounts so I can see them going in and out which is good and now if I go into my bank feeds I can just match out helping us up with the bank reconciliation and it'll probably pick it up since it doesn't need to match out two items in our books to match that one deposit so let's try to match it out again I'm going to refresh it and say is it going to pick it up I would think it should this time if it doesn't then there's a problem see it picked it up it knows what it's doing so there so there we have it so that's kind of how you almost have to do it with the sales receipt so if you're at a cash register situation you almost have to use that undeposited funds and then you're probably going to have to group the deposits on your end which means you're just going to be using the bank feeds in order to match if I record this it's not going to do anything new it's just helping me tie out what's on the bank to what's on the book double checking that that is indeed the case so so companies that have a cash register are probably going to still be doing a full-service cash-based system instead of relying on the bank to record the revenue side of things due to the logistics of the business they're in but may still be on basically a dependent on the bank feeds cash-based system for the vendor side or expenses side of things because they might be paying all their expenses with basically automatic transaction forms so they can basically automate so the revenue side even for small businesses will often be dependent upon not simply the size of the business but what what's the standard norm for collecting revenue for that particular business and what's going to work best for you so you got to kind of think through that stuff before you set up the bank feeds or else you can end up with a mess let's go to the tab to the right and just take a look at our trial balance see where we stand at this point in time just to see what's been built as we've been going we haven't been doing this every time because we kind of deviated from a full trial balance just from the bank feeds but<PHONE_NUMBER> you're kind of rambling this time I'm not rambling this is this is clear as day so but most of this stuff you can see how this is a lot cleaner than the balance sheet in the income statement see and and so we're we're I highly recommend taking a look at basically using the trial balance it's a lot cleaner of a report to look at and have open while you're doing the data input and you can see we're constructing our financial statements mainly from the information on the bank feeds


Effects of tongue scraping on plaque, gingivitis, and cavities. This is the first of a five-video series on tongue cleaning. What is tongue scraping, and is it the most effective way to clean our tongue? Watch this series to find out. In my last video series on halitosis, I explored the benefits of eating a high-fiber diet for causing a reduction of halitosis. This effect is thought to be due to the self-cleaning of the mouth while chewing food. However, soft foods, like how most fast food is designed so you can gulp it down, do not sufficiently scrape at the coating on your tongue, and so you can be left with a tongue coating, a whitish-grade layer of debris and microorganisms, particularly towards the back of your tongue. During the putrefaction of debris on the tongue, volatile sulfur compounds are created, like the rotten egg gas hydrogen sulfide. This putrefaction process may be responsible for up to 90% of bad breath. I did a video on dietary tweaks to lessen the formation of these compounds in the first place, but if you're unwilling or unable to change your diet, natural self-cleaning mechanisms might not necessarily remove the tongue coating, if it's really thick, in which case mechanical tongue cleaning can remove debris. But often tongue cleaning is not considered a routine part of oral hygiene. Should it be? Let's find out. Unless you have some pocket of pus from like periodontal disease, the most likely source of bad breath is the surface of your tongue. And it's not like there's one bad actor bacteria. Dozens of different bacteria can produce the same volatile sulfur compounds from the sulfur-containing amino acids concentrated in animal protein. That's why probiotics may fail to change the emissions. In fact, if you compare the tongue microbiome and healthy subjects versus those with bad breath, they have almost the same bacterial composition. So it may be less which type of bacteria you have on your tongue and more the sheer quantity of how many bacteria you have living there. Population studies suggest that the use of tongue scrapers is associated with less severe symptoms of halitosis. But maybe those who use tongue scrapers are also more scrupulous about oral hygiene. And otherwise, the only way to know for sure is to put it to the test. First though, some background. Tongue scraping and brushing have been practiced for centuries in many continents around the world. But it's been almost unknown elsewhere. Why clean your tongue? asked this editorial in the Journal of the American Dental Association. Dentists, hygienists, and manufacturers of toothpaste, toothbrushes, and floss have long emphasized the need to remove dental plaque from your teeth to prevent cavities. But why do so many Americans produce two immaculate, shining rust of teeth separated by an organ covered with millions of microorganisms emitting a strong mal odor? First of all though, what might be the effect of tongue brushing on formation of dental plaque? Like if you stop brushing your teeth completely, would it matter if you brush your tongue? No, stop brushing your teeth and the plaque builds up either way. Yeah, but what if you continue brushing but just add tongue brushing along with tooth brushing? No effect on the build-up of plaque on your teeth, suggesting that the majority of the important plaque-forming bacteria might not originate from the tongue. Though another reason for not finding an effective tongue brushing on plaque formation may be that brushing the back of the tongue is difficult because it can make you gag. What about gingivitis and gum inflammation? Those who clean their tongues tend to have less bleeding on probing, suggesting healthier gums, but you don't really know if it's caused an effect until you put it to the test. Randomize, control clinical trial tongue scraping versus no tongue scraping, and it made no significant difference. What about tongue scraping as a means to reduce the acid-producing bacteria that caused cavities called strep mutants? This study showed a beneficial effect compared to using Listerine brand oral care strips or saltwater rinses, but this other study found no significant effect. Maybe the population of bacteria is just so large that scraping removed only a small portion or maybe it's like sweeping a rug where you're just kind of moving stuff around. The bottom line is that studies investigating the role of tongue brushing and plaque accumulation or gum inflammation show conflicting results. And so on the basis of the medical research, there appears to be no data that justified the necessity to clean the tongue on a regular basis. But the one exception would be oral malodour. It works for combating bad breath, which we'll explore next.


Yeah, absolutely. We should be able to hear the chase cars as they pull out on the runway. Here's gonna be kind of behind him here. And the wing is so long because as you mentioned earlier, we're talking about how quiet the engine is about 70% up until just recently. But the U2, this thing might actually pass down. So let's see if he gets a little bit lower this time. So his mobile officer today is Leroy Matchin.  Here we can turn the way through for us. Pretty cool stuff right there. The departure template is applied down from...