You might have historical invoices when you started to use Treezsoft cloud accounting software. With Treezsoft, it provides you an easier way to keep track of your historical invoices as Treezsoft is using an automated accounting and integration processes. You may choose to enter each historical invoice or import the list of the historical invoices at once using the template prepared by us.
To import historical invoices, navigate through: Company > Opening Balances > Historical Invoices.
Click on the "Import Historical Invoices" button at the bottom left corner.
A popup (As illustrated below) will be displayed.
- To import data, click on Browse to select .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.
Preparing the Historical Invoices – Opening Balance import file
- Download the blank formatted CSV from here.
- Edit the CSV using Excel.
- Refer to the table below on the columns and restrictions when filling the data.
| Column |
Description |
Mandatory |
Remarks |
| Customer |
The respective customers |
Yes |
|
| Date |
Date of the transactions |
Yes |
|
| Invoice No. |
The invoice number |
Yes |
|
| Currency |
The currency used |
Yes |
|
| Rate |
Rate between based currency and foreign currency |
Yes |
Maximum 5 decimal places |
| Amount Without Tax |
The net amount which without tax |
Yes |
Maximum 2 decimal places, the amount must be the sum |
| Tax Rate |
Tax code |
|
|
| Tax Amount |
Amount of tax charged |
|
Maximum 2 decimal places |
| Amount |
Total amount after tax |
Yes |
Maximum 2 decimal places, the amount must be the sum |
* Note: No comma for the numerical value
You can read more on related topics in 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.