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

Ref No. (max 11 chars)

Advanced

Invoice date

CSV file encoding

A/R account

Date format

Item names from

Class

Terms

Line description

Merge repeated products into one line Mark lines taxable Create accounts / customer / items that are missing Also redefine the ones QuickBooks already has

Each product is looked up in src/lib/item-mapping.js, generated from the QuickBooks item list: the item name gets the category letter (14714 → F14714) and the item carries that list's description and income account. Products are imported as inventory parts; a code the mapping gives a type of its own keeps it — DIFF is the 10% Discount item. QuickBooks matches an item by its name, so a product already in that list is only referenced, never re-declared — re-declaring it would overwrite its sales price and COGS account. Tick the second box only for a brand new company file. Description placeholders: {name} {code} {ean} {txn} {clerk} {date} {time} {qty}

1 · Transactions CSV

2 · Invoice settings

3 · Result