Legal Billing Discrepancy Spreadsheet-I can only PAY $100
Budget: $30 – $250 USD
I have seven divorce-case billing statements from my lawyer, and I need them consolidated into a single Microsoft Excel workbook that makes every inconsistency jump out at a glance.
Your job is to import each statement onto its own tab, then build an analysis sheet that automatically flags:
• Overcharged hours
• Duplicate charges
• Unusual expenses
• Fraudulent billing
Smart use of formulas, conditional formatting, and (if helpful) pivot tables should let me see where each new statement differs from the last and exactly how the totals shift over time.
Please structure the workbook so I can drop in any additional statements later and have the discrepancy calculations update without extra work.
Deliverables
1. One Excel file (.xlsx) containing:
– Seven raw-data tabs (one per statement)
– A clearly labeled discrepancy dashboard
2. A brief note explaining the logic behind your checks so I can audit or extend them myself.
Accuracy is critical, so the workbook must reconcile down to the cent. Let me know if you need sample data before we begin.
Picture below is a sample of the dates for each submission was across the top below. It put the dollar amount and then a brief description for each one underneath it, and then on the left of the spreadsheet would be the date going down on each one there will be multiple dates with different writing in each one if you can color coordinate each date submitted and make it easier in the chart.
Your job is to import each statement onto its own tab, then build an analysis sheet that automatically flags:
• Overcharged hours
• Duplicate charges
• Unusual expenses
• Fraudulent billing
Smart use of formulas, conditional formatting, and (if helpful) pivot tables should let me see where each new statement differs from the last and exactly how the totals shift over time.
Please structure the workbook so I can drop in any additional statements later and have the discrepancy calculations update without extra work.
Deliverables
1. One Excel file (.xlsx) containing:
– Seven raw-data tabs (one per statement)
– A clearly labeled discrepancy dashboard
2. A brief note explaining the logic behind your checks so I can audit or extend them myself.
Accuracy is critical, so the workbook must reconcile down to the cent. Let me know if you need sample data before we begin.
Picture below is a sample of the dates for each submission was across the top below. It put the dollar amount and then a brief description for each one underneath it, and then on the left of the spreadsheet would be the date going down on each one there will be multiple dates with different writing in each one if you can color coordinate each date submitted and make it easier in the chart.