Documentation

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.

Getting Started

1. Select Source and Destination

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.

2. Connecting to Your Infusionsoft App

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, then click the Save Changes button.

3. Connecting to Xero

This is slightly more complicated than we would like, until InvoiceSync is authorised as a Xero Partner (this should happen soon!)

Setting Up Xero

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):

  1. Select Private App
  2. Enter InvoiceSync as the App name
  3. Select your demo company, unless you are sure you want to connect to your live accounts (if Demo Company isn’t listed, you will need to set this up in Xero first)
  4. Click on Paste from Clipboard
  5. Copy and paste the following (including the begin and end lines)
    -----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-----
  6. Check the “I have read and agree to the Xero Developer Platform Terms & Conditions” box (obviously 🙂)
  7. Click on Create App

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.

Setting Up InvoiceSync

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).

Then, enter the default Account Code that you’ll want all invoice line items to be recorded against. In most cases, this will be 200.

Optionally, you can specify different account codes for discounts, finance charges and shipping charges. If you leave them blank, those line items will also be recorded against your default Account Code.

Next, select the tax code to use when applying sales tax to taxable invoices. This is taken directly from your Xero application.

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.

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.

Finally, click Save Changes.

4. Setting Up Synchronisation (First-Time Settings)

Go to the Settings -> Other Settings menu option.

If you’ve not configured this already, you’ll see the First-Time Settings screen.

Firstly, you must select the initial invoice that InvoiceSync will synchronise. All invoices newer than the selected invoice will then be synchronised automatically – so you can synchronise historical data if you want. You can choose to go right back to the first ever invoice, or select an invoice ID, or a date.

Then, you need to select the number of days that will be added onto the invoice date when creating a Due Date for the invoice.

You must click the Save Changes button at this point before you can enable synchronisation.

Finally, when you switch Processing on, synchronsation will begin automatically.

Remember to click the Save Changes button again when you switch on the Processing option.

5. What Happens Next?

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

Invoice dates will be set as follows:

  • The invoice date will match the invoice date in Infusionsoft.
  • If the invoice was paid at the time of creation (e.g. an online order paid by credit card), the due date of the invoice will be set to the invoice date.
  • If the invoice contains a payment plan, the due date of the invoice will be set to the final date of the payment plan.
  • Otherwise, the due date of the invoice will be set to X days after the invoice date, according to the configuration you have chosen in InvoiceSync.

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.