CSV → QuickBooks IIF

Turns a POS transactions CSV into one QuickBooks Pro 2010 invoice, written in Big5 (cp950) bytes. Everything runs in this page — the CSV never leaves your computer.

1 · Transactions CSV

Drop a CSV here, or click to choose

Expects the POS export columns: 交易序號, 產品序號, 名稱, 價格, 數量, 小計, 交易日期

2 · Invoice settings

Customer

Advanced

Ref No. (max 11 chars)

Invoice date

CSV file encoding

A/R account

Income account

Date format

Item names from

Item type

Class

Terms

Line description

Merge repeated products into one line Mark lines taxable Create accounts / customer / items

Item names are prefixed with the category letter from src/lib/item-mapping.js (14714 → F14714). Description placeholders: {name} {code} {ean} {txn} {clerk} {date} {time} {qty}

1 · Transactions CSV

2 · Invoice settings

3 · Result