5 Days to Better Accounting Spreadsheets

Clean a transaction export, match with XLOOKUP, total with SUMIFS, reconcile two lists and add checks, all on one month of a small business's books.

Excel 45 lessons30 questions10-question final exam

What this course assumes and what it gives you

Assumes: Basic formulas such as SUM. No accounting qualification needed.

You will be able to: You can reconcile a cash book to a bank statement, explain every difference, and build a summary that checks itself.

The spreadsheet is in the page. You type your answers here and the engine works them out against real data, cell by cell, so an answer that gets there a different way is still right.

Syllabus

0 of 5 lessons done

1Day 1: Clean the cash-book exportTurn the text dates, references, categories and amounts of a raw export into clean columns beside it, and flag the duplicate and blank lines, leaving the original untouched.8 teaching steps · 6-question quizNot startedStart lesson →
2Day 2: Match transactions with XLOOKUPLook each cash-book line up in the bank's list by reference, label what is missing, and read the result in both directions.8 teaching steps · 6-question quizNot startedStart lesson →
3Day 3: Summarise with SUMIFSTotal the clean lines by category and by week with SUMIFS, set them against the budget, and read the variance with the right sign.8 teaching steps · 6-question quizNot startedStart lesson →
4Day 4: Reconcile two lists and explain the differenceCompare the bank balance with the cash book balance, put every item that explains the gap on its own line, and finish with nothing unexplained.8 teaching steps · 6-question quizNot startedStart lesson →
5Day 5: Add reconciliation checksWrite controls that say OK or CHECK, compare to the cent, and read the overall result as evidence for a few things and proof of none.8 teaching steps · 6-question quizNot startedStart lesson →

Final exam