Keep expense categories consistent across reports
A practical method for applying the same expense categories across reporting months and donor funds, with examples, rules and review checks.
An expense can be described in several reasonable ways. Fuel bought for a field visit might be called transport, travel, vehicle costs or programme activity. If the label changes each month, the report becomes difficult to compare and the remaining budget can be misleading.
The practical solution is to agree a short list of categories, write simple rules for using them and apply those rules across every month and fund. You do not need accountancy training to start. You need a clear reference that answers the same question every time: where should this expense go?
Separate the category from the fund
Start by separating two pieces of information that are often mixed together. The expense category explains what was bought. The fund, grant or project explains which source of money should pay for it.
For example, stationery costing 8,000 may be paid from a health grant in January and from unrestricted church funds in February. Both payments can use the category Office supplies. Their fund codes will be different, but the nature of the expense has not changed.
A useful transaction record therefore has separate columns for the date, description, supplier, amount, expense category and fund. You may also need columns for activity, location, payment method or donor budget line. Do not force all of these details into one category name.
Consider these three transactions:
- Fuel of 12,000 for visiting community groups: category Transport or Field travel; fund Youth project.
- Printer paper of 4,000 used by two projects: category Office supplies; fund allocation based on an agreed method.
- Training hall hire of 30,000: category Venue hire; fund Women’s training grant.
Create one master category list
Use one master category list for the organisation, even when donors use different budget headings. This internal list is sometimes called a chart of accounts. For a small organisation, it should be detailed enough to support reporting but short enough for the person entering transactions to use consistently.
A practical list might include Salaries, Casual labour, Staff travel, Participant transport, Fuel, Vehicle repairs, Office rent, Office supplies, Telephone and internet, Bank charges, Training materials, Venue hire, Meals and refreshments, Equipment, Professional fees and Programme supplies.
Avoid creating a new category every time a receipt uses different wording. Pens, paper, files and printer ink may all belong in Office supplies. Tea, lunch and bottled water provided during a workshop may all belong in Meals and refreshments. The receipt description remains in the transaction record, so the category does not need to repeat every item purchased.
Each category should have a short definition and one or two examples. It is also useful to record what does not belong there. For example, the rule for Fuel could say: “Petrol and diesel bought for organisation vehicles or approved project travel. Excludes vehicle servicing and participant transport refunds.”
Do not make categories too broad. A single category called Project costs may hide important differences between transport, materials, venue hire and meals. On the other hand, categories such as Blue pens, Black pens and A4 paper are too detailed for most donor reports.
Give every category a code if your spreadsheet or software allows it. For example, 5100 may mean Staff travel and 5110 may mean Participant transport. The code helps prevent small spelling differences from creating separate categories, such as Travel, travel and Travelling.
Map donor budget lines without changing your records
Different donors may use different names for similar costs. One donor may have a budget line called Workshops. Another may separate Venue, Refreshments, Materials and Participant travel. Your internal category list can stay the same if you maintain a mapping table for each fund.
A mapping table shows which internal categories feed into each donor budget line. For example, Venue hire, Training materials, Meals and refreshments, and Participant transport might all map to Workshops for Fund A. For Fund B, those same internal categories might map to four separate donor lines.
Suppose a February workshop has these costs: venue hire 40,000, printed manuals 20,000, refreshments 35,000 and participant bus refunds 25,000. Your internal records keep the four categories. Fund A’s report may show one Workshops total of 120,000. Fund B’s format may show each amount separately.
This approach avoids recategorising old transactions whenever a new grant uses different language. It also lets management see comparable costs across projects. Venue hire remains Venue hire in the organisation’s records, regardless of the heading required on the donor template.
Build the mapping before the first report for a fund. List every donor budget line and connect it to one or more internal categories. Mark any uncertain line for discussion with the project manager or donor contact. Keep the agreed answer with the grant records.
Some donor lines depend on purpose rather than the item bought. For example, printing may be Administration in one case and Training materials in another. If purpose matters, add an activity or cost-type column rather than creating many similar categories. The transaction could then show category Printing, activity Community training and fund Education grant.
Write rules for the difficult transactions
Consistency is easiest for regular costs such as rent and bank charges. The harder cases need written decisions. A short coding guide prevents the same question being answered differently in March and June.
Start with costs that can reasonably fit more than one category. Common examples include fuel used for a workshop, mobile data bought for field reporting, food purchased for volunteers, printing for an event and repairs to project equipment.
Write the rule in ordinary language. For example: “Travel by employees is Staff travel. Refunds paid to community participants are Participant transport. Vehicle fuel is Fuel, even when the journey relates to training.” This rule may not suit every donor, but it gives the organisation a stable internal treatment. The donor mapping handles the reporting format.
Also decide how to treat mixed purchases. A supplier invoice for 24,000 might include office paper of 6,000, training manuals of 10,000 and cleaning materials of 8,000. If the amounts are shown clearly, split the transaction into three category lines while keeping the same payment reference. Do not put the entire 24,000 into Office supplies simply because paper appears first on the invoice.
For shared costs, use an allocation method that can be explained and repeated. Office internet of 18,000 might be divided equally among three active funds if that reflects actual use, giving 6,000 to each fund. Another organisation may allocate it by staff use or occupied rooms. Record the method and use it consistently unless circumstances change.
When circumstances do change, document the new rule and the date it starts. Do not quietly apply a new method to one month only. If necessary, revise earlier months so that the year-to-date report uses one basis.
Your coding guide can be a single spreadsheet tab with four columns: category, use when, do not use when, and examples. Add a fifth column for the person authorised to decide exceptions.
Review patterns and correct errors openly
Before submitting a report, compare category use across several months. This is not only a check of totals. Look for changes in wording, unusual category combinations and costs that have moved without a clear reason.
For example, if vehicle fuel was recorded under Transport in January, Fuel in February and Programme activities in March, review the transactions against the coding guide. Choose the agreed category and correct all three months in the detailed records. The fund coding can remain unchanged.
A simple review can include sorting or filtering the transaction list by supplier and description. If payments to the same internet provider appear under Telephone, Communications and Office costs, they may need one consistent category. Also scan for categories used only once, blank categories and newly typed labels that are not on the master list.
Do not overwrite a submitted report without leaving a record. If a previous period needs correction, keep a note showing the original category, corrected category, amount, reason, date and approver. Follow the donor’s rules on whether the correction should appear in the current report or in a revised earlier report.
A reclassification normally changes where an expense appears, not the total spent. For example, moving 15,000 from Office supplies to Training materials reduces one line by 15,000 and increases the other by 15,000. If the total report changes, investigate whether the entry was duplicated, omitted or altered as well as reclassified.
Finally, compare actual categories with the approved budget. A correctly coded expense can still be outside the budget or charged to the wrong fund. Category consistency supports that review, but it does not replace checks on eligibility, approval, available budget and grant dates.
- Use only category names from the approved master list.
- Check similar suppliers and descriptions for different coding.
- Review any blank, new or rarely used category.
- Confirm that each category maps to a donor budget line.
- Document corrections instead of silently changing submitted figures.
Questions
Should each donor have its own expense categories?
Usually, keep one internal category list and create a separate mapping for each donor’s budget lines. This keeps everyday records comparable while allowing reports to follow different donor formats. A separate category may be justified when a grant has a genuinely distinct cost that needs regular tracking.
What if an expense could fit two categories?
Check the written category definitions and use the rule already agreed. If no rule exists, ask the authorised person, record the decision and add it to the coding guide. The important point is to apply the same decision to similar transactions later.
Can one payment be split between categories or funds?
Yes. Enter separate lines for each category or fund, using the same payment reference. The split amounts must add back to the full payment. Keep the invoice detail or allocation calculation that supports the split.
Should old months be changed when a coding error is found?
Correct the underlying records and keep a clear reclassification note. Whether you revise an earlier donor report or show the adjustment in the current period depends on the reporting agreement and the significance of the error. Do not hide the change.
How often should the category list be updated?
Review it when a new fund starts, a new type of activity begins or repeated coding questions appear. Avoid changing names in the middle of a reporting period without updating the mapping and coding guide. Retain old codes so earlier records remain understandable.
Consistent categorisation comes from separating category from fund, maintaining one master list, mapping it to each donor budget and recording decisions for difficult costs. Review patterns across months and document every reclassification. If useful, the same mappings and consistency checks can be set up in Honest Record so that repeated descriptions and category exceptions are easier to review.
Honest Record reads the statement and receipts, matches them, applies your fund's rules and verifies every row before the Excel exists. Free 14-day trial, no card.
Upload your first month free See a sample report