Summary of Expenses AES
Showcasing the Summary of Expenses I created in Microsoft Excel, highlighted both the technical skills (Excel formulas, data encoding, table organization) and the business value (financial tracking, reporting, and accountability).
đź“Š Summary of Expenses
Tool Used: Microsoft Excel
Description: Prepared a detailed expense summary for Axioma Engineering Services covering Q3 2024. The spreadsheet includes:
Expense Categories such as construction supplies, payroll, utilities, rentals, fuel, travel, insurance, and compliance contributions (SSS, PhilHealth, Pag‑IBIG).
Data Encoding of financial records with accurate totals for each category.
Formula Integration using SUMIF and other functions to automate calculations and ensure accuracy.
Multi‑Page Layout (Page 1 & Page 2) for organized presentation of large datasets.
Total Expense Tracking with consolidated figures for management review and decision‑making.
This sample demonstrates skills in financial documentation, Excel data management, and report preparation — ensuring clarity, compliance, and efficiency in construction company operations.
