QuickBooks Troubleshooting - Budget Actuals

QuickBooks Troubleshooting - Budget Actuals

Megan Sullivan

When an account is linked with QuickBooks, but doesn't seem to be pulling in or updating Budget Actuals, there are a few steps that you can take to troubleshoot the issue.  

  • In QuickBooks, confirm that the project costs are recorded under the "Items" section and are coded to the same Customer or Customer:Job CoConstruct is linked to. 
  • On the project's Budget page, hover over the "Sync" button to ensure that a sync has run recently.  If there is no Sync button at the top of the budget page, see the steps below on linking the project correctly.
  • If integrated with QuickBooks Desktop, ensure that a sync has been run on the Web Connector recently.  To do this, log into QuickBooks on the computer the integration was set up on > select File > Update Web Services > check the "Last Sync" time.
  • Verify that the project is correctly linked to QuickBooks
    • Navigate to the project Setup page > scroll down to QuickBooks integration > confirm that the "Link" option is selected and a Customer or Customer:Job are selected.
    • If the project is linked, ensure that it is linked correctly.  If CoConstruct is linked to a "Customer", only expenses coded to that main Customer will be pulled in.  Similarly, if CoConstruct is linked to a Customer:Job, only expenses coded to that particular Job in QuickBooks will be pulled in. 
  • On the Setup page, confirm that the "Budget Actuals" option is checked under the Automatic Sync options.  Check "Labor Actuals" as well if those should be included in the budget.
  • If the account is linked with QuickBooks Desktop, run a sync on the Web Connector to ensure that it's syncing correctly and has recently been run.  To do this, log into QuickBooks > select File > Update Web Services > check the box to the left of "CoConstruct Accounting Service" > Update Selected.  
    • When the Web Connector has finished running, you should see both progress bars at 100% and the message "Connection Closed" under the status.  
    • If there are any errors on the Web Connector status, contact Support@Co-Construct.com with the reference number provided.
  • If the account is linked with QuickBooks Online, or once the Web Connector sync has completed, navigate to the project in CoConstruct > Financials > Budget > select "Sync" at the top.  This sync can take a few minutes to run.  After waiting a couple of minutes, refresh your browser page and check the last sync date to ensure it has updated by hovering over the "Sync" button.  
    Budget_Sync_button_Hover_state.jpg
  • If after completing all steps above and confirming that a sync has been run (on both sides for QuickBooks Desktop), contact Support for further help.