Basic Payment Scheme Entitlements Excel Template Ireland
Track Irish BISS entitlements, hectares, transfers and estimated payments with this practical Excel template for farmers and advisers.
Download template
This Basic Payment Scheme Entitlements Excel Template for Ireland helps farmers, farm businesses and agricultural advisers organise entitlement information in one practical workbook. The template is designed around Ireland’s Basic Income Support for Sustainability, commonly referred to as BISS, which replaced the former Basic Payment Scheme under the Common Agricultural Policy arrangements. Use it to record entitlement values, units held, eligible hectares, transfers, claimed units, estimated payment amounts and application progress.
The workbook is intended for planning and record-keeping rather than as an official Department of Agriculture, Food and the Marine application form. Payment estimates should always be checked against current Irish scheme rules, official entitlement statements, application acknowledgements and final payment notifications.
The key benefits of this Excel template
- Keeps farmer, farm and application information in one organised register.
- Makes entitlement transfers, claimed units and eligible hectares easier to compare.
- Supports payment forecasting by combining BISS, eco-scheme and other estimates.
- Helps monitor application progress from initial preparation through payment.
- Creates a useful record of notes, references and verification checks.
- Can support records for individual farms, partnerships, businesses or advisory clients.
Step-by-step guide
Open the Entitlement Register and replace the example entries with your own information. Add a unique entitlement ID, farmer or business name, farm location, county and application reference. Enter the entitlement value per hectare, units held and eligible hectares declared using your official records.
Record transfers in as positive values and transfers out as negative values, then review the adjusted and claimed unit figures. Add estimated BISS, eco-scheme and other scheme payments where relevant. Check the estimated total payment and payment per eligible hectare for unusual results.
Keep the Active Farmer Confirmed? field and Application Status field updated as your application progresses. Use Notes to record documents checked, transfers awaiting confirmation, questions for an adviser or differences between your estimate and an official statement.
Save a dated copy when major information changes. This workbook is an administrative planning aid and should not replace official Department of Agriculture, Food and the Marine guidance, application systems, entitlement statements or professional advice.
What is included
What is an Irish BISS entitlement register?
An Irish BISS entitlement register is a structured record of the payment entitlements associated with a farmer or farm business. It can show the number of entitlement units held, the value assigned to each eligible hectare, the land area declared and any movements caused by transfers.
This Basic Payment Scheme Entitlements Excel Template Ireland provides a simple way to keep those details together rather than relying on separate notes, statements or spreadsheets. Because the former Basic Payment Scheme was replaced by Basic Income Support for Sustainability, the workbook uses BISS terminology while still addressing the common search need for a basic payment scheme entitlements template.
The register can be useful when preparing internal forecasts, reviewing a client file or checking whether the units being claimed appear consistent with the eligible hectares declared. A unique entitlement ID and application reference can make it easier to connect each row with supporting records. The notes field can be used for transfer documents, statements received, verification dates or questions that need follow-up.
This type of workbook does not create an entitlement or confirm eligibility. It is a personal administration tool. Final outcomes can depend on current Department of Agriculture, Food and the Marine requirements, active farmer conditions, eligible land rules, payment rates, inspections, penalties, reductions and other scheme decisions.
Users should compare entries with official records and obtain advice where circumstances are complex. Used carefully, the register gives farmers and advisers a clearer overview of the information required for BISS-related planning in Ireland.
Track entitlement units, hectares and transfers
Entitlement records are most useful when units, land and transfers are reviewed together. The template includes separate fields for entitlement units held, eligible hectares declared, transfer in or out, adjusted units and claimed units. This separation helps users see how the original position changes after a transfer and how many units are included in an internal estimate.
Positive transfer figures can represent units received, while negative figures can represent units moved out. Entering these movements consistently makes the register easier to review and reduces confusion when several records are being managed.
Eligible hectares are also important because payment estimates should relate to the land area that is eligible under the applicable rules, not simply the total area farmed or owned. Record the declared area using the figures from the relevant application or supporting documentation. If the hectares or transfer position changes, update the row and add an explanatory note so there is a clear history of what was changed and why.
The workbook is suitable for a single holding or a broader register covering several farmers, farms or businesses. Use the entitlement ID, farmer name and application reference to distinguish records. It may also help an adviser compare preliminary calculations with official acknowledgements.
However, the adjusted and claimed unit figures should be treated as planning information until confirmed through the official process. The template cannot determine whether land is eligible, whether a transfer is accepted or whether a farmer meets every scheme condition. Always retain the source documents and check current Irish guidance before submitting or relying on an estimate.
Estimate BISS and related farm payments
A payment estimate can help with farm budgeting, file preparation and discussions with an adviser. This Excel template includes fields for the estimated BISS value, a greening or eco-scheme estimate, other scheme payments and the estimated total payment. It also provides payment per eligible hectare, which can be a useful comparison measure when reviewing different holdings or checking whether a result appears unusual.
Enter only figures supported by a current rate, an official statement or a clearly labelled internal assumption. Use the Notes field to explain the source and date of each estimate.
The total shown in a planning workbook is not a guarantee of the amount that will be paid. Rates and eligibility can vary, and the final result may be affected by application corrections, inspections, land changes, payment reductions, penalties, cross-compliance or other scheme provisions.
Eco-scheme participation and other payment categories may have their own requirements, so they should not be included automatically simply because a farmer expects to receive support. Separating the categories makes assumptions more transparent.
For better control, save a dated version whenever rates or farm details change. Compare the workbook with the official application acknowledgement and final payment statement, and correct the register when confirmed information becomes available.
The template is especially useful for an overview of expected receipts, but it is not a substitute for official calculators, application portals or professional advice. Irish farmers should refer to the Department of Agriculture, Food and the Marine for current BISS and CAP information before making financial or operational decisions based on an estimate.
Who can use this Ireland payment template?
This Ireland payment template can be used by farmers, landowners, farm partnerships, agricultural businesses, consultants, accountants and bookkeepers who need a clear record of BISS-related information. A farmer may use it to review entitlement units, eligible hectares and expected receipts before completing an application.
An adviser may use separate rows for different clients and link each record to an application reference. A farm business can use the notes and status fields to identify documents still required, transfers awaiting confirmation or records that have already been checked.
The layout is intentionally straightforward. It uses euro amounts, hectare measurements and familiar application terms, while providing space for county and farm location details relevant to Irish holdings. Status information such as Draft, Submitted, Checked or Paid can provide a quick progress view.
The Active Farmer Confirmed? field can record an internal check, but it does not establish official eligibility. Any confirmation should be supported by appropriate records and reviewed against the latest rules.
Before using the workbook, gather entitlement statements, land details, transfer documentation, application references and any relevant scheme correspondence. Keep original documents securely and restrict access where the file contains personal or business information. If a record is uncertain, mark it in Notes rather than presenting an assumption as confirmed.
The workbook is not an official form and does not replace the Department of Agriculture, Food and the Marine application process. It is a practical register for organisation, estimation and review. For complex ownership, leasing, transfer, eligibility or tax issues, obtain advice from a suitably qualified Irish agricultural professional.