# Template Import

Place bills according to our provided template into a CSV file, and then you can import bills into iCost.

# Template Field Explanation

Column	Required	Explanation	Format	Supported Version
Date	✅	Bill time	Bill creation time, Supported Time Formats	Online version
Type	✅	Bill type	Currently only supports types such as Income/Expense/Transfer, etc.	Online version
Primary Category	Income/Expense ✅ Transfer ❌	Primary category to which the bill belongs	e.g., Dining, required for Expense/Income bills, not required for Transfer bills	Online version
Secondary Category	❌	Secondary category to which the bill belongs	e.g., Lunch, Breakfast, etc.	Online version
Account 1	Expense/Income ❌ Transfer ✅	Account associated with the bill	Associated account for Expense/Income, or Transfer bill's transfer-out account, required for Transfer bill	Online version
Account 2	Expense/Income ❌ Transfer ✅	Transfer bill's transfer-in account	Transfer bill's transfer-in account, required for Transfer bill	Online version
Note	❌	Note content	Note content	Online version
Amount	✅	Bill amount	Pure number, without currency symbol and positive/negative sign	Online version
Currency	❌	Currency symbol	Supported Currency Symbols	Online version
Tags	❌	Bill tags	e.g., `#Tag1#Tag2`	Online version

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.