# 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
| Column | Required | Explanation | Format | Supported Version |
|---|---|---|---|---|
| Date | Yes | Bill time | Bill creation time, Supported Time Formats | Online version |
| Type | Yes | Bill type | Currently supports Income/Expense/Transfer | Online version |
| Primary Category | Income/Expense: YesTransfer: No | Primary category for the bill | Required for income/expense bills, optional for transfer bills | Online version |
| Secondary Category | No | Secondary category for the bill | For example: lunch, breakfast, etc. | Online version |
| Account 1 | Income/Expense: NoTransfer: Yes | Account associated with the bill | Payment account for income/expense bills, or transfer-out account for transfer bills | Online version |
| Account 2 | Income/Expense: NoTransfer: Yes | Transfer-in account | Required for transfer bills | Online version |
| Note | No | Note content | Note content | Online version |
| Amount | Yes | Bill amount | Pure number, without currency symbol or positive/negative sign | Online version |
| Currency | No | Currency symbol | Supported Currency Symbols | Online version |
| Tags | No | Bill tags | For example #Tag1#Tag2 | Online version |
# Supported Time Formats
- yyyy年MM月dd日 HH:mm:ss
- yyyy年MM月dd日 HH:mm
- yyyy年MM月dd日
- yyyy-MM-dd HH:mm:ss
- yyyy-MM-dd HH:mm
- yyyy-MM-dd
- yyyy/MM/dd HH:mm:ss
- yyyy/MM/dd HH:mm
- yyyy/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
- 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.