Programme profile
Bookkeeping with Excel & QuickBooks
Do a real business's books on the computer
Overview
Course overview
Practical bookkeeping on the tools employers use: build ledgers and reports in Excel, then run a full set of books in QuickBooks, from invoices to month-end closing.
Outcomes
What you will achieve
- Build a working ledger and reports in Excel
- Set up a company file, customers and suppliers in QuickBooks
- Issue invoices, record expenses and track payments
- Close the month and export clean reports
Curriculum
What you will study
Module 1
Excel for Bookkeeping
Tables, formulas, ledgers and automatic summaries.
Module 2
QuickBooks Setup
Company file, chart of accounts, customers and suppliers.
Module 3
Daily Transactions
Invoices, expenses, bank feeds and payment tracking.
Module 4
Month-End & Reports
Reconciliation, closing and exporting reports.
Online lessons & study guides
Lessons included
Every lesson comes with a video, written notes and a downloadable slide study guide, unlocked in your learning space once payment is confirmed.
Lesson 1 · 40 min
Excel for Bookkeeping
Tables, formulas, ledgers and automatic summaries.
Video lesson · 9-slide study guide (download/print)
Lesson 2 · 40 min
QuickBooks Setup
Company file, chart of accounts, customers and suppliers.
Video lesson · 10-slide study guide (download/print)
Lesson 3 · 40 min
Daily Transactions
Invoices, expenses, bank feeds and payment tracking.
Video lesson · 9-slide study guide (download/print)
Lesson 4 · 40 min
Month-End & Reports
Reconciliation, closing and exporting reports.
Video lesson · 9-slide study guide (download/print)