Why does your Excel ledger export look ready for review while its dates, amounts and totals still leave you unsure? Excel data cleaning is a familiar challenge for finance teams: a file can look consistent on screen without being ready for analysis. The question is what evidence would make you trust it.
For a South African finance practitioner, that uncertainty matters at month end. A colleague reviewing the workbook needs more than tidy formatting. They need to understand how the records relate to the documents behind them. For a student, the same challenge connects spreadsheet skills with the judgement involved in preparing information someone else can check.
In this lesson, Baobab Foods gives Zane Daniels a ledger export with text dates, text amounts and a repeated invoice. His task raises a practical question: how can he establish that the finished workbook represents the source documents faithfully? Follow the example in the lesson to see how that question is resolved.
Dates stored as text: explore why appearance alone leaves room for doubt.
Amounts stored as text: consider what needs checking before a ledger total earns your confidence.
Excel tables: examine their place in organising a finance workbook for review.
Duplicate invoices: consider the evidence needed to distinguish repetition from separate transactions.
Source records: keep traceability in view when assessing the finished file.
The lesson brings ISNUMBER, Text to Columns and Remove Duplicates into the same worked scenario. The interest lies in how the checks fit together, not simply in locating commands on the ribbon. It gives you a focused setting for thinking about what to inspect, what to question and what evidence to retain.
The scope is a single monthly export with apostrophe-prefixed text amounts, a single text date format and exact duplicates. Recurring imports, Power Query refreshes, locale-dependent dates and fuzzy matches are outside this lesson. Text amounts containing spaces, currency symbols or separators also need attention beyond the example.
Open the clean data lesson in Amatle Institute’s Excel course to work through Baobab’s file and examine the checks behind a workbook you can explain at your next month end review.
Questions about this topic
What does stored as text mean in Excel?
It means Excel holds a value as characters, even when it visually resembles a number or date.
Who is this Excel lesson for?
The lesson is for finance students and practitioners who prepare or review ledger exports and want to understand the checks behind a dependable workbook.
Does this lesson cover automated ledger imports?
No. It covers cleaning a single monthly export. Recurring imports, Power Query refreshes and combining multiple ledger files are outside its scope.
Free · one email a week
IFRS and SAM, one requirement at a time
Each week you get the Institute's new articles: one requirement of IFRS 17, IFRS 9, IFRS 15, IFRS 18 or SAM, worked on a South African case. You start with the free IFRS 18 readiness checklist, ten areas to work through before IFRS 18 takes effect, each with its paragraph reference.