Close this search box.

QuickBooks Desktop Chart of Accounts – Complete Tutorial


In this video we show to you a complete tutorial of how chart of accounts in QuickBooks Desktop works


Table of Contents:

  • 00:00:00 – Intro (chart of accounts inside QuickBooks Desktop)
  • 00:01:00 – Chart of accounts (3 ways to get to chart of accounts)
  • 00:02:22 – How to Identify a balance sheet account from a profit & loss account
  • 00:03:21 – Company checking account
  • 00:05:12 – How to record an item in the chart of accounts (example) (account button, new) (add new account) (asset or liability) (enter opening balance)
  • 00:08:54 – Reports (profit & loss)
  • 00:09:41 – Make deposits (example)
  • 00:10:40 – How to merge accounts or make one subaccount of the other (example) (edit income account) (disappear redundant)
  • 00:13:07 – How to make some accounts inactive
  • 00:14:21 – Customize report (modify report: profit & loss) (advanced options)
  • 00:15:22 – How to delete or keep inactive the account and “use it once” option
  • 00:18:32 – How to sort profit & loss by total (ignoring the alphabetical order) or by default (organize or reorganize accounts) (Account, re-sort list)
  • 00:20:55 – Preferences (company preferences, use account numbers) (to see in chart of accounts the account number of every account) (edit account) (change location)
  • 00:24:00 – Edit account (changing account type) (example) (balance sheet accounts and profit & loss accounts) (issues may affect your profitability)
  • 00:26:20 – Tax-line mapping
  • 00:27:47 – Reports (accountant & taxes) (income tax preparation) (income tax summary)
  • 00:29:25 – Company tab (my company) (edit) (report information) (income tax form used)
  • 00:30:49 – Account (find transactions in) (shortcut)
  • 00:31:35 – Account button (flat view/hierarchical view options)
  • 00:34:17 – Description (click on the chart of account, customize columns)
  • 00:34:53 – Reports (list, account listing)
  • 00:35:44 – Reports & graphs (company preferences, name only/name descriptions)
  • 00:36:43 – How to export and import chart of accounts (file, utilities, export/import, lists to IIF files)
  • 00:37:50 – Excel CSV file (import chart of accounts to the file dragging it) (how to add accounts in excel, duplicate, replace)
  • 00:40:10 – How to import the chart of accounts changes in excel to QuickBooks Desktop (file, utilities, import, IIF files, select the file and open)
  • 00:40:56 – Spreadsheet (Maximum 31 characters account name/maximum 7 characters account number)
  • 00:42:26 – How to import a chart of accounts from excel to QuickBooks Desktop (file, utilities, import, excel files) (advanced import) (import a file) (browse) (select file) (create mapping) (import) (step by step)
  • 00:45:26 – How to import the balances (example) (they have to be brand new accounts in CSV) (step by step)
  • 00:48:08 – Error import
Hector Garcia

Hector Garcia

Use our link to get 30% off for a year, valid through 07/31/2022

Leave a Reply

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

Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course


30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022