DPS Tracker Excel - Free Template

1. Enter each claim on the DPS Claims sheet. Use a new row for each household or month, and keep the Claim ID in sequence so nothing gets lost.
2. Fill in the household details, PPS number, county and family size. Use the same spelling each time, especially if more than one person helps with the file.
3. Record the eligible prescription spend and the amount paid by the household. For example, if the eligible spend is €151.20 and the threshold is €114.00, the over-threshold amount is €37.20.
4. Add the pharmacy or provider and any notes. This is where you can log missing receipts, corrections or follow-up items.
5. Check the Dashboard sheet after you update the claims. Use it to review totals, compare months and see whether reimbursements are building up.
6. Use the Instructions sheet if someone else takes over the file. It gives the basic process without making them guess the layout.

This is the kind of spreadsheet a parent, carer or household admin person opens when the pharmacy receipts start building up and they want a clean record of what has been spent each month. In practice, it is often used at the kitchen table after a run to the chemist, or at month end when the folder of receipts needs sorting.

The DPS cap matters because the monthly limit is €114 in 2026. If a household spends €151.20 on eligible prescriptions in a month, the over-threshold amount is €37.20, and that is exactly the kind of figure you want the sheet to show without manual re-checking.

When this helps most

A family with two adults and three children might have one person paying for different prescriptions across the month. A tracker like this keeps the PPS number, address, county and family size together, so you do not have to dig through envelopes later.

Why a spreadsheet still makes sense

For a single household, a spreadsheet is usually simpler than a notebook once the claims start running into several months. If you have 12 claims a year and each one carries three or four receipts, you quickly end up with enough detail to benefit from a structured list rather than a loose pile of paper.

The DPS Claims sheet in image 1 is laid out for that job, with one row per claim and the key fields visible immediately. That is much easier to work with than trying to reconstruct a month from bank statements alone.

The key rule for the Drug Payment Scheme is simple: eligible prescription costs are capped at €114 per calendar month in 2026. Once you pass that level, the spreadsheet should show the amount over the cap so you can see what has been paid and what is claimable.

This is not the same as VAT, PAYE or business bookkeeping, but the record discipline is similar. Keep the dates, names and amounts clear, because a messy list with missing months can waste time when you are checking a claim or dealing with a pharmacy query.

What to record each month

Use the claim month in DD/MM/YYYY format, the household name, the partially masked PPS number, and the pharmacy or provider. The sample rows in the sheet show how a household spend of €96.40 sits below the cap, while €151.20 is above it and creates a €37.20 over-threshold amount.

Why the layout matters

A single, sequential Claim ID is better than typing free-form notes first and trying to sort them later. If you are dealing with six or eight months of claims, that one habit saves you from duplicate entries and from missing a reimbursement line that should have been captured.

The Dashboard sheet in image 2 is there for a quick overview, not for detailed entry. That split is useful because it keeps the working sheet tidy and stops the summary from being cluttered with raw receipt detail.

The same clean split carries over to a medical card income tracker, where the working sheet holds the entries and the dashboard stays clear for the summary only.

The most common problem is not entering the over-threshold amount at all, which leaves you with a list of receipts but no clear figure for what was actually above the monthly cap. If you miss €37.20 one month and €24.80 the next, that is €62.00 you may have to reconstruct later from paper receipts.

Another frequent error is mixing up one household member’s details with another, especially where two people share the same address and use the same pharmacy. A wrong PPS number or a missing family size field can turn a quick check into a back-and-forth that takes 20 minutes instead of 2.

Where the file goes wrong

People also leave the status column blank, so they cannot tell whether a claim is open, submitted or settled. After three months, that turns into duplicate work, and duplicate work usually means a second pass through every receipt folder.

What that costs

If you are tracking 12 claims a year and each correction takes 10 minutes, you lose 2 hours before you even count the stress of checking old paperwork. In a busy household, that is usually the difference between a tidy system and a folder nobody trusts.

The safest approach is to keep one row per claim and to update it as soon as the pharmacy receipt is in hand. That is much better than waiting until the end of the quarter, when the detail is half forgotten and the numbers have to be rebuilt.

The file only works if you use it at the same time each month. The easiest habit is to update it the day you sort receipts, or straight after the weekly shop if prescriptions are usually collected then.

Simple habits that stick

• Set one fixed day each month to add new claims, such as the first Monday.
• Keep a phone photo of each receipt until it is entered on the DPS Claims sheet.
• Copy last month’s row structure instead of typing the column names again.
• Use the Dashboard sheet at month end to check totals before you file away receipts.

When to move on

If you are handling claims for several households, or if the file is being shared between people who keep overwriting each other’s entries, a simple spreadsheet will start to creak. At that point, you may need a shared folder, stricter permission control or a proper case-management system rather than one workbook.

For a normal household, though, this template is enough. It gives you a routine, a summary and a place to keep the record straight without turning it into a second job.