Platform

Data import

Customer, price-library and opening-balance loads.

Financial templates Debtors

Customer master data

Loaded

Name, ABN, billing address, contacts and payment terms.

5 customers02/08/2026Import customers

4 active on 30 to 60 day terms · Formerline Projects archived.

Price and rate library

Loaded

Item, unit, sell rate, estimated cost, tax treatment and effective date.

42 items05/08/2026Import rates

Effective 01/07/2026 · QT-1188 and QT-1201 were priced off it.

Opening valuation

2 rows held back

Opening debtor balances and the inventory valuation carried into the ledger, each with the reconciliation reference it was agreed under.

16 of 18 rows11/08/2026Import valuation

Inventory valuation $486,200.00 agrees with the 580 stock records.

Recent financial imports

3 loads · 02/08/2026 to 11/08/2026

Three financial loads between 02/08/2026 and 11/08/2026
When	Import	File	Rows	Loaded	Failed	Result	By
11/08/2026 2:20pm	Opening valuation	opening-valuation.xlsx	18	16	2	With errors	Linh Hoang	Re-import
05/08/2026 4:40pm	Price and rate library	price-library-jul26.xlsx	42	42	0	Complete	Linh Hoang	View rows
02/08/2026 11:15am	Customer master data	customers.xlsx	5	5	0	Complete	Linh Hoang	View rows
3 loads			65	63	2

Two opening debtor balances carry no as-at date — Harbourline Constructions and Sterling Build Group. Date them from the agreed reconciliation and re-import.

Financial import templates

Required columns, in order:

customers      customer_code, customer_name, abn, billing_address, contact_name, payment_terms_days
rates          price_item_code, description, unit, sell_rate, estimated_cost, tax_code, effective_from
valuation      opening_balance_reference, customer_code, amount, as_at_date

Validation: abn is eleven digits, payment_terms_days is 30, 45 or 60, amounts are AUD to two decimals and as_at_date is dd/mm/yyyy on or before today.

A load is posted whole: the rows that pass go in, the rows that fail come back with the reason.