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?
A
akashdeep-bal-zo
July 14, 2022
Question

How to get Account Types list? Which Query is required?

  • July 14, 2022
  • 2 replies
  • 14 views
No text available

    2 replies

    Rubielyn_J
    Rubielyn_J
    Level 8
    July 14, 2022

    I'm here to walk you through how to get the Account type list in QuickBooks Online, @akashdeep-bal-zo.

     

    We can simply proceed to the Chart of Accounts menu to see lists of Account types. Let me show you how:

     

    1. Select the Accounting menu.
    2. Choose Chart of Accounts. 
    3. Click the New button.  
    4. From the Account Type drop-down you can see all the Account type lists. 

     

    Otherwise, you can also run the Account list report. For your reference, please see screenshot below:



     

    Additionally, I'll be attaching this link to help find out how to use account types and detail types in your chart of accounts: Learn about account types and detail types in QuickBooks Online.

     

    In case you have other questions generating account type lists, dont hesitate to comment below: Take care and have a wonderful day!

    A
    akashdeep-bal-zoAuthor
    July 14, 2022

    Thanks @Rubielyn_J  for your response I really appreciate it.

    But if I have to get Account type list from our Application then which query I have to execute for that.

    For example : To get list of Chart of Accounts I execute "select * from Account" query so, If I have to get list of Account Type then query I have to use?

    R
    RCVQuickBooks Team
    QuickBooks Team
    July 14, 2022

    Thanks for coming back, @akashdeep-bal-zo

     

    The information sent to QuickBooks Online (QBO) depends on what your third-party application shares with us. I'd recommend contacting their support on what Account Type you'll need to use to match with it in QBO. Here's an article you can refer to about using account types and detail types in your chart of accounts. 

     

    Once done with importing the transactions and when you're ready to reconcile your accounts to keep your QuickBooks accounts accurate. follow the steps below: 

    1. Go to the Gear icon in the upper-right.
    2. Click Reconcile under Tools.
    3. Select the correct account and add the following information that's shown in your bank statement.
    4. Tap Start reconciling.

     

    Additionally, you can also browse for the content of this helpful article so you can get back to your bank transactions after reviewing them: What are account registers in QuickBooks Online?

     

    If you have any other questions, you can always leave them in the comments below. I'll be here to address them. Have a great day ahead. 

      A
      akashdeep-bal-zoAuthor
      July 14, 2022
      No text available
      Need QuickBooks guidance?
      Log in to access expert advice and community support instantly.
      Terms & ConditionsAccessibility statement