The Bookkeeping Xperts
The Bookkeeping Xperts
  • 152
  • 433 127
QuickBooks and Square - Accepting Transactions and Matching Tutorial
Must see tutorial if you use Square integration!
How to accept transaction from Square App then match it in the bank feed.
Fix the deposit when the amount does not match the bank deposit. Find out what causes the issue and how to fix it.
To hire us for a one on one tutorial please contact us at:
407 504 9828
qboxperts@gmail.com
www.thebookkeepingxperts.com
มุมมอง: 50

วีดีโอ

QuickBooks and Honeybook Integration Tutoriral
มุมมอง 57วันที่ผ่านมา
Step by step tutorial on how to integrate QuickBooks Online and HoneyBook. How to avoid duplication when matching transactions. For a one on one tutorial, clean up or catch up work, and o going bookkeeping please contact us at: 407 504 9828 Qboxperts@gmail.com www.thebookkeepingxperts.com
Trust and Case Settlement Accounting for Attorneys | QuickBooks Tutorial
มุมมอง 8321 วันที่ผ่านมา
This video is key to all attorneys who hold client's money either in Trust or Global Settlement. Learn step by step how to create a client trust account and how to manage funds in and out of Trust and Global settlement account. This tutorial is for all accountants, bookkeepers and attorneys who handle unearned income and client's funds. If you want to hire us for a one on one tutorial please co...
Delayed Charges Recurring and Batch Invoicing | QuickBooks Online Tutorial
มุมมอง 68หลายเดือนก่อน
Step by step tutorial on how to create delayed charges, batch and recurring invoices. For one on one tutorials, catch up and clean up work, and ongoing bookkeeping please contact us at: 407 504 9828 qboxperts@gmail.com www.thebookkeepingxperts.com
Square and QuickBooks when you don't integrate
มุมมอง 108หลายเดือนก่อน
If you decide that Square and QuickBooks integration does not work for you. Here is the solution, create a template and update your books according to Square Financial report. The template can be customized according to your business need. This video is a must for those of you who decided that the integration is not a good option. If you want to hire us for a one on one tutorial, if you want to...
Batch Recategorization QuickBooks
มุมมอง 67หลายเดือนก่อน
New feature from QuickBooks Online batch recategorization for business owners and QuickBooks users. Must see easier way to fix miss categorized transactions. For one on one tutorials, ongoing bookkeeping, catch up and clean up work you may hire us by contacting us at/ www.thebookkeepingxperts.com Phone 407 504 9828 qboxperts@gmail.com
Shopify and QuickBooks Online Integration Workflow and Reconciliation
มุมมอง 266หลายเดือนก่อน
This video is a tutorial on how to integrate your Shopify account to QuickBooks Online. How to match transaction and how to reconcile. For a one on one tutorial, ongoing bookkeeping, clean up and catch up work contact us at: www.thebookkeepingxperts.com Phone 407 504 9828 qboxperts@gmail.com
QuickBooks Invoice Customization for New Template
มุมมอง 472 หลายเดือนก่อน
This is a step by step tutorial on how to customize the new QuickBooks Online template. If you noticed the change on the invoice template and don't know how to customize it this video will teach you how. For one on one tutorials, books clean up and catch up, and ongoing bookkeeping please contact us at: www.thebookkeepingxperts.com qboxperts@gmail.com 407 504 9828
QuickBooks Online and Toast Integration Tutorial
มุมมอง 7893 หลายเดือนก่อน
Toast does not have a good integration with QuickBooks this video will help you record all your toast expenses, sales tax, gift card liability using an alternative method. This is a step by step tutorial to help you succeed recording your monthly income and expenses from toast. For a one on one tutorial, clean up or catch up work, or ongoing bookkeeping please contact us at: www.thebookkeepingx...
Maintenance part II Reconciliation in QuickBooks Online and Fix Duplicated Transactions
มุมมอง 2913 หลายเดือนก่อน
When the reconciliation does not work out, here are some tips on how to fix duplicated transactions and other problems such as transactions that don't belong to the account you are reconciling. How to make sure your reconciliation is correct and the balance on the bank account matches what you have in QuickBooks Online. The first step is to categorize transactions after categorizing all transac...
QuickBooks Maintenance Categorization - Tutorial
มุมมอง 1173 หลายเดือนก่อน
This tutorial will assist you maintain your books after the clean up. The first part is categorization, in this video we will go over how to categorize transactions from checking and credit card accounts. After categorizing all transactions if there are transactions you are not sure what it is you may categorize and Uncategorized Expenses and Income. You will be able to see those transactions i...
How to Pay Yourself as a Business Owner
มุมมอง 1554 หลายเดือนก่อน
This video talks about what is the best way to pay yourself when you have a business. Depending on your business legal entity you may have different options for that. In this video you will learn the different options you have to get paid and the end of the day. Should you pay yourself a salary or just do an owner's withdraw?
How do you fix Unapplied Cash Payment in QuickBooks Online
มุมมอง 5284 หลายเดือนก่อน
How do you fix Unapplied Cash Payment in QuickBooks Online
How to Fix A Negative Accounts Payable
มุมมอง 8345 หลายเดือนก่อน
How to Fix A Negative Accounts Payable
What to do Prior to Integration QuickBooks to Square App
มุมมอง 6685 หลายเดือนก่อน
If you are integrating with Square you want to watch this video. This will explain how to set up prior to integrating your Square app. If you have it integrated and is having errors trying to add the transactions, you can disconnect and prior to reconnect follow the instructions to set it up. If you want to hire us for a one on one tutorial please contact us at: qboxperts@gmail.com www.thebookk...
QuickBooks Online: Don't Fix Your Prior Year Undeposited Funds with a Journal Entry
มุมมอง 1.2K5 หลายเดือนก่อน
QuickBooks Online: Don't Fix Your Prior Year Undeposited Funds with a Journal Entry
QuickBooks and PayPal Income and Expense
มุมมอง 3196 หลายเดือนก่อน
QuickBooks and PayPal Income and Expense
How to Record Cash Transactions in QuickBooks Online
มุมมอง 2576 หลายเดือนก่อน
How to Record Cash Transactions in QuickBooks Online
Cash Transactions Income and Expense in QuickBooks Online
มุมมอง 3966 หลายเดือนก่อน
Cash Transactions Income and Expense in QuickBooks Online
Reconciling in QuickBooks Online What to do When Transactions are not Matching
มุมมอง 2K6 หลายเดือนก่อน
Reconciling in QuickBooks Online What to do When Transactions are not Matching
How to Categorize Split Transactions in QuickBooks Online and Customize Profit and Loss by Customer
มุมมอง 9217 หลายเดือนก่อน
How to Categorize Split Transactions in QuickBooks Online and Customize Profit and Loss by Customer
Third Party Integration and Duplicated Income in QuickBooks Online
มุมมอง 1507 หลายเดือนก่อน
Third Party Integration and Duplicated Income in QuickBooks Online
How to Create Templates for Payroll in QuickBooks Online for Other Payroll Services
มุมมอง 3047 หลายเดือนก่อน
How to Create Templates for Payroll in QuickBooks Online for Other Payroll Services
Deferred Revenue how to Record and Transfer to Revenue when Income is Earned
มุมมอง 1.2K7 หลายเดือนก่อน
Deferred Revenue how to Record and Transfer to Revenue when Income is Earned
Clean up Undeposited Funds (Payment to Deposits), New QuickBooks Invoice Interface Must See!!
มุมมอง 1.4K8 หลายเดือนก่อน
Clean up Undeposited Funds (Payment to Deposits), New QuickBooks Invoice Interface Must See!!
How to record income and expenses paid with cash in QuickBooks Online
มุมมอง 2.7K8 หลายเดือนก่อน
How to record income and expenses paid with cash in QuickBooks Online
Income transactions in QuickBooks Online, categorization, matching, and workflow.
มุมมอง 9248 หลายเดือนก่อน
Income transactions in QuickBooks Online, categorization, matching, and workflow.
QuickBooks Online Categorize Transfers, and Set up Rules for Expense Transactions
มุมมอง 9448 หลายเดือนก่อน
QuickBooks Online Categorize Transfers, and Set up Rules for Expense Transactions
What Kind of QuickBooks Online Subscription Level Will Work Best for your Company
มุมมอง 1468 หลายเดือนก่อน
What Kind of QuickBooks Online Subscription Level Will Work Best for your Company
Clean up for Business Owners Part III
มุมมอง 1489 หลายเดือนก่อน
Clean up for Business Owners Part III

ความคิดเห็น

  • @LynieAnnDelizo-n7m
    @LynieAnnDelizo-n7m วันที่ผ่านมา

    what to do when it still not showing in the match transactions?

    • @ClaudiaXperts
      @ClaudiaXperts วันที่ผ่านมา

      Look at the deposit to find out if it is sent to the right account and to see if the date is correct.

  • @ritaquezada2878
    @ritaquezada2878 วันที่ผ่านมา

    I love how you explain. I was so confused how to resolve that problem with my client deposit , many did not match, Now everything is fine. Thank you. God bless you

  • @RestaurantAccountantInHell
    @RestaurantAccountantInHell วันที่ผ่านมา

    Working in Xtrachef & QBO- are there any experts out there with experience mapping COGS & Sales in Xtrachef to QBO? Please help if at all possible, I am willing to pay an expert to help with this. I am new to restaurant accounting and need to get my P&L correct. Please help! :)

    • @ClaudiaXperts
      @ClaudiaXperts วันที่ผ่านมา

      We can help

    • @ClaudiaXperts
      @ClaudiaXperts วันที่ผ่านมา

      I am specialized in QuickBooks integration we can look at it to see what is going on.

  • @SanjibKumarSen-ls6hd
    @SanjibKumarSen-ls6hd 4 วันที่ผ่านมา

    Thank you for the valuable content you create. I was wondering if you could consider making a video tutorial on eCommerce bookkeeping. It would be incredibly helpful to understand the nuances and best practices in this area.

    • @ClaudiaXperts
      @ClaudiaXperts 3 วันที่ผ่านมา

      Great suggestion! I will work on that!

  • @briteeye1170
    @briteeye1170 4 วันที่ผ่านมา

    this video is everything! Thank you!!!!

    • @ClaudiaXperts
      @ClaudiaXperts 3 วันที่ผ่านมา

      You are so welcome!

  • @danildaruiz2287
    @danildaruiz2287 5 วันที่ผ่านมา

    Hello, I am confused here. Why do we enter the gross sales when that has the tips collected as well? the actual sales are the gross sales minus the tips which will then give us an actual picture of our daily/monthly revenues. To match it with Toast we should then take the gross sales minus the tips and that is what our revenues should be. can you please clarify?

    • @ClaudiaXperts
      @ClaudiaXperts 2 วันที่ผ่านมา

      Hi Dan this information is taken from the Toast reports. Please note that the tips is a liability in the balance sheet. So we credited the liability account to match what in the Toast report. We are not making up those numbers they are coming from Toast. The tips liability is removed when tips are paid to employees. They are never recorded in the Profit and Loss

  • @HeatherMullikin-p4u
    @HeatherMullikin-p4u 11 วันที่ผ่านมา

    Great videos! Question. I have a restaurant and use Toast integration. Toast creates a journal entry every day. All of the cash sales go into the cash account. When we deposit it, I create a transfer from Cash to Checking and I'm able to match that amount from the bank feed. One day we got a check from a local work program for on the job training reimbursement for two employees. We deposited the check and cash at the same time so the bank combined them. I have the check amount categorized as other income. Now I cannot match my deposit from the bank feed! When I click match I see the cash transfer but not the other one. What am I doing wrong?

    • @ClaudiaXperts
      @ClaudiaXperts 10 วันที่ผ่านมา

      Record the deposit by clicking on deposit on the plus sign on the left hand side menu. You will need to select the cash deposit and for the one for the other deposit scroll down where it says add to deposit then add the name of the entity who reimbursed the money. Select other income then add the amount. If you recorded the deposit individually please delete so you will be able to do it. Please keep in mind that the cash payment needs to be sent to undeposited funds for this process to work.

  • @RubylinSantos
    @RubylinSantos 11 วันที่ผ่านมา

    ❤ greatly helps..I'm currently a Virtual Bookkeeper. I need to be more familiar with Honeybook. I'm from the Philippines ❤

    • @ClaudiaXperts
      @ClaudiaXperts 10 วันที่ผ่านมา

      Glad it was helpful!

  • @natasha89wood
    @natasha89wood 11 วันที่ผ่านมา

    Would be helpful to see you actually set up the integration and all the steps involved to match the transactions

  • @cheri121975
    @cheri121975 15 วันที่ผ่านมา

    To reconcile the Square bank do you use the Square transaction report ? Does the app automatically map to items in your products and services? Thanks for the video it is very helpful.

    • @ClaudiaXperts
      @ClaudiaXperts 15 วันที่ผ่านมา

      To reconcile you will use Sales Summary not the transaction report. The app does not automatically you will need to add the products and services from Square and import to QuickBooks.

  • @AccountsPayable-q8n
    @AccountsPayable-q8n 15 วันที่ผ่านมา

    This was so helpful! Thank you-

    • @ClaudiaXperts
      @ClaudiaXperts 15 วันที่ผ่านมา

      Glad it was helpful!

  • @DJRazorgirl826
    @DJRazorgirl826 19 วันที่ผ่านมา

    The account I'm working on is negating the sales by showing the sales income going in and out leaving only the fee. This doesn't match the bank record which only shows the net income (sales income minus the fee). I started by deleting the extra entry pulling out the net income and changing the incoming to the gross sales. Is this the best way?

    • @ClaudiaXperts
      @ClaudiaXperts 19 วันที่ผ่านมา

      The problem here is workflow. You added the transaction from the bank fees then matched in app transaction. The right workflow is to first add from the app transaction then match in the bank feed. The wrong workflow will create all kinds of problems. You should undo those transactions and use the right workflow .

    • @DJRazorgirl826
      @DJRazorgirl826 18 วันที่ผ่านมา

      @@ClaudiaXperts technically, I did nothing. I just got this account. But, I see what you're saying.

    • @ClaudiaXperts
      @ClaudiaXperts 15 วันที่ผ่านมา

      Undo those transactions then add the transactions first from app transaction then match them in banking.

  • @jasminwing9568
    @jasminwing9568 23 วันที่ผ่านมา

    Hi Claudia, thank you for this helpful video! I have followed your steps and I can see that the fixed asset and depreciation are showing correctly on the balance sheet report. I thought that this depreciation expense would automatically show on my P&L but it doesn't. Would you be able to advise me on how to make it show in the P&L please? Any guidance would be hugely appreciated :)

    • @ClaudiaXperts
      @ClaudiaXperts 23 วันที่ผ่านมา

      Glad it was helpful! The journal entry here is to add the asset. To depreciate the asset you will do a journal entry credit accumulated depreciation which is a conter asset account and debit depreciation expense which will show up in the P & L, if you already did it check the date of your transaction and the account type to make sure that accumulated depreciation is an expense account.

    • @jasminwing9568
      @jasminwing9568 18 วันที่ผ่านมา

      @@ClaudiaXperts thanks so much for coming back to me 😃

    • @ClaudiaXperts
      @ClaudiaXperts 18 วันที่ผ่านมา

      @@jasminwing9568 You are welcome!

  • @stephaniebird87
    @stephaniebird87 24 วันที่ผ่านมา

    Thank you for the video! Wondering if I am missing something because I go to the specific client and I am wanting to see how much is remaining on their account. I have created the invoice, received the payment and put in the sales receipt and their balance in still zero. They should have some of their retainer remaining. Can you let me know what I am doing wrong. Thank you!

    • @ClaudiaXperts
      @ClaudiaXperts 23 วันที่ผ่านมา

      You will need to create a Client trust liability account and when you see the deposit in the Trust bank categorize the transaction as as trust liability account. I will post a video this week on the subject stay tuned.

  • @HubLocationSound
    @HubLocationSound 25 วันที่ผ่านมา

    Is an Expendable a Cost of Good or Expense?

    • @ClaudiaXperts
      @ClaudiaXperts 23 วันที่ผ่านมา

      What do you mean as expandable?

  • @SunblaKhan-lk6ol
    @SunblaKhan-lk6ol 28 วันที่ผ่านมา

    The video provides clear steps for handling mismatched payments in QuickBooks Online. For efficient invoice management alongside your accounting, consider tools like InvoiceBerry for a seamless integration.

  • @ElizabethQuick-g3n
    @ElizabethQuick-g3n หลายเดือนก่อน

    Great video. Quick question: many of my products and services are over 100 characters long. It would take me a long time to shorten all of them in Square. Is there a way to get around this? Thanks so much

    • @ClaudiaXperts
      @ClaudiaXperts 29 วันที่ผ่านมา

      Hi Elizabeth, unfortunately no. If there is a difference between the names in Square and in QuickBooks the items will not integrate. Also you may import the Products and Services from Square to QuickBooks.

  • @Umie-p7c
    @Umie-p7c หลายเดือนก่อน

    As always, it was helpful 🙏 my Sis😊

  • @mostakahmmedaccountant
    @mostakahmmedaccountant หลายเดือนก่อน

    Thank you madam, I am from Bangladesh, I like your Video, I want to be an expert on QB like you, please give me some tips and tricks.

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      It is all about practice and research. Good luck in your pursuit!!

  • @TobyMiller1970
    @TobyMiller1970 หลายเดือนก่อน

    @The Bookkeeping Xperts .... I buy QBO for my bookkeeping client and I pass the entire discount to him. I created the expense and I checked the "Billable" field and assigned it to the client. I then created the invoice and added that expense to the invoice. I don't want this to increase my income, since I am not marking it up. Are the following steps necessary? Intuit customer service said that I need to create 2 new accounts in the Chart of Accounts (Billable Expense Income & Billable Expense). They also said that I needed to add a Product and Service and put a check mark next to "I sell this product/service to my customers." and under "Income Account" choose "Billable Expense Income". They also said that I should put a check mark next to the "I purchase this product/service from a vendor." and then choose "Billable Expense". Is that overkill or is it necessary to do all of those steps that they recommended?

  • @user-us3sf1gp4k
    @user-us3sf1gp4k หลายเดือนก่อน

    It is the first time we are using QBO and when connected to the bank , the bank feed only started from May 2024 and now it is automatically uploading new transactions. What is the best way to get the transactions from Jan 1 2023 to May 2024. Can we download from the bank as CSV or excel and upload to QBO or can we delete all transactions from Mat and do it over. Thank You.

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      You can request the CSV file for the exact dates you need from your bank and upload them to QuickBooks. If your bank can only provided the CSV file for all the dates including the ones you already have you may exclude those duplicate transactions

  • @ErickHG-it7vn
    @ErickHG-it7vn หลายเดือนก่อน

    ¡Gracias! POR SU APOLLO !THANKS FOR YOU SUPPORT !!😄😄

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      You are welcome❤️

  • @daliasmith
    @daliasmith หลายเดือนก่อน

    Hey Claudia - Your videos are very helpful. I have a transaction in my bank feed that doesn't match the payment that was transported from by interfaced program. The bank shorted the amount by a small amount of change then sent a credit for the change later. QBO will not allow me to match to the payment. I created a deposit for the two transactions but this did not clear the items from my bank feed. Any suggestions?

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      In this video it shows how to add the adjustment in the deposit so it can match the amount that cleared the bank. On the deposit click on add to this deposit and categorize the difference as bank fees or sales and add the difference as a negative amount to match what cleared in the bank fees. The video shows how to do it. If the amount is the same it will show a match

  • @natalieyoakum8915
    @natalieyoakum8915 หลายเดือนก่อน

    How can I import the service library into Quickbooks? My client is using Services in Square (due to using the Square Appointments tool), not Items, and I did not see the same option in Square to pull the list of services from Square into Quickbooks.

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      Your client will need to go to Square and look for his products and services. He will be able to send it as an Excel CSV format then go to QuickBooks go to Products and service then import. If he cannot find his Products and Services in Square ask him to contact Square.

  • @user-fe4tq9gp5p
    @user-fe4tq9gp5p หลายเดือนก่อน

    Thanks for your video it was helpful.

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      Glad it was helpful!

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      Glad it was helpful!

  • @cherryhintonaccounting5428
    @cherryhintonaccounting5428 หลายเดือนก่อน

    Brilliant thank you

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      You're very welcome

  • @Adventuresofthewilkins
    @Adventuresofthewilkins หลายเดือนก่อน

    What to do if account and date was incorrect and I saved? Can I change that now?

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      Yes you can, if you record to cash bank go to the chart of accounts, click on view register on the cash bank account then find the transaction and click on delete.

  • @Raw2Records
    @Raw2Records หลายเดือนก่อน

    Hello Claudia! is it possible we can have a quick meeting where i can show you my QBo file. I have A/R entries (Transactions) uncleared in Bank Rec. however, those are already matched in QBs directly with bank feed. previous months are already reconciled. can you help me on how to rectify those. i cannot even delete them as they are recorded correctly in QBs. Thank you,

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      Hello I do charge for the one on one meetings. You may email me at qboxperts@gmail.com and we can talk about cost and availability.

  • @venkatasivakrishnaabburi3633
    @venkatasivakrishnaabburi3633 หลายเดือนก่อน

    May I know how are you tracking the toast fee in QuickBooks? or are you ignoring the fee and taking only the net revenue from Toast

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      Not ignoring the fees, recording according to the reports.

  • @g5162
    @g5162 หลายเดือนก่อน

    When you received the money as income, why do you need to send the money to undeposited funds? Couldn't you send the money directly to the personal funds account instead?

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      You can, I prefer to send all transactions to Undeposited Funds to keep track of the deposits in the bank. If you never deposit them you may send it to Owner’s Distributions

  • @proaccounting2023
    @proaccounting2023 หลายเดือนก่อน

    Thank you. Very helpful.

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      Glad it was helpful!

  • @RonaldRenwick
    @RonaldRenwick หลายเดือนก่อน

    Can you actually do a reconciliation? can't figure mine out for the life of me.

  • @MaeA.-dj7ul
    @MaeA.-dj7ul หลายเดือนก่อน

    hi, how to fix if the payment if the payment was incorrectly reconciled and not applied to the invoice, but it was already marked as 'R'? can I click undo the transaction?

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      Check this video out to fix a wrong match for a transaction already reconciled. I know is for Square transaction but it works the same. For transactions already reconciled if you bring it back to for review it will mess up your reconciliation. You may go to the bank register find the transaction and manually reconcile to fix it. You may also click on what is causing the error and reconcile from there.

  • @ritaschowengerdt2197
    @ritaschowengerdt2197 หลายเดือนก่อน

    What happens when someone pays their account ahead and wants to carry the credit until next month's invoice? I have that a lot. Also, I collected payments one fiscal year and waited until next fiscal year (education institution) and to do invoicing to be in correct school year. I have a -$3,000+ balance in uncategorized account. Totally mixed up. Didn't seem to be this way in Desktop Quickbooks.

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      You may create an Unearned Revenue account and add those funds there. Make sure to add each customer name. You can also create a sub account to each customer to keep track. This video link below talks about how to do that. You may also create a credit memo for the customer. I have a video on unearned revenue if you want to go that route. th-cam.com/video/h3yIgeKGOks/w-d-xo.htmlsi=sl0XhEOniEdvg_K2

  • @adil.abbasi1.0
    @adil.abbasi1.0 หลายเดือนก่อน

    Thanks for sharing

    • @ClaudiaXperts
      @ClaudiaXperts หลายเดือนก่อน

      Thanks for watching!

  • @ToddJohnson15
    @ToddJohnson15 2 หลายเดือนก่อน

    Even the aggregate doesn't work well. QBO's import ignores square variations, gets sales tax incorrect for some reason, ignores Classes set up by product in QBO, doesn't properly fill in location. Square fees are also problematic. Sometimes QBO handles them correctly, but often if there is any issue with the imported square sales receipt and you need to fix it, then you can't match to the bank deposit. Also, if you get the Square sales receipt as a summary and the sales were paid using multiple deposits (say some square and some recorded as cash transactions when a customer zelles you) QBO cannot match one sales receipt to multiple deposits. You can only match one deposit to multiple receipts. If you just put all income into income as you do in the video you lose the ability to do a profit and loss statement that shows categories of income. In short, QBO's handling of Square is insane. I suspect that I can use the method you outline for sales receipts that don't work using the automation, but enter by category instead of lumping every sale into income.

    • @ClaudiaXperts
      @ClaudiaXperts 2 หลายเดือนก่อน

      This is not a perfect integration. I would suggest to track the sales detail in Square and not track item detail in QuickBooks. You are right the integration does not have the capacity to track classes unless you do it manually. If you have a few large transactions is fine when you have a large amount of transactions this does not work. This integration is not set up for complex tracking. You may disconnect the app and just add the sales summary as a Journal entry and create a Square clearance account for that. But it will not track any item details either.

  • @cristeliatijerina2336
    @cristeliatijerina2336 2 หลายเดือนก่อน

    Thank you for this information! Very helpful

    • @ClaudiaXperts
      @ClaudiaXperts 2 หลายเดือนก่อน

      Glad it was helpful!

  • @andreathomson9090
    @andreathomson9090 2 หลายเดือนก่อน

    How do I clear outdated deferred revenue accounts without affecting my income balances?

    • @ClaudiaXperts
      @ClaudiaXperts 2 หลายเดือนก่อน

      Deferred income must go to income unless it is never earned. Such as a refund, it will still go to income but it will be offset by the refund if that’s what happened.

  • @bettycedillo5783
    @bettycedillo5783 2 หลายเดือนก่อน

    How do I record this.. I did cash withdrawal from the bank and used it to pay a subcontractor?

    • @ClaudiaXperts
      @ClaudiaXperts 2 หลายเดือนก่อน

      Just categorize as subcontractor, if there was more than one you can split. Better yet you can record the money as a transfer to cash then record each contractor expense out of cash.

  • @Sosweetwater
    @Sosweetwater 2 หลายเดือนก่อน

    Hello - I wonder what would be the JE if you want to get deferred revenue off of the balance sheet. I did not receive the money and I did not provide a service. Do I debit the deferred revenue and credit a loss?? Thank you

    • @ClaudiaXperts
      @ClaudiaXperts 2 หลายเดือนก่อน

      You may reverse your original JE, or you can credit deferred revenue since it is an asset, and debit sales or bad debt. This is if you are on an accrual basis. If not you can reverse the original Journal Entry.

    • @Sosweetwater
      @Sosweetwater 2 หลายเดือนก่อน

      @@ClaudiaXperts Thank you for your clarification. Reversing the original JE might solve the issue. I think we classified deferred revenue as a liability not an asset. Thank you again 👍

  • @CindyDowell-jb2tn
    @CindyDowell-jb2tn 2 หลายเดือนก่อน

    Claudia, you are the only one helping us to make sense of Square and QBO...thank you! This video was extremely helpful, but how does one match a lot of small Square transactions to just a handful of deposits? I have about 30 small cash transactions and only 5 deposits. If I use the date span inbetween deposits as a guide, the amounts never match. Do I get as close as possible, and adjust for the rest? If so, do I code the difference back to Cash on Hand? Again, your expertise is greatly appreciated!

    • @ClaudiaXperts
      @ClaudiaXperts 2 หลายเดือนก่อน

      Hi Cindy, you want to deposit your cash into the Bank Account Cash on Hand. Then when you deposit the money in your bank account you categorize it as a transfer out of Cash on Hand Bank account. Money in when you record the cash deposit and money out when you record the transfer being deposited into your bank account. This is for cash transaction only.

  • @kristaparsons3298
    @kristaparsons3298 2 หลายเดือนก่อน

    What happens if all the deposits and payments match the bank statement and there still is a balance?

    • @ClaudiaXperts
      @ClaudiaXperts 2 หลายเดือนก่อน

      Then you will need to go item by item and compare to the statement to find transactions that are either duplicated or recorded to the wrong account.

  • @sasha.elaine
    @sasha.elaine 2 หลายเดือนก่อน

    Any videos for P&C insurance agencies

    • @ClaudiaXperts
      @ClaudiaXperts 2 หลายเดือนก่อน

      Not specifically for insurance agency but any video should work.

  • @maca4190
    @maca4190 2 หลายเดือนก่อน

    Instead of getting the clearing account to 0 by crediting Owners Investment, could I not use Accounts payable? Because this would mean the personal account is now owed money by the business so it would be a payable account?

    • @ClaudiaXperts
      @ClaudiaXperts 2 หลายเดือนก่อน

      Not accounts payable, but you can create a short term liability account name due to owner, so when you withdraw the money to pay yourself you categorize as the liability account and clear the balance.

  • @MehmoodKhan-nh1hx
    @MehmoodKhan-nh1hx 2 หลายเดือนก่อน

    Hi, I cant see the project overview to show the coloured lines income, costs, and profitability and profit margins, Am i missing something here to turn on. I have turned on the projects in the settings, I have QBO plus subscriptions . QB staffs are not very helpful in resolving.

    • @ClaudiaXperts
      @ClaudiaXperts 2 หลายเดือนก่อน

      You will need to click on projects, then select project. You will then create the project and all invoices payments will need to be done through projects. The reports will be inside the projects

  • @TashaWiginton
    @TashaWiginton 2 หลายเดือนก่อน

    Hi Claudia, I am in a pickle with Square Loan. I have the loan set up in my chart of accounts as a other current liability with an opening balance. How do I record payments since the payments are removed before square sends them over? Am I able to use a clearing account to show this? I would love a video on how to set up a Square clearing account that accounts for all fees, tax, and loans!

    • @ClaudiaXperts
      @ClaudiaXperts 2 หลายเดือนก่อน

      Yes, absolutely! You will need to go to a Square, select financial then loan. Click on the loan you need to record the payments for. It will show each payment deduction. When the transaction comes to QuickBooks it will be categorized as Square fees, sometimes uncategorized expense, you will need to change it to Square loan. I will see if I can cover that this week.

  • @adil.abbasi1.0
    @adil.abbasi1.0 2 หลายเดือนก่อน

    It's a great lesson. Please a make a complete video on QBO shopify workflow

    • @ClaudiaXperts
      @ClaudiaXperts 2 หลายเดือนก่อน

      Will do soon

  • @jeeptjfishingspi5407
    @jeeptjfishingspi5407 2 หลายเดือนก่อน

    Hello, good afternoon, I have a question and I am new with Quickbooks, a deposit appears in hold, I checked and I see that it says that they require information from me and I checked the email to continue, but I have nothing in my inbox from me email and I urgently need to release that payment since it is the material of one of my clients, could you help me ?

    • @ClaudiaXperts
      @ClaudiaXperts 2 หลายเดือนก่อน

      This would be with QuickBooks. They are the ones to process and release payments.

  • @heathersimon5917
    @heathersimon5917 2 หลายเดือนก่อน

    Working on QBO for a food truck. In the clearance account you mentioned recording income and expenses for Toast. For example, there are monthly fees associated with using the toast POS system automatically debited from the bank account. Should that be recorded under the clearance account? When recording September sales and adding the bank settlement deposits the clearance account has a balance. You mentioned it should zero out.

    • @ClaudiaXperts
      @ClaudiaXperts 2 หลายเดือนก่อน

      Hi Heather if the monthly fees are going through your checking account you just categorize from the bank feed no need to enter in the clearance account. At times clearance may hold funds, therefore, there will be a different till the funds are released.

  • @robertoromero7636
    @robertoromero7636 2 หลายเดือนก่อน

    You are great!❤

    • @ClaudiaXperts
      @ClaudiaXperts 2 หลายเดือนก่อน

      Thank you so much!!