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.

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.

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.

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.

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.

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.

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.

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 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.

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 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.

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 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.

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.

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 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.