Multiple Currencies Purchase Equipment On Account Excel 1340

QuickBooks Online 2021 multiple currencies purchased equipment on account with the help and use of Excel. Let’s get into it within two it’s QuickBooks Online 2021. Here we are in our QuickBooks Online multiple currencies practice file in prior presentations, we set up the 30 day free trial. So we can practice with the multiple currencies, we turned on the multiple currencies, which can be found in the cog up top, then in the advanced settings.

 

00:27

Remember, once turned on, you can’t turn off the multiple currencies, we’re not going to be opening up our financial statements by going to the tab up top and doing some duplicating right clicking on that tab, duplicate that tab, we’re going to do that again, duplicate the duplication by right clicking on the tab and duplicating, we will now be opening up the balance sheet and the income statement otherwise known as the profit and loss, the P and L, we’re going to go down to the reports on the left hand side, let’s start off with the good old P and L report that profit and loss.

 

00:58

Let’s go back up top and we’re going to do a date range change from a one a one to zero to 1231 to zero, run it close in the hamburger holding down control scrolling up just a bit to get to that 125 go into the tab to the left back down to the reports on the left. This time the BLS balance sheet report, which has good information, despite the initials of BS, we’re going to then do the range change up top from a 101 to zero to 1231 to zero, run that report running, and then close up the hamburger.

 

01:34

And this is what we have thus far. So now we’re going to think about the purchase of machinery and equipments, we’re going to be purchasing machinery equipment, we’re going to be purchasing it on account, or in other words, kind of like financing the machinery and equipment, that means we’re gonna have to put it on the books in terms of once again, the US dollar equivalent, even though we’re gonna promise to pay in the future in some currency other than the US dollars, which is our home currency. So let’s think about this first, and Excel will think about it in a transparent way. And then we’ll come back in here and we’ll enter that into the QuickBooks system.

 

02:07

So the scenario is going to be basically on the right here. So we’re looking at this item. So this item, let’s make it green. So that’s the one we’re working on the green one. So we’re saying a US company enters into a contract to purchase machinery from a Japanese company, the cost is going to be 400,000 yen, the machinery is delivered on 830. So we’re gonna record this on our books, then we’re promised we’re going to purchase the equipment, but we’re going to pay in games we’re promising to pay in the future, not in US dollars. But in yen for the purchase of the equipment. Now on seven one, there is a contract to purchase.

 

02:45

That’s great to put from a financial statement perspective, we don’t have the equipment, we haven’t made a payment, we’ve kind of we’ve kind of got a contract, but there’s no real financial transaction at that point. The equipment then is delivered, we’re saying on 830. So that’s the point in time that we actually have the equipment we have not yet paid for it at that point in time. So that’s when we’re going to put it on the books for so 830 we’re putting it on the books, standard kind of transaction, when we put equipment on the books, if we were to purchase it on account would be to debit the equipment and credit some kind of liability,

 

03:16

such as a loan payable or something like that, if we financed it, so I’m going to be debiting the machinery that’s pretty standard, the credit, then we’re not paying cash, we’re gonna pay, you know, in the future. So that would typically if it was a normal kind of like inventory that we’re going to pay in 30 days or something, we might put it to the accounts payable. And if it was in foreign currency, we might have an accounts payable in the foreign currency. Now note, if it’s machinery, we might think of it more as like a financing type of thing, we might think of it more as like a loan rather than a short term accounts payable.

 

03:49

And it’s interesting to note that because oftentimes, like in the desktop version of QuickBooks, just logistically, when we set up like a foreign currency type of account, we typically need to do it with an accounts payable account. But in the in the quickbooks online version, it looks like you You can basically use a loan account. So let’s just look at that logistically just so we can kind of see the difference over here. If I go back to the first tab, and we go down to the accounting down below.

 

04:20

I’m going to hold CTRL and scroll down just a little bit. Now normally, if I hit the new accounts, let’s just imagine we’re going to make a new account up top the bank account. As you can see, if I was to make basically a new bank account, I have the currency field here. So I can make a bank account in basically different currencies. If I go then to the accounts receivable, it’s kind of funny because we don’t have that currency thing here. But we can still kind of use the foreign currency account not with the fact that we are assigning it to a foreign currency.

 

04:49

But when we when we allocate a customer to it, QuickBooks will basically make an account that’s locked into kind of the foreign currency related to the customer. Now, we’re On the accounts payable side of things, so if I think about accounts payable, same kind of thing, we don’t have a choice to pick a currency here. But when we pick the vendor and assign the vendor to a currency, and then record that with a transaction bill, for example, then the accounts payable related to it will be assigned to that to that currency, QuickBooks will basically assign an account.

 

05:20

Now normally, if I if I went down, that’s a little bit by the way different than the desktop version, which does have a currency that you would typically assigned to the accounts payable and the accounts receivable I believe. And then, if I go to to like another account, like three, I went to like an expense account down here, there’s no expense account, currency allocation for like many of the other types of accounts, the main ones we’re thinking of, is cash, because these deal with cash, right cash in a foreign currency, accounts receivable and accounts payable that will be received or paid in foreign currency.

 

05:52

But then the loan payable is a little bit a little strange to if I went down here to say, long term liability or current liabilities, and I set up it as a loan. And the loan the difference, of course, being with a loan is typically that you have a longer term thing that you’re going to be paying principal and interest on setting it up as a loan as opposed to accounts payable, which would be more of a short term type of thing. So if we’re financing equipment over a long period of time, and paying interest on it, we might then set it up, for example, as a loan, and that does have the capacity here to then assign an account to it a currency type of account.

 

06:29

If I went to the long term liability, instead of like a loan, it does have the capacity here. So in other words, then if we’re purchasing the equipment, if it’s a short term purchase, we might just put it to accounts payable, foreign currency accounts payable. But in QuickBooks, it looks like we do have the option to have like, long term financing a loan, a loan account, rather than accounts payable be set up. So let’s go ahead and just practice that since that’s a little bit different. I’m going to say this is a this is accounts payable, let’s let’s just call it just for names sake, a loan payable, loan payable.

 

07:04

And we’ll just use a different type of account via similar kind of process and kind of a payable account, but we’ll call it loan payable in foreign currency, then the amount that we’re going to be calculating, let’s pull out the trust account, we’re going to be picking up the 400,000 yen. And again, these exchange rates are just made up exchange rates, they may not be anywhere near correct. So we’re 400,000. And we’re going to say that we’re going to pick this date, because this is the spot rate that we actually got the got the inventory, even though we haven’t yet paid for it at that point. And once again, we expect to pay for it in the future.

 

07:37

So you might say, hey, look, why am I using the spot rate? Now? Why don’t I use like a projected what I think it’s going to be when I get paid. And again, the idea here is that we’re going to use the spot the negotiation happened with the current rate, even though we’re not paying right now. And then we’ll make an adjustment for it when we actually pay it in the future for the difference between the exchange rates. So we’re going to take the 400,000 times the current spot rate, which is point 104, meaning for every one yen you can purchase point 104 dollars.

 

08:07

Again, I’m not sure how accurate that is, you know, in terms of current rates, but for practice problems, you get the idea. So that’s going to be the 41,600 in US dollars. So let’s go ahead and do that. Again, I’m going to say this is going to be equal to the 400,000 yen, times the point 104, there is the debit and the credit. So the machinery then if I post this out is going to be going on the books for 41,600. That then is not what we’re paying, we were going to pay in the future 400,000 foreign currency yen,

 

08:42

but the current equivalent value is going to be the 41,600 as of the point in time that we basically got the equipment or made the deal, even though we’re going to be paying for it at some point in the future in the foreign currency. And when we do, there’s going to be a different type of exchange rate. So bottom line is we have to record our books with the measuring tool of cash even though we’re paying in in yen, in this case, another foreign currency. So then the loan payable is going to go down here same kind of thing. I’m going to say this is the loan payable.

 

09:16

Now note that this says right here it’s loan payable in yen, loan payable and yen. So you might think well, that means that this 41,600 means we’re going to pay 41,600 yen because that’s what the name of the account is right? It’s in yen, but no, that means we’re going to be paying in yen, and that the obligation is in yen, but this is in terms of the US equivalent of the yen that we will be paying which is 400,000 yen, which in US equivalent dollars as of the point in time that we make the transaction is 41,600.

 

09:47

Obviously when we pay it at some future point, then the exchange rate will differ and we’ll have to have a gain or loss related to the exchange rate at that point in time. Once that happens. We don’t adjust the The machinery Generally, we keep the cost at what the cost is, even though the there’s a difference in the exchange value, when we actually pay it will then record the difference to basically a gain or loss down here in terms of the gain or loss on the exchange. So there it is here, we’re gonna next time we’ll do this in QuickBooks.

 

10:18

So we’re gonna move on over to QuickBooks next time. And and obviously, when we set this up, then it’s a fairly straightforward type of transaction, but we need to set up an account that’s going to be that’s going to be used. And again, our choices when we set up a new account, as to a liability account would be to use the accounts payable account. And if using that we would have signed the vendor that would be driving the accounts payable in the foreign currency or we can take a look at assigning it as a loan payable account and then sign assign the currency account down here. So we will take a look at that more next time.

QuickBooks 2018

Excel Vs QuickBooks – Set Up New Company

We will travel through the journey of setting up a new company file in Excel and QuickBooks, comparing and contrasting the process in both.

These presentations will work a comprehensive bookkeeping problem, both within Excel and Quickbooks, Excel having the advantage of being more transparent, allowing us to see all the components of the process; QuickBooks having the advantage of being able to use forms and simple data input to quickly and easily generate the end product, the financial statements.

We will work each component of the problem in Excel first and show how the same process can be done in QuickBooks.

First, we will set up a new worksheet in Excel and compare that to the setup process of a new company file in QuickBooks. When setting up a new company file in QuickBooks one of the first things QuickBooks generates is a chart of accounts like the one below. The chart of account is the first thing we will set up in Excel.

QuickBooks 2018

Note that the setup process in QuickBooks generally involves a shortcut, QuickBooks generating a chart of accounts based on the industry we select. The chart of accounts is not perfect but is often a good starting point.

For more information about QuickBooks take a look at our comprehensive course. Get more information by clicking the image below.

QuickBooks Pro 2018

Note that the chart of accounts is not ordered by alphabetical order but by account type. On a general level, the order of accounts will always be asset type account, liability type accounts, equity-type accounts, income type accounts, and then expense type accounts. Each account type will have more subcategories. For example, assets will be broken down into cash type accounts, accounts receivable type accounts, current assets, and other assets.

We will need a similar ordering when entering our chart of accounts into Excel. Below is an example of a chart of accounts generating in Excel. We have listed half the accounts on the left followed by half the account on the right to save space.

QuickBooks 2018

Note the same ordering of the accounts, assets first in green, followed by liabilities in orange, then equity in light blue, and revenue followed by expenses in navy blue.

This chart account is the starting point for entering data into our Excel worksheet. We have also set up a general journal and a general ledger.

Below is an example of the general journal.

QuickBooks 2018

The general journal will just be an area for us to enter our journal entries, journal entries that include date, accounts, and debits and credits.

Below is an example of the general ledger.

QuickBooks 2018

The general ledger can be intimidating because of its length, but it is just another list of accounts, the same list as the chart of accounts, in the same order of assets, liabilities, equity, income, and expense. The difference is that the general ledger will provide more detail, provide the activity in order by date of the transaction.

Next, we will take a quick look at the setup process for a new QuickBooks file.

QuickBooks 2018

First, we will run the QuickBooks software.

We will then select the file dropdown and new company.

QuickBooks has a few options for setting up a new company. We will chose the start Setup option.

QuickBooks 2018

Next, we enter company data.

QuickBooks 2018

Note that we have chosen the industry of retail shop or online commerce. QuickBooks will use this information to provide us with the chart of accounts, QuickBooks guessing which accounts will be needed based on our industry.

The startup process above is all we need to do for QuickBooks to set up a basic chart of accounts and get up and running.

QuickBooks 2018

For more information about QuickBooks take a look at our comprehensive course. More detail at the link below. Click the image for more information.

QuickBooks Pro 2018

QuickBooks Bank Reconciliation – How to Enter First Bank Reconciliation

 

QuickBooks 2018

QuickBooks Bank Reconciliation – How to Enter First Bank Reconciliation

Learn how to complete the first bank reconciliation for a new company in QuickBooks.

Entering a bank reconciliation into QuickBooks takes time to learn, and the first bank reconciliation often includes added difficulties.

We will show a real-life example providing a bank statement, QuickBooks data, and the bank reconciliation process.

If you would like a to follow along with a demonstration, we will be creating a QuickBooks 2018 course and providing backup files which can be used to practice and follow along step by step soon. Click Here

Reconciling the bank accounts is one of the most important things that we have to do to make sure our data is entered correctly into the accounting software.

If we complete the bank reconciliation, then we have good assurance that the information input into the system is correct. Bank reconciliations do not mean, however, there are no errors, but they do give good assurance that the data has been input.

First we will look at the balance sheet cash account as of the end of the month we are reconciling.

To open the balance sheet, we go to the reports dropdown, Company and Financial, and then Balance Sheet Standard.

QuickBooks 2018

We will change the dates to 01/31/2021 because we will be entering the first month of data as of January 31, 2021 for this problem.

QuickBooks 2018

We will compare this number with our QuickBooks data, on our balance sheet, to the bank statement. We would assume that if we input everything perfectly the book balance of $94,436.17 would match what is on the bank statement.

The book balance will never match the bank balance, however, even if we are talking about the same date, the date in this case of January 31, 2021. The reason is due to timing differences.

An example of a timing difference is a person writing a rent check today and giving it to their office building owner. If we wrote a check, we know the money has been spent, but the bank does not yet know. The bank will not know until the building owner deposits the check into their bank and their bank notifies our bank. This difference in information due to the time it takes for a check to process is what requires us to reconcile the bank accounts.

If we received our bank statement after having written a check two days prior, we would not be surprised that the check does not appear on the bank statement, but we would also recognize that the money is still essentially spent and gone.

If we can find every timing difference and can identify the exact transaction which are causing the differences between the bank balance and our balance we have also verified all the other transactions, all the transaction that are on both the bank statement and on our QuickBooks data, and by doing this we have a third party verification that all those transactions are correct. The bank is a very credible third party to verify all of our transactions.

Next, we will look at an example of a bank statement, the second document we are looking to reconcile to our QuickBooks data.

QuickBooks 2018

The bank statement will generally have a summary of the month, starting with the beginning balance, adding deposits, and subtracting checks and other decreases to arrive at the ending balance. It is important to note that the beginning balance on the bank statement will equal the prior bank statements ending balance.

Because the this is the first month of operation, we have entered the beginning balance shown on this banks statement of $25,000 into the opening balance of the checking account in QuickBooks. Entering the beginning balance for the first bank reconciliation is often a problem when we attempt the first bank reconciliation. We will talk about this more later, which will be great.

The ending balance is $109,415 on the bank statement. This $109,415 is the amount we need to reconcile with our book balance. We will make any adjustments necessary and reduce the differences to just timing differences, to just outstanding checks and outstanding deposits that we can verify and identify.

The bank statement then shows the detail of deposits, checks, and other decreases. The bank statement activity is what we will compare to our QuickBooks Data, checking off each item. The deposits will have to be verified by amount. The checks have an added level of verification in that we can check the amount and the check number. The dates on the bank statement will never match what we have on the QuickBooks data because of the timing differences; the bank statement dates always being later.

The example bank statement has two non-check decreases of withdrawal and bank service charges. These are items on the bank statement, which are most likely not entered into QuickBooks. Items on the bank statement that are not in our QuickBooks data are items we will have to enter into the QuickBooks data.

We will now open the bank reconciliation tool in QuickBooks by going to the Banking dropdown and selecting Reconcile.

QuickBooks 2018

We will reconcile for the month ended January 31, 2021. This is the first month of operation for our business.

QuickBooks 2018

The beginning balance will populate automatically, and the QuickBooks data is from us entering the opening balance into the checking account when we created the checking account in QuickBooks.

If we did not enter the beginning balance when setting up the company, there is a work around for the first month. We can enter zero as the beginning balance, enter the beginning balance into the register as of a date prior to the date we start recording operations, and then check of the begging balance amount as part of our reconciliation process.

The beginning balance is one to the tricky parts when entering the first bank reconciliation but will be much easier as we move forward to future bank reconciliations.

We then enter the ending balance from the bank statement of $109,415.

QuickBooks 2018

QuickBooks then provides the opportunity to enter service charges and interest earned, options that can save time, but which can also cause confusion. I recommend not using these options when we are starting out. We will enter these adjustments into the bank register once identified and then locate them on the bank reconciliation.

 

QuickBooks 2018

Once we continue to the bank reconciliation we will see a screen like the one above. This screen is where the magic happens.

The left side shows the checks and payments and is generally the longer of the two sides, unfortunately, ☹.

The checks and payment include the date of deposit into the QuickBooks system, the check number, the vendor, and the amount. The check number and amount are the most relevant items to match up with the bank statement. Remember that the date will differ due to timing differences, the bank dates always being later. The check numbers and amounts should match exactly.

QuickBooks 2018

On the deposit side, we only have date and amount which we can use to match up with the bank statement. Because there are fewer deposits, they should be easier to match up. QuickBooks should have grouped the deposits in the same format as they appear on the bank statement.

QuickBooks 2018

At the bottom right, we see our reconciliation tool. Once the difference number is down to zero the reconciliation process is complete, meaning the difference between the bank statement balance and QuickBooks data balance has been identified and reconciled.

The current QuickBooks data is showing that $25,000 has cleared, this being our cleared balance. The $25,000 has not cleared this month, the month of January, but has cleared the bank in prior months.

Once we check all item off that are on the bank statement we will increase the $25,000 cleared balance to match the balance on the bank statement and the difference will go down to zero. The unchecked items will represent items in the QuickBooks data not reported on the bank statement, the unchecked items representing the outstanding items, the timing differences.

 

 

QuickBooks 2018

Once we have the bank statement and QuickBooks data set up, we will go through the enjoyable task to checking of amounts that are on both the bank statement and the book, going from the bank statement to the QuickBooks data.

We generally start the checking off process with the checks and decreases. We can match up the check number and check amount on both the bank statement and QuickBooks data. Once we match up an amount, we will highlight the bank statement and put a check next to the QuickBooks data.

Note that the dates above are not the same between the bank statement and the QuickBooks data.

QuickBooks 2018

Once we complete the process of checking off all decreases on both the bank statement and in the QuickBooks data we see there are a few checks written in the QuickBooks data in the month of January that are not on the bank statement. These unchecked amounts are the outstanding checks and will make up the difference in the bank reconciliation.

We also see that there are two non-check items on the bank statement that are not on the QuickBooks data. These are items we will have to fix, items we will have to add to the QuickBooks data to reconcile and for our QuickBooks data to be correct.

If we are concerned with these outstanding items, we can contact the bank to see if those items had cleared in the following month, in the month of February in this case. If they have cleared in the following month then we know it is just a timing difference, a difference w is OK with, but one we will document in the bank reconciliation, as we will see.

Next, we will reconcile the deposit side.

QuickBooks 2018

The first deposit that is on both the bank statement and the QuickBooks data is the deposit of $50,000. We will check this amount off in the bank reconciliation and highlight the amount on the bank statement. Note that we do not have much information to help us with the deposit, lacking the check numbers, but the deposits are usually fewer in number so are not usually difficult to match up.

If we do not record the deposits in QuickBooks in the same format as they are recorded in the banks, however, reconciling the deposits becomes more difficult. For example, if we record each individual deposit into the QuickBooks but deposit them in batches to the bank we will have to add up the individual deposits in the QuickBooks data to match the bank deposits. We discuss how QuickBooks makes sure the batches match up in the QuickBooks course.

QuickBooks 2018

Once we check off all deposits on the banks statement and in the QuickBooks data, we see that we have found all deposits on the bank statement in the QuickBooks data but have on deposit in the QuickBooks data entered in January not included in the bank balance.

This one deposit is the outstanding deposit and will be the timing difference we will recognize on the bank reconciliation.

If we are concerned about this deposit, we can call the bank to see if it has cleared the bank in the following month, in the month of February for our example.

QuickBooks 2018

Once we have checked off all check, decreases, and deposits, we see QuickBooks indicating that we are still out of balance by $95. This $95 difference is not the timing differences, not the outstanding checks and deposits. The $95 represents items on the bank statement we have not checked off on the QuickBooks data.

In our example the $95 represents withdrawals and bank service charges, amounts that have been recorded by the bank but have not been recorded into QuickBooks, amounts which we must therefore, record into QuickBooks.

To enter the $95, we will select leave the bank reconciliation. Don’t worry the data will not be deleted. We will open the check register by selecting the Baking dropdown and Use Register.

QuickBooks 2018

We will then enter the data as of the end of the month. First, we will enter the $80 withdraw. We will enter the date of 1/31/21.

We want to make sure and not use a check number because this is not a check. I usually put something like the work other into the check number section as a placeholder.

We do not know the name of the vendor in this case because it was a draw. Therefore, we will leave this blank.

QuickBooks 2018

We then need another account to record the draw, and this is often a problem. In our example, we may not know why the $80 was drawn out of the business. If it was drawn out for personal use, we should use an equity account like draws or capital so that the amount is not reflected on the income statement and does not lower net income. If the draw was for a business use, we should use some kind of expense accounts.

Since we do not know the use of the $80 we will use an account called Misc. Expense, every auditor’s favorite account 😊.

Make sure we have select enter, or it will not yet have been recorded. Once we select enter QuickBooks will order the transaction by date, so it may disappear, but we can find it by date.

If we then go back to the bank reconciliation the $80 will magically appear with the check number other, and we can now check it off on the QuickBooks side and highlight the bank statement side reducing our reconciling balance to only $15, the amount of the bank service charges.

QuickBooks 2018

That $15 difference is on the bank statement as a banks service charge and is the next amount we will record into the check register.

QuickBooks 2018

We will go back to the check register in QuickBooks using the open windows.

We will enter the service charges as of January 1, 2021. We could enter the bank as the name, but we will keep it blank here. We then enter the amount of $15 and choose the account of Bank Service Charges.

When setting up QuickBooks for most industries, QuickBooks generally adds an account called Bank Services Charges to our chart of accounts. If the account has not been set up then we can set the account up.

QuickBooks 2018

Remember to select enter to complete the transaction.

We will then return to the bank reconciliation from the open windows, where we will see the $15 in the checks and payments section.

After checking off this last item, QuickBooks will indicate that we are in balance by showing a zero in the differences section.

QuickBooks 2018

The zero in the differences item indicates that we can no select reconcile so that QuickBooks can complete the process.

Before we continue note that this problem is more simplified than some reconciliation can be because we did not have any outstanding check from the prior month. If is often the case that a company will have outstanding checks, written in the prior month that had not yet cleared the bank in the prior month and which are clearing the bank this month.

If we do have outstanding checks for a prior month, checks that are represented on the bank statement at the beginning of the month but which are not represented in our QuickBooks data we can go back the register and enter the checks. Make sure to enter then as of the prior month, however, so they do not distort our current data.

QuickBooks 2018

Once we have completed the bank reconciliation and there is a zero in the difference section, we can select Reconcile Now so that QuickBooks can complete the process and generate the bank reconciliation.

If we do not have a zero in the Difference section and we select Reconcile Now QuickBooks will give us a message saying that we are not reconciled. We can tell QuickBooks to force the process and reconcile anyway, and QuickBooks will enter and adjusting journal entry

I highly, highly, highly recommend not forcing QuickBooks to reconcile even if the difference is small because it greatly reduces the value of the reconciliation process. Even when the difference is small, it could represent a lot of data not input into the system. For example, a difference of $.02 could be caused by a deposit of $100,000 and a check of $100,000.02, this being an extreme example, but one that shows that any difference reduces the value of the process, and the bank reconciliation process has a lot of value.

QuickBooks 2018

Once we select Reconcile Now QuickBooks will provide the screen above, asking us to choose a summary, detail, or both, type of report. We do want to print these reports or save them as a PDF because we cannot always go back to them.

I recommend saving the detailed version of the bank reconciliation because it will show us which checks, and deposits are outstanding. The summary version is also useful to show people who do not need to see all the detail.

QuickBooks 2018

Above is an example of QuickBooks Reconciliation Summary report. The main part of the report we are concerned with, the actual bank reconciliation, starts at the cleared balance of $109,415, this amount matching the amount on the bank reconciliation, the amount representing the bank balance.

The cleared balance is followed by uncleared items including uncleared checks and deposits. The uncleared checks and deposits are the outstanding amounts, amounts we input into the QuickBooks system, but which have not yet cleared the bank.

Next, we see the Register Balance of $94,341.17, representing the QuickBooks data balance as of January 31, 2021, meaning that this is the amount we will see on the check register as of January 31, 2021, and this is the amount we will see on a Balance sheet run as of January 31, 2021

The data above the cleared balance shows the beginning balance of $25,000, this being the beginning bank balance and the cleared checks and deposits, the checks and deposits on both the bank statement and the QuickBooks data.

The data after the Register Balance shows current transactions, those made after January 31, 2021

Next we have the detailed report.

QuickBooks 2018

The top portion of the detailed Reconciliation report shows the beginning balance of $25,000 and lists out the amounts that cleared, the amounts on both the bank statement and the QuickBooks data. The cleared data is not as important to us as the uncleared data, the cleared data having been recorded by both the bank and ourselves, the uncleared data not yet having been verified by a third party, by the bank.

QuickBooks 2018

The portion of the Reconciliation Detail report above is the portion we really want, the portion we would can the bank reconciliation. The portion of the Reconciliation Detail report above shows the beginning cleared balance, the bank balance, as did the summary, but now shows the detail of the outstanding items. The Reconciliation detail report shows a list of the checks and deposits that have not cleared, a list of the item in QuickBooks data but not on the bank reconciliation. This list of outstanding items is what we really want.

If this information has been helpful take a look at our QuickBooks 2018 course soon. Click Here