Integrating with QuickBooks Online

Integrating with QuickBooks Online

Background

If you use both Patriot Software and Intuit QuickBooks Online, you can connect your Patriot account and integrate your payroll entries from Patriot into QuickBooks Online. Each time you run a payroll in Patriot Software, a journal entry will be created and automatically sent to your QuickBooks Online account.  If you use QuickBooks Desktop, see the help article Exporting Patriot Software Payroll into QuickBooks Desktop via a QuickBooks IIF.  If you use Patriot Accounting, see Integrating Patriot Payroll with Patriot Accounting.

How to integrate Patriot Software with QuickBooks Online

Connecting Your Patriot and QuickBooks Online Accounts

  • Go to Settings > Payroll Settings > Payroll Integration Options
  • Select QuickBooks Online, and click “Connect to QuickBooks.”
  • You will be taken to the QuickBooks Online Sign In page to authorize integrating your QuickBooks account information into Patriot Software. Enter your QuickBooks Email or User ID and password.  If you have multiple QuickBooks accounts under the same login, choose the account you want to connect.
  • Once you authorize, you will come back to Patriot’s Payroll Integration Options page. From here, you can select which QuickBooks accounts will be used for Patriot’s payroll entries.
    Wage and Tax Account Coding
  • First, chose the integration entry type you want to send to your QuickBooks account. By default, one total summary will be sent for all employees. You can also choose to send separate check detail for each employee as a separate journal entry.

Your active chart of accounts from QuickBooks Online will be imported into the “select” dropdowns for each account. Choose the appropriate accounts for each type of payroll entry. If you have set up deductions or employer paid contributions, you will need to select the accounts to be used for these in payrolls.

Integrating Patriot Software with Quickbooks Online

Immediately after you run a payroll, a journal entry will be automatically transmitted to your QuickBooks Online account.  You can view the status of each transmission on the QuickBooks Integration Status Report found under Reports > Payroll  Reports > QuickBooks Integration Status.

If you make any payroll or QuickBooks Online settings changes that affect your journal entries, such as adding a new deduction, or adding/deleting an account in QuickBooks Online, you will see a reminder to update your Payroll Integration Options page.  You will also see a warning when you run payroll.  If you proceed with your payroll without first updating your Payroll Integration Options, Patriot will not be able to automatically send a journal entry.  You can, however, send it manually from the report once you have updated your integration options.  For more details see QuickBooks Integration Status Report.

Disconnecting Your Account

If you decide later that you do not want your Patriot Payroll to integrate with QuickBooks Online, you can disconnect your QuickBooks Online account.  This will remove all of your QuickBooks account information from Patriot Software.  You will still be able to view previous transaction history on the QuickBooks Integration Status Report.  If you choose to integrate your payroll with “Patriot Accounting” after you have connected your QuickBooks Online account, your QuickBooks Online account will be disconnected.


    • Related Articles

    • Exporting Payroll to QuickBooks Desktop via IIF

      Background on Generating Your QuickBooks IIF If you use the desktop version of QuickBooks for your accounting software and Patriot Software to run payroll, you may want to export your payroll data into QuickBooks.   An Intuit Interchange Format (IIF) ...
    • Payroll Detail Report

      The Payroll Details report shows all payroll activity for employees, including prior payroll history entries, payroll updates, and paychecks processed in Patriot Software. Payroll reports like these can be used to break down taxes for employees, or ...