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
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.
Subscribe to latest coupons on our
Telegram channel.
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
Introduction
Introduction
Personal QuickBooks File-Set Up & Enter Data For First Month
2 Personal QuickBooks File-Set Up & Enter Data For First Month
520 Set Up New QuickBooks Personal File
QuickBooks Backup FIles
PDF – Credit Card Statement – January
525 Add Checking Account & Beginning Balance Personal QuickBooks
530 Enter Business Deposits From Personal Bank Statement January
PDF – Credit Card Statement – January
535 Enter Personal Cash Outflows Transfer to Business Checking, Entertainment, &
540 Enter Personal Cash Outflows Credit Cards, College Costs, & Phone January
545 Enter Personal Cash Outflows Mortgagee, Medical, & IRA January
550 Bank Reconciliation Personal Account January
555 Print Reports Personal Account January
Accounting Comic Break
Separate Business QuickBooks File-Set Up & Enter Data For First Month
3 Separate Business QuickBooks File-Set Up & Enter Data For First Month
420 Set Up New QuickBooks Business File
QuickBooks Backup File
PDF – Bank Statement Business Account – January
425 Add Checking Account & Beginning Balance
430 Enter Business Deposits From Business Bank Statement January
435 Enter Business Outflows From Business Bank Statement January
440 Bank Reconciliation Business Account January
445 Print Reports Business Account January
Accounting Comic Break
Compare Separate Business & Personal QuickBooks Files For First Month
4 Compare Separate Business & Personal QuickBooks Files For First Month
QuickBooks Backup Files
610 Compare Business & Personal January
Accounting Comic Break
Personal QuickBooks File-Enter Data For Second Month
5 Personal QuickBooks File-Enter Data For Second Month
QuickBooks Backup Files
PDF – Bank Statement – Personal Account – February
745 Enter Business Deposits From Personal Bank Statement February
PDF – Credit Card Statement – February
747 Enter Personal Cash Outflows Food, Personal Books, & Charity February
750 Enter Personal Cash Outflows Credit Cards, College Costs, & Phone February
757 Enter Personal Cash Outflows Mortgagee, Medical, & Utilities February
760 Bank Reconciliation Personal Account February
762 Print Reports Personal Account February
Accounting Comic Break
Separate Business QuickBooks File-Enter Data For Second Month
6 Separate Business QuickBooks File-Enter Data For Second Month
QuickBooks Backup Files
PDF – Bank Statement – Business Account – February
722 Enter Business Deposits From Business Bank Statement February
724 Enter Business Outflows From Business Bank Statement February
726 Bank Reconciliation Business Account February
728 Print Reports Business Account February
Accounting Comic Break
Compare Separate Business & Personal QuickBooks Files For Second Month
7 Compare Separate Business & Personal QuickBooks Files For Second Month
QuickBooks Backup Files
772 Compare Business & Personal February
Accounting Comic Break
Make Copy of Personal File
8 Make Copy of Personal File
Copy Personal QuickBooks File
Accounting Comic Break
Track Investments In Personal QuickBooks File
9 Track Investments In Personal QuickBooks File
QuickBooks Backup Files
PDF – Investment Statements
Use QuickBooks File Q1
Q1 842 Record Investment At Cost Using One Account Personal QuickBooks
Q1 844 Record Investments At Market Using One Account Personal QuickBooks
Q1 846 Record Investment Activity For January No Effect On Income Statement Pers
Q1 847 Record Investment Activity For January Increasing Other Income Personal Q
Q1 848 Record Investment Activity For February Increasing Other Income Personal
Use QuickBooks File Q2
Q2 852 Record Investments At Cost & Market Value December Personal QuickBo
Q2 853 Record Investments At Cost & Market Value December Separate Accounts Pers
Q2 854 Record Investments At Cost & Market Value January Separate Accounts Perso
Q2 856 Record Investments At Cost & Market Value February Separate Accounts Pers
Accounting Comic Break
Track Home Value In Personal QuickBooks File
10 Track Home Value In Personal QuickBooks File
QuickBooks Backup File
Use QuickBooks File Q1
Q1 882 Record Home At Cost Personal QuickBooks
Q1 884 Record Home Increase In Value Personal QuickBooks
Use QuickBooks File Q2
Q2 892 Record Home At Appraised Value Using Two Accounts Personal QuickBo
Accounting Comic Break
Enter Home Loan / Mortgage In Personal QuickBooks File
11 Enter Home Loan Mortgage In Personal QuickBooks File
QuickBooks Backup File
Amortization Schedule – Home Loan
Use QuickBooks File Q1
Q1 902 Record Home Loan Adjust To Loan Statement Personal QuickBo
Use QuickBooks File Q2
Q2 905 Record Home Loan & Make Amortization Table Personal QuickBo
Q2 907 Record Home Loan & Adjust Loan Payments Personal QuickBooks
Accounting Comic Break
Enter W-2 Employee Income In Personal QuickBooks File
12 Enter W-2 Employee Income In Personal QuickBooks File
QuickBooks Backup File
PDF – Paycheck Stub
Use QuickBooks File Q2
Q2 910 Record Paycheck Personal QuickBooks
Accounting Comic Break
Enter Credit Card Purchases, Payments, & Liabilities In Personal QuickBooks File
13 Enter Credit Card Purchases, Payments, & Liabilities In Personal QuickBooks F
QuickBooks Backup Files
PDF – Credit Card Statement – January & February
Use QuickBooks File Q2
Q2 915 Credit Card Liabilities Personal QuickBooks
Accounting Comic Break
Enter Auto Value & Loan In Personal QuickBooks File
14 Enter Auto Value & Loan In Personal QuickBooks File
QuickBooks Backup Files
Use QuickBooks File Q1
Q1 917 Auto – Simple Method Personal QuickBooks
Use QuickBooks File Q2
Q2 919 Auto – Record & Depreciate Personal QuickBooks
Accounting Comic Break
Allocate Insurance & Prepaid Expenses In Personal QuickBooks File
15 Allocate Insurance & Prepaid Expenses In Personal QuickBooks File
QuickBooks Backup File
Use QuickBooks File Q2
920 Allocate Insurance Costs Personal QuickBooks
Accounting Comic Break
