Excel workbook previewAnti-bribery (FCPA, UK Bribery Act)
Gifts and Hospitality Register
3 free downloads per account. Just your email and a 6-digit code.
About this template
A gifts and hospitality register is the record of every gift, meal, event and trip that staff give to or receive from customers, suppliers and public officials. Auditors, customers and regulators ask for it to test whether a gifts policy works in practice. The DOJ and SEC Resource Guide to the FCPA names proper recording in the giver's books as a hallmark of appropriate gift-giving, and the UK Ministry of Justice guidance lists hospitality as an area where policies and procedures are expected.
The workbook has a register with live formulas that convert values to US dollars, apply the limit for the direction and type of recipient, and keep a running yearly total for each counterparty so that repeated small gifts show up. A Settings sheet holds the limits and exchange rates as inputs, and a Summary sheet counts entries by category and flags those over a limit or still awaiting approval.
Who it is for
The compliance officer or finance manager who must show an auditor or customer a complete record of gifts and hospitality given and received.
What is inside
- Register sheet with 16 columns, 12 worked sample rows and 20 blank formatted rows
- Live formulas convert each value to USD, look up the item limit and add up the year-to-date total per counterparty
- Limit check column shows Over item limit, Over annual cap, Needs pre-approval, Approved above limit or cap, Pre-approved, Declined or Within limits
- Separate limits for public officials and state-owned enterprise staff, given and received
- Settings sheet with yellow input cells for the limits, annual caps and exchange rates
- Summary sheet with counts and USD totals by category and the number of entries needing attention
- Dropdowns for direction, category, currency, approval and outcome, with colour on checks and pending approvals
- How to use sheet, freeze panes, filters and landscape print fit
How to use it
Open the Settings sheet first and enter your own limits and exchange rates, then replace the sample rows with your entries.
Files
- XLSXgifts-and-hospitality-register.xlsx16 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What should a gifts and hospitality register record?
At a minimum it records the date, whether the item was given or received, the employee, the counterparty organization, whether a public official is involved, a description and business purpose, the value, the approval and what happened to the item. This register also converts the value to US dollars and keeps a yearly total per counterparty, because repeated small gifts can matter as much as one large one.
Do gifts below the limit still need to be recorded?
That depends on your policy. Many companies record everything above a small floor and everything involving a public official whatever the value. The register works either way. The limit check simply shows Within limits for small items, and the year-to-date total still captures them, so a pattern of small gifts to one counterparty becomes visible.
How are foreign currency gifts handled?
Each row has an amount and a currency. The Settings sheet holds a rate to US dollars for each currency, and the register converts the amount with a live formula. The sample rates are placeholders. Enter the rate your expense policy uses and update it when you choose, so that limits are applied in one currency.




