Building a Complete Accounting System in Excel
Building a system that starts with the chart of accounts and journal and ends with the trial balance and financial statements.
Course contents
- 1The chart of accounts
- 2The journal and posting
- 3The ledger and trial balance
- 4The financial statements
- 5The user interface and protection
What you gain from the course
You finish with an Excel file that works as an accounting system for a small business.
Other courses in the same track
Practical applications
Payroll and Attendance Sheets in Excel
Designing an attendance file and a payroll sheet that calculates entitlements and deductions.
18 training hours
Inventory and Sales Management in Excel
A file to track items, movements, balances and sales, with reports and reorder alerts.
18 training hours