I will build a professional excel financial dashboard

Egypt

I speak Arabic, English

Excel and Data Reporting Specialist

Hello! I'm Ahmed, a Senior Accountant with over 5 years of experience in accounting, financial reporting, and data analysis. I specialize in Advanced Excel, Pivot Tables, financial dashboards, budget...
About this Gig

Turn your bookkeeping into a clear, one-page financial dashboard in Excel.


Tired of piecing together profit, cash, and client numbers by hand every month? I build an interactive dashboard that pulls everything from your accounting records and updates automatically when you add new data.


WHAT YOU GET

- KPI cards: revenue, direct costs, gross profit, expenses, net profit and cash, with margins

- Period filter: full period or any single month

- Monthly chart: revenue vs. costs vs. net profit

- Revenue by client with share of total

- Expense breakdown by category

- Project profitability: collections vs. direct costs

- Monthly income statement

- Balance sheet and cash summary (Premium)


HOW IT WORKS

Send me your transactions (Excel or CSV). I organize them into a clean journal sheet, and every dashboard number is a live formula. Add a row and everything updates.


WHY ME

- Formula-based, not static screenshots

- Clean layout that prints on one page

- Branded to your colors on request

- Works in Microsoft Excel, no macros or add-ins

- Your data stays confidential


WHAT I NEED

Date, description, category, amount, and client/project if relevant.


Technology:

Excel

•

Google Sheets

•

Power BI

•

Power Query

Analysis type:

Quantitative analysis

•

Qualitative analysis

Expertise:

Business Insights

•

Trends

•

Forecasting

•

Math

Programming language:

VBA

Tools:

Microsoft Excel

My Portfolio