How to read a twelve-month purchase ledger without drowning

Open the file. Resist the urge to make a chart. The first job is to decide whether this is even one year.

Confirm the period on the page, not in the filename

Exports named invoices_2024.xlsx still contain January credit notes posted in February, and March invoices entered in May. Sort by document date and by posting date. If they disagree by more than a few days on a large share of lines, ask the accountant which date the organisation uses for “a year of buying”. Write that answer down. A spend map that mixes two calendars will look confident and still be wrong.

Join names before you judge them

In Georgian records a vendor may appear in Mkhedruli, in Latin letters, and with Ltd, LLC, and შპს in rotating combination. Build a working list of tax numbers where you have them. Where you do not, join obvious spelling twins and keep a column that says “joined by judgement”. That column is how you defend the map later.

Face the blank descriptions

A surprising share of purchase orders in public and private files have an amount, a vendor, and a silence. Those lines are not “miscellaneous” yet. They are a queue for the person who remembers the delivery. Budget two conversations with that person before you invent a category. If they cannot remember either, the findings note should say so.

Categories come fourth

Only after period, names, and blanks do you group what was bought. Start from the storeroom language — salt, reagents, toner, hired plant — and map those onto account codes afterwards. Codes that lump linen with lab glass are a problem for the chart of accounts, not a reason to keep them married on the map.

If this is more than a lunch-hour exercise, it is the work we take as a full spend review.