Accounting Technology and Professional Practice

Spreadsheet-based accounting

Build a controlled journal and trial balance in a spreadsheet with checks.

Worksheets · Calculations · Classification · Concept checks · Sequencing

Accounting systems and ERPs

Explain sub-ledgers, the general ledger and how transactions flow through an ERP.

Worksheets · Calculations · Classification · Concept checks

GL exports and data validation

Validate a general-ledger export for completeness and accuracy.

Worksheets · Calculations · Classification · Concept checks

Chart-of-accounts mapping

Map a trial balance to reporting lines and test the mapping.

Worksheets · Calculations · Classification · Concept checks

The month-end close

Plan a close calendar and checklist and track completion.

Worksheets · Calculations · Classification · Concept checks · Sequencing

Balance sheet reconciliation workflows

Reconcile balance sheet accounts with support and sign-off.

Journal entries · Worksheets · Calculations · Classification · Concept checks · Simulator

Audit trails and financial controls

Explain why posted entries are corrected, not edited, and review an audit trail.

Journal entries · Classification · Concept checks

Accounting automation

Decide which close tasks to automate and what controls automation needs.

Worksheets · Calculations · Classification · Concept checks · Sequencing

Accounting analytics

Use ledger data to find unusual journals and trends.

Worksheets · Calculations · Classification · Concept checks