2024 TAX REVENUE COLLECTION DASHBOARD USING MICROSOFT EXCEL

I have collected data on the total revenue collected by the Adenta Taxpayer Service Centre of the Ghana Revenue Authority for the year 2024.

I have used Microsoft Excel to analysed the Data, performed calculations and visualize the data to reveal Key Performance Indicators (KPIs) such as: Total Direct Tax collected, Total Indirect Tax Collected, Total Amount paid as Registration Fees and Total Amount paid into Suspense Account.

I have created a dynamic and interactive Dashboard that displays the KPIs. On the dashboard are pivot charts that reveal actionable insights from the data that will enable management make decisions on revenue collection.

I have created the 2024 Revenue Collection Dashboard to enable management to derive actionable insights from the total revenue collected per month by the GRA Adenta office and to show the Variance of Actual Revenue collected and Revenue Targets.