
Master QuickBooks desktop basics to streamline financial management, perform data entry and reconciliation, generate clear financial statements, and customize company files, accounts, and transactions.
Explore Flourish Bakeries' financial story by examining assets, liabilities, income, expenses, and owner's equity. See how QuickBooks desktop supports loan tracking and revenue analysis for a thriving Seattle bakery.
Navigate the QuickBooks desktop 2024 interface, exploring the file menu, centers for vendors, customers, and employees, and the reminder bar, home, insights, and navigation bar.
Open or restore an existing QuickBooks company file from the recent list, locate the latest file, and verify the current company at the top before setting up a new one.
Set up a new QuickBooks company file via file open or new company, then Start Setup. Enter business details, choose industry, provide EIN or DBA, and Create Company.
Learn how to securely back up and restore QuickBooks company files using local backups, scheduled reminders, and external storage options, including date and time stamps and multiple backup copies.
Learn to edit your company information in QuickBooks using the pencil icon in the my company dialog, updating website, EIN, tax forms, and payroll details with changes taking effect immediately.
Explore chart of accounts customization in QuickBooks to categorize transactions, set up income and expense accounts, and manage accounts payable/receivable for precise tax reporting.
Add bank accounts and credit cards in QuickBooks by creating chart of accounts entries, naming the accounts, and entering opening balances. Ensure accurate reconciliation with ending balances and routing numbers.
Add a service item for baking classes and an inventory part in QuickBooks to enable seamless invoicing and sales tracking for Flourish Bakeries.
Explore the fixed asset manager in QuickBooks to track depreciation and value of physical assets, create asset accounts, log purchases, serials, warranties, and sales, and manage vehicles and billable mileage.
Learn to set up and customize customer and vendor profiles in QuickBooks, including messages, customer types, payment methods, terms, and vendor types, to streamline business operations.
Learn to create and edit customers, vendors, and employees in QuickBooks using the centers to manage profiles, transactions, and notes, with Excel or manual data entry.
Create detailed estimates in QuickBooks for baking classes by adding line items, applying taxes, and sharing personalized pricing with customers.
Learn how to set up QuickBooks for purchase orders, assign preferred vendors, and create and manage orders for baking classes, ensuring accurate ship-to address and cost of goods sold accounts.
Master the invoicing workflow by creating blank invoices, adding items and a subtotal, and customizing recipient details, terms, and taxes to ensure accurate, timely billing.
Learn to receive payments and print receipts in QuickBooks, processing cheques against invoices, updating customer balances, and using undeposited funds for end-of-day deposits to support bank reconciliation.
Learn to create sales receipts for cash transactions in QuickBooks, manage walk-in sales, itemize purchases, select customers, apply payment methods, and track undeposited funds.
Identify overdue invoices via reminders or the customer center, then send tailored statements in QuickBooks to selected customers with adjustable date ranges and a preview before printing or emailing.
Master managing credit card charges and printing checks in QuickBooks to streamline vendor payments, account allocations, and billable expenses with voucher or wallet style customization, including logos and signatures.
Record deposits in QuickBooks to reflect bank transactions, manage overdue invoices, and send statements to customers, using undeposited funds, reminders, customer center, and statement previews for efficient reconciliation and communication.
Learn how to void invoices and other line items in QuickBooks, preserving records, not affecting balances, and managing voided checks and bills through a clear, reference-ready workflow.
Reconcile bank accounts in QuickBooks to align statements with the check register. Select the account, set the statement date, and mark transactions until the ending balance matches the cleared balance.
Navigate the QuickBooks Report Center, run standard and detailed profit and loss reports, and customize ranges, columns, and filters for targeted financial insights.
Learn to draft essential financial reports and share insights by customizing profit and loss reports with filters, memorizing layouts, and exporting data to Excel for collaborative decision making.
Master QuickBooks Desktop to streamline Flourish Bakeries' finances, from setting up and backing up company files to daily tasks like estimates, invoicing, and reconciliations.
Master financial management with QuickBooks Online by learning data entry, bank reconciliation, and preparing the balance sheet, income statement, and cash flow statement.
Watch this video for essential training information, learn how to access downloadable instructor files, unzip them, and optimize video playback and review prompts for a smooth learning experience.
Explore Flourish Bakers' financial story from assets and liabilities to revenue, expenses, and owner's equity, and learn how QuickBooks online streamlines dashboards, invoicing, bank reconciliation, and reports.
Explore the QuickBooks Online interface, set up your account, customize the left navigation, use tabs and bookmarks, and access the plus button for transactions and settings with the gear icon.
Explore QuickBooks online account and settings to customize company details (logo, name, tax identification number, entity type), billing and subscriptions, sales, expenses, payments, security, multi-currency, locations, classes, projects, tax forms.
Create and manage customers, vendors, and 1099 subcontractors in QuickBooks Online, configuring details, opening balances, and 1099 track payments for accurate financial records.
Explore how chart of accounts acts as the financial backbone in QuickBooks Online, categorizing assets, liabilities, equity, income, and expenses to power balance sheets, income statements, and cash flow reports.
Explore the chart of accounts in QuickBooks online, from bank to retained earnings. Learn to create accounts, track invoices, depreciation, and liabilities across assets and equity.
Set up service and non-inventory items in QuickBooks online, creating service items with hourly rates and mapping revenue accounts. Learn to craft non-inventory products like leisure goods for sales tracking.
Learn how to link QBO with bank accounts, either by connecting your bank or uploading transactions, to keep the feed current and enable accurate classifications and reports.
Learn to create sales receipts in QuickBooks Online, record deposits as income, and distinguish sales receipts from invoices, including how to deposit by customer and use bank deposits.
Record expenses paid from bank accounts and credit cards in QuickBooks Online. Select payees or vendors, add new ones, choose payment accounts, attach receipts, and categorize expenses.
Navigate QuickBooks online to issue checks, whether handwritten or printed, selecting payees, bank accounts, and categories, then batch print and customize templates for efficient expense tracking.
Explore inter-bank transfers between checking and savings, and pay down a credit card by transferring funds from a bank account to the card in QuickBooks Online.
Categorize bank feed transactions in QuickBooks online under the appropriate chart of accounts, using linking, csv uploads, and rules to streamline categorization and matching.
**This bundle includes practice exercises, downloadable files, and LIFETIME access**
Welcome to The Ultimate Accountant Productivity Bundle, a meticulously curated course collection designed to elevate your understanding and application of QuickBooks, financial modeling, risk management, and Excel for data analysis.
Whether you use QuickBooks Desktop or the Online version, this great-value six-course bundle has you covered. It also gets you full access to courses on financial forecasting and modeling, financial risk management, and Excel for accountants, to help boost your accounting and business productivity.
The only prerequisites to these courses are a basic understanding of finance and accounting, access to the applications used and taught in this bundle, and an eagerness to learn.
QuickBooks Desktop 2024
Understand the importance of QuickBooks for managing finances in business.
Navigate QuickBooks Desktop confidently to manage files, users, and backups.
Customize QuickBooks Desktop for specific company and business needs.
Perform daily operations seamlessly, including creating estimates, invoicing, and managing payments.
Develop skills to streamline financial processes and make informed decisions.
QuickBooks Online Beginners
Recognize QuickBooks Online's role in efficient transaction recording.
Navigate QuickBooks Online and set up companies and chart of accounts.
Customize QuickBooks Online for specific company needs.
Perform tasks like creating estimates, invoicing, and managing payments.
Analyze financial statements for informed decision-making.
Accurately reconcile bank statements.
Gain practical skills by simulating a company in QuickBooks Online.
Utilize QuickBooks Online for optimized accounting and decision-making.
QuickBooks Online Intermediate
Customize the QuickBooks Online interface.
Reconcile bank accounts with QuickBooks Online.
Create and analyze detailed financial reports.
Integrate third-party apps with QuickBooks Online to automate tasks.
Track income and expenses by project using the Projects feature.
Automate recurring transactions to reduce manual work and minimize errors.
Manage inventory and non-inventory items.
Financial Forecasting and Modeling
The basics of financial modeling and forecasting using Excel.
The purpose of financial forecasting.
How to build a sound financial model.
The role of forecasting in strategic planning.
How to go through the three financial statements (balance sheet, income statement, and cash flow statement).
How to define your forecasting objectives.
Identifying key variables and drivers.
Analyzing financial forecasts using ratio analysis.
Future trends in forecasting.
Financial Risk Management
Distinguish between risk, uncertainty, and randomness.
Understand the importance of risk governance.
Describe risk budgeting and understand its role in risk governance.
Recognize the difference between idiosyncratic and systematic risks.
Define, classify, and distinguish between financial risks.
Identify and understand the principles of credit, foreign exchange, interest rate, and operational risk.
Distinguish between risk prevention and avoidance.
Define and apply the concepts of self-insurance, risk shifting, and risk transfer.
Realize insurance as a way to transfer risks.
Recognize outsourcing and derivatives as two ways of shifting risk.
The Accountants Excel Toolkit
Navigate and format data in Excel efficiently and grasp Excel formulas and functions.
Import and deduplicate files using advanced functions like XLOOKUP.
Understand accounting principles and the accounting cycle.
Understand the fundamentals of assets, expenses, liabilities, and income.
Record journal entries for assets, expenses, income, and liabilities.
Link accounts in QuickBooks Online, ensuring consistently updated records.
Prepare a trial balance and pass adjusting entries at the end of an accounting period.
Develop an insightful overview of financial statements.
Decode a company's financial health through various ratio analyses.
Efficiently reconcile accounts using both Excel and QuickBooks Online.
This course bundle includes:
22 hours of video tutorials
180+ individual video lectures
Course files to follow along
Certificate of completion