QuickBooks Online vs. QuickBooks Desktop vs. Excel

Explore QuickBooks Desktop options, including Pro, Premier Plus, and Enterprise, compare with online, assess features like inventory, reports, time tracking, payroll add-ons, and a free trial.

Learn how to download, install, and update QuickBooks Desktop 2023, via trial, purchase, or upgrading from 2022, and manage multiple company files.

Learn how to download, install, and use QuickBooks Desktop 2023, including options for a 30-day free trial or purchase, data file updates, and required IDs.

Install QuickBooks Desktop 2023 Pro Plus using the InstallShield wizard, and enter license codes for an express upgrade and clear organization of data, company, and backup files and their locations.

Learn to increase QuickBooks Desktop 2023 display size by adjusting Windows display scale (100% to 150%), using Windows 11 settings while working with a company file.

Build a comprehensive Excel accounting worksheet from data input and journal entries to trial balance and general ledger, including subsidiary ledgers and basic financial statements, with color-coded formatting.

In this Excel-based lecture, finish a trial balance using a two-tab workbook, apply debit–credit formulas, and use conditional formatting to track balance and calculate net income.

Build an excel-based accounting worksheet by entering transactions with debits and credits, posting to the trial balance and general ledger, and validating balances with a practical check.

Create and format an Excel accounting worksheet, input assets and liabilities including accounts payable, post transactions to trial balance and general ledger, using color coding and formulas for balances.

Build an accounting worksheet in Excel, creating a trial balance and general ledger from debits and credits. Use running balances and check figures to verify the ledger stays in balance.

Create an Excel accounting worksheet, building journal entries, trial balance, and general ledger, and develop subsidiary ledgers by customer and by vendor with check figures and conditional formatting.

Create an accounts payable subsidiary ledger in Excel by vendor, linking journal entries to the general ledger and trial balance, and maintain beginning balances with a check figure.

Build a functional inventory subsidiary ledger in excel, linking purchases, cost of goods sold, and ending inventory to the trial balance using the weighted average method.

Create a balance sheet in Excel from a trial balance, organizing assets, liabilities, and equity, with subledgers for accounts receivable, accounts payable, and inventory.

Create accounting worksheet part 10 guides building an Excel-based worksheet from a blank sheet, linking trial balance, journal entries, general ledger, inventory, balance sheet, income statement, and equity.

Build an Excel accounting worksheet from the trial balance to the balance sheet, income statement, and statement of equity, including drawers, investments, and beginning equity.

Explore the QuickBooks Online vendor, expense, purchases, pay, or AP cycle, including bills, accounts payable, and data input forms for accurate financial statements.

Explore the vendor cycle in QuickBooks Online, covering expenses, accounts payable, bills, paying bills, with bank feeds and journal entries.

Learn how to use QuickBooks Online 2024 bill forms to manage accounts payable, track vendors, and align bills with expenses, inventory items, or fixed assets.

Demonstrate QuickBooks Online accrual-based processes for entering bills, managing accounts payable, and paying bills via the pay bills form, contrasting expense and check forms in the vendor cycle.

Learn how QuickBooks Online 2024 handles purchase orders, vendor cycles, and perpetual versus periodic inventory to manage accounts payable and cost of goods sold from order to invoice.

Set up and manage sales tax in QuickBooks Online 2024, configure tax centers, rates, and agencies, handle tax payable, and apply exemptions across locations.

Learn how QuickBooks Online uses expense and check forms within cash and accrual workflows, bank feeds, and vendor cycles to produce accurate balance sheets and income statements.

Void a prior period check in QuickBooks Online with an audit trail, using a current-period journal entry to preserve retained earnings and ensure accurate bank reconciliations.

Learn how to download and open a QuickBooks Desktop sample file, distinguish data files from backup files, and organize or locate company data for efficient navigation.

Explore QuickBooks desktop 2023 home page navigation and open windows, with balance sheet and profit and loss reports.

Explore QuickBooks Desktop 2023 bank feeds, open data files, set date ranges, and generate balance sheet and income statement to understand data input and double entries.

Open QuickBooks Desktop 2023 preferences from the Edit menu, explore categories such as accounting, bills, calendar, desktop, and sales tax, and distinguish between the software and data file.

Explore the vendor cycle in QuickBooks Desktop 2023, using the vendor center and data input forms to manage accounts payable, enter bills, and affect the balance sheet and income statement.

Navigate QuickBooks Desktop 2023’s vendor center to enter and pay bills and track accounts payable. Access vendor data, view open bills, and print or export the vendor list for reporting.

Enter and manage vendor bills in QuickBooks Desktop 2023 using the bill form to increase accounts payable, record expenses, and track due dates in an accrual-based system.

Explore how QuickBooks Desktop 2023 uses the pay bill form and bill payment checks to manage accounts payable, vendor center, and accrual process, affecting the balance sheet and income statement.

Explore QuickBooks Desktop 2023 purchase orders to request inventory, track open orders, and link to bills, invoices, and vendor center, including perpetual inventory basics.

Learn how QuickBooks Desktop 2023 links inventory to purchase orders, records bills against open orders, and uses perpetual or periodic inventory with valuation reports.

Learn inventory adjustment in QuickBooks Desktop 2023 using a perpetual system. Align the subledger with the balance sheet and cost of goods sold, and address physical counts for shrinkage.

Explore how to manage the sales tax form in QuickBooks Desktop 2023, including setup, invoices, bills, accounts payable, and paying the sales tax through a dedicated payable system.

Learn how QuickBooks Desktop 2023 uses the check form to pay vendors. Navigate bank feeds, pay bill, sales tax, and payroll liability forms, and track checking accounts and accounts payable.

Explore how to void a prior period check in QuickBooks Desktop 2023, including audit trail, journal entries, and the impact on income statements and balance sheets.

Learn how a bill form affects accounts payable, utilities expense, and inventory, and how debits, credits, and the general ledger drive trial balance and financial statements.

Explore the pay bills workflow, from entering bills to paying them, and posting to accounts payable, the general ledger, trial balance, and subsidiary ledger in Excel.

Record check-form transactions in Excel, including utilities, equipment, and inventory, post to the checking account and general ledger, and balance the trial balance with inventory sub-ledger details.

Explore voiding a check in the same period and handling prior period adjustments with an audit trail, using a void and journal entries to preserve equity and accurate trial balance.

Explore the customer accounts receivable and revenue cycle in QuickBooks Online, detailing invoices, payments, deposits, clearing accounts, and the contrast between cash and accrual methods.

Explore QuickBooks Online 2024's customer accounts receivable and sales center, including invoices, estimates, overdue invoices, and essential reports.

Explore how QuickBooks Online 2024 handles invoice forms under accrual accounting, including creating service and inventory items, managing accounts receivable, sales tax, and customer billing terms.

Learn to receive payment on an invoice in QuickBooks Online, linking accounts receivable to income and using undeposited funds or deposits for bank reconciliation.

Explore how QuickBooks online uses the deposit form to record cash receipts, link payments from invoices to undeposited funds, and reconcile deposits with bank feeds, loans, and owner investments.

Explore how to use the QuickBooks Online 2024 sales receipts form to record cash and credit card sales, undeposited funds, and reconcile deposits with bank feeds.

Analyze the customer cycle in QuickBooks Desktop 2023, tracing invoices and sales receipts to deposits and its impact on the balance sheet and income statement.

Access and use the QuickBooks Desktop 2023 customer center to manage customers and vendors, invoices, and accounts receivable. Navigate reports and forms to track balances and performance.

Explore how QuickBooks Desktop 2023 invoice forms drive accounts receivable, sales tax, and cost of goods sold, with inventory and item lists in a job cost system.

Explore how QuickBooks Desktop 2023 handles invoices and receive payments, including accounts receivable, undeposited funds, and deposits, and learn accrual vs cash-based bookkeeping concepts and bank reconciliation.

Explore how the deposit form increases the checking account and groups undeposited funds. See how invoices, receive payments, and sales receipts feed receivables, balance sheet, and P&L.

Learn how to use QuickBooks Desktop 2023 sales receipts, including when to issue a sales receipt versus an invoice, handling undeposited funds, deposits, and tax implications.

Explore recording barter transactions in QuickBooks desktop 2023 by creating a barter clearing account, invoicing and billing, and clearing the balance via undeposited funds and deposits.

Learn credit memos and refunds in QuickBooks Desktop 2023, including reversing invoices, applying bad debt or sales returns, and adjusting inventory.

Explore QuickBooks Desktop 2023's statement charges workflow, including creating charges without invoices, updating accounts receivable, and processing payments with undeposited funds and reports.

Explore how to set up and apply finance charges in QuickBooks Desktop 2023, including aging, overdue invoices, due dates, grace periods, and posting to other income.

Explore QuickBooks Desktop 2023 statements, including how to generate and customize customer statements from accounts receivable, invoices, and finance charges, with options for printing, emailing, and handling open balances.

Demonstrates creating and customizing a QuickBooks Desktop 2023 estimate, explains its role in a job cost system, and shows converting an estimate to an invoice without impacting financial statements.

Explore how to record invoice transactions in Excel, tracking accounts receivable, sales, inventory, sales tax payable, and cost of goods sold, with service and inventory items.

Demonstrates recording invoices and receipts in Excel, linking accounts receivable to the general ledger, and using deposited funds and a clearing account for bank reconciliation in QuickBooks Online and Desktop.

Explore deposit forms and deposited funds in Excel, showing how they impact the checking account, accounts receivable, and bank reconciliation within QuickBooks workflows.

Explore how to record sales receipts in Excel, including service and inventory transactions, deposits, sales tax, cost of goods sold, and the linked general ledger and subsidiary ledgers.

Explore Excel-based credit memos, refunds, and bad debt expense using a service item, recording reversals for invoices and accounts receivable, with ledgers and trial balance.

Record a credit memo with inventory in a journal entry within QuickBooks, tracing effects on accounts receivable, sales tax payable, inventory, and cost of goods sold while reconciling general ledger.