skip to main content

An Evaluation of ARIMA, ETS, and HOLT-WINTERS Frameworks in Forecasting State Tax Revenue Collections in Indonesia

*Ferry Ferry orcid  -  Directorate General of Taxes Indonesia, Indonesia
Qadri Fidienil Haq  -  Directorate General of Taxes Indonesia, Indonesia
Fajar Fathurrahman orcid  -  Directorate General of Taxes Indonesia, Indonesia
Received: 31 Jan 2026; Revised: 4 Apr 2026; Accepted: 23 Apr 2026; Available online: 10 Jul 2026; Published: 13 Jul 2026.
Open Access Copyright (c) 2026 Tax Accounting Applied Journal
Creative Commons License This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Citation Format:
Abstract

This study evaluates the performance of Auto-Regressive Integrated Moving Average (ARIMA), Error-Trend-Seasonality (ETS), and Holt-Winters frameworks in forecasting state tax revenue collections in Indonesia. Accurate tax revenue prediction is essential for prudent fiscal governance, yet comparative assessments of these methods remain limited in the existing literature. Using monthly tax collection data from January 2016 to March 2024, we employed the period from January 2016 to March 2023 for model identification and the remaining twelve months for out-of-sample validation. Three key findings emerge from our evaluation using Mean Absolute Error (MAE), Mean Squared Error (MSE), and Root Mean Squared Error (RMSE) metrics. First, all three frameworks demonstrate satisfactory predictive accuracy for Indonesian tax revenues. Secondly, each method shows distinct strengths, such as ARIMA performs optimally for withholding tax on employment (PPh 21), ETS achieves superior results for domestic value-added tax (PPN DN), and Holt-Winters provides the most accurate forecasts for personal income tax (PPh OP). Finally, the ETS framework generally outperforms both ARIMA and Holt-Winters across most tax categories. While these findings are specific to Indonesia, the methodological framework offers transferable insights for tax authorities seeking to enhance revenue forecasting and inform evidence-based policymaking.

Keywords: forecasting, tax revenue, public policy, data analytics, public administration

Article Metrics:

Article Info
Section: Articles
Language : EN
  1. Box, G. E. P., & Jenkins, G. M. (1970). Time Series Analysis: Forecasting and Control. San Francisco: Holden-Day
  2. Central Bureau of Statistics Indonesia. (2025). Actual Government Revenues (Billion Rupiahs), 2007−2024. https://www.bps.go.id [Online; accessed 2024-02-15]
  3. Chatfield, C. (1978). The Holt‐Winters forecasting procedure. Journal of the Royal Statistical Society: Series C (Applied Statistics), 27(3), 264−279
  4. Cleveland, R. B., Cleveland, W. S., McRae, J. E., & Terpenning, I. (1990). STL: A seasonal-trend decomposition. J. Off. Stat, 6(1), 3−73
  5. Dickey, D. A., & Fuller, W. A. (1979). Distribution of the estimators for autoregressive time series with a unit root. Journal of the American Statistical Association, 74(366a), 427−431
  6. Directorate General of Taxes Indonesia. (2018). Annual Report Year 2017: Transparency in Building the Nation, Financial Information Transparency for Tax Purposes. https://pajak.go.id/ [Online; accessed 2024-02-25]
  7. Directorate General of Taxes Indonesia. (2023). Annual Report Year 2022: Together in the Spirit of Reform, Establishing a Tradition of Excellence. https://pajak.go.id/ [Online; accessed 2024-02-26]
  8. Fathoni, M. I., & Saputra, A. (2023). Forecasting Value-Added Tax (VAT) revenue using Autoregressive Integrated Moving Average (ARIMA) Box-Jenkins method. Scientax: Jurnal Kajian Ilmiah Perpajakan Indonesia, 4(2), 205–218. https://doi.org/10.52869/st.v4i2.568
  9. Harris, C. R., Millman, K. J., Van Der Walt, S. J., Gommers, R., Virtanen, P., Cournapeau, D., ... & Oliphant, T. E. (2020). Array programming with NumPy. Nature, 585(7825), 357−362
  10. Hunter, J. D. (2007). Matplotlib: A 2D graphics environment. Computing in science & engineering, 9(03), 90−95
  11. Hyndman, R.J., & Athanasopoulos, G. (2021) Forecasting: principles and practice, 3rd edition, OTexts: Melbourne, Australia. OTexts.com/fpp3. Accessed on 25 June 2024
  12. Iraman, E. (2023). Tax Revenue Forecasting: an Empirical Evidence Using Autoregressive-Distributed Lag (ARDL). Qeios
  13. Kithure, M. E. (2021). Use of Time Series Models on Forecasting of Value Added Tax Revenue in Kenya Revenue Authority. African Tax and Customs Review, 4(2), 22−22
  14. Kwiatkowski, D., Phillips, P. C. B., Schmidt, P., & Shin, Y. (1992). Testing the null hypothesis of stationarity against the alternative of a unit root: How sure are we that economic time series have a unit root? Journal of Econometrics, 54(1-3), 159–178
  15. Lütkepohl, H., & Xu, F. (2012). The role of the log transformation in forecasting economic variables. Empirical Economics, 42, 619–638. https://doi.org/10.1007/s00181-010-0440-1
  16. Makananisa, M. P. (2015). Forecasting annual tax revenue of the South African taxes using time series Holt-Winters and ARIMA/SARIMA Models. South Africa: University of South Africa
  17. McKinney, W. (2010, June). Data structures for statistical computing in Python. In SciPy (Vol. 445, No. 1, pp. 51−56)
  18. Molapo, M. A., Olaomi, J. O., & Ama, N. O. (2019). Bayesian vector auto-regression method as an alternative technique for forecasting South African tax revenue. Southern African Business Review, 23(1). https://doi.org/10.25159/1998-8125/4416
  19. Muslim, H. A. (2022). Time Series Analysis for Customs Revenue Prediction using Arima Model in Python. Journal of Information Technology and Its Utilization, 5(2), 47−55
  20. Nandi, B. K., Chaudhury, M., & Hasan, G. Q. (2014). Univariate time series forecasting: A study of monthly tax revenue of Bangladesh. East West Journal of Business and Social Studies, 1
  21. Pedregosa, F., Varoquaux, G., Gramfort, A., Michel, V., Thirion, B., Grisel, O., ... & Duchesnay, É. (2011). Scikit-learn: Machine learning in Python. Journal of Machine Learning Research, 12, 2825−2830
  22. Pegels, C. C. (1969). Exponential forecasting: Some new variations. Management Science, 311−315
  23. Priandono, Y. A., & Prasetya, M. E. (2025). Dekomposisi Penerimaan Pajak di Indonesia untuk Meningkatkan Peramalan Estimasi Basis Pajak. Owner: Riset dan Jurnal Akuntansi, 9(1), 130−139
  24. Rahal, R. M., Hamann, H., Brohmer, H., & Pethig, F. (2022). Sharing the recipe: Reproducibility and replicability in research across disciplines. Research Ideas and Outcomes: RIO, 8(Article e89980), 1−20
  25. van Rossum, G. (1995). Python tutorial: Technical Report CS-R9526, Centrum Voor Wiskunde En Informatica (CWI), Amsterdam
  26. Seabold, S., & Perktold, J. (2010). Statsmodels: econometric and statistical modeling with python. Proceedings of the 9th Python in Science Conference
  27. Smith, T. G., et al. pmdarima: ARIMA estimators for Python, 2017, http://www.alkaline-ml.com/pmdarima [Online; accessed 2024-02-14]
  28. Streimikiene, D., Rizwan Raheem, A., Vveinhardt, J., Pervaiz Ghauri, S., & Zahid, S. (2018). Forecasting tax revenues using time series techniques–a case of Pakistan. Economic research-Ekonomska istraživanja, 31(1), 722−754. https://doi.org/10.1080/1331677X.2018.1442236
  29. Suprayogi, M. A. (2022). Model Double Exponential Smoothing Dalam Peramalan Penerimaan Pajak Pemerintah Pusat Indonesia. Jurnal Statistika dan Komputasi, 1(2), 83−92
  30. Susilawati, S., Falefi, R., & Purwoko, A. (2020). Impact of COVID−19’s Pandemic on the Economy of Indonesia. Budapest International Research and Critics Institute-Journal (BIRCI-Journal), 3(2), 1147−1156
  31. Urrutia, J. D., Mingo, F. L. T., & Balmaceda, C. N. M. (2015). Forecasting Income Tax Revenue of the Philippines Using Autoregressive Integrated Moving Average (Arima) Modeling: a Time Series Analysis. Am. Res. Thoughts, 1(9), 1938−1992
  32. Wahyu, F. P., Rahmawati, I. D., & Umam, K. (2022, December). Identifying best method for forecasting tax income using time series analysis. In IAPA Proceedings Conference (pp. 60−73)
  33. Waskom, M. L., (2021). seaborn: statistical data visualization. Journal of Open Source Software, 6(60), 3021, https://doi.org/10.21105/joss.03021
  34. World Health Organization. (2020, December 2). Coronavirus Disease 2019 (COVID-19) Situation Report – 36. Retrieved from https://www.who.int/indonesia/news/novel-coronavirus/situation-reports [Online; accessed 2024-06-25]

Last update:

No citation recorded.

Last update:

No citation recorded.