I need a Google Sheet that focuses on financial tracking, specifically the reconciliation of data coming from two sources: periodic Excel extracts and our NetSuite exports. The flow should be simple for the team—drop the raw files into predefined tabs, trigger a refresh (formulas or a lightweight Apps Script), and instantly see which transactions match, which do not, and the net variance. Key elements I must see • Import-friendly structure for both Excel and NetSuite CSV files • Normalisation logic to align fields (dates, account codes, memo text) before comparison • Clear reconciliation dashboard with filters for date, account and status, plus automated balance checks • Error flags that highlight missing or duplicate records without manual digging • Sheet protection where necessary so users can’t accidentally break formulas, yet everything remains fully editable for future tweaks Acceptance criteria • After pasting ~10,000-row Excel and NetSuite dumps, results populate in under 30 seconds • All calculations stay inside Google Workspace—no paid add-ons or external databases • Variances show as zero when sample datasets are fully matched, and as accurate differences when rows are intentionally removed When you reply, focus on your experience building similar Google Sheets solutions—especially any reconciliation, data import, or Apps Script work you have done. A brief rundown of techniques (e.g., QUERY, ARRAYFORMULA, VLOOKUP/XLOOKUP, onEdit triggers) is enough; I will follow up for deeper details once I know you’ve handled comparable projects. If this sheet performs well, I plan to fold our existing expense, income, and budgeting trackers into the same workflow, so there is room for future collaboration.