Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Accounting Intermediate

Bookkeeping in Practice: Bank, Receivables, Inventory & Assets

The real bookkeeping jobs after the basics: bank reconciliation, receivables ageing, payables and discounts, inventory costing, depreciation, disposals, petty cash and payroll, all on live auto-graded spreadsheets.

8 lessons 8 labs 2 h Certificate

  • One-time payment
  • 14-day money-back guarantee
  • Secure checkout with Stripe

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

  • Reconcile Northwind’s bank statement with ledger 1000 Cash at 31 Mar 2026 and book the adjusting entries.
  • Age Northwind’s open invoices with SUMIFS, estimate the allowance for doubtful accounts and book the write-off and the year-end adjustment.
  • Work out the discount deadline and the discount on a supplier invoice, price the cost of skipping it, and record purchases and payments.
  • Value Northwind’s year-end copy-paper stock and cost of goods sold with weighted average cost and with FIFO (periodic system).
  • Test three product lines for a write-down to net realisable value and record it.
  • Depreciate Northwind’s new delivery van with three methods, using Excel’s SLN and DDB functions.
  • Bring a packing machine’s depreciation up to the sale date, calculate the gain on disposal and record the sale through a disposal account.
  • Replenish Northwind’s petty cash box, work out net pay and record both month-end entries.

About this course

Once the basics are clear, real bookkeeping is about the recurring tasks that keep the books accurate. This course gives you those tasks one by one. You reconcile a bank statement to the cash book, age receivables and set an allowance for doubtful accounts, and record supplier invoices with purchase discounts. Inventory labs compare FIFO with weighted average and write stock down to net realisable value where needed. You then depreciate assets three ways, straight-line, declining balance and units of production, and book the gain or loss when an asset is sold. The course closes with petty cash and a payroll accrual. Suited to junior bookkeepers, accounting students and office managers who keep a company's ledger.

Curriculum

Course content

8 lessons · 8 labs · 2 h · final exam

  1. Bank ReconciliationLab14 min4 checked tasks
    Unlocked when you buy the course
  2. Receivables Ageing & the Allowance for Doubtful AccountsLab16 min5 checked tasks
    Unlocked when you buy the course
  3. Accounts Payable & Purchase DiscountsLab14 min4 checked tasks
    Unlocked when you buy the course
  4. Inventory Costing: FIFO & Weighted AverageLab16 min4 checked tasks
    Unlocked when you buy the course
  5. Lower of Cost and Net Realisable ValueLab12 min4 checked tasks
    Unlocked when you buy the course
  6. Depreciation Methods: Straight-Line, Declining Balance & Units of ProductionLab15 min4 checked tasks
    Unlocked when you buy the course
  7. Disposal of an Asset: Gain or LossLab14 min4 checked tasks
    Unlocked when you buy the course
  8. Petty Cash & Payroll AccrualLab16 min5 checked tasks
    Unlocked when you buy the course
  9. Final exam12 questions, 75% to pass, unlimited retries.

Certificate

Finish with a certificate you can verify

Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.

  • Names the course, your score and the date of issue
  • A verification link for your CV or LinkedIn profile
  • 12 questions, 75% to pass, unlimited retries.

A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.

Illustration. Your certificate shows your own name, course and credential ID.

Before you buy

Questions about this course

Is this a subscription?

No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.

What exactly do I get?

All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.

Can I get a refund?

Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.

When can I start?

Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.

Do I need Excel or other software?

No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.

Is the certificate an official qualification?

No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.

Full details are in our Terms · hello@tutorvo.com

Browse all Accounting courses →
$9.99one-time payment
Buy course