*The following article is for users who wish to insert sub-currencies into their data.
If you do not intend to insert any sub-currencies when importing Excel files, please refer to the instructions on the link below:
1. Download the attached .xls file (import.xlsx)
2. Go to Google Spreadsheet (https://sheet.new)
3. On Google Spreadsheet, click on File> Import > Upload > Browse > select the downloaded import.xlsx file and upload.
4. Type in the data in reference to the format of the attached file.
5. Make the Excel data with the downloaded format.
・ You can sort your data in the following order.
Follow the below date and category name format as below.
Date – Account – Main Category – Subcategory – Contents – Amount -Income/Expense – Details - Amount Sub - Currency
Date : yy.mm.dd or yyyy.mm.dd, e.g.) 20.08.09 or 2020.08.09
The category and account name have to be the same as the app setting.
'Account' and 'Category' fields must be filled. Otherwise, the data importation would fail.
・ You can specify your data into three categories which are “Income”, “Expenses”, and “Transfer-Out”.
・ For transfer-expenses, it is required to indicate the sender’s account details at “Account” whereas the beneficiary’s account details should be indicated under “Main Category”.
*The sub-currencies must be added in the Money Manager app on your phone before the import.
(Phone > Money Manager > More > Configuration > Sub Currency Setting > click on the + button on the top right corner > search and select the sub-currency to add)
*Insert the sub-currency amount in the sub-currency amount field on the spreadsheet.
(For example, if you have purchased an item worth 9.13 Euros, insert 9.13 in the 'AmountSub' field, and the converted 10 Dollars in the 'Amount' field.)
*The sub-currency field should be inserted with the ISO codes (For example, USD, EUR, KRW etc.) of the sub-currencies. (Reference: ISO 4217 Code)
6. On Google Spreadsheet, click on File > Download > Tab Separated Values (.tsv) > Save
7. Connect your phone to PC / iTunes and locate the .tsv file into MoneyManager/import.
(Mac OS 14 or Before/Windows PC > iTunes)
(Mac OS 15 or later > Finder)
8. Money Manager > More > Backup > Select 'import.tsv'
Find the import.tsv file that is newly appeared.
* Note *
・ As the .xlsx file is not backup data, this process is limited to fully recover by exported .xlsx files.
We recommend using 'money_android.sqlite' file for backup/restore. (How to backup and restore data)
・ There would be some possible exceptions due to the complexity of conversion from MS Excel file.
In order to prevent losing your data, backup your data to email or Google Drive in advance of the import process.
Please carry out a trial run for this prior to the actual data import in preventing the failure.