QuickBooks Desktop vs. Excel

Learn to build a comprehensive Excel accounting worksheet from scratch, including data input, journal entries, trial balance, and general ledger, with color coding and practice problems.

Create an Excel accounting worksheet with a trial balance, using a debit-positive, credit-negative format to calculate net income and apply conditional formatting to monitor balance and align with the ledger.

Create an Excel accounting worksheet from scratch, enter debits and credits, post to the general ledger and trial balance, and verify balances and net income.

Construct an Excel accounting worksheet by entering assets and liabilities, posting transactions to the trial balance and general ledger, and using a debit/credit formula for net income.

Explore building an accounting worksheet in Excel, posting transactions, and generating a running balance, trial balance, and general ledger with check figures and conditional formatting.

Create and format an end-to-end accounting worksheet in Excel, including data input, trial balance, general ledger, and accounts receivable/payable subsidiary ledgers, with checks and conditional formatting to verify balances.

Explore creating an accounts payable subsidiary ledger by vendor in Excel, linked to journal entries, trial balance, and general ledger; implement aging by vendor and check balances.

Create an inventory subsidiary ledger in Excel using weighted average method to track purchases, units, unit costs, and cost of goods sold, aligning with the trial balance and general ledger.

Create a balance sheet in Excel from a trial balance, detailing assets, liabilities, and equity with subcategories, including accumulated depreciation, and formatting tips.

Create an accounting worksheet in Excel from a blank sheet. Build the trial balance, balance sheet, and income statement, then tie to equity using plus-minus calculations.

Build the statement of equity from the trial balance, balance sheet, and the income statement in Excel; examine permanent and temporary accounts, draws, and owner investments.

Learn to download and open QuickBooks Desktop 2023 sample files, locate and organize data and backup files, and navigate a sample Rock Castle Construction company file to understand file structure.

Explore how QuickBooks Desktop 2023 uses a home page, open windows, and cycles to navigate vendors, customers, and employees, with forms driving the balance sheet and income statement.

Learn how to use QuickBooks Desktop 2023 bank feeds, navigate data input forms, and build balance sheets and income statements while considering cash vs accrual, invoices, and inventory impacts.

Explore QuickBooks Desktop 2023 preferences, including how to access edit options, navigate categories, and adjust company and general settings for a construction data file.

Discover how the vendors section in QuickBooks desktop 2023 drives the accounts payable cycle, entering and paying bills, updating the balance sheet and income statement via forms.

Explore QuickBooks Desktop 2023 by using the vendor center to manage bills and vendors. Review P&L and balance sheet reports and understand accounts payable.

Enter a bill in QuickBooks Desktop 2023 to record expenses and increase accounts payable. Choose expenses or inventory items, manage vendors, and review impacts with reports.

Explore how QuickBooks Desktop 2023 handles bills and bill payments, showing how entering a bill increases accounts payable and paying it decreases accounts payable and the checking account.

Explore how QuickBooks desktop 2023 handles purchase orders, including vendor center workflows, inventory implications, perpetual versus periodic systems, and the link between purchase orders and bills.

Learn how QuickBooks Desktop 2023 connects inventory to purchase orders, bills, and accounts payable, with open purchase orders and inventory valuation using weighted average cost.

Explore how to perform an inventory adjustment in QuickBooks Desktop 2023, using a perpetual inventory system, reconciling physical counts with subledgers and updating cost of goods sold and shrinkage.

Master setting up and managing sales tax in QuickBooks Desktop 2023, including handling invoices and sales receipts, creating the sales tax payable, and generating related reports.

Learn to use QuickBooks Desktop 2023 to pay vendors with the check form, manage bank feeds and the check register, and handle accounts payable, payroll, and sales tax forms.

Learn to void a prior period check in QuickBooks Desktop 2023, preserve an audit trail with journal entries, and avoid deleting transactions to protect prior year income statements.

Explore how a bill form affects accounts payable, assets and expenses, debits and credits, and the flow from the general ledger to financial statements in an Excel-based practice sheet.

Learn the pay bill process in accounting software: record a bill to accounts payable, pay it with a pay bill form, then post to the general ledger and subsidiary ledger.

Explains how a check form decreases the checking account, records utilities, equipment, and inventory as journal entries, and ties subsidiary ledgers like inventory to the general ledger.

Explore how voiding a check and prior period adjustments in QuickBooks affect the audit trail, journal entries, and equity, and why current period entries must offset prior period errors.

Examine the customer cycle in QuickBooks Pro Plus Desktop, comparing cash basis, accrual basis, and bank feeds within accounts receivable. Learn invoicing, bank reconciliation, and core financial statements.

Explore the customer center in QuickBooks Desktop Pro Plus 2022, manage customers and transactions including invoices and payments, and review accounts receivable via a subsidiary ledger.

Explore how the QuickBooks desktop invoice form updates accounts receivable, sales, and inventory, including sales tax and cost of goods sold, with subsidiary ledgers and reports.

Explore how to record customer payments in QuickBooks Pro Plus Desktop 2022 using the receive payment form, link to invoices, and manage deposits and clearing accounts for reconciliation.

Explore how QuickBooks Desktop deposits work, including the deposit form and deposited funds, customer payments, and bank reconciliation to the checking account.

Explore the sales receipts form in QuickBooks Desktop, detailing how deposits, cash versus accrual timing, inventory, sales tax, and journal entries impact ledgers and financial statements.

Learn how to create credit memos and refunds in QuickBooks to reverse accounts receivable and sales, handle bad debt expense, and adjust inventory and sales tax.

Explore how to process a credit memo form with inventory in QuickBooks, reversing invoices and adjusting accounts receivable, cost of goods sold, sales tax, and inventory.

Explore the QuickBooks Desktop customer cycle, including revenue flow, accounts receivable, invoicing and sales receipts, deposits, bank feeds, cash vs accrual, and inventory considerations.

Explore the QuickBooks Desktop 2023 customer center, including managing customers, vendors, invoices, sales receipts, and accounts receivable with open balances and key reports.

Explore how to create and customize an invoice form in QuickBooks Desktop 2023, including items, sales tax, accounts receivable, and the impact on balance sheet and profit and loss.

Learn how to process customer payments in QuickBooks Desktop 2023 using the receive payment form, linking to invoices and accounts receivable, managing undeposited funds, and reconciling deposits with the bank.

Learn how the QuickBooks Desktop 2023 deposit form increases the checking account while managing undeposited funds and received payments for accurate bank reconciliation.

Learn how to use QuickBooks Desktop 2023 to create sales receipts at the point of sale, manage undeposited funds and deposits, and reconcile revenue, taxes, and inventory through key reports.

Learn how to record barter sales in QuickBooks Desktop 2023 using a barter clearing account, invoices, bills, and the full accrual process for balance sheet and receivables/payables.

Learn how to handle credit memos, refunds, and bad debt in QuickBooks Desktop 2023, including reversing invoices and managing inventory, cost of goods sold, and sales tax.

Learn how to create and manage statement charges in QuickBooks Desktop 2023, post them to accounts receivable, and review the results in the subledger and key reports.

Explore how to configure QuickBooks Desktop 2023 finance charges, including setting terms, grace periods, and an annual interest rate, and how charges affect accounts receivable, balance sheet, and other income.

Explore creating and customizing statements in QuickBooks Desktop 2023 to manage accounts receivable. Select open balances and invoices, include past-due items, and choose print or email options for customers.

Explore QuickBooks Desktop 2023 estimates: an informational, job-cost form that can convert to an invoice, affecting accounts receivable but not financial statements until billed, with customizable templates.

Practice building invoices in excel to record accounts receivable, sales, tax payable, and inventory effects, and link customer sub ledgers to the general ledger.

record customer payments by linking invoices to receive payment forms, post to accounts receivable and either direct cash deposits or deposited funds, and reconcile with the bank.

Explore how deposit forms and deposited funds affect the accounts receivable cycle, clearing accounts, and checking balances, and compare direct deposits, bank reconciliation, and QuickBooks versus Excel practices.

Discover how to use the sales receipts form in QuickBooks Desktop to record customer payments at the point of sale, handling deposits, revenue, sales tax, and inventory costs.

Explore how to record credit memos and refunds in Excel, handling accounts receivable, sales, and bad debt expense with a service item through journal entries and trial balance checks.

explore a credit memo with inventory in excel, recording accounts receivable, sales tax payable, and cost of goods sold, then reverse it with sales returns and allowances to balance ledger.

Explore QuickBooks Pro Plus Desktop 2022 basics, including banking and companies sections, shortcuts, and lists like the chart of accounts and item lists.

Learn to customize shortcuts and home page icons in QuickBooks Pro Plus Desktop 2022, and adjust desktop preferences to show essential items like estimates, payroll, and inventory.

Explore QuickBooks Desktop 2023 banking and company sections, including chart of accounts, items, and shortcuts, and learn how deposits, reconciliations, and reports shape income statement and balance sheet.

Learn how to customize the QuickBooks Desktop 2023 home page icons, shortcuts, and favorites to streamline data input and tailor the interface to your business.

Decide between payroll within QuickBooks Desktop or a third-party provider, and set up payroll with tax withholdings, liabilities, and required reports like 941 and W-2 forms.

Learn how to set up and manage payroll in QuickBooks Desktop using the Employee Center and Payroll Center, including paychecks, withholdings, liabilities, and payroll tax forms.

Explains payroll processing in QuickBooks Desktop 2023 using the pay employees form, covering withholdings, taxes, and how payroll entries impact the balance sheet and income statement.

Process payroll liabilities in QuickBooks Desktop 2023 using the payroll liabilities wizard to pay liabilities, manage withholdings and payroll taxes, and generate payroll reports and government forms.

Explore how QuickBooks Desktop 2023 processes payroll and liabilities, uses payroll cycles and reports to prepare 941, 940, and W-2 filings, tying payroll data to balance sheet and income statement.

Learn to enter time in QuickBooks Desktop 2023. See how time tracking feeds payroll and billing, and how hourly and salaried employees and job cost affect invoicing.

Learn how to model payroll in Excel, calculating gross pay, withholdings (federal income tax, Social Security, Medicare, benefits), and prepare journal entries and payroll liabilities for aggregation vs. per-employee records.

Develop excel-based payroll journal entries for gross pay, withholdings, and net pay; post to payroll liabilities and taxes, and tie to the trial balance and financial statements.

Explore 1560 lists in QuickBooks desktop, including chart of accounts and items lists, plus payroll, fixed assets, sales tax, and inventory, to set up a new company file.

Explore the QuickBooks chart of accounts in a desktop setup, learn how account types order assets, liabilities, equity, and income and expenses, and how to enable account numbers.

Explore item lists in QuickBooks Pro Plus Desktop 2022, including service items, inventory parts, and non-inventory parts, and how sales and costs flow through accounts like cost of goods sold.