KB: Billing with Unsupported Billing Solutions

From RangerMSP Wiki - PSA software for MSPs and IT services providers
Revision as of 12:03, 12 January 2017 by Dina (talk | contribs) (→‎Introduction)
Jump to navigation Jump to search

Introduction

As you may know by now, CommitCRM currently integrates with QuickBooks© Desktop (American, UK, Canadian and Australian versions setup in US mode) and with QuickBooks Online by using the CommitCRM-QuickBooks Link and with Xero by using the CommitCRM-Xero Link. Other Accounting solutions such as Sage Line 50©, MYOB©, PeachTree© etc. can also be used to carry out invoicing duties without using the CommitCRM-QuickBooks or CommitCRM-Xero Links.

Solutions

You may be able to perform some level of integration using import & export tools (import items and customers from your accounting system and export Charges (or customers or items) from CommitCRM). We also provide an ODBC Link which allows reading the charge information from CommitCRM and API which allows you to update data in the CommitCRM database.


Exporting Charges

  • By exporting your charges, you can later import the charge list into a 3rd party Accounting Solution, which will automatically add the CommitCRM charges to be invoiced according to the imported list. This method can be done once a day/week, or even a few times a day (whenever comfortable). This method can also be used to sync accounts/customers and items/items back and forth between CommitCRM and your accounting software.
  • This method can also be used to sync your newer accounts and items to your Accounting solution, so that you don't need to enter your data twice. This can be done in both directions (Importing & Exporting).


ODBC

  • Using ODBC is very similar to the first option; however, instead of exporting and importing the information, you can have it automatically retrieved from CommitCRM directly into your Accounting Solution, which will automatically add the CommitCRM charges to be invoiced, as long as your Billing Solution supports ODBC. The ODBC is an advanced option, and should be used if you've have had experience with getting ODBC applications to talk to each other.



QuickBooks

  • Has powerful integration options which also include issuing invoices from within CommitCRM, syncing the Accounts & Items in QuickBooks to the Accounts & Items in CommitCRM. When the invoices are generated from within CommitCRM, the charge info is stored in QuickBooks, along with the rest of the invoices QuickBooks has invoiced in the past.



SageSync

SageSync is a 3rd party plugin which provides seamless integration between CommitCRM and Sage Line 50 (UK). This add-on makes invoicing easy while also being simple to configure and use. You can read more about this Sage 50 plugin here.


See Also