Checked transactions
One combined CSV of accepted transaction rows, retaining original filename and source row for tracing.
ONE-TIME SERVICE · VERIFIED CSV OUTPUT FORMAT
Sales CSVs scattered?
Merge, summarize and check them.
For small teams with matching sales-export CSVs: I combine validated transactions, calculate totals by customer and product, and list rejected records instead of silently counting them.
Fixed-scope manual fulfillment. No subscription, account access, or software installation required from the buyer. Sample data are fictional—not customer projects or sales results.
Three deliverables
Customer & product totals
Totals for matching customer/product codes: total quantity and calculated amount (quantity × unit price).
Exclusions and reasons
Missing fields, invalid dates, ambiguous names or duplicate source files are listed for review, not hidden.
Download four fictional CSV examples
The five-row sample has three valid transactions and two rejected rows (one blank quantity, one nonexistent calendar date). Accepted total: KRW 55,000. These are actual test-engine examples, not real client data.
Original example5 sales rowsDownload input CSV ↓
Validated merged data3 accepted rowsDownload merged CSV ↓
Totals by customer/product6 units / KRW 55,000Download summary CSV ↓
Error and exclusion list2 rejected rowsDownload errors CSV ↓
All example files are UTF-8 CSVs with a BOM, not XLSX. Some spreadsheet programs may remove leading zeros from product codes unless you explicitly import codes as text.
Confirm the scope before ordering
- Seven input columns
- Exact Korean header names:
거래일, 거래처코드, 거래처, 상품코드, 상품명, 수량, 단가(date, customer code/name, product code/name, quantity, unit price). Column order may differ. The public offer does not yet include flexible header mapping or automatic translation. - Input limits
- 1–5 CSV files, ≤10 MB each, ≤20 MB total, ≤10,000 data rows. UTF-8 or CP949; dates YYYY-MM-DD, quantity a positive integer, unit price a nonnegative KRW integer.
- Included
- Three CSV output files and a short QA summary. Only valid rows are counted. Excluded rows create a partial total, not a complete sales total.
- Different CSV headers?
- Our published US$79 offer does not include mapping different column names. If each input still represents the seven clear transaction fields, you may ask whether a separately scoped manual mapping job is feasible using fictional or redacted header names. This workflow has only been verified with synthetic test data; a separate quotation and agreed validation would be required. Do not buy the standard product first.
- Not included
- Excel XLSX, ERP or API integration, remote login, reusable source scripts, auto-fetch, recurring processing, automatic interpretation of refunds/returns, bookkeeping and tax advice.
- Privacy and timing
- First provide only fictional or redacted header examples and estimated file/row counts; agree on rules and turnaround before ordering. Do not share actual sensitive data in the inquiry form.
GUMROAD COMMISSION · PUBLISHED OFFER
US$79 for the agreed one-time service
The Gumroad product describes a 50% deposit at checkout and 50% balance upon completion. The payment processor's current checkout display, fees, FX rates and terms control the actual transaction. Confirm the exact input scope and timing first.
View Gumroad product / ordering →
Opening the product link does not pay or create an order.
Free file-scope inquiry
Share only the header names, estimated file counts/sizes and desired totals. Please do not paste personal data, transaction records, account numbers or passwords.
A FormSubmit anti-spam check may appear. Alternative: email the operator directly.