All tracks

Accounting assessment prep

Advanced 1 hr 4 exercises

Reconciliations, audit sampling, aging, and reporting workflows most commonly tested in accounting Excel assessments.

What you'll learn

  • Classify open invoices into aging buckets to build an accounts receivable aging schedule
  • Roll journal entries into a trial balance and verify debits equal credits with SUMIFS
  • Reconcile a bank statement against internal records using VLOOKUP and SUMIF
  • Match transactions between two systems and categorize discrepancies by type with VLOOKUP, IF, and ISNA

Functions you'll practice

IF ISNA SUMIF SUMIFS VLOOKUP
Start track

Exercises in this track

0 of 4 completed 0%
1

Build an accounts receivable aging schedule

Intermediate

Classify outstanding invoices into aging buckets in a simple accounts receivable aging schedule.

IF
Start
2

Prepare a trial balance from journal entries

Intermediate

Aggregate journal entries into a trial balance, then flag accounts with balances that look unusual.

SUMIFS IF
Start
3

Bank statement reconciliation

Advanced

Reconcile a bank statement with internal records, identify missing items.

SUMIF VLOOKUP IF
Start
4

Full data reconciliation

Advanced

Match transactions between two systems, flag discrepancies by type.

VLOOKUP IF ISNA
Start
Start track

Where to go next

Pick another track

Browse all learning tracks to find your next focus area.

Browse all tracks

Build on what you learned

When you're ready for the step after Excel, here's where we'd point you next.

Ready to get certified in finance?

Once you've put the modeling work in, the FMVA from CFI makes it official. It's the credential finance and FP&A teams actually recognize, and it's hands-on, not just theory.

This is an affiliate link. A purchase helps support the site.

Explore the FMVA program(affiliate link)