Previous studies have highlighted the importance of automation in tax compliance. Research has shown that automation can reduce errors, increase efficiency, and enhance taxpayer compliance (Kumar et al., 2019; Smith et al., 2020). Excel has been widely used for various applications, including tax planning and compliance (Johnson et al., 2018). However, there is limited research on designing an ERCA business income tax declaration form using Excel.
The Electronic Receipt Cum Assessment (ERCA) business income tax declaration form is a crucial document for businesses to report their income and claim tax deductions. However, the manual process of filling and submitting the form can be tedious and prone to errors. This paper proposes a novel approach to designing an ERCA business income tax declaration form using Excel, leveraging its built-in features to automate calculations, validate data, and generate a compliant form. Our proposed design aims to reduce errors, increase efficiency, and enhance taxpayer compliance. erca business income tax declaration form excel
Johnson, K., Smith, J., & Williams, P. (2018). Using Excel for tax planning and compliance. Journal of Taxation, 129(3), 34-41. However, there is limited research on designing an