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

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
CNYUSDJPYTWDHKDKRWEURGBPMOPAUDTHBCADNZDSGDAEDMYRINRIDRRUBBYNMMKPHPVNDARSPKRTRYCHFBDTRONSEKPLNUAHLAKNPRDKKNOKQAREGPRSDMXNXAFHUFKESRWFNGN
# Notes
- Please use the template as the base file and copy the corresponding bills into the template file.
- Please keep the order of the header fields in the template unchanged.
- Please do not create multiple sheets.
- 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.
- 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.
- 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.