This project demonstrates my ability to manage, organize, and process invoicing and billing data accurately using spreadsheet tools like Microsoft Excel and Google Sheets. The dataset includes 20 sample invoices generated over a three-month period, simulating real-world business transactions across multiple international clients.
Each record contains essential billing details such as invoice date, unique invoice number, client name, service description, quantity/hours worked, unit pricing, total amount calculation, and payment status (Paid, Pending, or Overdue).
The project highlights my skills in:
Accurate data entry and formatting
Invoice tracking and organization
Performing calculations (e.g., total amount = quantity × unit price)
Maintaining data consistency and structure
Handling financial records with attention to detail
This sample dataset reflects common tasks performed in data entry and billing roles, including managing client records, tracking payments, and ensuring data accuracy for financial reporting.
Client had raw sales data (14 rows across UK/USA, split by quarter) and needed it turned into something actually usable. I cleaned it up and built a PivotTable that breaks total sales down by rep and country, with grand totals for both.
What I did:
Structured the raw data into a proper table (consistent headers, currency formatting)
Built a PivotTable summarizing Sum of Sales by Last Name and Country
Used SUMIFS so the totals update automatically if the source data changes — nothing hardcoded
Checked every formula for errors before delivery
Delivered as a working .xlsx file, ready to plug into a bigger report or dashboard.
If you've got messy sales/ops data sitting in a spreadsheet and need it turned into something you can actually read at a glance, this is exactly the kind of thing I can help with.