Data and reporting
Find a practical guide by topic, then take a concrete next step.
Define gross and net sales consistently
Document which discounts, refunds and taxes are included in each measure.
Read the guide →Data and reportingChoose a reporting cut-off time
Use the same time zone and cut-off across comparisons.
Read the guide →Data and reportingCheck missing order IDs
Count blank identifiers and resolve them before merging datasets.
Read the guide →Data and reportingDetect repeated order IDs
Distinguish line items and status updates from genuine duplicates.
Read the guide →Data and reportingValidate currency columns
Reject or flag rows without a known currency rather than assuming MYR.
Read the guide →Data and reportingCheck decimal separators
Test number parsing on representative source files.
Read the guide →Data and reportingValidate negative amounts
Determine whether negatives represent refunds, reversals or errors.
Read the guide →Data and reportingSeparate quantities from currency amounts
Preserve field definitions when joining stock and sales files.
Read the guide →Data and reportingReconcile report row counts
Compare exported, imported and rejected counts for every batch.
Read the guide →Data and reportingCheck file encoding before import
Inspect product names and identifiers for corrupted characters.
Read the guide →Data and reportingPreserve source version dates
Record when reports were downloaded and whether historical data can change.
Read the guide →Data and reportingBuild a controlled SKU mapping
Use one reviewed mapping rather than ad hoc name matching.
Read the guide →Data and reportingReview dashboard totals against source
Reconcile headline metrics to a reproducible source report.
Read the guide →Data and reportingAvoid mixing paid and placed orders
Use the same status population when comparing periods.
Read the guide →Data and reportingCalculate refund rate with a defined denominator
State whether the rate uses order count or value.
Read the guide →Data and reportingCalculate stock turnover cautiously
Use consistent cost bases and clearly defined periods.
Read the guide →Data and reportingTrack dashboard changes
Document formula edits so apparent performance changes can be explained.
Read the guide →Data and reportingPrepare e-Invoice questions for an adviser
List marketplace roles and document flows, then check current HASiL guidance with the professional.
Read the guide →Data and reportingCheck legal entity details across documents
Resolve inconsistent entity names and identifiers with the responsible professional.
Read the guide →Data and reportingDocument limits of a management estimate
State assumptions, missing evidence and who must review the result.
Read the guide →