Integrate Zoho Books with Universal CSV

Import card transactions, bill payments, reimbursements and bank feed into Zoho Books

David James avatar
Written by David James
Updated over a week ago

Integrate Zoho Books using Universal CSV

Online accounting tool Zoho Books allows you to collaborate across departments while managing your money and automating business processes. Zoho Books takes care of tedious accounting procedures so you can concentrate on your business, from contract negotiations to sales order creation to invoicing.

Firstly you will need to create a bank account in your Zoho books software named VOLOBANK-SGD and share the name of the account with us.

Exporting transactions from Volopay

You can export from the accounting table: Accounting table>Pending to export>Export CTA.

You can bulk select or select transactions individually, and after clicking export, a small window will pop up. In the modal popup there will be three options; to export and download.

Once you select “Export as Zohobooksl format”it will go to the “downloads' ' tab. There, upon opening you will see your exported file in the Jurnal format with the “status” ready. Again when you select download as csv or pdf it will direct you to the downloads tab and you will find the downloaded file with the “status” ready.

Importing into Zoho Books

After exporting the transactions from Volopay, you will have to follow these steps for importing the files in Zoho Books.

Card Transactions

Go to Purchase>click on Expense>click on the three dash menu> Import Expense>it will direct you to Configure>select the file>click on next>you will be directed to mapping of fields>check the date format it should be dd-mm-yyyy(or else it will throw an error)>click next you will be redirected to preview>click import>Voila you have your imported card transactions.

Bills

Go to Purchase>click on Bills>click on the three dash menu> Import Bills>it will direct you to Configure>select the file>click on next>you will be directed to mapping of fields>check the date format it should be dd-mm-yyyy(or else it will throw an error)>click next you will be redirected to preview>click import>Voila you have your imported bills.

Bill Payments

Go to Purchase>click on Payments Made>click on the three dash menu> Import Payments>it will direct you to Configure>select the file>click on next>you will be directed to mapping of fields>check the date format it should be dd-mm-yyyy(or else it will throw an error)>click next you will be redirected to preview>click import>Voila you have your imported billpay transactions.

Reimbursements

For Reimbursement it will be the same as bill and bill payment. If it is an approved reimbursement claim then it will be imported as a bill and if it is a settled reimbursement claim then it will be imported first as a bill then a payment.

Zoho books does not provide the facility to import “Others tab transactions' 'you will have to insert the transactions manually into the software.

Bank Feed

Go to Banking>select Import statements>Choose bank account>it will direct you to Configure>select the file>click on next>you will be directed to mapping of fields>check the date format it should be dd-mm-yyyy(or else it will throw an error)>click next you will be redirected to preview>click import>Voila you have your imported billpay transactions.

"Please note that there may be updates on this topic from the time of publishing. We recommend reaching out to your account manager, or drop us a chat message, to clarify your concerns. Thank you!"

Did this answer your question?