Description:
In this video we show to you a complete tutorial of how chart of accounts in QuickBooks Desktop works
Video:
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
