Every lesson. One plan.

Unlock both tracks, unlimited new numbers, hints and full solutions.

Lifetime

$179 once

Pay once. Keep access.

  • Everything in Annual
  • Every lesson we add later
  • No renewals

Monthly

$19.99/month

Flexible. Cancel anytime.

  • Everything in Annual
  • Billed monthly
  • Cancel in two clicks

Prices in US dollars. Every plan has a 30-day money-back guarantee. Pass a certificate test for a certificate of completion anyone can verify; Bookkeeping basics is free to try. Until checkout opens, the first exercise of every lesson is open to everyone with no sign-up.

What's included.

Excel for Accounting (MO-220 practice)

  1. Relative and absolute references (3 exercises)
  2. Totals on a ledger (3 exercises)
  3. Rounding to the cent (3 exercises)
  4. Monthly periods with Fill (3 exercises)
  5. Budget vs actual (3 exercises)
  6. Accounting number formats (3 exercises)
  7. Flag values outside expected ranges (3 exercises)
  8. Split account code and name (3 exercises)
  9. Combine and clean text (3 exercises)
  10. Transaction dates to periods (3 exercises)
  11. Due dates and days outstanding (3 exercises)
  12. Remove duplicate transactions (3 exercises)
  13. Import a bank export (3 exercises)
  14. Data validation for account codes (3 exercises)
  15. Hide, delete and format consistently (3 exercises)
  16. Sort the general ledger (4 exercises)
  17. Filter transactions (3 exercises)
  18. Totals by account (3 exercises)
  19. Look up account names and types (3 exercises)
  20. Normal balances with IF (3 exercises)
  21. Trial balance (3 exercises)
  22. Income statement from a trial balance (3 exercises)
  23. Balance sheet that balances (3 exercises)
  24. Format statements for presentation (3 exercises)
  25. Financial ratios (3 exercises)
  26. Liquidity and solvency ratios (3 exercises)
  27. Highlight anomalies (4 exercises)
  28. Find and fix formula errors (3 exercises)
  29. Summarize with PivotTables (4 exercises)
  30. Charts and a one-page dashboard (4 exercises)
  31. Loan amortization schedules (3 exercises)
  32. Bank reconciliation (3 exercises)
  33. Find outstanding checks and deposits in transit (3 exercises)
  34. Accounts receivable aging and bad debt (3 exercises)
  35. AP aging and payment schedule (3 exercises)
  36. Payroll: gross to net (3 exercises)
  37. Employer payroll taxes and irregularities (3 exercises)
  38. Depreciation schedules (3 exercises)
  39. Projected depreciation and units of production (3 exercises)

Bookkeeping practice

  1. The accounting equation (3 exercises)
  2. Account types and normal balances (3 exercises)
  3. Debits and credits (3 exercises)
  4. Classify the chart of accounts (3 exercises)
  5. Sales and purchases (3 exercises)
  6. Returns and allowances (4 exercises)
  7. Sales and purchase discounts (2/10, n/30) (4 exercises)
  8. Sales tax collected and remitted (5 exercises)
  9. Owner investments and drawings (5 exercises)
  10. Notes payable and interest (5 exercises)
  11. Payroll entries (3 exercises)
  12. Post to T-accounts (3 exercises)
  13. General ledger running balances (4 exercises)
  14. Trial balance (3 exercises)
  15. Find and correct errors (5 exercises)
  16. Prepaid expenses (3 exercises)
  17. Unearned revenue (3 exercises)
  18. Accrued expenses (3 exercises)
  19. Accrued revenue (4 exercises)
  20. Depreciation entries (3 exercises)
  21. Bad debts: the allowance method (4 exercises)
  22. Supplies and inventory shrinkage (4 exercises)
  23. Adjusted trial balance (3 exercises)
  24. Income statement (3 exercises)
  25. Statement of owner’s equity (3 exercises)
  26. Classified balance sheet (3 exercises)
  27. Closing entries (3 exercises)
  28. Post-closing trial balance (3 exercises)
  29. Reversing entries (4 exercises)
  30. Bank reconciliation adjustments (3 exercises)
  31. Reconcile a bank statement (3 exercises)
  32. Petty cash (4 exercises)
  33. Subsidiary ledgers and control accounts (4 exercises)
  34. Notes receivable (5 exercises)
  35. Perpetual inventory entries (5 exercises)
  36. Periodic inventory and cost of goods sold (4 exercises)
  37. FIFO, LIFO and weighted average (4 exercises)
  38. Lower of cost or net realizable value (3 exercises)
  39. Capitalized asset cost (4 exercises)
  40. Selling or scrapping equipment (4 exercises)
  41. Installment notes (4 exercises)
  42. Bonds payable basics (5 exercises)
  43. Month-end close practice set (6 exercises)

Payroll practice

  1. Hourly pay and overtime (4 exercises)
  2. Salaried and partial periods (3 exercises)
  3. Commissions and bonuses (3 exercises)
  4. Pre-tax vs after-tax deductions (3 exercises)
  5. Withholding with an example table (3 exercises)
  6. Employer taxes (example rates) (3 exercises)
  7. The payroll register (3 exercises)
  8. Payroll journal entries (4 exercises)
  9. Paying payroll liabilities (3 exercises)
  10. Accrued payroll at period end (3 exercises)

Questions.

How can I cancel?

Monthly and annual plans can be cancelled at any time from your account and stay active until the end of the period you've paid for.

Is there a money-back guarantee?

Yes. If Premium isn't right for you, ask for a refund within 30 days of your first payment and you get all of it back, on any plan, Lifetime included.

What's included in Premium?

Every lesson in both tracks, every exercise with unlimited new numbers, hints and solutions, and new lessons as they're added.

Do I get a certificate? Is it accredited?

Pass one of the certificate tests (the MO-220 practice exam, the Excel test for accounting jobs, the bookkeeping or AP/AR test, or the free Bookkeeping basics test) and you get a certificate of completion with a link anyone can verify, ready to add to LinkedIn. The numbers are chosen and your answers graded on our server. It is not an accredited qualification or a Microsoft certification; it shows an employer exactly which tasks you solved, and when.

I'm an instructor. Can my students use it?

Yes. Instructors get free access, and class codes for students are on the way.

Is this affiliated with Microsoft?

No. Accounting Exercises offers independent MO-220 practice and is not affiliated with Microsoft or Certiport.