If there is anything missing from the documentation or you have a general question, please ask in the Facebook Group, which is available to all InvoiceSync users.
When you first log in and go to the Settings page, you’ll be asked to select the following:
Source: Infusionsoft is currently the only option
Destination: Select Xero or QuickBooks Online
Click Save Changes
Note: Once you’ve selected your destination, this page will not appear again and the regular Setting page will be displayed instead. Until you’ve authorised Infusionsoft and either Xero or QuickBooks Online, the page will look like this:
Go to the Settings -> Source (Infusionsoft) Settings menu option.
Then click on the “Click here to authorise Infusionsoft” link.
If you’re not already signed into Infusionsoft, the standard Infusionsoft login screen will appear – you’ll need to enter your Infusionsoft ID and password.
You’ll then see an authorisation screen where you’ll be asked to select your Infusionsoft app and grant authorisation for InvoiceSync to connect.
(right now, you’ll need to close the authorisation tab when complete and then refresh the Settings screen that you go back to)
Once you’ve refreshed the Settings screen, you must confirm the currency that your Infusionsoft application is using, and select the appropriate option for Tax Handling and Finance Charges, then click the Save Changes button.
This is slightly more complicated than we would like, until InvoiceSync is authorised as a Xero Partner (this should happen soon!)
Add the InvoiceSync application to your Xero organisation by first logging into Xero, then going to https://developer.xero.com/myapps
Click on the “New App” button in the top right-hand corner of the page, which will open a pop-up window.
In the pop-up window, do the following (see also screenshot below):
-----BEGIN CERTIFICATE----- MIID3TCCA0agAwIBAgIJAMp0dGEaGRH5MA0GCSqGSIb3DQEBBQUAMIGmMQswCQYD VQQGEwJVSzEWMBQGA1UECBMNU3RhZmZvcmRzaGlyZTEdMBsGA1UEBxMUTmV3Y2Fz dGxlLXVuZGVyLUx5bWUxHjAcBgNVBAoTFUNhbGRvbiBDb25zdWx0aW5nIEx0ZDEW MBQGA1UEAxMNQWRyaWFuIFNhdmFnZTEoMCYGCSqGSIb3DQEJARYZYWRyaWFuQGFk cmlhbnNhdmFnZS5jby51azAeFw0xNzA5MDUwNzMyMDJaFw0yMjA5MDQwNzMyMDJa MIGmMQswCQYDVQQGEwJVSzEWMBQGA1UECBMNU3RhZmZvcmRzaGlyZTEdMBsGA1UE BxMUTmV3Y2FzdGxlLXVuZGVyLUx5bWUxHjAcBgNVBAoTFUNhbGRvbiBDb25zdWx0 aW5nIEx0ZDEWMBQGA1UEAxMNQWRyaWFuIFNhdmFnZTEoMCYGCSqGSIb3DQEJARYZ YWRyaWFuQGFkcmlhbnNhdmFnZS5jby51azCBnzANBgkqhkiG9w0BAQEFAAOBjQAw gYkCgYEAs2x/yYdz5B7bEN8V5wG+oVkiZ1rAEGDCrPajayzJoVxtGC7IdwzXR5b8 VMwGcMcQJ0LbNnnVL6SlkyOzO7w677BLuQ7mzE/ZuT3eJzBEzPP5zNFMzniowoD2 WWOLPsaVIyYNYLKvaPai/RQGdTX5G+friEg0Yq/qvYcdvijSG3MCAwEAAaOCAQ8w ggELMB0GA1UdDgQWBBTIgOOHwqQxWSRopCiyqP2PPfhQHDCB2wYDVR0jBIHTMIHQ gBTIgOOHwqQxWSRopCiyqP2PPfhQHKGBrKSBqTCBpjELMAkGA1UEBhMCVUsxFjAU BgNVBAgTDVN0YWZmb3Jkc2hpcmUxHTAbBgNVBAcTFE5ld2Nhc3RsZS11bmRlci1M eW1lMR4wHAYDVQQKExVDYWxkb24gQ29uc3VsdGluZyBMdGQxFjAUBgNVBAMTDUFk cmlhbiBTYXZhZ2UxKDAmBgkqhkiG9w0BCQEWGWFkcmlhbkBhZHJpYW5zYXZhZ2Uu Y28udWuCCQDKdHRhGhkR+TAMBgNVHRMEBTADAQH/MA0GCSqGSIb3DQEBBQUAA4GB AJlzM7cK54Deikp7EdGufokNUN3dDG6+MLqsQIhghGa7jWU7gM1bv9byXyWWFyyz Yrcgl/pEmdY2wiU3D1nXlV6MZemvabk6nqYsMCx81H17EurmS3H/zOwK0FhhTiKa FbCecNZV1MGxJafeD8u/oAC0/eoXWdC3h3FlGmkQ/yMN -----END CERTIFICATE-----
Make a note of the OAuth Credentials provided on the right hand side of the screen – you’ll need the Consumer Key and the Consumer Secret in the next step.
Back in InvoiceSync, Go to the Settings -> Destination Settings menu option.
Enter the Consumer Key and Consumer Secret and hit Save Changes (before you select any of the other options). Until you’ve clicked Save, all the fields will show as Cannot connect to Xero.
Once you’ve saved the Consumer Key and Secret, the dropdowns will show None Specified.
You now need to enter the default Account Code that you’ll want all invoice line items to be recorded against by default. In many cases, this will be 200, the default Revenue account in Xero
Optionally, you can also specify different account codes for discounts, finance charges and shipping charges. If you leave them blank, those line items will be recorded against your default Account Code. IMPORTANT: you can only have accounts of type REVENUE as the Default, Discount, Finance Charge and Shipping account codes.
If you want payments to be synced as well, you will also need to select the account for payments. IMPORTANT: Please note that Xero will only allow payment if the account you have chosen has the “payments to this account” option enabled and is of type BANK or CURRENT ASSET for both Payments and Payments – PayPal account codes.
Next, select the tax code to use when applying sales tax to taxable invoices. This is taken directly from your Xero application. In our example above, it is 20% for taxable items.
Then, select the tax code to use that signifies zero sales tax, which is applied to line items that do not incur sales tax. Again, this is taken directly from your Xero application. In our example above, it is No VAT on non-taxable items
Finally, select the status that all new invoices will be created with – either Draft, Submitted or Authorised. Beware – if you select Authorised, it will not be possible to amend or delete the invoices that InvoiceSync creates, you will only be able to void them.
If you want InvoiceSync to also sync payments, you have to set the status to Authorised, as only Authorised invoices can be marked as paid.
Finally, click Save Changes.
PLEASE NOTE: The product description in Xero will be the Infusionsoft product name.
Go to the Settings -> Sync Settings menu option.
If you’ve not configured this already, you’ll see the First-Time Settings screen.
You must click the Save Changes button at this point before you can enable synchronisation.
Finally, switch on Processing and click the Save Changes button again. Synchronisation will then begin automatically.
Once everything is set up and Synchronisation Processing is turned ON, InvoiceSync will connect to your Infusionsoft account once an hour, download the new invoices, and replicate them into Xero or QuickBooks Online.
So every time a new invoice gets created in Infusionsoft, a matching invoice with the same line items, discounts, sales tax, etc., will be created in Xero/QBO within an hour.
You can check what’s happened recently by going to the Activity Log page in your account.
Invoice dates will be set as follows:
Xero Account Codes
Invoice line items will be set to use the default account code you specified in the settings, unless you have created products in Xero that match products that exist in Infusionsoft. The SKU code is used to match products, and where a matching product is found, the invoice line items will use the account code as specified in the Xero product.
What’s Not Implemented
Payments. This is complicated. We’re working on a simple implementation but there are no plans at this stage to include full-on reconciliation.
If you have more than one Sales Account code and want your Xero invoices to automatically use the correct account code for each item, InvoiceSync can do this. Simply match the product’s SKU code in Infusionsoft to the item code in Xero.
E.g. SKU code in Infusionsoft: TIL
Item code in Xero: TIL
Below are some examples:
Please note that more than one product in Infusionsoft can have the same SKU code. This will NOT use the Xero Item code or the item’s description, it will purely use that item’s account code, in our example 201 – The Implementation Lab for item code TIL.
The product description in Xero will be the Infusionsoft Product Name.
If you would like the Xero Item Code to be populated as well based on the Infusionsoft SKU code, please send an email to email@example.com asking us to switch this on for you.
If you would like to sync from your accounting system to Infusionsoft as well as the other way, please send an email to firstname.lastname@example.org, stating the email address you use to log into InvoiceSync with and the date you want ReverseSync to start from.