How to do Bank reconciliation in QuickBooks Online, the traditional way?

QuickBooks Online
QuickBooks Desktop Payroll Update 2016
January 15, 2016
Recurring Transactions
How to I create a “Recurring Transactions” in QuickBooks Online.
March 8, 2016
Bank Reconciliation In QuickBooks Online

What is “Manual Reconciliation” and how to do?

QuickBooks Online allows both downloading transactions directly from Bank and entering transactions traditionally as you would.

When you use the feature of “Download transactions” from Bank and allocate it in QuickBooks, wherein no additional reconciliation is required.

As the below diagram shows (if Balances are matched, no more reconciliation required)

Bank reconciliation

But, for those who do not want to switch to this feature of “downloading transactions” and want to continue entering transactions the traditional way and do reconciliation,

QuickBooks Online does offer manual reconciliation.

The below screens will show how to extract the same:

Step 1: Select “Reconcile”

Bank Reconciliation QuickBooks

Step 2 :

Select your Bank and click “Reconcile”

Step 3 :

Enter Ending Balance, Statement Ending Date and Service charges and click “OK”

Step 4 : (as shown below)

QuickBooks Online Bank Reconciliation

1. This box displays summary of reconciliation.

2. Assign a check mark to hid transactions after the statement’s end date. i.e. if you have entered Statement Ending date as “July 31st 2015”, transactions after that date will not be listed.

This can be helpful if you are clearing previous months transactions, so as not to get full list of transactions.

Assign a check mark to the cheques / deposits which are cleared, matching with Bank Statement.

Step 5 :

Click “Finish Now” if your Books and Banks are reconciled.

You also have option of “Finish Later” if the balances are not matching and come back and start from where you have left.

Step 6: If your statements are matching you will get next option to view your “Reconciliation Report” (Shows as below)

Manual Bank Reconciliation QuickBooks Online

Step 7 :

If your statements are not matching and if you select “Finish Now”, QuickBooks will automatically “create adjustment for difference” transactions.

Other links for Bank Reconciliation

https://www.youtube.com/watch?v=MgF2nkWvKCQ
  • Workshop Review

    pop up review1

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Just Right

    pop up review2

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Just Right


    7. What did you like best or find most useful about the workshop?

    I enjoyed the hands on and the collaboration of the group. We each brought something different to the table that was helpful and made for a pleasant learning experience.

    pop up review3

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Just Right


    7. What did you like best or find most useful about the workshop?

    Hands on approach and discussion with other participants.

    pop up review4

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Above


    7. What did you like best or find most useful about the workshop?

    Our program director did a very good job keeping everyone engaged, ensured there was great interaction, sections of the material being covered did not continue until everyone was comfortable moving on.

    pop up review5

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Just Right


    7. What did you like best or find most useful about the workshop?

    I found Harsh to be very knowledgeable. His manner of teaching was very engaging. Although I have experience with QuickBooks I still was able to take away new skills and learn different features of the program that I was not using beforehand.

    pop up review6

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Above


    7. What did you like best or find most useful about the workshop?

    Harsh is an excellent Teacher. He made the workshop thoroughly enjoyable and very informative. I took away alot of information that will help me further my career. I recommend this workshop to anyone interested in Quickbooks.

    pop up review7

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Just Right


    7. What did you like best or find most useful about the workshop?

    Harsh effective way of teaching which keeps you attentive throughout 6 hours long session is incredible. He is very knowledgable person in Quickbooks.

    pop up review8

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Just Right


    7. What did you like best or find most useful about the workshop?

    I did the May 2018 Workshop. Harsh is a super teacher, the pace and material is just perfect. Absolutely spot on.

    pop up review9

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Just Right

    pop up review

    1. How would you rate the usefulness of the content?



    2. How would you rate the hands-on activities?



    3. How would you rate the presenter’s knowledge in the subject?



    4. How would you rate the presenter’s style of teaching?



    5. How would you rate the pace of the presentation?



    6. Was the workshop above or below your current skill level?

    Above

    pop up review

    1. How would you rate the usefulness of the content?



    2. How would you rate the hands-on activities?



    3. How would you rate the presenter’s knowledge in the subject?



    4. How would you rate the presenter’s style of teaching?



    5. How would you rate the pace of the presentation?



    6. Was the workshop above or below your current skill level?

    Above

    Pop up review

    1. How would you rate the usefulness of the content?



    2. How would you rate the hands-on activities?



    3. How would you rate the presenter’s knowledge in the subject?



    4. How would you rate the presenter’s style of teaching?



    5. How would you rate the pace of the presentation?



    6. Was the workshop above or below your current skill level?

    Above


    7. What did you like best or find most useful about the workshop?

    The most useful things were the practice of entering information ourselves and also learning about the full capabilities of Quickbooks.

    Pop up review

    1. How would you rate the usefulness of the content?



    2. How would you rate the hands-on activities?



    3. How would you rate the presenter’s knowledge in the subject?




    4. How would you rate the presenter’s style of teaching?



    5. How would you rate the pace of the presentation?



    6. Was the workshop above or below your current skill level?

    Above


  • Workshop Review

    pop up review1

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Just Right

    pop up review2

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Just Right


    7. What did you like best or find most useful about the workshop?

    I enjoyed the hands on and the collaboration of the group. We each brought something different to the table that was helpful and made for a pleasant learning experience.

    pop up review3

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Just Right


    7. What did you like best or find most useful about the workshop?

    Hands on approach and discussion with other participants.

    pop up review4

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Above


    7. What did you like best or find most useful about the workshop?

    Our program director did a very good job keeping everyone engaged, ensured there was great interaction, sections of the material being covered did not continue until everyone was comfortable moving on.

    pop up review5

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Just Right


    7. What did you like best or find most useful about the workshop?

    I found Harsh to be very knowledgeable. His manner of teaching was very engaging. Although I have experience with QuickBooks I still was able to take away new skills and learn different features of the program that I was not using beforehand.

    pop up review6

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Above


    7. What did you like best or find most useful about the workshop?

    Harsh is an excellent Teacher. He made the workshop thoroughly enjoyable and very informative. I took away alot of information that will help me further my career. I recommend this workshop to anyone interested in Quickbooks.

    pop up review7

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Just Right


    7. What did you like best or find most useful about the workshop?

    Harsh effective way of teaching which keeps you attentive throughout 6 hours long session is incredible. He is very knowledgable person in Quickbooks.

    pop up review8

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Just Right


    7. What did you like best or find most useful about the workshop?

    I did the May 2018 Workshop. Harsh is a super teacher, the pace and material is just perfect. Absolutely spot on.

    pop up review9

    1. How would you rate the usefulness of the content?


    2. How would you rate the hands-on activities?


    3. How would you rate the presenter’s knowledge in the subject?


    4. How would you rate the presenter’s style of teaching?


    5. How would you rate the pace of the presentation?


    6. Was the workshop above or below your current skill level?

    Just Right

    pop up review

    1. How would you rate the usefulness of the content?



    2. How would you rate the hands-on activities?



    3. How would you rate the presenter’s knowledge in the subject?



    4. How would you rate the presenter’s style of teaching?



    5. How would you rate the pace of the presentation?



    6. Was the workshop above or below your current skill level?

    Above

    pop up review

    1. How would you rate the usefulness of the content?



    2. How would you rate the hands-on activities?



    3. How would you rate the presenter’s knowledge in the subject?



    4. How would you rate the presenter’s style of teaching?



    5. How would you rate the pace of the presentation?



    6. Was the workshop above or below your current skill level?

    Above

    Pop up review

    1. How would you rate the usefulness of the content?



    2. How would you rate the hands-on activities?



    3. How would you rate the presenter’s knowledge in the subject?



    4. How would you rate the presenter’s style of teaching?



    5. How would you rate the pace of the presentation?



    6. Was the workshop above or below your current skill level?

    Above


    7. What did you like best or find most useful about the workshop?

    The most useful things were the practice of entering information ourselves and also learning about the full capabilities of Quickbooks.

    Pop up review

    1. How would you rate the usefulness of the content?



    2. How would you rate the hands-on activities?



    3. How would you rate the presenter’s knowledge in the subject?




    4. How would you rate the presenter’s style of teaching?



    5. How would you rate the pace of the presentation?



    6. Was the workshop above or below your current skill level?

    Above


  • Fintech-solutions