Financial Data Entry & Validation

I have a pre-built Excel template that captures several account metrics, and I need every numeric field populated with up-to-date financial data pulled from my source documents. Accuracy is critical, so I also want range-based validation applied where it makes sense—for instance, preventing negative values where only positive cash flows are possible or flagging any total that exceeds the historical high I will provide.

Here’s what I expect back:
• The template filled out completely, with each cell double-checked against the source figures.
• Range limits implemented through Excel’s Data Validation so out-of-bounds numbers trigger an immediate warning.
• A brief note (one worksheet or a separate text file) summarising any entries that required clarification or exceeded the set limits.

Everything must remain in standard Excel format so I can audit formulas and add my own pivots later. If you’re comfortable working with large numeric datasets and meticulous about spot-checking your inputs, this should be a straightforward task.