Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

QuickBooks Desktop Pro -Personal Bookkeeping-Accounting

Name: QuickBooks Desktop Pro -Personal Bookkeeping-Accounting
Rating: 4.3 (202 reviews)

QuickBooks for personal bookkeeping, finance, and accounting. Enter personal financial data, financial Statements

Created byRobert (Bob) Steele

Last updated 4/2020

English

What you'll learn

How to track personal bookkeeping, financial data, & tax information using QuickBooks
How to create and analyze personal financial statements from QuickBooks including a balance sheet and income statement or profit and loss
How to set up a personal QuickBooks file and enter the chart of accounts
How to enter personal data into QuickBooks, setting up new accounts as is needed, using a personal bank statement
How to track business financial data in a separate QuickBooks file and record intercompany transactions, those between a personal account and a business account
How to track and record personal investment data using QuickBooks
Hot to track personal home valuation using QuickBooks
How to record home loan balance and related payments of both interest and prinipal
How to enter W-2 wages into personal QuickBooks files, breaking out gross pay and withholding amounts
How to enter and track personal credit card payments and balances using QuickBooks
How to track auto valuation using QuickBooks
Methods for tracking prepaid amounts such as insurance using QuickBooks

Course content

15 sections • 110 lectures • 9h 25m total length

Introduction11:33

2 Personal QuickBooks File-Set Up & Enter Data For First Month1:51
520 Set Up New QuickBooks Personal File7:37
QuickBooks Backup FIles1:46
Download, unzip, and organize QuickBooks backup files for business and personal data, then restore qb files to access the appropriate prior dataset for each practice section.
PDF - Credit Card Statement - January0:02
525 Add Checking Account & Beginning Balance Personal QuickBooks9:49
530 Enter Business Deposits From Personal Bank Statement January16:17
Enter personal deposits from January into a separate QuickBooks file, classifying W-2 income, tax refunds, Amazon book royalties, interest, and miscellaneous income; verify with the profit and loss.
PDF - Credit Card Statement - January0:02
535 Enter Personal Cash Outflows Transfer to Business Checking, Entertainment, &23:21
540 Enter Personal Cash Outflows Credit Cards, College Costs, & Phone January22:21
Enter personal cash outflows in quickbooks, including credit card payments, college costs, and phone, from bank statements for accurate reconciliation and tax purposes.
545 Enter Personal Cash Outflows Mortgagee, Medical, & IRA January22:09
550 Bank Reconciliation Personal Account January12:40
Explore how to perform a January bank reconciliation in QuickBooks Desktop Pro for personal bookkeeping, entering the beginning balance, reconciling deposits and checks, and resolving data-entry differences.
555 Print Reports Personal Account January4:53
Accounting Comic Break0:14

3 Separate Business QuickBooks File-Set Up & Enter Data For First Month2:01
420 Set Up New QuickBooks Business File4:57
QuickBooks Backup File0:05
PDF - Bank Statement Business Account - January0:02
425 Add Checking Account & Beginning Balance10:16
430 Enter Business Deposits From Business Bank Statement January10:43
435 Enter Business Outflows From Business Bank Statement January13:47
Enter January bank outflows in QuickBooks, recording electronic transfers and checks, set up vendors and expense accounts, and review the balance sheet and profit and loss.
440 Bank Reconciliation Business Account January6:17
Perform a January bank reconciliation in QuickBooks desktop, verify deposits and checks against the bank statement, adjust the beginning balance, and review the reconciliation reports.
445 Print Reports Business Account January3:30
Accounting Comic Break0:14

5 Personal QuickBooks File-Enter Data For Second Month1:21
QuickBooks Backup Files0:05
Access QuickBooks backup files on the linked page and download them to support personal bookkeeping and accounting in QuickBooks Desktop Pro.
PDF - Bank Statement - Personal Account - February0:02
745 Enter Business Deposits From Personal Bank Statement February12:46
PDF - Credit Card Statement - February0:02
747 Enter Personal Cash Outflows Food, Personal Books, & Charity February8:28
Enter February cash outflows from bank statements into QuickBooks Desktop Pro bookkeeping file using the check register, electronic transfers, and vendor setup; review balance sheet and profit and loss reports.
750 Enter Personal Cash Outflows Credit Cards, College Costs, & Phone February8:57
757 Enter Personal Cash Outflows Mortgagee, Medical, & Utilities February5:22
760 Bank Reconciliation Personal Account February7:08
Perform a February bank reconciliation for a personal QuickBooks desktop account, verifying beginning and ending balances and matching bank statement transactions in a cash-based system.
762 Print Reports Personal Account February5:57
Accounting Comic Break0:14

6 Separate Business QuickBooks File-Enter Data For Second Month0:56
QuickBooks Backup Files0:05
PDF - Bank Statement - Business Account - February0:02
722 Enter Business Deposits From Business Bank Statement February6:13
724 Enter Business Outflows From Business Bank Statement February17:00
726 Bank Reconciliation Business Account February4:10
728 Print Reports Business Account February3:46
Print February balance sheet as of a point in time and February income statement from the business account, compare January–February data, and save the reports for cross-file QuickBooks comparison.
Accounting Comic Break0:14

7 Compare Separate Business & Personal QuickBooks Files For Second Month0:42
Compare separate business and personal Quick Books files for the second month, examining intercompany transactions and how payments between business and personal accounts are accounted in equal and opposite ways.
QuickBooks Backup Files0:05
Access a page containing QuickBooks backup files and download them to secure your desktop bookkeeping data.
772 Compare Business & Personal February14:13
Compare two QuickBooks files for business and personal accounts, generate balance sheet and profit and loss for January through February 2020, and analyze intercompany transfers, equity, and draws.
Accounting Comic Break0:13

9 Track Investments In Personal QuickBooks File1:00
QuickBooks Backup Files0:05
PDF - Investment Statements0:02
Use QuickBooks File Q10:09
Q1 842 Record Investment At Cost Using One Account Personal QuickBooks16:36
Q1 844 Record Investments At Market Using One Account Personal QuickBooks7:31
Q1 846 Record Investment Activity For January No Effect On Income Statement Pers9:47
Q1 847 Record Investment Activity For January Increasing Other Income Personal Q5:28
Q1 848 Record Investment Activity For February Increasing Other Income Personal7:35
Use QuickBooks File Q20:09
Q2 852 Record Investments At Cost & Market Value December Personal QuickBo16:46
Q2 853 Record Investments At Cost & Market Value December Separate Accounts Pers16:11
Record investments at cost and market value in QuickBooks for December, and break mutual funds into subaccounts for cost and unrealized gains/losses to show detailed portfolio value.
Q2 854 Record Investments At Cost & Market Value January Separate Accounts Perso12:52
Q2 856 Record Investments At Cost & Market Value February Separate Accounts Pers10:17
Record investments at cost and market value for February in separate investment accounts within QuickBooks, update investment statements, and adjust unrealized gains or losses on the balance sheet.
Accounting Comic Break0:14

Requirements

It would be best to have QuickBooks Desktop although this is not a requirement and many of the concepts will be applicable to QuickBooks Online and other accounting software.

Description

QuickBooks for personal bookkeeping, finance, and accounting. Enter personal financial data, create and analyze financial statements including personal balance sheet and income statements or profit & loss statement, & track important tax data.

The course will provide backup files that can be used to jump forward or to rework any component of the course. Backup files and the ability to use multiple QuickBooks files, in a similar way we use multiple Microsoft Word documents, is a HUGE benefit to learning QuickBooks and accounting that QuickBooks Desktop offers us. If our goal is to learn accounting concepts, bookkeeping, and or data input, we should take advantage of the use of backup files to improve our skills and gain new ones.

We will set up a new QuickBooks file explicitly designed for personal data entry and tracking, including a personalized chart of accounts.

The course will provide examples and practice problems to enter personal data into QuickBooks using a bank statement. We will provide example bank statements in PDF format that can be used to work the problem step by step along with instructional videos.

We will enter credit card data into QuickBooks from credit card statements. The course will provide PDF files of credit card statements.

The course will also set up a small QuickBooks business file as a comparison to the personal file, and to show how to account for intercompany or inter-QuickBooks file transactions. In other words, we will track transactions between the business and personal checking accounts in both the individual and business QuickBooks files.

We will track and record personal investments into QuickBooks, discussing various options and their pros and cons.

The course will discuss how to record and track home valuation in QuickBooks, as well as the tracking of home loans and the recording of payments that include both interest and principal.

We will cover the entering of W-2 wages into a personal QuickBooks file and the various methods we can use including breaking out the gross pay and the withholding amounts.

The course will discuss various methods for tracking and recording credit card payments and balances.

We will also discuss how to record and track the valuation of an automobile and how to enter and track prepayments like prepaid insurance

Who this course is for:

Anybody who wants to track personal financial data
Anybody who wants to organize tax data
Anybody who want to create personal budgets and financial plans
Anybody who want to understand their personal financial position better and how to create and analyze personal financial statements, including a balance sheet and income statement

QuickBooks Desktop Pro -Personal Bookkeeping-Accounting

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 12min

Personal QuickBooks File-Set Up & Enter Data For First Month13 lectures • 2hr 3min

Separate Business QuickBooks File-Set Up & Enter Data For First Month10 lectures • 52min

Compare Separate Business & Personal QuickBooks Files For First Month4 lectures • 18min

Personal QuickBooks File-Enter Data For Second Month11 lectures • 50min

Separate Business QuickBooks File-Enter Data For Second Month8 lectures • 32min

Compare Separate Business & Personal QuickBooks Files For Second Month4 lectures • 15min

Make Copy of Personal File3 lectures • 5min

Track Investments In Personal QuickBooks File15 lectures • 1hr 45min

Track Home Value In Personal QuickBooks File8 lectures • 26min

Requirements

Description

Who this course is for: