Skip to main content

Accounting Connection: Quickbooks Online to Zenoti Integrated Payroll

Once Zenoti Integrated Payroll is connected to QuickBooks Online through the accounting integration, payroll data flows directly into your QuickBooks account. This reduces manual effort and ensures accuracy in your general ledger. Here’s what to expect from the integration:

  • Exports payroll details directly to QuickBooks Online.

  • Supports direct deposit and manual payroll entries.

  • Automatically creates journal entries when payroll moves to the "processing" status, if the Auto-Push feature is enabled.

  • Maintains an accurate General Ledger by mapping payroll categories to your Chart of Accounts.

Follow the steps below to connect your Quickbooks Online account to Zenoti Integrated Payroll.

Note:

  • The transaction date for journal entries will be the payroll approval deadline or payday if no deadline exists.

  • For questions about mapping categories, please reach out to your Quickbooks Online professional.

  • The integration exports lump-sum totals for payroll categories (e.g., wages, taxes, benefits). However, individual withholdings or employee-specific breakdowns are not included in the journal entries. To access this level of data granularity, you can manually import the daily data into QuickBooks Online.

Connect QuickBooks Online to Zenoti Integrated Payroll

  1. Go to business set up tab view.

  2. In the left navigation bar, click Accounting connection.

  3. Select QuickBooks online.

  4. Click Connect.

    quickbooks_02.png
  5. Log in to your QuickBooks Online account when prompted.

  6. Follow the on-screen instructions to map your payroll fields to the appropriate accounts in your general ledger.

  7. Mapping payroll categories ensures that journal entries align with your Chart of Accounts, reducing the risk of discrepancies. Although the data is summarized, it provides a high-level overview that accurately reflects your payroll records.

    Note: Unmapped payroll categories will not be transferred to your General Ledger. To prevent future errors, ensure that all relevant categories are mapped, even if they are currently unused.

    The following payroll categories must be mapped to your Chart of Accounts to ensure the proper flow of payroll data into QuickBooks Online.

    Optional categories can be marked as 'N/A' in the dropdown. It is recommended to map all categories to an account to prevent errors if you decide to use them in the future.

    quickbooks_03.png

    Category

    Flow

    Description

    Sample Entries

    Wages and Salaries

    Expense, Debit

    All earnings paid to employees and contractors in the pay period. (Also known as “Compensation”. )

    • Employee Wages & Salaries (Gross Pay excluding Reimbursements)

    Contractor Payments

    Expense, Debit

    All earnings paid to contractors in the pay period. (Also known as “Compensation”. )

    • Contractor Payments(Gross Pay excluding Reimbursements)

    Expense Reimbursements

    Expense, Debit

    All reimbursements paid to employees and contractors in the pay period.

    • Employee Reimbursements

    • Contractor Reimbursements

    Employer Taxes

    Expense, Debit

    All employer taxes for the pay period.

    • Employer Taxes

    Employee Benefits

    Expense, Debit

    All benefits paid by the employer and remitted by the employer for the pay period.

    • Employee Benefits

    Bank Account

    Liability, Credit

    The account that funds the amount that the employer is liable for over a given pay period.

    • Cash Requirement (ACH) -- including any taxes and/or garnishments paid by Check

    • Checks, ie. Check #122 -- broken out individually

    Payroll Taxes Payable

    Liability, Credit

    All employer taxes to be paid

    • Non-remittable Taxes

    Cash Tips

    Liability, Credit

    All cash tips paid to employees directly

    • Cash Tips

    Imputed Income

    Liability, Credit

    Other imputed income such as use of a company car or gym membership

    • Other Imputed Income

    Other Payroll Liabilities

    Liability, Credit

    All employer benefits and PTDs to be paid out by the employer

    • Employee Benefits Liabilities

    • Garnishments

  8. (Optional) Enable Auto-Push to automatically send payroll journal entries to the General Ledger as a new journal entry when payroll reaches the Processing status.

  9. Click Save.

  10. Once the setup is complete, payroll data will sync to QuickBooks Online as journal entries based on your selected mapping.

If you need to re-sync data after adjusting categories or need assistance with pushing past payrolls, feel free to reach out to your Zenoti representative.

Quickbooks online integration FAQs