Intelligent Business Services
Intelligent Business Services
  • 23
  • 180 176
QuickBooks Online - How to Reinstate Accounts Receivable NSF or Stop Payment Cheque (Check)
This is a brief tutorial to show you how to reinstate an invoice in accounts receivable due to non sufficient funds or a stop payment.
See my next video for an alternative method of doing this.
Переглядів: 639

Відео

How to Add Bank Feed Rules in QuickBooks Online
Переглядів 456 років тому
Adding bank feed rules is a great way to speed up adding repetitive entries in QuickBooks Online. This is a short video on when and how to use these rules.
QuickBooks Online - How to Correct Online Banking Match Errors
Переглядів 6 тис.6 років тому
This is a brief video that shows how to unmatch an incorrectly matched transaction from the credit card feed, and how to match it to the correct transaction.
Depositing Accounts Receivable and Misc. Checks Together
Переглядів 3926 років тому
This is a video showing how to deposit both accounts receivable checks and miscellaneous checks in one bank deposit in QuickBooks Online. First the accounts receivable invoices are paid by cheque under the Undeposited Funds account. Next the Bank Deposit is selected and the accounts receivable checks are ticked off. Finally we add the miscellaneous check to the bank deposit.
How to Change the Date format in QuickBooks Online
Переглядів 2,8 тис.7 років тому
How to Change the Date format in QuickBooks Online
How to Change Invoice Numbering Sequence in QBO
Переглядів 28 тис.7 років тому
In this scenario, we are changing accounting systems to QuickBooks Online. We want the invoice numbering sequence to follow the old accounting systems. This video will show you how to accomplish this.
How to Reimburse Expenses Incurred by the Company Owner
Переглядів 20 тис.7 років тому
This is a tutorial on how to keep track of expenses paid by the owner on behalf of his or her company and the subsequent reimbursement to the owner by cheque. A credit card type chart of account is setup and named Owed to Owner or Owed to Shareholder. The account is used to input the expenses paid by the owner and to record the reimbursement cheque to the owner. It is a type of clearing account...
How to Record Owner's Equity Draws in QuickBooks Online
Переглядів 21 тис.7 років тому
This tutorial will show you how to record an owner's equity draw in QuickBooks Online. If you have any questions, please feel free to ask.
QuickBooks Online Bank Reconciliation
Переглядів 1 тис.7 років тому
A tutorial on how to reconcile your bank account in QuickBooks Online. If you have any questions, feel free to ask.
Bad Debt Expense Write Off
Переглядів 4267 років тому
A tutorial on how to write off a customer invoice using the direct write off method in QuickBooks Online. In another tutorial I'll show you the allowance for doubtful accounts method. I would be happy to answer any questions you have.
Refunding a Customer for an Overpayment in QuickBooks Online
Переглядів 24 тис.7 років тому
Refunding a customer for an overpayment doesn't happen very often, as normally they would just deduct it from their next payment. This video shows one way to reimburse the customer.
Recording Prepaid Expenses in QBO
Переглядів 13 тис.7 років тому
If you have any questions, feel free to ask.
How to Correctly Use Undeposited Funds
Переглядів 5327 років тому
QuickBooks Online tutorial on when and how to use the "Undeposited Funds" Account. This account is a clearing account only, and at the end of each month it should always balance to zero. It's used only when you are physically depositing many cheques and/or cash into your bank account on one day. After the cheques and cash have been physically deposited, the next step is to deposit all of the in...
IBS Trailer
Переглядів 4127 років тому
About Intelligent Business Services This is an educational channel for QuickBooks Online, Bookkeeping and Excel. If you have enjoyed my videos, please subscribe.
QuickBooks Online - How to Record Customer Deposits or Retainers
Переглядів 8 тис.7 років тому
A step-by-step video on how to record and bill for customer deposits or retainers paid in advance of shipping or a service that hasn't been started. After the entire procedure is finished the chart of accounts for "Customer Deposits" or unearned revenue will be zero, which is the expected goal. There is no need to do an accrual journal entry if the shipment or service takes place in a different...
Excel Tips: Replacing Line Breaks in A Single Cell with Commas and Separating into Columns
Переглядів 4,5 тис.8 років тому
Excel Tips: Replacing Line Breaks in A Single Cell with Commas and Separating into Columns
Excel Tip: Using IF and AND Functions for Multiple Conditions
Переглядів 38 тис.8 років тому
Excel Tip: Using IF and AND Functions for Multiple Conditions
Excel Tip: VLOOKUP Function Used on Proforma Invoice
Переглядів 1,3 тис.8 років тому
Excel Tip: VLOOKUP Function Used on Proforma Invoice
Excel - How to Split Info Contained in a Single Cell into Separate Columns for Mail Merges
Переглядів 9268 років тому
Excel - How to Split Info Contained in a Single Cell into Separate Columns for Mail Merges
Excel Tip: Transposing Horizontal Data to Vertical Using Paste Special
Переглядів 2278 років тому
Excel Tip: Transposing Horizontal Data to Vertical Using Paste Special
Excel Tip: Tables, Validation Lists and Indirect Function
Переглядів 2088 років тому
Excel Tip: Tables, Validation Lists and Indirect Function
Excel Tip: How to Change Upper Case Letters to Proper Case
Переглядів 7838 років тому
Excel Tip: How to Change Upper Case Letters to Proper Case
Excel Tip: Using RIGHT, LEFT Functions to Add a Space to a P.C.
Переглядів 8 тис.8 років тому
Excel Tip: Using RIGHT, LEFT Functions to Add a Space to a P.C.

КОМЕНТАРІ

  • @nabeeltariq6864
    @nabeeltariq6864 4 місяці тому

    Hi, Good Day, I need your help regarding when we making invoice there is serial number like 1 2 3.But when we printing the invoice the serial number is not showing in final face.Can you please help me out on this?

  • @Michael-hd2qo
    @Michael-hd2qo 9 місяців тому

    I have used this video 20 times! So helpful. The problem is I don't do it often enough to remember so I have to keep coming back. Thankfully it's still here every time!

  • @bmuts3964
    @bmuts3964 Рік тому

    Thank u so much!

  • @loli3939
    @loli3939 Рік тому

    So what does your journal report look like? I am here because QBO duplicated everything three times and I need to remove two of each journal entry. thx.

    • @loli3939
      @loli3939 Рік тому

      using same program for student but on Better Blooms. Long for Success was fine. ARS 3.1- 3.3

  • @iBackshift
    @iBackshift Рік тому

    Thank you. I have a newer version of QBO and the procedure is nearly the same. Was getting frustrated. Thanks

  • @sineadgaynor5439
    @sineadgaynor5439 Рік тому

    Thank you for this!! It works perfectly.

  • @mandykong4345
    @mandykong4345 Рік тому

    Thanks so much!!! I've been looking for the method of how to refund my customer, that is exactly what I am looking for, very much appreciated :)

  • @torirenaud
    @torirenaud 2 роки тому

    thank you for this! the only issue I'm running into is it keeps asking to add the tax amount, however when I put 13% for my province it only gives me the amount before taxes to credit the customer, leaving an additional credit on their account Do I put it is 'out of scope' for taxes?

  • @TM-lu1fu
    @TM-lu1fu 2 роки тому

    OMG, thank you! I figured it out!!!

  • @EsmatAliMohamed
    @EsmatAliMohamed 2 роки тому

    Amazing Thank you very much .

  • @movingbeat
    @movingbeat 2 роки тому

    After that I make an actual check to the customer to clear the refund/expense, right?

  • @mikeynaz8
    @mikeynaz8 2 роки тому

    Thank you!

  • @nikkivallejos6147
    @nikkivallejos6147 2 роки тому

    Thank you for presenting a clear and concise video on how to change the invoice numbers. Does it make sense to set up assignments for each of my customers to track what we are billing and what payments are received? I think QBO already does this, but I want to understand what's the best way to track information.

  • @jaimeborjas
    @jaimeborjas 2 роки тому

    Great tip! Thanks!

  • @GS-of3zz
    @GS-of3zz 3 роки тому

    Thank you Dr. QBO!!

  • @Flax.112
    @Flax.112 3 роки тому

    Thanks a lot for your help!! ❤️❤️❤️

  • @odinthemal606
    @odinthemal606 3 роки тому

    Thank you, have been watching a million videos and none told me what I needed to do until this one!

  • @seanbrown6152
    @seanbrown6152 3 роки тому

    That didn't work for me. When the amount set to 0 after selecting both the Check that I wrote and the credit memo it gave me an error of needing to set a transaction amount.

  • @katies.9777
    @katies.9777 3 роки тому

    Thank you so much for this!

  • @wellscoservices7066
    @wellscoservices7066 3 роки тому

    Great video. Thank you!

  • @MeMyselfAndI7777
    @MeMyselfAndI7777 4 роки тому

    Thank you so much. this is very helpful and not self evidence (as usual for QB)

  • @corimehnert4853
    @corimehnert4853 4 роки тому

    Extremely helpful, thank you!

  • @MasterVortex555
    @MasterVortex555 4 роки тому

    Loved your vedio

  • @Othermails08
    @Othermails08 4 роки тому

    Where can I find this QB screen with my QB Pro Desktop 2019?

  • @kinahhalim8482
    @kinahhalim8482 4 роки тому

    Hi, is it possible for me to list down the data downward in a same row and not by using " - " Example NO : Book - Pencil - Eraser - Case YES : Book Pencil Eraser Case

  • @luminary5878
    @luminary5878 4 роки тому

    Really helpful, thanks

  • @KishParmar
    @KishParmar 4 роки тому

    Thank you for that very helpful and clear explanation. Much appreciated.

  • @mazdaadhami7643
    @mazdaadhami7643 4 роки тому

    This is great! Thank you. Just one little question: What happens once the refund is pulled into my banking queue to clear transactions? ie the refund clears the bank. Will it automatically 'match' to this already cleared transaction, assuming its an expense I've created? Any comments are appreciated. Thank you!

  • @chrisdifonso717
    @chrisdifonso717 4 роки тому

    If the final month's amount expense for reducing the Prepaid Exp balance to zero is slightly different, will QB Online automatically adjust? Or will it require manual intervention? For example, the total Prepaid Exp is $5,000 and the cost will be spread over 12 months. For the first 11 months, the expense is $416.67. For the last month, the expense is $416.63. Will QB online record $416.63 for the final month? Or will it record $416.67? Thank you.

  • @elizabethsullivan1894
    @elizabethsullivan1894 4 роки тому

    Thanks, you're a lifesaver. QBO's help area was...less that clear about how to get this working.

  • @vinithaprasannan4134
    @vinithaprasannan4134 4 роки тому

    When we use delayed credit?

  • @ghazikamar4609
    @ghazikamar4609 4 роки тому

    thanks for such a simple explanation

  • @DigitalMediaCanada
    @DigitalMediaCanada 4 роки тому

    Great job on this video, Liane - your explanation is very helpful. I've watched it several times and now it is making sense to me. I have a question though - when I opened my business, I personally made a capital purchase on behalf of my company. Because the purchase was recorded as a journal entry, the "payment account" option didn't appear and therefore, it didn't get recorded in the "Owed to Shareholder" account. How could I correct this so this capital purchase is recorded in the "Owed to Shareholder" account? Thanks in advance.

  • @meyrodrigueskelly8609
    @meyrodrigueskelly8609 4 роки тому

    Thank you so much for your help. It's ridiculous how QB doesn't have this feature. Thank God here has a creative and smart person, you.

  • @banderalrshoud2315
    @banderalrshoud2315 4 роки тому

    Thanks for your video, I need help to determine how much annual withdrawals from the business made by the owners and that will be through the Balance sheet and income statement, is there any easy excel already made to help me solve the issue.

  • @Ari-zp4dd
    @Ari-zp4dd 4 роки тому

    Thats helpful! Do you know how can i seperate semi colon " ; " to line break in mac? most videos show how to use "replace" function, but that doesnt work in mac. thank you

    • @intelligentbusinessservice7913
      @intelligentbusinessservice7913 4 роки тому

      You're welcome. Follow the second step in my video, "Text to Columns", but select semicolon instead of comma.

  • @lisagabor5787
    @lisagabor5787 4 роки тому

    THANK YOU!! I've been struggling with this

  • @financetips
    @financetips 4 роки тому

    This is definitely the best method I have seen! For the payment to owner, I might do a journal and match the bank feed. Your COA for Credit Card is really helpful! Thanx for sharing. Much love from Cape Town

  • @daihanexim3929
    @daihanexim3929 4 роки тому

    Thank you so much for tutorial.

  • @setapartbuildingconstructi6179
    @setapartbuildingconstructi6179 4 роки тому

    Thank you for making this video! Very helpful!

  • @ayesharaza7287
    @ayesharaza7287 5 років тому

    thanks for the great info...can somone share how to change home currency on Quickbooks....online it says in the advanced setting currency should have an edit button but mine doesnt please advise

  • @diego111987
    @diego111987 5 років тому

    Thank you so much, you just saved me a big headache

  • @michaelamat2872
    @michaelamat2872 5 років тому

    Thank you so much. I dont know why but it took me so long to find this explanation

  • @chiragchokshy3389
    @chiragchokshy3389 5 років тому

    Very helpful, Thank You

  • @kzachary395
    @kzachary395 5 років тому

    This are the best instructions of a refund on the internet. When I would follow other sets of instructions, including QBO's own instructions, it was like I was still out of balance. Your instructions are also the only place I've seen to comment on getting the refund to change from "partial" to "closed". This is what the other directions we're missing. I have your video saved and it's my go to place when I have to process a refund. Thank you!!

  • @marcconstant3191
    @marcconstant3191 5 років тому

    Thanks for the instructional video. How can I record an Owner's Equity Draw in QuickBooks Online to a personal bank account that's not at the same bank where the business account that is link to Quickbooks Online?

  • @shellyleerobinson444
    @shellyleerobinson444 5 років тому

    Thank you! I could not figure out how to do this... So helpful!!! :-)

  • @bsnelgrove920
    @bsnelgrove920 5 років тому

    Hi, newbie here! Why is the owed to owner account set up in the chart of accounts as a credit card account when you paid for the expenses using cash? Wouldn’t that have have to be set up as a second different owed to owner account as a cash account?

  • @leannersanatomy
    @leannersanatomy 5 років тому

    This was ridiculously helpful Thank you!

  • @RkyMtnMac
    @RkyMtnMac 5 років тому

    Thank you for the excellent instruction.