Skip to main content
December 26, 2018
Question

How do I set up a contra account or control the natural balance of a GL account in Quickbooks Online?

  • December 26, 2018
  • 4 replies
  • 0 views
Original commenter did not share additional details

4 replies

Rustler
December 27, 2018

a contra account is an account that typically carries the opposite balance of that type of account

 

sales income records the full amount of sales (credits)
sales income discount (a contra account) records discounts given (debits)

 

so sales income less sales income discount = gross sales

 

would you restate your question and describe what you are wanting to do

November 23, 2019

The question wan't what is it...it was...how to you set it up in QBO.

February 6, 2020

I need help with this as well.  Quickbooks also has the worst phone support on the planet.  Worst that Microsoft.  That is horrible. 

 

How do you create these accounts?

September 18, 2020

There is no answer to contra accounts...best i can guess is that QB does NOT have the ability. 

. please, everyone, do not waste your time reading this tread like i did.  

November 7, 2020

It's not like the question was asked in a foreign language. What's wrong with these people?!

February 13, 2021

Setting up Contra Accounts is fairly easy although it does take a bit of preplanning.

 

Yes it does make a difference on how you go about setting up the Contra Account depending on whether you want to affect the Income or Expense section of the P&L.

 

First, I will show you two Contra Accounts that have already been created and in use that affect Gross Sales.

 

 

 

The key here (i.e., the trick) is that the box explaining that this product is sold has been chosen. This designation assigns it to Sales Income.

 

Setting up a Cost of Services (COG) account that will decrease Gross Sales and result in lower Net Revenue / Net Sales on the P&L is similarly to how the photos above depict the steps.

 

However, since I want to have a subtotal on the P&L of Sales Income that represents Gross Sales - Refunds - Commissions/Referrals, I will not make the COG a subcategory of the Sales Income COA.

 

In fact, QBO has a distinct Account Type named COG that will be used.

 

Now comes the tricky part (at least for me in this particular case). Since I want to record third-party vendors services provided to me that are a part of the direct cost of providing the service I sell to my customers, I am going to create a Product / Service that I buy (not sell) and map it to the COG Account I just created. 

 

See below and compare this contra account to the previous two show above. All three n

 

So the steps in the order to be taken for a contra account that affects Income and be labeled as COG or Cost of Services are as follows:

 

1. Create the requisite COA using COG account type.

2. Create the Product / Service you want to designate to be used for this Direct Cost and map it to the COA created above.

2A. Check the box I sell this product/service if you need to assign to a Customer Invoice.

2B. Check the box I buy this product/service if you need to assign to a Vendor Invoice.

 

My apologies for not addressing the specific question about Accumulated Depreciation.

 

 

Hope this discussion helps someone who comes across this thread like I did a few hours ago and couldn't find the answer I was expecting to see that would confirm the approach I've been taking.

 

Best Regards

 

mkm2

 

April 3, 2023

This might be a good answer for QBO, but I have Quickbooks Premier Plus 2023 - Desktop.

The screens are completely different on the desktop version versus QBO.

So, how to I setup a contra account in QB Premier Plus Desktop 2023?

 

Thank you. 

Kevin, CPA

February 1, 2023

I think the makers of QBO should consult an accountant to understand what a contra account is and then to consult the nerds (a term of love, trust me - I married one and are surrounded by many and the world would be a much darker place without them) on how to code that into the program. This is not a hard concept. Come on guys! Do what you do and fix this in the software. Jeez.

April 3, 2023

I agree with this comment 100%.  The product we get is written by computer people who have no clue what accounting is, further, there appears to be no input from CPA's and Accountants.

One more thing...try reversing a GJE in QB Premier Plus.  You can't do it in the GJE screen.

April 3, 2023

I'd love to show you the way and set up an account in QuickBooks Desktop, @khatfieldcpa.

 

Yes, you're right. QuickBooks Online has different interphase and features compared to QuickBooks Desktop. Moving forward, follow the steps below for the complete process of an account set up in the QuickBooks Desktop version.

 

Here's how:

 

  1. Go to the Lists menu, then select Chart of Accounts.
  2. From the Account ▼dropdown, select New.
  3. Select an account type, then Continue.
  4. Complete the account details.
  5. Select Save & Close.

 

Furthermore, you can create different account types in the chart of accounts. See this article for your guide: Work with the chart of accounts in QuickBooks Desktop.

 

Additionally, QuickBooks Desktop can generate account numbers for every account type. Do you need to have one? Visit this link as your reference: Add, edit, or delete accounts in QuickBooks Desktop.

 

Let me know if you have other concerns about your financial records. I'll be here to assist you more. Thank you for your time.