linewickPreparing your CSV files.
For the free check, Linewick formats your exports for you. This page is for trying the demo with your own files.
The templates hold the demo’s fictional sample. Replace those rows with your own.
Before you begin
- One currency (USD, GBP or EUR), with prices and amounts before tax.
- The same customer and subscription IDs in all three files.
- Dates as
YYYY-MM-DD, including the first and last day. - A unique
row_idon every line, up to 1 MB and 5,000 rows per file.
1. License history
The original charge for the period, plus every change that affects it.
Columns
| Columns | What to put here |
|---|---|
row_id | A reference back to the source line. |
customer_idsubscription_id | Stable IDs used in all three files. |
customer_nameproduct | Readable labels. Customer names can be pseudonyms. |
period_startperiod_end | The dates this charge or change covers, not the export date. |
quantity | The full seat count on this row, 0 to 100,000. |
event | base, reversal, replacement or credit. |
currency | USD, GBP or EUR. |
2. Selling rules
The price agreed with your customer, not your cost or list price.
Columns
| Columns | What to put here |
|---|---|
row_idcustomer_idsubscription_id | A source reference and the matching IDs. |
period_startperiod_end | The selling period to review, up to 366 days. |
pricing_model | daily, period_prorated or closing_quantity. |
unit_price | The price per seat for that model, up to six decimals. |
currency | The same currency as the other files. |
history_complete | true only once the base charge and every change are included. |
daily is unit price × seat-days. period_prorated is unit price × seat-days ÷ days in the period. closing_quantity is unit price × seats on the last day.
3. Customer invoices
Every invoice line for the period. Matching lines are added together.
Columns
| Columns | What to put here |
|---|---|
row_idcustomer_idsubscription_id | The invoice line reference and matching IDs. |
period_startperiod_end | The service dates, matching the selling rule. |
amount | The pretax amount actually billed. Include credit lines as negatives. |
currency | The same currency as the other files. |
Special cases
Seat changes, credits and rounding
If 20 seats become 24, keep the original base row, add a reversal of 20 for the affected dates and a replacement of 24. The template doesn’t use a “+4” delta.
A negative supplier amount doesn’t always mean fewer seats. The review flags credits for a separate decision. Use one selling rule per subscription; a price change mid-period needs a format check. The expected amount is rounded to two decimals.
A header-only invoice file means no invoices. Confirm completeness only if that’s true. Microsoft’s billing scenarios and reconciliation fields explain the source data.