The Bookkeeping Xperts
The Bookkeeping Xperts
  • 156
  • 445 558

Відео

QuickBooks Online for Accountants | Clean Up and Monthly Workflow
Переглядів 5821 годину тому
QuickBooks Online for Accountants | Clean Up and Monthly Workflow
Reconcile Bank Acc and Clean Up Duplication in QuickBooks Online
Переглядів 155День тому
Step by step tutorial on QuickBooks Bank reconciliation, and how to fix duplication. While you are reconciling a bank account you may get a zero difference but don't push the finish reconciliation button until you watch this video. Reconciliation is one of the most important steps of the QuickBooks Monthly workflow. When reconciliation is not property done the account will be off and your Balan...
Square Cash payment Workflow | QuickBooks Online Tutorial
Переглядів 4614 днів тому
Square Cash payment Workflow | QuickBooks Online Tutorial
QuickBooks and Square - Accepting Transactions and Matching Tutorial
Переглядів 7821 день тому
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
QuickBooks and Honeybook Integration Tutoriral
Переглядів 77Місяць тому
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
Переглядів 106Місяць тому
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
Переглядів 74Місяць тому
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
Переглядів 1202 місяці тому
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
Переглядів 682 місяці тому
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
Переглядів 3812 місяці тому
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
Переглядів 483 місяці тому
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
Переглядів 9633 місяці тому
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
Переглядів 3484 місяці тому
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
Переглядів 1204 місяці тому
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
Переглядів 1604 місяці тому
How to Pay Yourself as a Business Owner
How do you fix Unapplied Cash Payment in QuickBooks Online
Переглядів 6805 місяців тому
How do you fix Unapplied Cash Payment in QuickBooks Online
How to Fix A Negative Accounts Payable
Переглядів 9675 місяців тому
How to Fix A Negative Accounts Payable
What to do Prior to Integration QuickBooks to Square App
Переглядів 7936 місяців тому
What to do Prior to Integration QuickBooks to Square App
QuickBooks Online: Don't Fix Your Prior Year Undeposited Funds with a Journal Entry
Переглядів 1,4 тис.6 місяців тому
QuickBooks Online: Don't Fix Your Prior Year Undeposited Funds with a Journal Entry
QuickBooks and PayPal Income and Expense
Переглядів 3496 місяців тому
QuickBooks and PayPal Income and Expense
How to Record Cash Transactions in QuickBooks Online
Переглядів 3077 місяців тому
How to Record Cash Transactions in QuickBooks Online
Cash Transactions Income and Expense in QuickBooks Online
Переглядів 4777 місяців тому
Cash Transactions Income and Expense in QuickBooks Online
Reconciling in QuickBooks Online What to do When Transactions are not Matching
Переглядів 2,4 тис.7 місяців тому
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
Переглядів 1,1 тис.7 місяців тому
How to Categorize Split Transactions in QuickBooks Online and Customize Profit and Loss by Customer
Third Party Integration and Duplicated Income in QuickBooks Online
Переглядів 1627 місяців тому
Third Party Integration and Duplicated Income in QuickBooks Online
How to Create Templates for Payroll in QuickBooks Online for Other Payroll Services
Переглядів 3318 місяців тому
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,3 тис.8 місяців тому
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,6 тис.8 місяців тому
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
Переглядів 3,1 тис.8 місяців тому
How to record income and expenses paid with cash in QuickBooks Online

КОМЕНТАРІ

  • @rainedeleon937
    @rainedeleon937 23 години тому

    Hi Claudia. Thank God I found you and your videos. The Payment to deposit account of my client is ballooning. I have both Deposit and Payment with the same amount. Basically referring to same transaction. The QBO Care told me to edit the Sales Receipt or Payment in the Register and change the account where it should be deposited. So I changed it from Payment to Deposit Accounts to the Bank Account of my client, did I do it right?

  • @rainedeleon937
    @rainedeleon937 День тому

    Hi Claudia. Thank God I found this video of yours. The Payment to deposit account of my client is ballooning. I have both Deposit and Payment with the same amount. Basically referring to same transaction. The QBO Care told me to edit the Sales Receipt or Payment in the Register and change the account where it should be deposited. So I changed it from Payment to Deposit Accounts to the Bank Account of my client, did I do it right? I'm going insane with this.

  • @ShoaibRahman00
    @ShoaibRahman00 2 дні тому

    Very Good

  • @yshangot1009
    @yshangot1009 6 днів тому

    Hi, what to do when the deposit from square app transactions are cash sales?

    • @ClaudiaXperts
      @ClaudiaXperts 6 днів тому

      Deposit to the cash on hand account and when the client deposit in the bank record as a transfer from the cash account to the checking account. Check the video below which explains the process.

    • @ClaudiaXperts
      @ClaudiaXperts 6 днів тому

      Square Cash payment Workflow | QuickBooks Online Tutorial ua-cam.com/video/XpPTPlt6Sds/v-deo.html

  • @DBRBookkeeping
    @DBRBookkeeping 7 днів тому

    Hi Claudia, what if the balance sheet has a negative undeposited fund balance? How do you clean negative UF? Thanks!

    • @ClaudiaXperts
      @ClaudiaXperts 6 днів тому

      You will need to go into the undeposited funds register and find the transaction that created the negative amount. It is probably a Journal Entry. The other possibility is that a deposit was created before the invoice.

  • @newmhelemish
    @newmhelemish 12 днів тому

    This client has more than 8 credit cards and 2 bank accounts

  • @newmhelemish
    @newmhelemish 12 днів тому

    Also how about also he create an invoice in the old account for a customer and the client paid it then he asked for a refund and my client refunded him. The reason there two accounts... the old one was really messed up for years and no proper reconciling and my client add bank feeds for his personal a d business credit cards in old QBO. I created the new account and start from scratch in this new account. My client still use the old one and create invoices on it because in the new one QB payments consider him a new client and charge him a big fees.

    • @ClaudiaXperts
      @ClaudiaXperts 12 днів тому

      I would ask the client to contact QuickBooks to fix the rate and process in the new account. But yes create a sales receipt instead and record the deposit and match it in banking.

    • @newmhelemish
      @newmhelemish 12 днів тому

      @@ClaudiaXperts I already called QB as a ProAdvisor and they said .. they consider him as a new client with a new account.

    • @ClaudiaXperts
      @ClaudiaXperts 12 днів тому

      @@newmhelemish so you will need to create the sales receipt in QBO and the deposit and match it in the Bank feed

  • @newmhelemish
    @newmhelemish 12 днів тому

    I have a client has two QBO accounts one is old and one is new..he create the invoice and receive the money on the old account. But we work snice this year in the new account. So in bank feeds there is money received with no invoice created and of course there is qbo payment fees. To reconcile this transaction. What shall I do? Do I need to create the invoice by whole amount but what about the fees?

    • @ClaudiaXperts
      @ClaudiaXperts 12 днів тому

      If those payments are processed by QuickBooks Online you are likely to have an invoice. Go to the client and go to invoice to see if that’s the case. If there is no invoice it will appear in the Profit and Loss as unapplied cash payment then you do create an invoice and apply the payment to the invoice.

  • @devonobert3179
    @devonobert3179 18 днів тому

    Hi, I have a question. So, I added in Honey books a tax rate. Is that the sales tax? If so, how do I see all the sales tax I will have by the end of the year. I do not charge my clients sales tax in their invoices so i'm assuming i will have to pay that back. Where do I see the sales tax in QuickBooks because as of right now it says my sales tax is 0$. Also, in regard to sales tax how does it work if I travel and get paid in another State/Country where the sales tax would be different. My LLC is in Florida, so I don't know if it makes a difference. I'm a photographer, and I travel a lot. Thank you!

    • @ClaudiaXperts
      @ClaudiaXperts 12 днів тому

      You will need to set up your sales tax in QuickBooks. Go to taxes select sales tax and add all the agencies you use. Each state has its own sales tax rate and rules. Some states do not require you to file up to a certain amount you will need to research each state you are doing business with.

  • @LynieAnnDelizo-n7m
    @LynieAnnDelizo-n7m 21 день тому

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

    • @ClaudiaXperts
      @ClaudiaXperts 21 день тому

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

    • @LynieAnnDelizo-n7m
      @LynieAnnDelizo-n7m 48 хвилин тому

      @@ClaudiaXperts Hi Claudia, I'm dealing with the same issue as in the video. There is $500 in undeposited cash/check that I can't find when I try to match the transaction. I've already confirmed that it was sent to the correct account. Could you please advise? Thank you.

  • @ritaquezada2878
    @ritaquezada2878 21 день тому

    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 22 дні тому

    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 21 день тому

      We can help

    • @ClaudiaXperts
      @ClaudiaXperts 21 день тому

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

  • @SanjibKumarSen-ls6hd
    @SanjibKumarSen-ls6hd 24 дні тому

    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 24 дні тому

      Great suggestion! I will work on that!

  • @briteeye1170
    @briteeye1170 24 дні тому

    this video is everything! Thank you!!!!

  • @danildaruiz2287
    @danildaruiz2287 25 днів тому

    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 22 дні тому

      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 Місяць тому

    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 Місяць тому

      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 Місяць тому

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

  • @natasha89wood
    @natasha89wood Місяць тому

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

  • @cheri121975
    @cheri121975 Місяць тому

    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 Місяць тому

      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 Місяць тому

    This was so helpful! Thank you-

  • @DJRazorgirl826
    @DJRazorgirl826 Місяць тому

    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 Місяць тому

      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 Місяць тому

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

    • @ClaudiaXperts
      @ClaudiaXperts Місяць тому

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

  • @jasminwing9568
    @jasminwing9568 Місяць тому

    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 Місяць тому

      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 Місяць тому

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

    • @ClaudiaXperts
      @ClaudiaXperts Місяць тому

      @@jasminwing9568 You are welcome!

  • @stephaniebird87
    @stephaniebird87 Місяць тому

    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 Місяць тому

      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 Місяць тому

    Is an Expendable a Cost of Good or Expense?

  • @SunblaKhan-lk6ol
    @SunblaKhan-lk6ol Місяць тому

    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 Місяць тому

      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 2 місяці тому

    @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 2 місяці тому

    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 2 місяці тому

      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 2 місяці тому

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

  • @daliasmith
    @daliasmith 2 місяці тому

    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 2 місяці тому

      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 2 місяці тому

    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 2 місяці тому

      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 2 місяці тому

    Thanks for your video it was helpful.

  • @cherryhintonaccounting5428
    @cherryhintonaccounting5428 2 місяці тому

    Brilliant thank you

  • @Adventuresofthewilkins
    @Adventuresofthewilkins 2 місяці тому

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

    • @ClaudiaXperts
      @ClaudiaXperts 2 місяці тому

      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 2 місяці тому

    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 2 місяці тому

      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 2 місяці тому

    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 2 місяці тому

      Not ignoring the fees, recording according to the reports.

  • @g5162
    @g5162 2 місяці тому

    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 2 місяці тому

      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 2 місяці тому

    Thank you. Very helpful.

  • @RonaldRenwick
    @RonaldRenwick 2 місяці тому

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

  • @MaeA.-dj7ul
    @MaeA.-dj7ul 2 місяці тому

    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 2 місяці тому

      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 2 місяці тому

    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 2 місяці тому

      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. ua-cam.com/video/h3yIgeKGOks/v-deo.htmlsi=sl0XhEOniEdvg_K2

  • @adil.abbasi1.0
    @adil.abbasi1.0 2 місяці тому

    Thanks for sharing

  • @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.

  • @Imtjesillybeaninurwalls
    @Imtjesillybeaninurwalls 2 місяці тому

    Thank you for this information! Very 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 3 місяці тому

    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.