Send cloudBuy your AP (Accounts Payable) and PO (Purchase Order) data so we can identifty the items you've been purchasing, and we'll start finding your organisation's savings.
Five types of files are supported:
The columns supported in each of these files and the meanings of these columns are described in detail below.
A row in a typical PO file gives:
Product information is not normally available in AP systems, so a row in a typical AP file consists of just:
However, where you do have line item detail in AP data, full use can be made of this.
These two files – the PO file and the AP file – are the minimum requirement for a run of SpendInsight.
Additional supporting information helps SpendInsight establish the true identity of products (catalogue or contract data) or suppliers (supplier information database).
Often this supporting information will be a part of a separate extract. SpendInsight is fully able to link data together from multiple sources.
The standard input data format for SpendInsight is CSV, where:
For example, the first few records of a PO file might look like this:
25/1/10,o1,ACME,aws,ACME standard widget,5,£3,£15
25/1/10,o2,ACME,aw2,'ACME widget, type 2',5,'£3,000','£15,000'
25/1/10,o3,ACME,aw-s,'ACME 'super' widget', type 1,5,£3,£15