Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
J
JoanDM1211
August 27, 2021
Solved

Clearing account

  • August 27, 2021
  • 1 reply
  • 5 views

I am still learning QBO. I have shopify and a local/physical store. I manually recording monthly shopify sales and  then debited the total amount to a clearing account. Once the shopify sales/payment reflected on the bank, i just categorized the deposits under clearing account to offset the journal entry I made.

Now for the sales coming from local store, I just do the "received payments" and then later on matched with the deposits reflected from the bank feeds. 

My problem now is that when I check on the registry of that clearing account, the payments from sales of local store were also included. It should not be the case because the balance of clearing account should match the shopify sales only.

I checked the information of product and services portion of QBO and note that the income amount of invoices is under Sales of product income. How is it that the payment from the invoice  also goes to the clearing account? Is there something i need to fix/ edit? 

Best answer by Jen_D

It's nice to see you here in the support page for QuickBooks, Joan.

 

I can share some insights on how you can correct the wrong posting of the funds in the clearing account. Normally, income from sales are reported based on the income account used on the items on the sale.

 

If there are incorrect posting of funds, try to review the items sold, and see if the Income Account is correct. Otherwise, you can open the clearing account register and check the transactions under it. This way you will see any duplicate postings and you can correct them.

 

I would like to share some links on how to handle Etsy transactions in QBO:

 

 

If you need anything else with this invoicing topic, please let me know in the comment below. I'll be right here to help you further with your Etsy entries. Have a happy week!

1 reply

Jen_D
Jen_DAnswer
Level 8
August 27, 2021

It's nice to see you here in the support page for QuickBooks, Joan.

 

I can share some insights on how you can correct the wrong posting of the funds in the clearing account. Normally, income from sales are reported based on the income account used on the items on the sale.

 

If there are incorrect posting of funds, try to review the items sold, and see if the Income Account is correct. Otherwise, you can open the clearing account register and check the transactions under it. This way you will see any duplicate postings and you can correct them.

 

I would like to share some links on how to handle Etsy transactions in QBO:

 

 

If you need anything else with this invoicing topic, please let me know in the comment below. I'll be right here to help you further with your Etsy entries. Have a happy week!

    J
    JoanDM1211Author
    August 28, 2021

    Hi Jen!

    Thank you for your response, I highly appreciated your support. I'd like to note thought that I map the products and services under Sales of product income.  It should not be mixed with clearing account because I used different account in categorizing shopify sales - that is Shopify sales sub account shopify sales income. 

    I am confuse as to why the deposits from the bank goes to clearing account.

    I'd like to mention also that when I received payment on my invoices, i used undposited funds and then create a bank deposits. I then matches this on the bank feeds.

    Did I do anything wrong in the process that lead the payment goes to shopify clearing account? 

    Angelyn_T
    Angelyn_TModerator
    Moderator
    August 28, 2021

    Thank you for getting back, Joan. Allow me to join the thread and share some information about handling your sales transactions in QuickBooks Online (QBO).

     

    Your process is correct. Yes, you can deposit the invoice payments into the undeposited funds if you're not yet ready to put them into your bank account. By the time you'll record a Bank Deposit, please make sure to pick the correct account from the Account drop-down to deposit the amounts accordingly.

     

    1. From the +New icon, select Bank Deposit under Other.
    2. Make sure to pick your bank account from the Account drop-down, not the clearing account.
    3. Select the payments you want to deposit.
    4. Save the transaction.

     

    I'm adding this article as an additional reference: Record and make bank deposits in QuickBooks Online.

     

    You can also review the topics from this link for more tips and resources while working with your sales and other customer transactions in the future: Topics about your company's income and customers.

     

    If you have any other follow-up questions about your deposit entries, notify me by adding a comment below. I'm more than happy to help. Keep safe!

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement