✓
HR employee reconciliation
Scenario: HR has an employee master, but IT has a separate email or device list. Names may not match perfectly and inactive employees may still appear in system dumps.
Example: Compare employee master vs Gmail/Zoho dump to find active users without mailboxes, inactive users still consuming licenses, and unknown mailboxes that require investigation.
| Input files | Employee Master CSV/XLSX + Email Dump CSV/XLSX |
|---|
| Matching keys | Employee Code, Work Email, Email Username, Employee Name |
|---|
| Output | Active matched users, inactive users with licenses, missing mailboxes, unknown accounts and action sheet for HR/IT. |
|---|
✓
IT asset reconciliation
Scenario: IT has a master asset list, dispatch history, received history and user ownership dump. Serial numbers may be repeated or ownership may be outdated.
Example: Upload asset master and vendor/dispatch data, match by serial number, then use latest activity date to identify current owner or returned status.
| Input files | Asset Master + Dispatch Sheet + Received Sheet + Blank Serial List |
|---|
| Matching keys | Serial Number, Asset Tag, Employee Code, Dispatch Date, Received Date |
|---|
| Output | Latest owner, returned devices, missing serials, duplicate assets and ownership conflict report. |
|---|
✓
Vendor billing reconciliation
Scenario: Vendor billing contains rental laptops, devices or services, but internal records may not match the billed list.
Example: Compare vendor invoice data against internal asset master to identify billed-but-missing devices, internally present but not billed devices, duplicate serials and rent mismatches.
| Input files | Vendor Billing Sheet + Internal Asset Master |
|---|
| Matching keys | Serial Number, Asset Tag, Vendor Reference, Invoice Number |
|---|
| Output | Missing-in-master list, billing issue list, duplicate serial groups and management-ready financial impact summary. |
|---|
✓
Email license audit
Scenario: Teams pay for Google Workspace, Zoho or other email accounts, but the license dump may include ex-employees, aliases, generic mailboxes and unknown users.
Example: Match email dump against active HR records and separate accounts into Keep, Review, Remove or Investigate buckets.
| Input files | HR Active List + Gmail/Zoho Dump + Optional Generic Mailbox List |
|---|
| Matching keys | Email, Username, Employee Code, Status |
|---|
| Output | License usage summary, inactive-user mailboxes, unknown accounts and a safe action list for IT Admin. |
|---|
✓
Finance invoice checks
Scenario: Finance receives invoices with reference numbers, amounts and dates that must be compared against internal approvals or asset records.
Example: Compare invoice lines with approved records to flag missing references, changed amounts or duplicate invoice numbers before payment review.
| Input files | Invoice Dump + Approval Sheet + Vendor Master |
|---|
| Matching keys | Invoice Number, Vendor Reference, Amount, Date |
|---|
| Output | Matched invoices, unmatched invoices, duplicate invoices, amount mismatch list and payment-review action sheet. |
|---|
✓
BYOD and personal laptop checks
Scenario: Employees may appear in BYOD, personal laptop and company asset lists at the same time. This creates compliance and ownership confusion.
Example: Compare BYOD declaration with personal laptop list and company asset assignment to find employees appearing in multiple categories.
| Input files | BYOD List + Personal Laptop List + Asset Assignment Export |
|---|
| Matching keys | Employee Code, Email, Employee Name |
|---|
| Output | Employees present in multiple lists, duplicate names, missing declarations and follow-up action sheet. |
|---|