Workbook Shop Cart 0

Excel for Accounting & Tax – PDF Workbooks

Excel for Accounting & Tax as 5 hands-on PDF workbook volumes (2,718 pages, 1,041 lessons). Every volume has worked labs, quizzes and a full solutions appendix — instant download, free sample in every book.

More: Excel & Business Workbooks · all books

All 5 volumes

What you will learn in Excel for Accounting & Tax

These workbooks cover 52 complete courses (selection below):

  • Accounting & Bookkeeping Fundamentals
  • Excel for Nonprofit Treasurers & Volunteers: Donations, Budgets & Reports
  • Excel for Accounts Payable & Receivable Clerks: Invoices, Aging & Payments
  • Excel for Freelance Bookkeepers: Clients, Bank Feeds, Monthly P&L & Practice Profit
  • Managerial & Cost Accounting
  • Excel for Junior Auditors: Sampling, Vouching, Analytics & Workpapers
  • VAT & Sales Tax Fundamentals
  • Bookkeeping in Practice: Bank, Receivables, Inventory & Assets
  • Advanced Accounting: Leases, Deferred Tax & Consolidation
  • Audit & Forensic Analytics in Excel
  • Payroll Accounting & Bookkeeping
  • Inventory Accounting: FIFO, LIFO, Weighted Average & Valuation
  • Lease Accounting: IFRS 16 & ASC 842 in Excel
  • Deferred Tax Accounting: Temporary Differences, DTA & DTL
  • Consolidation & Group Accounting: Goodwill, NCI & Intercompany Eliminations
  • Revenue Recognition: IFRS 15 & ASC 606 Five-Step Model in Excel
  • Accounts Payable & Purchase-to-Pay: Three-Way Match, Duplicates & Payment Runs
  • Impairment Testing: IAS 36 Value in Use, CGUs & Goodwill
  • Foreign Currency Accounting: Transactions, Remeasurement & Translation (IAS 21 / ASC 830)
  • Construction Contract Accounting: WIP Schedules, Over/Under Billing & Margin Fade
  • Transfer Pricing Basics: Arm's Length, Margins & Benchmarking
  • Stock-Based Compensation Accounting: Grant-Date Fair Value, Vesting & Expense (IFRS 2 / ASC 718)
  • Accounts Receivable & Collections: DSO, CEI, Credit Limits & Bad Debt
  • Nonprofit Fund Accounting: Restricted Funds, Grants & Functional Expenses
  • Partnership Accounting: Profit Sharing, Capital Accounts, Admission & Dissolution
  • Internal Controls Testing: Control Matrices, Sample Sizes & Deficiency Evaluation
  • Cash Basis to Accrual Accounting: Conversions, Adjustments & Year-End Entries
  • Earnings per Share: Basic & Diluted EPS, Weighted Shares, Splits & Convertibles
  • Fixed Asset Accounting: Depreciation Methods, Disposals, Revaluation & Componentisation
  • Crypto Asset Accounting: Cost Basis, Lots, Fair Value & Gains
  • Purchase Price Allocation: Goodwill, Intangibles & Fair Value Step-ups
  • Provisions & Contingencies (IAS 37): Recognition, Expected Values & Unwinding
  • Hedge Accounting Basics: Fair Value, Cash Flow Hedges & Effectiveness Testing
  • Statement of Cash Flows: Indirect Method, Working Capital & Free Cash Flow
  • Intangible Assets (IAS 38): R&D Capitalisation, Amortisation & Software Costs
  • Agriculture Accounting (IAS 41): Biological Assets, Fair Value Less Costs to Sell & Produce
  • Investment Fund Accounting: Daily NAV, Unit Pricing, Subscriptions & Redemptions, Fee Accruals & Performance Fees with a High-Water Mark
  • Bank Transaction Categorisation: Keyword Rules, Vendor Maps, Amount Rules, Split Transactions & an Exceptions Queue
  • The Effective Interest Method: Amortised Cost Schedules for Loans & Bonds with Fees, Discounts, Premiums and Changed Cash Flows
  • Daily Sales Reconciliation for Shops & Restaurants: Register Reports, Card Settlements, Tips, Refunds, Gift Cards & the Daily Sales Journal

Prices are $14.99 per PDF workbook. One-time payment, no subscription.