No worries if you have a lot of transactions records to import into the system in one shot, this tutorial is to assist you step by step on how to create transactions records in just a minute!

NOTE

This function is currently a Beta feature.

Step by step tutorial to import transactions data with Excel file

1. Proceed to Import Data located at the side menu.

2. Scroll down to the bottom of the page.

3. Download the sample Excel file by clicking on the Download Sample button. The sample Excel file contains sample data for you to modify according to your needs.

4. Select or drag and drop your modified excel file into the field area.

5. Click Import button to import your data into the system.

Guidelines on the Excel file fields

1. trans_date - the date and time when the transaction occurs. eg. 2025-04-01 13:13:13
2. account_id - you may find the account's id by referring to the screenshots below.

- Proceed to Accounting > Bank & Cash Accounts located at the side menu.
- Here shows all the accounts you have created previously.
- Each account's id is listed in the table under ID column.
- Copy the account's id and put into the account_id Excel field.
- Only one id is allowed at a time in a single Excel cell.
- You can create new account from this page by clicking on the button + Add New.
- You may also edit existing account by clicking on the Action > Edit button.

3. transaction_category_id

- Proceed to Accounting > Transaction Categories located at the side menu.
- Here shows all the categories you have created previously.
- Each category's id is listed in the table under ID column.
- Copy the category's id and put into the transaction_category_id Excel field.
- Only one id is allowed at a time in a single Excel cell.
- You can create new transaction category from this page by clicking on the button + Add New.
- You may also edit existing transaction category by clicking on the Action > Edit button.

4. type

- Only accepts two types of values: income OR expense
- Please keep the value in small letters

5. amount

- the amount of the transaction
- NO currency symbol is required, just the numbers is sufficient
- NO negative symbol is required for expense, as it is already been stated under type column

6. method

- payment method of the transaction
- could be any name such as Cash, Touch n Go eWallet, Bank Transfer etc.
- should be kept consistent across transactions, for example, the word "Cash" should be kept the same for all cash payments transactions, you SHOULD NOT have different variations such as "CASH" or "cash" or " Cash" or "C" and so on, as this might cause duplicate entries or inconsistencies in reports.

7. reference - the transaction ID
8. description - describe the record briefly (optional)
9. product_id

You can find the product's id by following the screenshots below.

- Proceed to Products & Services > Products & Services located at the side menu.
- Select the product record you desired, click on the Action dropdown button, click on the View button to view product's details.

- Look at the URL of the product details page.
- The product's id is located at the end of the URL. In this case, the number "9" is the product's id. You may use this product id to fill into the product_id Excel field.

10. class_code - each product item inside the invoice document should have a class_code linked to it (as required by MyInvois portal). Please refer to this link for the list of classification codes accepted by MyInvois portal. If product_id Excel field has value, class_code of the same row record should not be empty, else the record will not be imported into the system.

NOTE
If the transaction record needs to be converted to consolidated invoice, the class_code field value must be 004. Vice versa, if the transaction record will not be used to convert to consolidated invoice, the class_code field value should not be 004.

When converting transactions to consolidated invoice / purchase, our system will automatically convert the class_code of the transaction record to 004, therefore there will be no need for businesses to change the class_code one by one.

11. tax_ids - you may find the tax's id by referring to the screenshots below.

- Proceed to Tax Settings located at the side menu.
- Here shows all the taxes you have created previously.
- Each tax's id is listed in the table under ID column.
- Copy the tax's id and put into the tax_ids Excel field.
- You can apply several taxes onto a single transaction record by putting "," to separate the taxes ids. For example: 1,2

12. exempted_tax_ids - for the taxes that should be exempted on the transaction record, you may fill in the tax id into this Excel field, you may also exempt a several taxes by putting "," to separate the exempted taxes ids. For example: 1,2
13. exempted_tax_reasons - for every tax being exempted, you are required to provide reason to it (as required by MyInvois portal). If you are trying to exempt a few taxes, please ensure that the reasons are separated by the symbol "|". For example: Sample exemption reason 1.|Sample exemption reason 2.