Data entry work sample

What this file shows

The invoice sheet holds 60 entries from October to December 2024. Each one points to a customer ID, and the customer name and city are looked up from the customer sheet, so nothing is typed twice.

A separate sheet takes untidy names, phone numbers, emails and dates and turns them into one clean format. A last sheet checks the whole workbook and reports any problem.

Checks that run on the data

• No duplicate invoice numbers or customer IDs
• No blank cells in any entry column
• Every invoice matches a real customer
• Phone numbers have 10 digits, pincodes have 6
• Amounts match quantity times rate
• Dashboard totals match the invoice totals