How to Import Transactions from Excel Through IO

Modified on Mon, 06 Jun 2022 at 03:42 PM

How to Import Transactions from Excel Through IO

In order to update or import a template of the live transaction, you need to extract first the template from the system by using the IO Export feature.



1.1. Create a sample transaction under the module you opt to update.

e.g. Bill Entries



1.2 Click Search for the listing.

1.3 Right-click the transaction to be exported and go to IO> Export > To Excel.

1.4. Save the Excel file. Open the file, there will be 2 portions/tables of details you need to fill in.


First Table of the Excel file - focuses on the General Document info.



Basis of the First Table

Second Table of the Excel File - pertains to the Specific Details of the document.



Basis for the Details Table


Once the data in excel is complete, you may now use the IO Importation feature.




To import Live Transaction template, go to the transaction form where you will upload the data (e.g. Bills).


2.1. Click Search under Home tab. List of all Bills Document will be displayed. Right click > IO > Import > from Excel.

2.2. Select the filled-out excel file using the 3-dot button. Click OK.



- Tick ‘Overwrite existing data’ to replace existing Document No. in the system

- Tick ‘Validate data on saving’ to know possible error if the uploading is not successful


Uploaded documents will be shown and will be included in the transaction list.


  1. Importation can be done in bulk, just put multiple Line Items in the Excel.
  2. Export and Import of data are not included/captured in the Audit Trail.


For further concerns regarding this matter, please contact support to assist you or create ticket thru this link

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article