Journal entry is used to record down every business transaction of your business. To record down the day-to-day transaction might be complicated for a business. You can choose to record them one by one or by bulk using the TreezSoft import function. This is because Treezsoft allows you to simplify the complicated process of recording and equalizing the debit and credit side of the accounting.
To create journal entries individually, you can refer to our blog post here.
To import journal entries in bulk, navigate through General Ledger > Journal Entry.
![](/upload/blog/484/20211019143040.png)
Click on the "Import Journal Entry" button at the bottom left corner.
![](/upload/blog/484/20211019143128.png)
A popup (As illustrated below) will be displayed.
![](/upload/blog/484/20211019143159.png)
- To import data, click on Browse to select the .csv file which you have edited. (Please ensure the exact file is selected otherwise an error message will be prompt.)
- Click on Upload to proceed.
To import the journal entry listing, you can get the template from:
![](/upload/blog/484/20211019143236.png)
You may refer to the table below on the columns and restrictions when filling the data.
Column |
Description |
Mandatory |
Remarks |
Journal No. |
The journal number |
|
|
Date |
|
Yes |
Format: YYYY-MM-DD |
Currency Code |
The currency code |
Yes |
|
Currency Rate |
The currency rate |
Yes |
Not allow 0 and negative
Max. 5 decimal places |
Tag Code |
The tag code |
|
Add || in between if multiple |
Description |
|
Yes |
|
Journal Account Code |
|
|
Value: COA Code |
Journal Description |
|
Yes |
|
Journal Tax Code Details |
|
|
Mandatory for GST mode
Value: Tax Code |
Journal Debit |
|
|
Max. 2 decimal places |
Journal Credit |
|
|
Max. 2 decimal places |
* Note: No comma for the numerical value
You can read more on related topics in the TreezSoft blog:
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.