Validated Sales Transaction Entry -- 2

I need help keying in a backlog of sales-transaction records into my master spreadsheet. All raw figures are already collected in Excel/Google Sheets, but they still have to be copied into the main sheet, double-checked, and cleaned up so reporting formulas work without errors.

Accuracy is critical. Each row should be verified against the source totals, date formats must stay consistent (DD/MM/YYYY), and duplicate invoice numbers have to be flagged before they slip through. Feel free to set up data-validation rules, drop-down lists, or conditional formatting—whatever streamlines the process while keeping mistakes out.

Deliverables
• A completed spreadsheet with every transaction entered, validated, and clearly formatted.
• A short log that notes any anomalies you found and how you resolved them.

I’ll share the source file and the destination template once we start; both live in Google Drive so we can collaborate in real time. If you’re comfortable juggling large spreadsheets and enjoy spotting tiny inconsistencies, this task should be straightforward and quick to finish.