Integrated Cloud Accounting Software:

AccountsIQ provides a full Application Programming Interface (API) to enable the update of datasets from and to 3rd party applications.

The API provides the best possible toolset to enable seamless integration with a variety of other applications such as webshops, CRM systems, EPOS, payroll systems, stock control and so on.  Our API eliminates the need for time consuming re-keying of data into two separate systems.

Integration Partners can send data to accountsIQ as a data package using a predefined set of methods.  It is possible for partners to send data to multiple customer databases within accountsIQ.

AccountsIQ provides an encrypted partner key to 3rd party integrators.  A customer key identifying the customer database(s) can be created from within the application. 3rd party integrators need their user to get their own key from within their accountsIQ database: this key can be obtained from the Integration tab on the Company Information screen. Each transfer of data requires these keys to be submitted as part of the request.

The partner submits a HTTPS request using the required method, supplying the relevant parameters.  The API validates this request and responds with either a success or a failure notification.  If successful, the data is immediately imported into the tables within the relevant customer database.  A failure message indicating the cause is supplied if the validation fails.

In addition, a 3rd party can use methods within the API to extract data from accountsIQ for display or reporting within their own application.  This is useful if you need to display stock or customer balance data for example within another application.

Integration Points

Create / Update Customers: Create or update customer records in the system directly from another application (e.g. CRM system, webshop).  These are stored within the main accounts table in AIQ and accessible from the customer maintenance functions Create / Update Sales Orders: Create or update sales order records that originate from another application such as a sales order processing system or website.
Create / Update Sales Deliveries: Register the delivery of a selected order with full update to the stock module within AccountsIQ.  You can choose to dispatch stock from multiple locations and multiple racks (bins) within these locations. Create / Update Product (stock) items: Add product items directly into the product tables within AccountsIQ.  Useful if your product catalogue is maintained within another system and you wish to keep it synchronised with AccountsIQ.
Create / Update / Post Sales Invoices: Create sales invoice records in the system directly from another application.  This will post directly into the sales ledger updating the relevant accounts. Create / Update / Post Sales Credit Notes: Create sales credit note records in the system directly from another application.  This will post directly into the sales ledger.
Create / Allocate Sales Receipts: Create sales receipts allocated to specific customer invoices.  This will create the relevant postings to the customer account and company bank account. Create / Update Purchase Invoices: Create/update supplier invoice records from another application.  This will create the relevant postings in the purchases ledger.
Create / Update Purchase Debit Notes: Create/update supplier debit note records from another application.  This will create the relevant postings in the purchases ledger. Create / Update a GL Journal: Create or update a General Ledger Journal transaction that originates from another system.  This would create a movement between two or more general ledger accounts, e.g. the posting of a salary journal from a payroll system.
Extract a List of GL Accounts: Obtains a listing of General Ledger Accounts directly from the system.  Useful for posting a journal into AccountsIQ from within another application. Extract a List of Departments: Obtains a listing of departments/tracking codes directly from the system.  Useful for posting a journal into accountsIQ from within another application.
Extract a List of Customer Statement Details: Extract a full list of customer statement data for a selected set of customers.  Useful for enabling the display of customer statement data within another application. Extract a List of Product (Stock) Items: Extract a list of stock items and related information.  If stock items are maintained within accountsIQ this is a useful means of displaying them within another application e.g. web shop.

Some of our existing integrations include:

accountsIQ and Salesforce CRM integration:

accountsIQ has completed numerous integrations with Salesforce CRM on varying degrees. There are complete and partial integrations, depending on the clients’ requirements. This stems from the extensive client base of Charities that we have on the system, and their use of Salesforce CRM.

 

accountsIQ and Fourth Hospitality integration:

Fourth Hospitality is the leading provider of cloud-based cost control solutions to the hospitality industry covering purchase to pay, inventory management, menu engineering, HR, labour productivity and payroll. By integrating with accountsIQ we have created a seamless complete system that flows from the management system straight through to your accounting system.

 

accountsIQ and iSAMs (School administration system) integration:

iSAMs is a leading school administration system covering all areas of pupil administration. The integration covers the fee billing module with the accountsIQ invoice module to allow seamless flow of data regarding billing and the accountancy system. accountsIQ has a parent/child capability enabling the accountancy package to easily handle the complexities involved whereby a pupil’s invoice is paid by numerous parties.

 

accountsIQ and SuperSalon hairdressing system integration:

Rogers Software Development’s SuperSalon hairdressing system is the world’s leading Point of Sale (POS) system for salons and hairdressers. With over 12,000 separate installations in 40 countries it is the leading salon management system. accountsIQ has fully integrated from the Point of Sale system allowing transactions to automatically flow into the accountancy system.

 

accountsIQ and Retail Solutions ePOS integration:

Retail Solutions is a leading electronic point of sale (ePOS) system in Ireland with clients ranging from supermarkets, petrol stations, and general retail sectors. The accountsIQ integration allows the ePOS system to immediately post the transaction into the accounting system without any need for duplication of transactional inputting – greatly saving time and expense.

 

accountsIQ and Bleep ePOS integration:

Bleep PLC is a leading electronic point of sale (ePOS) system for the retail and hospitality sectors including bars, nightclubs, pubs, restaurants, bakeriesm fast food, stadia and arenas. The accountsIQ integration allows the ePOS system to immediately post the transaction into the accounting system without any need for duplication of transactional inputting – greatly saving time and expense.

 

accountsIQ and OnPay integration:

OnPay are a leading cheque printing software provider in the United States of America. The integration allows the accountsIQ accountancy system to provide a feed of payment information to OnPay who will then automatically generate the payment cheques with attached remittances which will then be posted to suppliers back in the accountancy system. accountsIQ does have their own cheque printing capability and this integration was completed to allow a large number of cheques to be printed using a third party provider.

 

accountsIQ and Readsoft integration:

Readsoft (which has now merged with Lexmark) provide invoice scanning functionality that will read and disseminate an emailed PDF invoice and automatically enter it into the accounts system.

 

accountsIQ and Sourcedog:

accountsIQ are delighted to announce a new partnership with SourceDogg, a cloud based e-procurement and supplier management platform. SourceDogg is designed to streamline the sourcing process by providing full procurement functionality from requisitioning through to fulfilment, while maintaining ease of use while significantly reducing procurement effort and costs.

 SourceDog

accountsIQ and Tableau:

Using our Excel API tool which provides a secure and direct link to live data contained in the system you can easily integrate Tableau into you analysis and reporting

 Tableau

Note that accountsIQ also provide ad-hoc integrations with in-house developed systems and can provide the integration work on a consultancy basis. Alternatively we can give you the ability to complete the integration work which allows your IT department to complete and manage the integrations.

Request A Demo View Video

For more information visit www.accountsiq.com or Contact Us.