Accounting
ZOHO Books Integration
26min
overview he zoho books allows you to manage your finances, customers, automate your workflow along with working across different departments integrate with this end to end accounting solution to manage your finances from a single platform purpose we offer two way sync functionality for order status and order payment status from the zoho books to the onprintshop account and automatically raise invoices for the payments note with zoho books integration, 1000 data can be synced in a day how to integrate read along the systematic guide to understand the zoho books integration with your application 1 create client and get client id/secret 1 create client and get client id/secret visit the zoho’s developers’ console https //accounts zoho com/developerconsole sign up with your name, email address, and other login credentials confirm your account via email and again login with an email and password if you already have an account then login into the console click on the get started button in the next screen, create a new application by selecting the client type as server based applications enter the following details client type – here automatically ‘server based applications’ will be selected, keep it as it is client name – enter the name of your application you want to register with zoho homepage url – this is the name of your domain to be used in urls to identify your web page authorized redirect uris – a uri endpoint of your application to which zoho accounts redirects you with a grant token (code) after successful authentication add the url in the format https //your domain/external service/zohobooks/auth php you will be navigated to the next screen, as below client id – the consumer key generated from the connected app client secret – the consumer secret generated from the connected app save these codes for future use and click on the close 2 create organization and get the organization id 2 create organization and get the organization id this is the organization where all the synced data from the onprintshop admin panel will be mapped to create and get the organization id, follow the below steps – go to the zoho books site click on the access zoho books button this will take you to the zoho books home page where you need to create the organization on the screen, enter the organization name and your business location when done, click on the “let’s get started!” set up your organization profile and click on the get started button now, you can see your organization created to get the organization id, click on the organization name appearing at the top right corner in the header you’ll get the organization id from the my organization section copy and save the organization id for future use 3 enable sales order and configure gst as well as tax 3 enable sales order and configure gst as well as tax to sync the sales orders and taxes, we need to configure the same in the zoho books sales order from the zoho books home page, click on the settings icon from the top right corner and then click on the preferences preferences , select the general preferences and then check the box for “ sales order ” if not already checked configure gst settings go to settings >> taxes >> taxes settings select ‘ yes ’ for the option ‘ is your business registered for gst? ’ configure your abn , reporting period , tax basis , and choose the date from which you wish to generate your first tax return save the details note the above configuration is only required for the australia country i e if your organization's country is australia this will update your tax settings that will reflect in your transactions, reports and returns if would like to file your gst from zoho books, you will have to enable online filing configure tax rates now, let’s configure the tax rates for this organization from the same screen, click on the taxes menu under the settings tax rates under the taxes and then click on the new tax button tax name enter the name for the tax rate % specify the rate in % tax authority add or select the name of the tax authority note for australian organizations, this field is not mandatory click on save to create the new tax rate you can create multiple taxes as per the requirement or even group them using the new group button beside the new tax button 4 configuration into onprintshop admin panel 4 configuration into onprintshop admin panel let’s configure all the ids, secret key, and tokens into the admin panel on the admin panel, go to the store configuration >> external service settings >> accounting tab >> zoho books client id enter the client id saved in step 1 client secret enter the client secret saved in step 1 redirect uri enter the redirect uri saved in step – 1 (the redirect uri will be provided by the ops technical team ) organization id enter the organization id saved in step 2 code click on the connect button from the bottom of the page it will take you to a web page where you need to click on the accept button to generate the code as soon as you click on accept , the system will generate the code , to sync your onprintshop data into zoho books api url add the zoho domain api url https //www zohoapis com/books/v3/ api token url add the zoho domain api token url https //accounts zoho com tax select a tax from the list which will be synced in the ops for the tax calculation (taxes created in zoho books organization will be displayed in the list runtime) note only one tax (if you have multiple) can be synced at a time invoice number enable this option to enter the invoice number manually in the zoho books you need to enable this field, if you have configured the invoices section in zoho books and selected the “ i will add them manually each time ” radio button in the invoices >> new invoice >> invoice number settings screen of the zoho books order status the drop down will list ops order status select the status for which you want the ops orders to sync in the zoho books paid status when the payment status in the zoho books for an invoice is set as ‘paid’ then, the status selected in this field will be displayed in the ops for that order email status this field is to send a trigger of the invoice payment request email for the customers to the zoho books system the field lists ops order status, select the order statuses for which the invoice payment request email needs to be sent ops will send a trigger only when the invoice status is “unpaid” in the zoho books and if all the order product status in an ops order matches with the status selected in this field note ops will just send an email trigger to the zoho books system zoho books will send the payment request email notification to the necessary customers sync order choose to sync sales order, invoice, or both debug mode this is for the ops technical team testing purposes note you can enable this option if you find that the sync process is taking more than usual time once enabled, it will sync 3 orders, 3 products as well as 3 addresses at a time once the above details are configured, you are all set to manually sync customer, address, product and order by clicking on the respective buttons note you must sync the above modules in the following sequence only – customers, address, product and last order if the above sync sequence is not maintained then, all sync will fail as the system will not get the required dependent data zoho books logs zoho books logs with the zoho books logs functionality, you can view the details of the products, orders (sales orders), invoices and customers synced on the screen, you can get the ids from the zoho books and ops for the items synced along with the date and time for sync for the invoices, you may know if the email has been sent to the customers the log which appears by clicking on the view button is generally for the ops technical team for the technical purpose