Invoice Test Data
Use invoice dummy data inspired by the qualified invoice preservation method under the Consumption Tax Act and the Electronic Books Preservation Act to test tax-rate totals, rounding, and electronic storage together.
Compliance disclaimer
This content is a technical sample and does not guarantee tax calculations or compliance with the Electronic Books Preservation Act. Have a tax accountant or auditor review it before production use.
Invoice data involves complex calculation logic such as tax-rate totals and rounding, which makes covering test cases time-consuming. A standard schema lets you reproduce the key use cases safely.
The invoice schema covers everything from line items and tax-rate totals to payment and storage categories. Below are representative fields and references. Field names stay in Japanese even in the en-US locale, so they work directly for accounting-software import tests.
| Field | Description | Reference |
|---|---|---|
| 請求書番号 | Unique invoice number | Digit count and prefix can be adjusted to your internal invoice-numbering scheme |
| 発行日 | Invoice issue date (YYYY-MM-DD) | Used as the reference date for tax-rate totals and rounding |
| 発行事業者登録番号 | Qualified invoice issuer registration number | "T + 13 digits" format; one of the required entries under the qualified invoice preservation method of the Consumption Tax Act |
| 請求先名 | Billed party's name | A fictional billed-party name unrelated to any real company |
| 明細 | A JSON array with line number/item/quantity/unit/unit price/tax category/amount | Stored as a JSON string in a single cell when exported to CSV |
| 10%対象金額 | Total of amounts subject to the standard 10% rate | Follows the principle of totaling per tax rate before applying rounding once |
| 10%消費税額 | Consumption tax amount based on the 10% total | The amount after applying the rounding mode (roundingMode) once |
| 8%対象金額 | Total of amounts subject to the reduced 8% rate | Adjust the share of line items at this rate with the reducedRateRatio parameter |
| 端数処理 | Rounding method used | Corresponds to the roundingMode parameter (floor/round/ceil) |
| 税込合計 | Total including tax (tax-exclusive total + tax total) | Useful for reconciliation checks when importing into accounting software |
| 支払状況 | Status such as unpaid or paid | Adjust the rate of overdue invoices with the overdueRatio parameter |
| 電子保存区分 | Electronic transaction storage-category label | Models the search requirements (date, amount, counterparty) required by the Electronic Books Preservation Act |
The qualified invoice preservation method requires recording the taxable amount and consumption tax amount per tax rate, with rounding applied only once per rate. This schema follows the same logic — totaling per tax rate before rounding once — so you can use it directly to test aggregation logic.
Retain the tax category (10% / 8% / exempt) per line item so you can trace exactly where a mismatch occurs in the tax calculation.
Since the qualified invoice preservation method requires rounding only once per tax rate, test for logic that mistakenly rounds on every line item.
Use the generated data to verify in advance a storage design (indexing) that supports searching by transaction date, amount, and counterparty.
Document as a business rule how to handle invoices without a registration number, and reflect it in your test cases.
A. Following the qualified invoice preservation method, the logic totals the taxable amount per tax rate first, then applies rounding to the consumption tax amount exactly once. The roundingMode parameter switches between floor (round down), round (round to nearest), and ceil (round up).
A. Yes — the reducedRateRatio parameter adjusts the share of line items taxed at 8%. Set it to 0 for invoices with only the 10% rate, or closer to 1 for invoices dominated by the reduced rate.
A. Because line items are an array containing line number, item, quantity, unit price, tax category, and amount, CSV exports store them as a JSON string in a single cell. Use the JSON export, or expand the array with a script afterward, if you need one row per line item.
A. You may need to check and adjust the field layout and header names, but it is well suited to testing tax-rate-total and rounding logic. If you need columns matched to a specific accounting product's format, open a GitHub Issue to discuss it.
Get invoice data with tax-rate totals, rounding, and Electronic Books Preservation Act categorization as CSV, JSON, or via the REST API. Combine it with corporate master data to build end-to-end billing-through-payment test scenarios.
Download a ready-made sample for each schema to check the format before touching the generator.
100-row sample with dummy watermark