QUICKBOOKS ONLINE 2024 BEGINNERS GUIDE-MLPT E-Book
QUICKBOOKS ONLINE 2024 BEGINNERS GUIDE-MLPT E-Book
QUICKBOOKS ONLINE 2024 BEGINNERS GUIDE-MLPT E-Book
BEGINNER’S
GUIDE
2024 TRAINING FOR
NEW BUSINESS OWNERS
WWW.MLPTSERVICES.COM
HI THERE, I'M DIANA ALVARADO
Diana Alvarado
MLPT CEO & QBO PRO ADVISOR
WWW.MLPTSERVICES.COM
TABLE OF CONTENTS
Welcome to the
QuickBooks Add your Company
Online 2024 Information 4
Beginner's Guide!
Setup your Chart of
Accounts 6
This comprehensive eBook is
designed to help you navigate the Setup your Products
world of QuickBooks Online with and Services 8
ease. Whether you're a small
Connect your Bank
business owner, freelancer, or
and Credit Cards 10
just getting started with financial
management, this guide will walk Connect/Integrate
you through 10 essential steps, your Apps 12
from setting up your company file
to mastering basic transactions Create an Invoice/ Record
and generating reports, each a Payment for an Invoice 13
chapter is crafted to provide
Create a Bill/ Record
clear, step-by-step instructions.
Payment for a Bill 17
Unlock the power of QuickBooks
Categorize Online
Online and streamline your Bank Transactions 21
financial tasks with confidence.
Let's embark on this journey Reconcile a Bank or
together and empower you to Credit Card Account 24
take control of your finances
effortlessly. Review Financial
Statements 28
STEP 1:
ADD YOUR COMPANY INFORMATION
WWW.MLPTSERVICES.COM PAGE 4
STEP 1 Continued:
ADD YOUR COMPANY INFORMATION
WWW.MLPTSERVICES.COM PAGE 5
STEP 2:
SETUPYOUR CHART OF ACCOUNTS
WWW.MLPTSERVICES.COM PAGE 6
STEP 2 Continued:
SETUPYOUR CHART OF ACCOUNTS
WWW.MLPTSERVICES.COM PAGE 7
STEP 3:
SETUP YOUR PRODUCTS AND SERVICES
WWW.MLPTSERVICES.COM PAGE 8
STEP 3 Continued:
SETUP YOUR PRODUCTS AND SERVICES
1. Select New.
2. Select Non-inventory
or Service.
3. Enter a Name for the
product or service
and an SKU, if you
track them.
4. From the Category
dropdown, select the
category that best
describes your
product or service.
WWW.MLPTSERVICES.COM PAGE 9
STEP 4:
CONNECT YOUR BANK AND CREDIT CARDS
WWW.MLPTSERVICES.COM PAGE 10
STEP 4 Continued:
CONNECT YOUR BANK AND CREDIT CARDS
WWW.MLPTSERVICES.COM PAGE 11
STEP 5:
CONNECT YOUR APPS
WWW.MLPTSERVICES.COM PAGE 12
STEP 6:
CREATE AN INVOICE
WWW.MLPTSERVICES.COM PAGE 13
STEP 6 Continued:
CREATE AN INVOICE
WWW.MLPTSERVICES.COM PAGE 14
STEP 6.2
RECORD PAYMENT FOR AN INVOICE
WWW.MLPTSERVICES.COM PAGE 15
STEP 6.2 Continued:
RECORD PAYMENT FOR AN INVOICE
WWW.MLPTSERVICES.COM PAGE 16
STEP 7:
CREATE A BILL
After you get a bill from a vendor, here's how to record it:
Click + New on the left hand navigation bar, then select
Bill.
WWW.MLPTSERVICES.COM PAGE 17
STEP 7 Continued:
CREATE A BILL
WWW.MLPTSERVICES.COM PAGE 18
STEP 7.2
RECORD PAYMENT FOR A BILL
There are two ways to record bill payments. If you have yet to pay
for the bill, you can schedule an online payment directly through
QuickBooks Bill Pay. Or, you can record a check, cash, or credit
card payment to keep your books accurate.
QuickBooks Bill Pay lets you send checks and ACH bank payments
quickly and easily (If you’re interested in this paid service, click
here).
WWW.MLPTSERVICES.COM PAGE 19
STEP 7.2 Continued:
RECORD PAYMENT FOR A BILL
WWW.MLPTSERVICES.COM PAGE 20
STEP 8:
CATEGORIZE ONLINE BANK TRANSACTIONS
After you connect your bank and credit card accounts (Step
4) QuickBooks Online automatically downloads the latest
transactions. For most banks, QBO will refresh the latest
available transactions every 24 hours. Some may take a little
longer. You can also manually update your accounts
anytime.
WWW.MLPTSERVICES.COM PAGE 21
STEP 8 Continued:
CATEGORIZE ONLINE BANK TRANSACTIONS
1. Select Update. This updates all of your bank and credit card
accounts.
2. Select the tile for the account you want to review.
3. Select the For review tab to start your review. QuickBooks
Online automatically suggests categories for these
transactions based on how you, and other customers,
categorized similar transactions.
WWW.MLPTSERVICES.COM PAGE 22
STEP 8 Continued:
CATEGORIZE ONLINE BANK TRANSACTIONS
WWW.MLPTSERVICES.COM PAGE 23
STEP 9:
RECONCILE A BANK OR CREDIT CARD ACCOUNT
To reconcile an account:
1. Go to Settings and then Reconcile. If you're reconciling
for the very first time, select Get started.
WWW.MLPTSERVICES.COM PAGE 24
STEP 9 Continued:
RECONCILE A BANK OR CREDIT CARD ACCOUNT
1. From the Account dropdown, select the account you want to reconcile.
Make sure it's the same one on your statement.
2. Make sure the Beginning balance in QuickBooks matches the one on your
statement. If you connect your bank and credit card accounts, QuickBooks
automatically downloads your historical transactions up to a certain date.
It totals them up and enters the opening balance and date for you. If you're
reconciling an account for the first time and the beginning balance is off,
skip to part 2 of Step 9.
3. Enter the Ending balance and Ending date on your statement. Some banks
call the ending balance a "new balance" or a "closing balance."
4. When you're ready to start, select Start reconciling.
WWW.MLPTSERVICES.COM PAGE 25
STEP 9 Continued:
RECONCILE A BANK OR CREDIT CARD ACCOUNT
WWW.MLPTSERVICES.COM PAGE 27
STEP 9.2
TROUBLESHOOT OPENING BALANCES
The opening balance is the
balance of your bank account
on the day you choose to start
tracking transactions. Most
beginning balance issues are
caused by an incorrect
opening balance.
Important: If you forgot to
enter an opening balance
when you created an account
AND have reconciled it, you
will need a professional to help
fix opening balance issues.
To manually enter an opening
balance for the first time (never
reconciled):
1. Make sure you know the
amount you need to enter
for your opening balance.
2. Go to Settings⚙ and select
Chart of accounts.
3. Select New, then set up
your account.
4. In the open balances
section, pick the date you
want to start tracking your
finances from.
5. Then, enter the account
balance for that date. Then
select Save.
WWW.MLPTSERVICES.COM PAGE 26
STEP 10:
REVIEW FINANCIAL STATEMENTS
WWW.MLPTSERVICES.COM PAGE 28
STEP 10 Continued:
REVIEW FINANCIAL STATEMENTS
WWW.MLPTSERVICES.COM PAGE 29
Believing in
yourself is the
first secret to
success
Thank You!
Are you looking for more support with
QuickBooks? We offer customized
packages for handling all of your
bookkeeping needs. We are QuickBooks
ProAdvisors & provide training and
consulting to clients.
Let's Connect!
@mlptservices.com
www.mlptservices.com
[email protected]
THIS EBOOK GUIDE IS INTENDED TO PROVIDE GENERAL INFORMATION
AND GUIDANCE ON TRAINING FOR QUICKBOOKS ONLINE IN THE YEAR
2024. WHILE EVERY EFFORT HAS BEEN MADE TO ENSURE THE
ACCURACY AND COMPLETENESS OF THE CONTENT, IT IS ESSENTIAL TO
NOTE THAT THE INFORMATION PROVIDED IS FOR EDUCATIONAL
PURPOSES ONLY.
BONUS:
QBO CHECKLISTS
WWW.MLPTSERVICES.COM
BOOKKEEPING CHECKLIST: Daily or Weekly
10. Make sure things look reasonable for your business. If you
need help reading your reports, set up a time and we’ll go
over them together!
QuickBooks Online
BONUS:
KEYBOARD
SHORTCUTS
WWW.MLPTSERVICES.COM
QuickBooks Online Hacks: Keyboard Shortcuts
Gone are the days of meticulously writing down each and every
transaction on a piece of paper and adding them up manually.
QuickBooks Online is here to make your life easier, and one of the
convenient features that help with this is keyboard shortcuts.
Here are some commonly used shortcuts to try (in alphabetical
order):
BONUS:
CHART OF
ACCOUNTS
WWW.MLPTSERVICES.COM
chart of accounts for a service/freelance business
1. Assets:
101 Cash
102 Accounts Receivable
103 Prepaid Expenses
104 Office Supplies
2. Liabilities:
201 Accounts Payable
202 Accrued Liabilities
3. Equity:
301 Owner's Equity
4. Revenue:
401 Service Revenue
5. Expenses:
501 Salaries and Wages Expense
502 Rent Expense
503 Utilities Expense
504 Office Supplies Expense
505 Advertising Expense
506 Depreciation Expense
507 Insurance Expense
508 Miscellaneous Expense
1. Assets:
101 Cash
102 Accounts Receivable
103 Inventory
104 Prepaid Expenses
105 Shipping Supplies
2. Liabilities:
201 Accounts Payable
202 Accrued Liabilities
203 Customer Refunds Payable
3. Equity:
301 Owner's Equity
4. Revenue:
401 Product Sales
402 Shipping Revenue
5. Cost of Goods Sold (COGS):
501 Cost of Goods Sold
6. Expenses:
601 Marketing and Advertising Expense
602 Website Maintenance Expense
603 Payment Processing Fees
604 Shipping Costs
605 Customer Service Expense
606 Software and Technology Expenses
607 Office Supplies Expense
7. Other Income:
701 Interest Income
chart of accounts for a healthcare practice
1. Assets:
101 Cash
102 Accounts Receivable
103 Medical Supplies Inventory
104 Equipment (e.g., medical equipment)
2. Liabilities:
201 Accounts Payable
202 Accrued Liabilities
203 Loans Payable
3. Equity:
301 Owner's Equity
4. Revenue:
401 Patient Consultation Fees
402 Procedure Fees
403 Insurance Reimbursements
5. Cost of Goods Sold (COGS):
501 Cost of Medical Supplies
502 Cost of Medical Equipment Depreciation
6. Operating Expenses:
601 Rent or Lease Expense (Office and Equipment)
602 Utilities Expense
603 Salaries and Wages Expense (Medical Staff)
604 Salaries and Wages Expense (Administrative Staff)
605 Employee Benefits Expense
606 Insurance Expense
607 Professional Fees (e.g., consulting, legal)
608 License and Certification Fees
609 Continuing Education Expenses
610 Marketing and Advertising Expense
611 Medical Software Expenses
612 Telecommunications Expenses
613 Office Supplies Expense
614 Travel and Lodging Expenses
615 Depreciation Expense
616 Repairs and Maintenance Expense
7. Other Income:
701 Grants or Research Funding
8. Taxes:
801 Sales Tax Payable (if applicable)
802 Payroll Taxes Payable
chart of accounts for a Nonprofit Organization
1. Assets:
101 Cash
102 Accounts Receivable (if applicable)
103 Prepaid Expenses
104 Investments
105 Property and Equipment
2. Liabilities:
201 Accounts Payable
202 Accrued Liabilities
203 Deferred Revenue (if applicable)
3. Net Assets (Equity):
301 Unrestricted Net Assets
302 Temporarily Restricted Net Assets
303 Permanently Restricted Net Assets
4. Revenue:
401 Contributions (Individuals)
402 Contributions (Foundations)
403 Contributions (Corporations)
404 Government Grants
405 Program Service Revenue
406 Membership Dues
407 Investment Income
5. Expenses:
501 Program Expenses (e.g., direct costs of programs)
502 Management and General Expenses
503 Fundraising Expenses
504 Occupancy Expenses
505 Salaries and Wages Expense
506 Employee Benefits Expense
507 Professional Fees (e.g., legal, accounting)
508 Office Supplies Expense
509 Travel and Lodging Expenses
510 Depreciation Expense
511 Insurance Expense
6. Other Income:
601 Gain on Sale of Investments
7. Taxes:
701 Tax-Exempt Interest Income
chart of accounts for a restaurant business
1. Assets:
101 Cash
102 Accounts Receivable
103 Inventory (Food and Beverages)
104 Prepaid Expenses
105 Equipment
2. Liabilities:
201 Accounts Payable
202 Accrued Liabilities
203 Loans Payable
3. Equity:
301 Owner's Equity
4. Revenue:
401 Food Sales
402 Beverage Sales
403 Catering Sales (if applicable)
5. Cost of Goods Sold (COGS):
501 Cost of Food Sold
502 Cost of Beverage Sold
6. Operating Expenses:
601 Rent Expense
602 Utilities Expense
603 Salaries and Wages Expense (Kitchen Staff)
604 Salaries and Wages Expense (Front of House Staff)
605 Employee Benefits Expense
606 Supplies Expense (e.g., napkins, condiments)
607 Marketing and Advertising Expense
608 Insurance Expense
609 Repairs and Maintenance Expense
610 Depreciation Expense
611 Professional Fees (e.g., accounting, legal)
612 License and Permit Fees
613 Music Licensing Fees
614 Miscellaneous Expenses
7. Other Income:
701 Event Hosting Income (if applicable)
8. Taxes:
801 Sales Tax Payable
802 Payroll Taxes Payable