Expense Tracking and Management

This project demonstrates my ability to handle multi-branch expense tracking with accuracy, organization, and attention to detail using Excel. By maintaining well-structured records and ensuring proper categorization of transactions, I was able to provide a clear and reliable financial overview that supports better business decision-making. I am confident in my ability to deliver consistent and efficient bookkeeping support, and I am ready to help businesses streamline their financial processes and maintain accurate records with professionalism and care.

Consolidated Expense Report for 5 Stores (August 2024)

✅ Expense Summary – August 2024 (5 Branches)

This expense report covers five Generika Drugstore branches in Baguio, showing a detailed record of operational expenses including supplies, utilities, transportation, rent, and miscellaneous costs. Transactions were properly categorized into VAT and Non-VAT expenses to ensure accurate financial tracking and compliance.

Across all branches, the total recorded expenses amount to ₱721,425.06, reflecting consistent monitoring of daily business operations.

📊 Branch Breakdown:

-Calderon Branch:₱393,452.18 (highest due to rental and utilities)

-Upper Mabini Branch:₱149,938.80

-Lower Mabini Branch:₱89,423.08

-Lakandula Branch:₱40,731.50

-Additional Small Branch/Records:₱47,880.50

💼 Key Expense Categories:

-Rent (largest expense across all branches)

-Utilities (electricity, water, internet)

-Supplies (office and store use)

-Transportation (fuel, freight)

-Representation (meals and staff incentives)

-Miscellaneous and professional fees

📊 Expense Graph

✅ Tasks Performed

-Recorded and organized daily expense transactions from multiple branches

-Categorized expenses (Supplies, Utilities, Rent, Transportation, etc.)

-Classified transactions into VAT and Non-VAT

-Verified supporting documents (receipts, invoices, vouchers)

-Consolidated expenses from 5 branches into one report

-Reviewed and ensured accuracy of totals and entries

-Prepared monthly expense summary for reporting

I make it easier for businesses to manage their finances by keeping expense records accurate and organized. With reliable bookkeeping support, business owners can focus on growth knowing their financial data is in good hands.