Skip to main content

Accounting and Integrations

Use this guide to complete the accounting set up in Collage Payroll

Written by Laine Greenidge

The Accounting section provides a centralized location for configuring the accounting settings used to generate payroll journal entries.

Accounting configuration can include:

  • GL codes and accounting codes

  • Accounting Code Rules

  • Accounting integrations

  • Journal Entry Defaults

  • Coming Soon: Tags

Collage Payroll supports accounting integrations with QuickBooks Online and Xero.

An integration can be used to import eligible accounts from the connected accounting platform. Accounting codes can also be created manually when an integration is not used.

To connect to an accounting system (optional), navigate to the main menu and select Accounting:

Select Integrations and connect to your preferred accounting system:

  • Click → Connect, you will be redirected to the QuickBooks or Xero login page

  • Return to Collage Payroll with your accounting platform successfully connected

  • Click → Import Accounts

  • You can only import accounts that are liability, expense or bank

No accounting connection? You can create GL Codes manually:

Set up required base accounts:

Once you’ve imported your accounts, you would first need to map your “Bank Account” and “Net Payroll Payable” in Settings

  • Bank account: the cash account used for payroll payments

  • Net Payroll Payable: the liability account used to hold net pay and withholdings until paid

  • Next, you'll confirm the accounts have imported by reviewing the list under GL Codes

Configure Accounting Rules:

  • Rules determine which GL Code should be assigned to payroll line items.

  • Rules can be broad enough to provide default accounting treatment for a category of payroll items or specific enough to apply to an individual payroll item or preset.

  • Coming Soon: Tags are optional. Accounting Code Rules can be configured globally without a tag condition, or can use a tag to direct a payroll item by the tag assigned to the employee

To configure Accounting Code Rules:

  • Navigate to Accounting → Rules.

  • Create broad rules for the organization's standard accounting treatment.

    • Examples include:

      • All Earnings → Wages Expense

      • All Employer Taxes/Liabilities → Payroll Liabilities

      • All Allowances → Allowances Expense

  • Add more specific rules where separate accounting treatment is required.

    • Examples include:

      • Overtime Earnings → Overtime Expense

      • Vacation Pay → Vacation Payable or Vacation Expense

      • Bonus Earnings → Bonus Expense

      • Specific Preset → Specific Accounting Code

  • Coming Soon: Leave the tag condition unset when the rule should apply globally or select specific tag group for the rule

  • Repeat until all accounting rules have been created as per your requirements.

Considerations:

  • All payroll items need to be mapped to allow for a successful export into your accounting software

Review setup before processing payroll:

  • If you have not mapped all your codes, you will see a warning message on the Payroll dashboard

  • If all the codes have been successfully mapped, you can proceed with running payroll

  • Once payroll is marked as Paid you can export your journal entry to QuickBooks or Xero

Did this answer your question?