Blog Archive

How to Keep Data Sales Records With a Simple Spreadsheet

  • BY:Yhommydata

Use one row per order. Start with the date, network, bundle, customer payment, wallet debit, order reference and status. Keep only the customer details you need to resolve an order and restrict access to the spreadsheet.

Create rows that reconcile

For a completed order, log the amount collected and amount deducted. For a pending order, record its status before counting it as a completed sale. If a refund arrives later, record it against the same reference so it can be traced.

Compare the sheet with your wallet history

At closing time, compare completed debits, credits and refunds with the wallet record. If the numbers differ, sort by reference and check for duplicate rows, missing funding entries or orders that moved from pending to completed.

View available YHOMMYDATA bundles and check the current allowance, price and validity before buying.

You may also like