Data Import lets you upload and integrate all information into the TreezSoft cloud accounting all at once. Therefore, you will not miss any of your existing cash payment records even when you first started with TreezSoft. You can download the template prepared by us and refer to a table in restrictions when filling the data to import your list of cash payments. Apart from directly importing a list of cash payments, you also can choose to enter each cash payment manually. You can find the guide to enter individual cash payments through this link.
In this blog, we will guide you on how you can import a list of cash payments all at once into your TreezSoft account.
How to import cash payment listing?
To import the list of cash payments to TreezSoft, navigating through Banking > Cash Payments.
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 payments based on a formatted CSV file provide by TreezSoft.
2. Click on "Upload' to proceed.
To import a list of cash payments, 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 payment |
Yes |
Format: YYYY-MM-DD |
| Payment No |
The payment number |
Yes |
|
| Pay From Account |
The payment account |
Yes |
Value: Bank Account Code |
| Pay To |
Pay to |
|
|
| 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 payment 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.