 QuickBooks Desktop 2023. Banking Reports. Let's do it within 2-8 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 Raw Castle construction practice file provided by QuickBooks going through the setup process we do every time maximizing the home page. Going to the view drop-down noting we got the hide icon bar and open windows list checked off open windows open on the left. We're going to go to the reports drop-down company and financial the P&L the income statement the profit loss to the change into the ranging from 010124-123124 and then customize it poor five or fonts and numbers change the font on up to 12 bring it on up yes okay and then reports drop-down again company and financial again balance sheet different this time balance sheet and then we're going to go to the drop-down we're looking for the fiscal year 123124 customized the fonts and the numbers to change it to 12 and then okay and then we'll say yes and then okay that's the set of process we do every time you did that really fast yeah because we do it every that's our setup process we do every time we got the major balance sheet and income statement those primary financial statement reports all other reports typically giving more information on one or multiple line items of these major two financial statement reports we're going to be looking at reports in the banking section of the report center this time them primarily giving more information about the balance sheet accounts of the cash accounts however just remember when we're looking at the cash accounts because cash is the lifeblood of the company we often might be looking at the cash accounts to look at other cycles and other account details as well for example if I go back to the home page over here you can see that we have the vendor cycle the customer cycle the employee cycle the vendor cycle represents us paying at the end of the day no matter what that cycle is at some point the money is typically going to be going out which of course will impact cash in order to buy goods and services that we're going to use for the company the customer cycle at the end of the cycle will represent hopefully money coming into the company deposits to the checking account for goods and services that we are providing to customers the employee cycle is kind of like a specialized vendor cycle money at the end of the process going out for services that we're buying for in essence the employees so if I go into the balance sheet here you can see that the cash account if I double click on it by the fact that all these different types of transactions are going through the cash account that it's critically important in us being able to understand all the other cycles because every transaction we have here has another side given the double entry accounting system to other some other component in the cycle all other accounts are much more restrictive they're not going to have as much activity in terms of the types of transactions so if we look at the detail in the checking account that's one of the major places we will go to check on not just the checking account but other areas within the cycle depending on how they relate to the checking account and it's also something that if we can reconcile if we can understand if we can be confident about the transactions in the checking account we can be confident not only about the ending balance in the checking account but in this in the other transactions as well that are taking place in the in this the other cycles so if I close this back out let's go into the reports we got the reports down here in the banking section we can do it this way deposit detail check detail missing checks reconciliation and previous reconciliation or we can go into the report center which will do now let's go into the report center maximize it and then we're going into the banking section let's just review these reports and then we'll go into them in more detail we got the deposit detail deposits as you recall are the forms typically used to increase the checking account we could get to a report similar to this by simply running a jail account or transaction detail report and filtering by deposits for example the check detail this represents the things that are decreasing the checking account clearly you can run a similar report possibly by making a general ledger account or transaction detail report and filtering by the decreases to the checking account the checks the missing checks represents an internal control type of report to see if we have check numbers that are duplicated or missing for example the reconciliation discrepancy report shows us problems or differences within our reconciliation when we tie out to the bank to understand that better we can think about the previous reconciliation report now the bank reconciliation is a critical internal control but it's a little bit different from a report standpoint to other reports this is really not like a financial reporting report it's an internal control reporting report and the general idea would be that we're going to enter transactions into the checking account on our side the bank is going to enter the transactions related to our checking account on their side increases and decreases of the checking account we will then reconcile our accounts to the bank account and in so doing we'll be able to have an outside third party check about the transactions that's a really huge internal control because if we go to the balance sheet you might say well yeah that's great it gives us a verification that my checking account ties out it does that but we can figure that out by just go into the bank and looking at the ending balance and getting an idea of it at least it also gives us information that all the information that we entered into the checking account is valid why does that matter if I know the ending balance is valid it matters because all of this detail is tied to all the other sides of the cycle because cash is related to everything else so if I go to the homepage if I can verify that all the transactions that went into the checking account are valid then that gives me a lot more validation about you know transactions that that are related to the checking account so the sales types of transactions that result in us depositing money into the checking account are going to be something more verified for us the payments that we made on the vendor side are going to be a more verified for us so it's a huge internal control to do the bank reconciliation but it's not the kind of report that's generated as we do the data input meaning when I enter a bill when I enter an invoice or receive payment these forms are usually the things that create the balance sheet the income statement and the subsidiary reports like the subsidiary ledger report for the accounts receivable aging report the accounts payable aging report these forms do not create the reconciliation the reconciliation is something we have to do separate to kind of check our numbers to the bank also just realize that if you're using the bank feeds to create the data input you're waiting until something clears the bank for the deposits for example before you enter them into the system then you do not have two separate systems meaning it's not like we enter the data into our system and then the bank entered it and we're reconciling the two in that case we're just taking the bank's data and building our financial statements from it the bank reconciliation still important in that sense because you can check to see if you missed transactions or if you double entered transactions but it's not as big an internal control as it would be if you entered the data yourself on your side with the sales receipts the invoices and then depositing separate from the bank and then reconciled to the bank and you could use the bank feeds in that process as well so there's kind of a difference we'll talk a lot more about that when we do the bank reconciliation section when we actually talk about how to put together a bank reconciliation for now just note the bank reconciliation really important but it's a little bit different of a kind of or type of report than the other reports let's look at the deposit detail report let's run that report and so there we have it let's run it from 010124 to 123124 now this is the activity that would generally be increasing the checking account so we're kind of filtering on those items that are increasing the checking account here you could run kind of a similar report you would think by going to the balance sheet for example you could say well what if I double click on say the checking account and then I try to filter by type over here by the increases by the deposit forms so you could say okay I'm going to customize the report up top you could try to filter by type on this side transaction type and then we're going to go down to simply the deposit forms and then okay so we got a similar kind of process we can kind of use that filtering field might give you a little bit different kind of data when you look at it this way but just to just to get a sense or a feel of what's happening here we're looking at the deposits of course the increases so these are the deposits they give you a little bit more detail on this okay so let's close that out and say now let's go to the report center and we've got the check detail opening that up the check is not only the form that you would use when you write a physical check but the check form is usually the form or is the form that QuickBooks sees as the thing that decreases the checking account let's customize this let's go to the fonts and numbers and increase the size to like 12 or let's make it 11 so notice it has normal checks here but it also has the types of forms which are the bill checks so that's a special check that decreases as we saw in prior presentations when we go into accounts payable and then pay off the accounts payable so they're putting all checks the decreases to the checking account here here's a liability check which might be the payroll liabilities that are being paid off so we're using a special widget in order to use that particular check form still simply a decrease of the checking account but giving us a bit more information about it here's a paycheck form so this was processed with the paycheck clearly again it's the decrease of the checking account but giving us more detail now you could run a similar report notice they're giving you a lot of detail in this report so but you can run a similar kind of report in general go into the balance sheet double click the checking account and try to sort for all the check type forms here that are that would be a decrease to the checking account for example customize we can go to the filters and we can go to the transaction detail or transaction type the check would be deep what we need multiple multiple transactions we got a check form sales receipt payment we've got the credit memo the bill the bill credit bill payment a bill payment there's one bill credit card sales tax payment purchase order inventory paycheck liability check so everything with a check here we're looking for generally sales order so something like that and we can run that report let's make it a little bit larger on the font bring it on up to 11 let's say and so now now you have you have kind of a similar report giving you the splits on the other side of the account here this split doesn't give you as much detail in this one line because if there's multiple accounts affected like a paycheck then it only shows you the other account that's why the check detail report gives you a bit more detail on something like a payroll check so that could be quite nice so you can see the difference between the two but in general you kind of see what what is happening here these are all the things that are decreasing the checking account and you could just simply filter the detail in the checking account to see a similar kind of format of report okay so let's go back on over let's close that back out and let's let's go back to the report center we've got the missing checks now I'll just give you the the little info here to read the missing checks for a specific account list all checks that have been written so you can check where to go so you so you missing so you can check for duplicate and missing numbers so remember that the checks if you actually you know write the physical checks then you're still going to need the checks that have a pre-number on it because that's an internal control and you could check to see if the numbers are duplicated or if you're missing numbers type of report and then we talked about the reconciliation report which will go into a lot more detail later but if we're comparing our books to the to the books for the bank we go through a bank reconciliation process and if we force the bank reconciliation to work meaning if there's a discrepancy from the bank to our books and and we just force it to work we say okay quick books reconcile anyways quick books will then make make an adjustment for us in order to reconcile if we do that it decreases the value of the reconciliation a lot as an internal control which we'll talk more about later but it's nice to be able to track you know the discrepancies that possibly have been entered in that way as well so again bank reconciliation special report very important internal control report however different therefore than the other normal financial statements supporting subsidiary ledger type of reports we'll get into that a lot more in the practice problem when we actually create a bank reconciliation