 QuickBooks Desktop 2023 statements. Let's do it within two-its. QuickBooks Desktop 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 QuickBooks Desktop, sample rock castle construction practice file provided by QuickBooks, going through the setup process we do every time, maximizing the home page, going to the view dropdown open windows list on the left-hand side, reports dropdown company and financial, looking at that P&L profit and loss tab, range change from 01, 01, 2, 4, 12, 31, 2, 4, January, 2 December, 2024, customizing that report up tops, fonts and numbers, changing the font to 12. Okay, yes, okay. One more report up top company and financial, that being the balance sheet standard date, 12, 31, 2, 4, customize, fonts, changing, 12, okay. Yes, please, okay. There's the setup process we do every time, back to the home page in the open windows. We've been focusing in on the customer cycle, which could be called the sale cycle, the revenue cycle, the accounts receivable cycle, one which at the end of the day, we're hoping results in an increase to the checking account for goods and services we provided to customers. We've thinking about the flow in prior presentations, the forms in that flow, the impact of them on the financial statements. We're now considering this item, which is the statements. Now remember that if we're in a situation where we're tracking accounts receivable, meaning we have an accrual type of business, one in which we're not receiving the cash at the same point we do the work, like a food truck for example, or having like gig work where we're waiting until something clears the bank before we record it as revenue, but rather we have to bill the client or invoice the client, something like a law firm or a bookkeeping firm or landscaping for example, the invoice will be increased in the accounts receivable. In that instance then of course, a lot of our time will be put in place to make sure that we collect on the accounts receivable because at the end of the day, what we're looking to have happen is have a deposit into our checking accounts. So when we create the invoice, that will increase the accounts receivable. Now periodically we might be going in and saying, well I would like to remind my customers about the outstanding invoices that they have. However, they might have multiple outstanding invoices. We saw last time in prior presentations we created some statement charges. So we might have statement charges that are basically increases to accounts receivable but not done so with the invoice. Not all companies use them, but you might have those and you might have our finance charges meaning there's past due amounts that you tried to charge finance charges to. So you might have multiple things which one company that owes you money that you would like to include on one statement. That's of course where the statements can be helpful. So you might have a system of running the statements possibly periodically if you have outstanding accounts receivables so that you could provide those statements on a periodic basis which will include all the information on the outstanding items to the customers. So if we go to the customer center let's go to you can do that here or you can go to the customers up top customer center first item and you can look at each individual customer and you can see the activity that they have. Let's look at the ones with the outstanding balance by hitting the dropdown and then going down to open balances. And so we could see the items here and we could see the invoices that are still open. You could select here and say maybe I wanna see the just the invoices. Let's say we want the invoices and let's say we want the invoices that are open. For example, and you could check an individual customer in this fashion. I'm gonna double click on this invoice and then within this invoice we could say email the invoice for example or something like that. But we might periodically want to be sending out statements to all outstanding balance customers closing this back out. So and we would like to do so in such a way that it includes everything that's outstanding for a particular customer. So I'm gonna go back to the homepage here and I'm gonna go into the statements in the customers area. Look at the statements. I'm gonna close the icon on the left hand side just to give us a bit more space. It gives us the statement date that will typically be the date that we are running it. You've got the statement period. So you might be selecting the statement for a particular period like a month by month period. So you might run the statement for example every month. However, that means that it's gonna have a beginning balance if there was anything due before that month and then the activity within that month. The other way you could do it is to select all open transactions as of the statement date. I think by default this might be a more appropriate one or might be an easier thing to do because then you don't have people asking you questions about the activity for the beginning balance that might be there before this date because it wouldn't be included in there. It would just give you a beginning balance if you ran the top one. So include only transactions over 30 days past due. So you may want all transactions that you would think generally would be the idea but you have that option. And then you could select the customers. Now oftentimes if you run the statements periodically like every month or something like that you might simply just run them for all the customers at that point in time. But you could choose multiple specific customers. So you might then choose multiple customers. You just tick off the customers in this fashion or you might just choose one customer in which case of course you could choose whichever customer you would like for the one customer and the customer type. So commercial, residential and preferred send method. So oftentimes you would have all customers here view the selected customers. You could view them in this window and then you've got the preview. So if I look at the preview option it's gonna be generating our reports. If I go into this item for example you could see for that first customer it's got the invoice up top, the amount. And notice this next one was a finance charge that we did in a prior presentation and it's gonna add both of those items in place when it gets down here to the total. So that's great because again it gives us that one report that we could show what is outstanding for a particular customer at one point in time. However, oftentimes you can note that if you have like complicated or a lot of information on the invoices for example this might get quite long or if they have a lot of past due stuff that's why sometimes you might choose like a statement balance looking more like this. And then if I preview the items it's going to look like this for that timeframe. Let's take a look at the second one here. You can see it has this balance forward item up top. Now nothing's in this balance forward but if you have this balance forward item because they had an outstanding balance in a prior period and scroll down. So this one is just a balance forward amount. That's all it has. So it doesn't give you the detail of what the activity was. And so that's when you might get questions because they're gonna say, what does that entail? You're not giving me the detail. That's because you owed it to me prior to when I ran the report and it's the beginning balance. That's why a lot of times this one might be the easier way to go because it'll give you that detail for the prior balances although it could make a longer statement. So that would be the general idea. And then we could print them, we could email them. Notice of course this statements don't have any impact on the actual transactions because it's just an information system that's gonna help us to present this information to the customers hopefully to help us with collection. We've got the template options up top so you could try to customize the template for the report and that could be useful because of course this is a type of report that's gonna be given to an external person. Those are the kind of reports that are useful for to try to customize in such a way that it's gonna have our brand and all that kind of stuff like an invoice form and reports that are going out to the customers. Create one statement per customer so if you have a job situation as this company does it could be a little bit complex to think about the customers versus the jobs. And then we've got some options up top show invoice item details on the statement. So that could be useful again if you wanna give that added information about the details of the invoices but if you have long invoices meaning there's a lot of line items on each invoice which is often the case with like a construction company then that can create a very long statement which might be a bit overwhelming. So for example, if I check that one off and preview it let's say we've got the customer one doesn't have much so this one you could see that we have a lot of kind of detail on that invoice that could be useful unless you end up with a statement that's got like too much stuff. It's a bit overwhelming for example if you've got too much going on with it but if not again, a little more information about it might reduce the question so you wanna have the happy medium ground between overwhelming the people with a statement they're not even gonna look at cause there's too much stuff in it to kind of reducing the questions by adding the detail that would be necessary so they don't get calls that are gonna ask for the detail or calls about like the beginning balance if you can reduce those calls in the first place by just giving that detail on the statement without overwhelming that would be good. I'm gonna go back to the default print statements by billing address zip code so if you're actually mailing them out maybe that's an easier way to do it so you could sort the statements but oftentimes you might be emailing statements at this point, print due date on transactions I think that would be typically useful so that's checked off do not create statements with zero balances normally you probably don't because if there's no outstanding balance but you could have statements for example that have an invoice and then like an amount going in and amount going out but they're not tied out or matched to each other so if that's the case then you could check this one off with a zero with a zero balance so with a balance less than zero so normally you shouldn't have a balance less than zero but if you might have something wrong with your accounts receivable so that we have some negative balances on there or something like that or some credits that are outstanding and possibly you don't wanna send a statement out to people that have negative balances or credit balances probably not an issue for most people because most of the time you don't have those but if you do then you could check that off and then you can apply with a balance less than you can make the balance if there's a smaller balance that you think is in material for you to basically be creating an invoice or creating a statement and you don't wanna then you can create a minimum balance other than zero with no account activity or for inactive customers so typically if a customer is inactive meaning there was activity for a customer in the past and then you've created them you've made them inactive for whatever reason they've fallen you've given up on collecting from that particular customer or something like that then you're gonna say inactive customers and that will typically be the default so I'm gonna close this out just to show you that inactive I'm gonna open up the carrot over here and if we go to the customer information if I go to the dropdown and all customers so these are all the customers and then you could see here we've got just the active customers versus the active customers and if you were to make a customer inactive if you were to say this particular customer is falling off the face of the hairs we're giving up on collection from this person what you would want to do first is write off to bad debt or whatever any balance that was outstanding once that was done you can then edit the customer and say they're gonna be customer is active or inactive so then you could change it you could change it to inactive down here so that won't show up on your general information list and but you could still see the inactive customers if you need to pull them up for basically prior period activity so once again to do that if they have any outstanding balances you would think that you would want to take care of that first if you've given up on collection you basically write it off to bad debt or whatever bring the balance down to zero make the customer then inactive so that when you generate reports and whatnot and then scroll through your stuff here you won't have those customers kind of cluttering up your activity so that's the general idea on the statements remember that if I go back here on the statements then we're looking to try to give our customers or collect on the accounts receivable so tool to try to help to collect on the accounts receivable and try to do that in as efficient a way as possible given the information as much as possible to the customers so that it'll lower or lessen the amount of questions that can come up with regards to the charges that are outstanding hopefully helping us to get to that end result back to the homepage of the customer section typically being a deposit into the checking account for goods and services provided to the customer.