Following are reference meterial for the CSV templates
Supplier Import Template Details#
| Field Name | Description |
|---|---|
| VendorCode | Enter the supplier code |
| Name | Enter the supplier name |
| PartyIdentificationType | Enter the identification type |
| PartyIdentification | Enter the identification type number |
| Enter the supplier name | |
| Phone | Enter the supplier phone number |
| DomiciledCountry | Enter the supplier country code e.g AU |
| Enabled | 1 |
| DiscountingLimit | Enter the supplier discounting limit |
| Rating | Enter the supplier rating e.g Good |
| Address PostBox BuildingNumber BuildingName StreetName AdditionalStreetName Department CityName PostalZone CountrySubentity CountrySubentityCode Country CountryCode |
Enter supplier address information as below e.g 250 e.g LEVEL 29 91 e.g queens e.g KING WILLIAM STREET e.g kings street e.g 2 e.g ADELAIDE e.g 5000 e.g New South Wales e.g NSW e.g Australia e.g AU |
| BankAccounts CountryCode Name BankName BranchName SwiftCode BankCode BranchCode AccountNumber CurrencyCode Enabled Default |
Enter supplier bank account information as below e.g AU e.g Account1 e.g bank wespac e.g Branch One 1 e.g CTBAAU2S e.g CBA e.g RBS e.g 147254896312536 e.g AUD 1 1 |
Click here to download the CSV template to upload the supplier details
Payable Invoice Import Template details#
| Field Name | Description |
|---|---|
| SupplierCode | Enter the supplier code |
| SupplierName | Enter the Supplier name |
| InvoiceNumber | Enter the invoice number |
| InvoiceAmount | Enter the invoice amount |
| TaxAmount | Enter the tax amount |
| Currency | Enter the currency code e.g AUD |
| InvoiceDate | Enter the invoice issued date (mm/dd/yyyy) e.g 1/25/2022 |
| DueDate | Enter the invoice due date (mm/dd/yyyy) e.g 1/28/2022 |
| InvoiceTypeCode | Enter the invoice type code e.g taxInvoice |
| ControlTypeCode | Enter the control type code e.g invoice |
| WithdrawFlag | 0 |
| InvoiceLines Description UnitAmount Quantity TaxAmount LineAmount |
Enter the line item related information as below e.g description e.g 1 e.g 2 e.g 3 e.g 4 |
Click here to download the CSV template to upload the invoice details
Credit Note Import Template details#
| Field Name | Description |
|---|---|
| InvoiceTypeCode | CreditNote |
| ControlTypeCode | Adjustment |
Click here to download the CSV template to upload the credit invoice details
Debit Note Import Template details#
| Field Name | Description |
|---|---|
| InvoiceTypeCode | DebitNote |
| ControlTypeCode | Adjustment |
Click here to download the CSV template to upload the debit invoice details
Purchaser Import Template Details#
| Field Name | Description |
|---|---|
| VendorCode | Enter the purchaser code |
| Name | Enter the purchaser name |
| PartyIdentificationType | Enter the identification type |
| PartyIdentification | Enter the identification type number |
| Enter the purchaser email | |
| Phone | Enter the purchaser phone number |
| DomiciledCountry | Enter the purchaser country code e.g AU |
| Enabled | 1 |
| DiscountingLimit | Enter the purchaser discounting limit |
| Rating | Enter the purchaser rating e.g Good |
| Address PostBox BuildingNumber BuildingName StreetName AdditionalStreetName Department CityName PostalZone CountrySubentity CountrySubentityCode Country CountryCode |
Enter purchaser address information as below e.g 250 e.g LEVEL 29 91 e.g queens e.g KING WILLIAM STREET e.g kings street e.g 2 e.g ADELAIDE e.g 5000 e.g New South Wales e.g NSW e.g Australia e.g AU |
| BankAccounts CountryCode Name BankName BranchName SwiftCode BankCode BranchCode AccountNumber CurrencyCode Enabled Default |
Enter purchaser bank account information as below e.g AU e.g Account1 e.g bank wespac e.g Branch One 1 e.g CTBAAU2S e.g CBA e.g RBS e.g 147254896312536 e.g AUD 1 1 |
Click here to download the CSV template to upload the purchaser details
Invoice Manual Adding Templete#
| Field Name | Description |
|---|---|
| Purchaser | Select the purchaser from the drop down. |
| Identification type | Select the identification type from the drop down (ACN, ABN, UEN, CRN). |
| Identification number | Enter the number of the identification type. |
| Invoice ID | Enter the invoice ID. |
| Invoice type | Select the Invoice type from the drop down. |
| Purchaser Code | Enter the purchaser code. |
| Issue date | Select the Issued date of the invoice. |
| Due date | Select the due date of the invoice. |
| Item name | Enter the name of the item. |
| Item description | Enter the description of the item. |
| Unit price | Enter the unit price of the item. |
| Quantity | Enter the quantity of the item. |
| Tax | Enter the tax amount of the item. |
| Amount | Enter the total amount of the item. |
Receivable Invoice Import Template details#
| Field Name | Description |
|---|---|
| purchaserCode | Enter the purchaser code |
| purchaserName | Enter the purchaser name |
| InvoiceNumber | Enter the invoice number |
| InvoiceAmount | Enter the invoice amount |
| TaxAmount | Enter the tax amount |
| Currency | Enter the currency code e.g AUD |
| InvoiceDate | Enter the invoice issued date (mm/dd/yyyy) e.g 1/25/2022 |
| DueDate | Enter the invoice due date (mm/dd/yyyy) e.g 1/28/2022 |
| InvoiceTypeCode | Enter the invoice type code e.g taxInvoice |
| ControlTypeCode | Enter the control type code e.g invoice |
| WithdrawFlag | 0 |
| InvoiceLines Description UnitAmount Quantity TaxAmount LineAmount |
Enter the line item related information as below e.g description e.g 1 e.g 2 e.g 3 e.g 4 |
Click here to download the CSV template to upload the invoice details
Reverse Factoring Financing Scheme Templete#
| Field Name | Description |
|---|---|
| Financing Instrument Code | Reverse factoring |
| Negotiating Party | Select the purchaser |
| Allocation Limit Type | Total – Total facility amount. Internal debt – Facility amount will be dynamically updated whenever a transaction takes place (e.g. When the allocation limit is 100,000 and if you finance 80,000 for an invoice and you receive 50,000 as the payback, then you will get the 70,000 (20,000+50,000) as the remaining.) |
| Allocation limit | Maximum allocated limit which suppliers can request for financing. |
| Invoice Limit | Percentage of the total invoice value that a financier will finance per financing |
| Approval Lead time | Maximum hours which could be taken to proceed the invoice financing. |
| Tolerance | The maximum amount which can go beyond the allocation limit. |
| Minimum Request Limit | Minimum invoice amount which is eligible for financing. |
| Maximum Request Limit | Maximum invoice amount which is eligible for financing. |
| Repayment Date | Date which the payback amount could be settled. Facility date - Payback amount will be settled on the date which initiated the financing. Maturity date - Payback amount will be settled on the invoice due date. |
| Currency Code | Invoice currency code. |
| Interest Rate Type | Flat-Total interest amount will be charged (e.g. Invoice amount $5000, interest rate 10.5% and invoice duration 30 days. Interest amount will be calculated 5000 * 10.5/100). Flat annual - Interest amount will be charged considering the duration of the invoice (e.g. Invoice amount $5000, interest rate 10.5% and invoice duration 30 days. Interest amount will be calculated 5000 * 10.5/100 * 30/365). Market Rate - Base interest rate is accessed from an external source (eg: Bloomberg), to which the financier can add a margin. The aggregated amount will be the interest rate that is charged. |
| Minimum Due Days | Minimum no of days from financing requesting day to invoice due date |
| Interest Rate | Interest Percentage amount |
| Approval Method | Unsupported - Financing scheme won’t be supported. Auto – Supplier finance requests will be auto approved by the platform, provided the request meets all the finance scheme criteria. Manual – Financier manually approves each finance request. |
Country Codes And Currency Codes#
| Country | 2 - Character Code | 3 - Character Code | Currency Code |
|---|---|---|---|
| Andorra | AD | AND | EUR |
| United Arab Emirates (the) | AE | ARE | AED |
| Afghanistan | AF | AFG | AFN |
| Antigua and Barbuda | AG | ATG | XCD |
| Anguilla | AI | AIA | XCD |
| Albania | AL | ALB | ALL |
| Armenia | AM | ARM | AMD |
| Angola | AO | AGO | AOA |
| Argentina | AR | ARG | ARS |
| American Samoa | AS | ASM | USD |
| Austria | AT | AUT | EUR |
| Australia | AU | AUS | AUD |
| Aruba | AW | ABW | AWG |
| Åland Islands | AX | ALA | EUR |
| Azerbaijan | AZ | AZE | AZN |
| Bosnia and Herzegovina | BA | BIH | BAM |
| Barbados | BB | BRB | BBD |
| Bangladesh | BD | BGD | BDT |
| Belgium | BE | BEL | EUR |
| Burkina Faso | BF | BFA | XOF |
| Bulgaria | BG | BGR | BGN |
| Bahrain | BH | BHR | BHD |
| Burundi | BI | BDI | BIF |
| Benin | BJ | BEN | XOF |
| Saint Barthélemy | BL | BLM | EUR |
| Bermuda | BM | BMU | BMD |
| Brunei Darussalam | BN | BRN | BND |
| Bolivia (Plurinational State of) | BO | BOL | BOB |
| Bonaire, Sint Eustatius and Saba | BQ | BES | USD |
| Brazil | BR | BRA | BRL |
| Bahamas (the) | BS | BHS | BSD |
| Bhutan | BT | BTN | BTN |
| Bouvet Island | BV | BVT | NOK |
| Botswana | BW | BWA | BWP |
| Belarus | BY | BLR | BYN |
| Belize | BZ | BLZ | BZD |
| Canada | CA | CAN | CAD |
| Cocos (Keeling) Islands (the) | CC | CCK | AUD |
| Congo (the Democratic Republic of the) | CD | COD | CDF |
| Central African Republic (the) | CF | CAF | XAF |
| Congo (the) | CG | COG | XAF |
| Switzerland | CH | CHE | CHE |
| Côte d'Ivoire | CI | CIV | XOF |
| Cook Islands (the) | CK | COK | NZD |
| Chile | CL | CHL | CLF |
| Cameroon | CM | CMR | XAF |
| China | CN | CHN | CNY |
| Colombia | CO | COL | COP |
| Costa Rica | CR | CRI | CRC |
| Cuba | CU | CUB | CUC |
| Cabo Verde | CV | CPV | CVE |
| Curaçao | CW | CUW | ANG |
| Christmas Island | CX | CXR | AUD |
| Cyprus | CY | CYP | EUR |
| Czechia | CZ | CZE | CZK |
| Germany | DE | DEU | EUR |
| Djibouti | DJ | DJI | DJF |
| Denmark | DK | DNK | DKK |
| Dominica | DM | DMA | XCD |
| Algeria | DZ | DZA | DZD |
| Ecuador | EC | ECU | USD |
| Estonia | EE | EST | EUR |
| Egypt | EG | EGY | EGP |
| Western Sahara | EH | ESH | MAD |
| Eritrea | ER | ERI | ERN |
| Spain | ES | ESP | EUR |
| Ethiopia | ET | ETH | ETB |
| Finland | FI | FIN | EUR |
| Fiji | FJ | FJI | FJD |
| Falkland Islands (the) (Malvinas) | FK | FLK | FKP |
| Micronesia (Federated States of) | FM | FSM | USD |
| Faroe Islands (the) | FO | FRO | DKK |
| France | FR | FRA | EUR |
| Gabon | GA | GAB | XAF |
| United Kingdom of Great Britain and Northern Ireland (the) | GB | GBR | GBP |
| Grenada | GD | GRD | XCD |
| Georgia | GE | GEO | GEL |
| French Guiana | GF | GUF | EUR |
| Guernsey | GG | GGY | GBP |
| Ghana | GH | GHA | GHS |
| Gibraltar | GI | GIB | GIP |
| Greenland | GL | GRL | DKK |
| Gambia (the) | GM | GMB | GMD |
| Guinea | GN | GIN | GNF |
| Guadeloupe | GP | GLP | EUR |
| Equatorial Guinea | GQ | GNQ | XAF |
| Greece | GR | GRC | EUR |
| Guatemala | GT | GTM | GTQ |
| Guam | GU | GUM | USD |
| Guinea-Bissau | GW | GNB | XOF |
| Guyana | GY | GUY | GYD |
| Hong Kong | HK | HKG | HKD |
| Heard Island and McDonald Islands | HM | HMD | AUD |
| Honduras | HN | HND | HNL |
| Croatia | HR | HRV | HRK |
| Haiti | HT | HTI | USD |
| Hungary | HU | HUN | HUF |
| Indonesia | ID | IDN | IDR |
| Ireland | IE | IRL | EUR |
| Israel | IL | ISR | ILS |
| Isle of Man | IM | IMN | GBP |
| India | IN | IND | INR |
| British Indian Ocean Territory (the) | IO | IOT | USD |
| Iraq | IQ | IRQ | IQD |
| Iran (Islamic Republic of) | IR | IRN | IRR |
| Iceland | IS | ISL | ISK |
| Italy | IT | ITA | EUR |
| Jersey | JE | JEY | GBP |
| Jamaica | JM | JAM | JMD |
| Jordan | JO | JOR | JOD |
| Japan | JP | JPN | JPY |
| Kenya | KE | KEN | KES |
| Kyrgyzstan | KG | KGZ | KGS |
| Cambodia | KH | KHM | KHR |
| Kiribati | KI | KIR | AUD |
| Comoros (the) | KM | COM | KMF |
| Saint Kitts and Nevis | KN | KNA | XCD |
| Korea (the Democratic People's Republic of) | KP | PRK | KPW |
| Korea (the Republic of) | KR | KOR | KRW |
| Kuwait | KW | KWT | KWD |
| Cayman Islands (the) | KY | CYM | KYD |
| Kazakhstan | KZ | KAZ | KZT |
| Lao People's Democratic Republic (the) | LA | LAO | LAK |
| Lebanon | LB | LBN | LBP |
| Saint Lucia | LC | LCA | XCD |
| Liechtenstein | LI | LIE | CHF |
| Sri Lanka | LK | LKA | LKR |
| Liberia | LR | LBR | LRD |
| Lesotho | LS | LSO | LSL |
| Lithuania | LT | LTU | EUR |
| Luxembourg | LU | LUX | EUR |
| Latvia | LV | LVA | EUR |
| Libya | LY | LBY | LYD |
| Morocco | MA | MAR | MAD |
| Monaco | MC | MCO | EUR |
| Moldova (the Republic of) | MD | MDA | MDL |
| Montenegro | ME | MNE | EUR |
| Saint Martin (French part) | MF | MAF | EUR |
| Madagascar | MG | MDG | MGA |
| Marshall Islands (the) | MH | MHL | USD |
| Republic of North Macedonia | MK | MKD | MKD |
| Mali | ML | MLI | XOF |
| Myanmar | MM | MMR | MMK |
| Mongolia | MN | MNG | MNT |
| Macao | MO | MAC | MOP |
| Northern Mariana Islands (the) | MP | MNP | USD |
| Martinique | MQ | MTQ | EUR |
| Mauritania | MR | MRT | MRU |
| Montserrat | MS | MSR | XCD |
| Malta | MT | MLT | EUR |
| Mauritius | MU | MUS | MUR |
| Maldives | MV | MDV | MVR |
| Malawi | MW | MWI | MWK |
| Mexico | MX | MEX | MXN |
| Malaysia | MY | MYS | MYR |
| Mozambique | MZ | MOZ | MZN |
| Namibia | NA | NAM | NAD |
| New Caledonia | NC | NCL | XPF |
| Niger (the) | NE | NER | XOF |
| Norfolk Island | NF | NFK | AUD |
| Nigeria | NG | NGA | NGN |
| Nicaragua | NI | NIC | NIO |
| Netherlands (the) | NL | NLD | EUR |
| Norway | NO | NOR | NOK |
| Nepal | NP | NPL | NPR |
| Nauru | NR | NRU | AUD |
| Niue | NU | NIU | NZD |
| New Zealand | NZ | NZL | NZD |
| Oman | OM | OMN | OMR |
| Panama | PA | PAN | USD |
| Peru | PE | PER | PEN |
| French Polynesia | PF | PYF | XPF |
| Papua New Guinea | PG | PNG | PGK |
| Philippines (the) | PH | PHL | PHP |
| Pakistan | PK | PAK | PKR |
| Poland | PL | POL | PLN |
| Saint Pierre and Miquelon | PM | SPM | EUR |
| Pitcairn | PN | PCN | EUR |
| Puerto Rico | PR | PRI | USD |
| Portugal | PT | PRT | EUR |
| Palau | PW | PLW | USD |
| Paraguay | PY | PRY | PYG |
| Qatar | QA | QAT | QAR |
| Réunion | RE | REU | EUR |
| Romania | RO | ROU | RON |
| Serbia | RS | SRB | RSD |
| Russian Federation (the) | RU | RUS | RUB |
| Rwanda | RW | RWA | RWF |
| Saudi Arabia | SA | SAU | SAR |
| Solomon Islands | SB | SLB | SBD |
| Seychelles | SC | SYC | SCR |
| Sudan (the) | SD | SDN | SDG |
| Sweden | SE | SWE | SEK |
| Singapore | SG | SGP | SGD |
| Saint Helena, Ascension and Tristan da Cunha | SH | SHN | SHP |
| Slovenia | SI | SVN | EUR |
| Svalbard and Jan Mayen | SJ | SJM | NOK |
| Slovakia | SK | SVK | EUR |
| Sierra Leone | SL | SLE | SLL |
| San Marino | SM | SMR | EUR |
| Senegal | SN | SEN | XOF |
| Somalia | SO | SOM | SOS |
| Suriname | SR | SUR | SRD |
| South Sudan | SS | SSD | SSP |
| Sao Tome and Principe | ST | STP | STN |
| El Salvador | SV | SLV | USD |
| Sint Maarten (Dutch part) | SX | SXM | ANG |
| Syrian Arab Republic | SY | SYR | SYP |
| Eswatini | SZ | SWZ | SZL |
| Turks and Caicos Islands (the) | TC | TCA | USD |
| Chad | TD | TCD | XAF |
| French Southern Territories (the) | TF | ATF | EUR |
| Togo | TG | TGO | XOF |
| Thailand | TH | THA | THB |
| Tajikistan | TJ | TJK | TJS |
| Tokelau | TK | TKL | NZD |
| Timor-Leste | TL | TLS | USD |
| Turkmenistan | TM | TKM | TMT |
| Tunisia | TN | TUN | TND |
| Tonga | TO | TON | TOP |
| Turkey | TR | TUR | TRY |
| Trinidad and Tobago | TT | TTO | TTD |
| Tuvalu | TV | TUV | AUD |
| Taiwan (Province of China) | TW | TWN | TWD |
| Tanzania, United Republic of | TZ | TZA | TZS |
| Ukraine | UA | UKR | UAH |
| Uganda | UG | UGA | UGX |
| United States Minor Outlying Islands (the) | UM | UMI | USD |
| United States of America (the) | US | USA | USD |
| Uruguay | UY | URY | UYI |
| Uzbekistan | UZ | UZB | UZS |
| Holy See (the) | VA | VAT | EUR |
| Saint Vincent and the Grenadines | VC | VCT | XCD |
| Venezuela (Bolivarian Republic of) | VE | VEN | VEF |
| Virgin Islands (British) | VG | VGB | USD |
| Virgin Islands (U.S.) | VI | VIR | USD |
| Viet Nam | VN | VNM | VND |
| Vanuatu | VU | VUT | VUV |
| Wallis and Futuna | WF | WLF | XPF |
| Samoa | WS | WSM | WST |
| Yemen | YE | YEM | YER |
| Mayotte | YT | MYT | EUR |
| South Africa | ZA | ZAF | ZAR |
| Zambia | ZM | ZMB | ZMW |
| Zimbabwe | ZW | ZWE | ZWL |