QuickBooks Online Integration

Exporting invoices to QuickBooks Online

Time to read: 5 minutes

 

Disconnected from Quickbooks? See what do to do here.

Main Takeaways: 

  • The integration with QuickBooks Online (QBO) allows invoices, created in Forecast, to be exported to a linked QBO company
  • Once invoices are exported, they are synchronised hourly, or on-demand, with its exported counterpart

Setup

Step 1: Go to the integrations page in your admin panel, and scroll down to QuickBooks Online
ezgif.com-video-to-gif (18)-Jul-09-2020-12-52-44-68-PM

 

Step 2: Click Connect

2020-07-09 (6)

 

Step 3: Authorize by signing in to your QuickBooks account

2020-07-09 (10)

 

Success!

Your Integration is now complete. In your Forecast page, you should see the following:
2020-07-09 (12)

Note: To disable the integration, click Disable 


You are now ready to start exporting invoices from the Invoicing page, found in the sidebar in the project page.

 

Exporting your Invoices from Forecast to Quickbooks

Step 1: Go to the invoicing section found in the settings of the given project

ezgif.com-video-to-gif (18)-Jul-09-2020-01-21-28-89-PM

 

Step 2: Create a new invoice or select an existing one. To learn how to create invoices, see this article

 

Step 3: Click export

export

Note: A popup window with options will be promted

 

Step 4: Choose your settings and click Export 

2020-07-09 (15)

All done! 


Step 5: To access your invoice in Quickbooks where you can edit it further, click on the QuickBooks icon

2020-07-09 (18)

Integration limitations

  • Exporting an invoice removes all existing payments from that invoice
  • An exported invoice cannot be modified in Forecast
  • An invoice cannot be exported if the target QBO company does not have any customers
  • Disabling the integration will unlink all exported invoices, irrevocably
  • Changing an exported invoice to calculate tax before applying the discount will result in a different discount being calculated in Forecast, after synchronisation
  • If an invoice is missing a cent (0.01) in payment, it will be ignored, as this can occur when invoices are paid in QuickBooks

Non-US QuickBooks Companies

As QuickBooks behaves differently for non-US companies, there are some additional constraints on these in Forecast:

  • If an invoice in Forecast has a reference number which an invoice in the QuickBooks company already has, it cannot be exported to QuickBooks
  • If different tax rates apply to different sales line items in QuickBooks, and a fixed discount is applied, this discount will appear larger in Forecast