Smart Tools Better Business.


You can also include a column for account number if you wish. The spreadsheet can contain other columns, but they won’t be imported into QuickBooks Online. The first line of the spreadsheet should contain a label for each column, which doesn’t necessarily have to match the field name in QuickBooks Online. Learn how to create an Intuit Account and connect all of your Intuit products. QuickBooks and Intuit are a technology company, not a bank. Banking services provided by our partner, Green Dot Bank.


Next, click the green New button in the upper right corner of the screen to access the account setup window for your new account. QuickBooks Online mobile access is included with your QuickBooks Online subscription at no additional cost. Laura was awarded 2019 Top Client Accounting Services Proadvisor. She is the founder of Redmond Accounting Inc and Aero Workflow and is a member of Intuit’s Trainer / Writer Network. RAI is a boutique accounting firm whose service delivery is centered solely on QuickBooks Online and its eco-system of apps. Aero Workflow is used by accounting firms to distribute their knowledge capital and manage service delivery.

How to Edit an Account in the Chart of Accounts List

Intuit reserves the right to change these hours without notice. Terms, conditions, pricing, service, support options, and support team members are subject to change without notice. $5/month for Core, $8/month for Premium, and $10/month for Elite. Contractor payments via direct deposit are $5/month for Core, $8/month for Premium, and $10/month for Elite. If your business requires tax calculation and/or filing in more than one state, each additional state is $12/month for Core and Premium. There is no charge for state tax calculation or filing for Elite.


There is no need to download QuickBooks Online because it is connected to the cloud, which means you can access online accounting from any device with an internet connection. You can download the QuickBooks Online mobile app from the Google Play Store or Apple App Store. If you have to open a new QBO account, make sure to click the Buy button to get the discounted price for up to 6 months. If you purchase from the trial account, you have to pay the regular rate. After selecting your spreadsheet, click the green Next button in the bottom right corner of the screen . Your spreadsheet must contain columns for the account name, account type, and detail type.

How QuickBooks Creates and Classifies Accounts

If you’re an accountant or ProAdvisor, use QuickBooks Online Accountant to connect to your clients’ accounts. This version of QuickBooks lets you review their books, edit transactions, and fix issues. It also gives you enhanced bookkeeping toolsand access to ProAdvisor benefits. After verifying the information is correct, click the green Import button to complete the importing process.


You can also sign up for a one-time expert setup with a Live Bookkeeper to get started on the right foot. Imported accounts will add to—not replace—your current chart of accounts. Congratulations on completing another tutorial on QuickBooks Online where you learned to add, edit, delete, and import accounts for your chart of accounts list. The next tutorial in our QuickBooks Online Training Course is How To Set Up the Products and Services List. The list of product and service items in QuickBooks Online is extremely important and is central to how QuickBooks simplifies the bookkeeping process.

Laura has co-authored many of’s QuickBooks Online certification programs. From the Chart of accounts screen, click the drop-down arrow next to the green New button and select Import. From the chart of accounts screen, click the Run Report button on the top right side of the screen to view a copy of your chart of accounts. The fields available in the account setup screen are the same as discussed in the previous section.

Find an accountant

For those who don’t have an cash flow frog yet, you can choose between a 30-day free trial or 50% off for three months. In this tutorial, you’ll learn how to add, delete, and modify accounts in the QuickBooks Online Chart of accounts list. We’ll also teach you how to import a chart of accounts from an Excel spreadsheet or comma-separated values file. Once your bookkeeper receives all the necessary documentation, they’ll typically complete your cleanup within 30 days. In some cases, your cleanup may take longer depending on timeliness of documentation and the complexity of your books. QuickBooks Payments account subject to eligibility criteria, credit and application approval.

Similarly, your inventory account must have Detail Type “Inventory” so that QuickBooks Online knows which account to increase when you purchase products. When you’re satisfied with your mapping, click the green Next button. The final screen before importing provides your last opportunity to change any account information or deselect any accounts you don’t wish to import. QuickBooks Online won’t import an account if there’s another account with the same name either already in your chart of accounts or import file. After importing your accounts, QuickBooks Online will provide a list of accounts that didn’t import due to duplicates.

In the example above, Paul’s Plumbing is making account number 1120, Company Savings Account, inactive. Since the account has been used in at least one transaction, the account will still count toward the maximum number of accounts Paul’s Plumbing can use. Instead of deleting accounts in QuickBooks Online, you must mark them as inactive. If the account has never been used in a transaction, the account will no longer count toward your maximum number of accounts. If the account has been used in a transaction, the history of the account will be retained, and the account will continue to count toward your maximum. Tim is a Certified QuickBooks Time Pro, QuickBooks ProAdvisor, and CPA with 25 years of experience.

He brings his expertise to Fit Small Business’s accounting content. We’ll send you a link with instructions to verify your email address. Follow these steps if you need to access and manage your personal data from your Intuit Account. Now that business is expanding, get tools to simplify new demands and set everyone up for success.


For each QuickBooks Online Field, select the column in your spreadsheet that contains the data. After clicking Run Report, a copy of your chart of accounts appears. You can then export your chart of accounts to an Excel file, print it out, or email it if needed. From the Chart of accounts screen, click the drop-down arrow next to View register for the account you wish to make inactive.

How to Use QuickBooks Online: Step-By-Step Guide –

How to Use QuickBooks Online: Step-By-Step Guide.

Posted: Thu, 16 Feb 2023 08:00:00 GMT [source]

Because the chart of accounts is the backbone of your bookkeeping system, it pays to take time now to make sure your list of accounts is complete and appropriate for your business. We recommend having at least the following accounts included in your chart of accounts. Create an Intuit Account to manage your data, subscriptions, privacy, and other settings for all of your QuickBooks Online, TurboTax, and Mint products. Use this account any time you want to sign up for a new QuickBooks or TurboTax product.

Make the needed changes to the account and then click the green Save and Close button. To edit an existing account, find the account on the Chart of accounts screen and click the drop-down arrow next to View register. You enter an email address when you first sign up for products like QuickBooks Online or TurboTax.


Ask questions, get answers, and join our large community of QuickBooks users. If your monthly average is $50,001 or more, the monthly price for QuickBooks Live is $400. If your monthly average is $10,001-50,000, the monthly price for QuickBooks Live is $300. If your monthly average is $0-10,000 per month, the monthly price for QuickBooks Live is $200. If you invoke the guarantee, QuickBooks will conduct an evaluation of the Live Bookkeeper’s work.

Intuit Launches New QuickBooks Small Business Index in … – Kenneth C. Griffin Department of Economics

Intuit Launches New QuickBooks Small Business Index in ….

Posted: Tue, 14 Mar 2023 19:28:08 GMT [source]

When you are satisfied with your answers, click either the green Save and Close button or the drop-down arrow next to it and select Save and New to add another account. The user will need to check with their accountant regards setting up accounts in QuickBooks Online. Once they have it set up they can then link the accounts to the appropriate sections in Clio.

Leave a comment

Your email address will not be published. Required fields are marked *