# Template Import


Fill in bills according to our provided template, and then you can import bills into iCost.

iCost import template sample table

Click to Download Template (opens new window)

# Template Field Explanation

Field Requirement Description and Format
Date Required Bill creation time. View supported time formats.
Type Required Bill type: Income, Expense, or Transfer.
Primary Category Conditional The bill's primary category, such as Dining. Required for income/expense bills; optional for transfers.
Secondary Category Optional The bill's secondary category, such as Lunch or Breakfast.
Account 1 Conditional Account for income/expense bills, or the transfer-out account. Required for transfers; optional for income/expense bills.
Account 2 Conditional Transfer-in account. Required for transfers; optional for income/expense bills.
Note Optional Note content.
Amount Required Bill amount. Enter a number without a currency symbol or a positive/negative sign.
Currency Optional Currency symbol. View supported currency symbols.
Tags Optional Bill tags in the format #Tag1#Tag2.

# Supported Time Formats

Chinese
yyyy年MM月dd日 HH:mm:ssyyyy年MM月dd日 HH:mmyyyy年MM月dd日
Hyphens
yyyy-MM-dd HH:mm:ssyyyy-MM-dd HH:mmyyyy-MM-dd
Slashes
yyyy/MM/dd HH:mm:ssyyyy/MM/dd HH:mmyyyy/MM/dd

# Supported Currency Symbols

  • CNY
  • USD
  • JPY
  • TWD
  • HKD
  • KRW
  • EUR
  • GBP
  • MOP
  • AUD
  • THB
  • CAD
  • NZD
  • SGD
  • AED
  • MYR
  • INR
  • IDR
  • RUB
  • BYN
  • MMK
  • PHP
  • VND
  • ARS
  • PKR
  • TRY
  • CHF
  • BDT
  • RON
  • SEK
  • PLN
  • UAH
  • LAK
  • NPR
  • DKK
  • NOK
  • QAR
  • EGP
  • RSD
  • MXN
  • XAF
  • HUF
  • KES
  • RWF
  • NGN

# Notes

  1. Please use the template as the base file and copy the corresponding bills into the template file.
  2. Please keep the order of the header fields in the template unchanged.
  3. Please do not create multiple sheets.
  4. Please make sure to keep the suffix as csv/xls/xlsx format. After editing, use "Save As" to save it as a csv/xls/xlsx file format.
  5. If the imported bill's time is incorrect or some bills are missing after import, please check if the time format is correct and if there are any extra spaces before and after the type, category, and date.
  6. After importing, the amount of assets may not match with the original importing app. This is normal, and you may need to adjust the amount of assets manually.