The data migration process involves export to import. You have to export the existing data from the previous system and import them into our system when you started to use TreezSoft cloud accounting software. You have the option of manually entering each cash receipt into the system or simply importing the cash receipt listing using the template we prepared.
How to import cash receipts listing?
To import the list of cash receipts to TreezSoft, navigating through Banking > Cash Receipts.
Click on the “Import" button at the bottom left corner.
You will see the screen below after you click on the import button.
1. Click on "Browse" to select your cash receipts based on a formatted CSV file provide by TreezSoft.
2. Click on "Upload' to proceed.
To import a list of cash receipts, you can download the template from:
To view the sample, you can download it from:
You can refer to the table below on the columns and restrictions when filling the data.
| Column |
Description |
Mandatory |
Remarks |
| Date |
The date of the issued cash receipt |
Yes |
Format: YYYY-MM-DD |
| Receipt No |
The receipt number |
Yes |
|
| Deposit Account |
The deposit account |
Yes |
Value: Bank COA Code |
| Received from |
Received from |
|
|
| Tag Code |
The tag code |
|
Add || in between if multiple |
| Currency Code |
The currency code |
Yes |
|
| Currency Rate |
Currency rate in use when you created the cash receipt |
Yes |
Not allow 0 and negative
Max. 5 decimal places
|
| Payment Method |
The payment method used (eg. cash, credit card, cheque) |
Yes |
Value: Cheque/Credit card/Cash/EFT/Others |
| Cheque No |
Cheque number |
|
Mandatory if Payment Method = Cheque |
| Remark |
The statement/opinion/comment to mark |
|
|
| Journal Account |
Journal account |
Yes |
Value: COA Code |
| Journal Details |
Journal details |
|
|
| Journal Amount |
Journal amount |
Yes |
Max. 2 decimal places |
You can visit these links to read more about cash receipt in TreezSoft:
You can also read more on import function in TreezSoft by visiting these links:
TreezSoft is a cloud accounting software for Small and Medium-sized Enterprises (SMEs). It allows you to access your financial information anytime, anywhere. It also allows you to have unlimited users for FREE for your account in TreezSoft. Our aim is to help reduce our clients' time spent on accounting mainly by using our automated processes and integration to help increase their company efficiency at minimum costs. SMEs can use TreezSoft to keep track of their expenses, accounts, daily operation e.g. Point of Sales (namely QPOS) system and etc.
Visit TreezSoft at http://www.treezsoft.com/ to sign up for a 30 days trial account with us!
You can also email us at [email protected] for more inquiries.