Time to prepare and pay taxes (hours)
Real data: World Bank, Jobs, indicator IC.TAX.DURS, retrieved 19 November 2026. Values are as published; we only reshaped the file.
What it measures
Time to prepare and pay taxes is the time, in hours per year, it takes to prepare, file, and pay (or withhold) three major types of taxes: the corporate income tax, the value added or sales tax, and labor taxes, including payroll taxes and social security contributions.
Limits and exceptions (World Bank note)
To make the data comparable across countries, several assumptions are made about businesses. The main assumptions are that they are limited liability companies, they operate in the country's most populous city, they are domestically owned, they perform general industrial or commercial activities, and they have certain levels of start-up capital, employees, and turnover. The Doing Business methodology on business taxes is consistent with the Total Tax Contribution framework developed by PricewaterhouseCoopers (now PwC), which measures the taxes that are borne by companies and that affect their income statements. However, PwC bases its calculation on data from the largest companies in the economy, while Doing Business focuses on a standardized medium-size company.
The numbers in 2016
In 2016, 188 countries have a value. The highest is Brazil (2,038); the lowest is United Arab Emirates (12). The median country value is 209.5. The World Bank's World aggregate for 2016 is 245.3.
Top 10 countries, 2016
hours
Highest, 2016
| # | Country | Value |
|---|---|---|
| 1 | Brazil | 2,038 |
| 2 | Bolivia | 1,025 |
| 3 | Libya | 889 |
| 4 | Venezuela, RB | 792 |
| 5 | Chad | 766 |
| 6 | Ecuador | 664 |
| 7 | Cameroon | 648 |
| 8 | Congo, Rep. | 602 |
| 9 | Viet Nam | 540 |
| 10 | Equatorial Guinea | 492 |
Lowest, 2016
| # | Country | Value |
|---|---|---|
| 1 | United Arab Emirates | 12 |
| 2 | Bahrain | 27 |
| 3 | Qatar | 41 |
| 4 | San Marino | 52 |
| 5 | Luxembourg | 55 |
| 6 | Estonia | 56 |
| 7 | Switzerland | 63 |
| 8 | Singapore | 66.5 |
| 9 | Brunei Darussalam | 66.5 |
| 10 | Saudi Arabia | 67 |
How many countries report, by decade
| Decade | Most countries in one year |
|---|---|
| 2000s | 171 |
| 2010s | 188 |
World aggregate by year
As published by the World Bank (in the regions file, not the country file).
| Year | World |
|---|---|
| 2016 | 245.3 |
| 2015 | 256 |
| 2014 | 258.2 |
| 2013 | 262.1 |
| 2012 | 248.5 |
| 2011 | 254 |
| 2010 | 259.3 |
| 2009 | 263.6 |
| 2008 | 276.6 |
| 2007 | 292 |
| 2006 | 300.1 |
| 2005 | 302.2 |
By region, 2016
| World Bank region | Value |
|---|---|
| Latin America & Caribbean | 339.7 |
| Sub-Saharan Africa | 284.8 |
| South Asia | 284.2 |
| Middle East, North Africa, Afghanistan & Pakistan | 209.1 |
| East Asia & Pacific | 190.8 |
| Europe & Central Asia | 189.2 |
| North America | 153 |
First rows
time-to-prepare-and-pay-taxes-hours.csv
| countrytext | iso3text | regiontext | income_grouptext | yearnumber | valuenumber |
|---|---|---|---|---|---|
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2005 | 275 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2006 | 275 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2007 | 275 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2008 | 275 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2009 | 275 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2010 | 275 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2011 | 275 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 2012 | 275 |
Data dictionary
| Column | Type | Meaning |
|---|---|---|
| country | text | Country or economy, World Bank name |
| iso3 | text | ISO 3166-1 alpha-3 code |
| region | text | World Bank region |
| income_group | text | World Bank income group |
| year | number | Calendar year of the value |
| value | number | Time to prepare and pay taxes (hours), exactly as the World Bank API returns it (not rounded) |
Only country-years with a value are in the long file; blank cells in the wide file mean no value was published.
Practice questions
answers computed from the file
Which country has the highest value in 2016?
Brazil, with 2,038.
Excel (on the long CSV: E = year, F = value)
=FILTER(A2:A100000,(E2:E100000=2016)*(F2:F100000=MAXIFS(F2:F100000,E2:E100000,2016)))SQL (table wb = the CSV)
SELECT country, value FROM wb WHERE year = 2016
AND value = (SELECT MAX(value) FROM wb WHERE year = 2016);pandas (df = pd.read_csv("time-to-prepare-and-pay-taxes-hours.csv"))
y = df[df.year == 2016]
y[y.value == y.value.max()][["country", "value"]]File: time-to-prepare-and-pay-taxes-hours.csv
How many countries report a value for 2016?
188 of the 217 economies in the file's country list.
Excel (on the long CSV: E = year, F = value)
=COUNTIF(E2:E100000,2016)SQL (table wb = the CSV)
SELECT COUNT(*) FROM wb WHERE year = 2016;pandas (df = pd.read_csv("time-to-prepare-and-pay-taxes-hours.csv"))
(df.year == 2016).sum()File: time-to-prepare-and-pay-taxes-hours.csv
What is the median across countries in 2016?
209.5 (median of the 188 country values; not a World Bank aggregate).
Excel (on the long CSV: E = year, F = value)
=MEDIAN(FILTER(F2:F100000,E2:E100000=2016))SQL (table wb = the CSV)
-- SQLite has no MEDIAN(); this picks the middle value(s)
SELECT AVG(value) FROM (SELECT value FROM wb WHERE year = 2016 ORDER BY value
LIMIT 2 - (SELECT COUNT(*) FROM wb WHERE year = 2016) % 2
OFFSET (SELECT (COUNT(*) - 1) / 2 FROM wb WHERE year = 2016));pandas (df = pd.read_csv("time-to-prepare-and-pay-taxes-hours.csv"))
df[df.year == 2016]["value"].median()File: time-to-prepare-and-pay-taxes-hours.csv
Which country rose the most between 2006 and 2016?
Maldives: from 0 to 405.5, a rise of 405.5 (out of 166 countries with both years).
Excel (on the long CSV: E = year, F = value)
Use the wide file (time-to-prepare-and-pay-taxes-hours-wide.csv): add a column = [2016] - [2006], then sort it largest to smallest.SQL (table wb = the CSV)
SELECT a.country, b.value - a.value AS rise FROM wb a JOIN wb b ON a.iso3 = b.iso3
WHERE a.year = 2006 AND b.year = 2016 ORDER BY rise DESC LIMIT 1;pandas (df = pd.read_csv("time-to-prepare-and-pay-taxes-hours.csv"))
w = df.pivot(index="country", columns="year", values="value")
(w[2016] - w[2006]).dropna().nlargest(1)File: time-to-prepare-and-pay-taxes-hours.csv
Which year has the most countries reporting?
2016, with 188 countries.
Excel (on the long CSV: E = year, F = value)
Make a pivot table: year in Rows, Count of value in Values, then sort by the count.SQL (table wb = the CSV)
SELECT year, COUNT(*) AS n FROM wb GROUP BY year ORDER BY n DESC, year DESC LIMIT 1;pandas (df = pd.read_csv("time-to-prepare-and-pay-taxes-hours.csv"))
df.groupby("year").size().sort_values(ascending=False).head(1)File: time-to-prepare-and-pay-taxes-hours.csv