Customer open items file

The file Customer open items (customer_items) gives the open items of each customer at the cutover date, for example the invoices that the customer did not pay. The items go into the lines Party balances of the draft opening balances, on the control account of the customers.

Rules of the rows

The company must be Migrating, and the opening balances must be a draft.
Each party must have the role customer.
Write one row for each open item, with its original date. The date gives the age of the item. Without a date, the item has the cutover date. A date after the cutover date is an error.
Write the amount that the customer must pay in debit. Write an advance or a credit of the customer in credit.
The items of one customer must all be on the same side. Write the net amount: for example, one credit row for a customer with more advances than invoices.
The total of the items of all customers is the balance of the control account of the customers.
Caution: A new file replaces all the lines of the earlier file.

Rules of the file

Row 1 has the column names. Do not change them. The data starts on row 2.
Write the data on the sheet "customer_items". The system reads the sheet "customer_items", or else the first sheet.
A column that is not necessary can stay empty. You can remove a column that is not necessary.
A file can have at most 100,000 data rows and 20 MB. Put more data in more than one file.
Codes and other text: write them as text. Excel keeps a code such as 001 only in a text cell.
Y means yes and N means no. A list column takes more than one value, separated by ";".
Do not write formulas. The system reads the values only.

Columns of the file (version 1)

Column	Necessary	Type	Meaning	Example
`party_code`	Yes	code, at most 32 characters	The code of a party with the role customer.	`C-0001`
`item_date`	No	date YYYY-MM-DD	The date of the item (for example of the invoice). Empty: the cutover date. Not after the cutover date.	`2026-08-15`
`reference`	No	text, at most 40 characters	The number of the source document, for example the invoice number.	`INV-1042`
`debit`	No	amount, at most 2 decimals, without a thousands separator	The amount that the customer must pay.	`2500.00`
`credit`	No	amount, at most 2 decimals, without a thousands separator	An advance or a credit of the customer.
`description`	No	text, at most 500 characters	A text for the item.
`source_note`	No	text, at most 100 characters	A note that identifies the row in your source. The system shows it in the messages, and it does not keep it.	`voucherdt:001`

Example

A file with one row, in CSV format. Row 1 has the column names.

party_code,item_date,reference,debit,credit,description,source_note
C-0001,2026-08-15,INV-1042,2500.00,,,voucherdt:001