Record each new purchase into the transactions worksheet

Unrecorded purchases create gaps in your transaction dataset and skew revenue analysis. Save each sale to a transactions worksheet so analysts have complete data before next reporting.