Integration with Accounting Software

Synoriq LMS generates accounting vouchers and the trail balance of loan-related ledgers. These reports are available in the Insights portal. 

But, as a lender, other non-loan accounting ledgers are required. Lenders generally use accounting software to manage these ledgers. Commonly used accounting software include Tally, Zoho Books, and Microsoft Dynamics. 

Typically, lenders upload the vouchers in the accounting software from Synoriq LMS every 2 weeks. 

There are two ways to integrate Synoriq LMS with your current accounting software:

Approach #1 - Upload manually to accounting software

• Upload vouchers
  • • Accounting software provides the capability to upload vouchers through excel upload. 
    • Refer to LMS053 Voucher MIS in the Insights portal. 
    • Input the data as required in the accounting software upload file. 
• Upload trial balance
  • • Go to Insights. 
    • Click on the Trial Balance menu. Select the date range. 
    • TB would be generated. 
    • Download the excel report and upload to the accounting software. 

Approach #2 - API integration

• Upload vouchers or Upload trial balance
  • Based on the approach finalization, Synoriq provides both the APIs which can be consumed by the accounting software. 

Common queries to be addressed by customers

1. Time of pushing vouchers/TB to accounting software
   • At a specific time daily
   • Automatically as EOD happens in the LMS
2. COA codes to remain consistent in both LMS and accounting software

Sample response format - Voucher API

{
  "response": true,
  "data": [
    {
      "transaction_date": "2024-05-14",
      "transaction_value_date": "2024-05-14",
      "voucher_header_id": "247928",
      "voucher_type": "INV",
      "transaction_name": "Installment Billing",
      "coa_code": "3002001",
      "coa_name": "Interest Income_BL",
      "credit_amount": "2957.0",
      "debit_amount": "0.0",
      "loan_account_number": "WEBL00000533",
      "voucher_details_id": "497883"
    },
    {
      "transaction_date": "2024-05-14",
      "transaction_value_date": "2024-05-14",
      "voucher_header_id": "247928",
      "voucher_type": "JV",
      "transaction_name": "Installment Billing",
      "coa_code": "1001201",
      "coa_name": "Loan Principal_BL",
      "credit_amount": "228.0",
      "debit_amount": "0.0",
      "loan_account_number": "WEBL00000533",
      "voucher_details_id": "497898"
    },
  ]
}