Show/Hide All

 Overview

Use this procedure to synchronize data between Sage 100 and Sage 100 Payroll Services. You can upload general ledger account numbers and bank codes to the service and download payroll transactions from the service into Transaction Journal Entry.

 Before You Begin

Before you can synchronize data, you must set up the integration. See Integrate Sage Payroll Services With General Ledger.

 

To synchronize data between Sage Payroll Services and General Ledger

1. In Sage Payroll Services, process payroll for your employees.

2. In Sage 100, select General Ledger Payroll Services menu > Payroll Services Synchronization Wizard.

3. In the Sage Payroll Services Synchronization Wizard window, follow the on-screen instructions to complete the wizard. The wizard synchronizes the General Ledger module with the payroll service and automatically performs the following tasks:

4. Uploads the general ledger accounts and bank codes selected in the Sage Payroll Services Account Selection window to the payroll service. Any changes to the selected accounts and bank codes since the last synchronization are automatically updated in the payroll application.

Only active general ledger accounts are uploaded. Accounts with Inactive or Deleted status are not uploaded during synchronization.

Bank codes are uploaded only if the Bank Reconciliation module is integrated with the payroll service.

• Detects new transactions to download from the payroll service and downloads the data.

• Creates entries for the downloaded transactions in General Ledger Transaction Journal Entry.

When the Bank Reconciliation module is integrated with the payroll service, two entries are created in General Journal Transaction Entry for each downloaded transaction that affects the balance of a cash account. For more information on how the transactions are posted, see the posting examples below.

Separate "Tax Impound" transactions are downloaded from the payroll service, which represent the employer's tax liabilities for each payroll run. These transactions credit cash and debit the employer's tax liability accounts.

No detail check data is downloaded for employees who receive a 100% direct deposit check. These direct deposit entries are downloaded as a separate transaction. For employees who receive both a check and a direct deposit, the direct deposit portion of the entry is included with the checks in the same transaction.

The wizard window displays messages describing the success or failure of every step in the synchronization process.

Note If a synchronization error or an error in receiving data from one of the payroll services occurs, contact customer support for assistance.

You are now ready to use Transaction Journal Entry to process the downloaded payroll transactions. You can also print the Sage Payroll Services Activity Log as a record of the synchronization activity.

 

Example - Posting downloaded payroll transactions when Bank Reconciliation is not integrated with the payroll service

The following general ledger postings are made for payroll transactions downloaded from the payroll service when the Bank Reconciliation module is not integrated with the payroll service.

 

GL Account	Debit	Credit
Cash - Check 1		X
Cash - Check 2		X
Tax & Other Payroll Liabilities		X
Payroll Expenses, Tax Expense, and Other Expense	X

 

Example - Posting downloaded payroll transactions when Bank Reconciliation is integrated with the payroll service

 

When the Bank Reconciliation module is integrated with the payroll service, two entries are created in General Journal Transaction Entry for each transaction downloaded from the payroll service that affects the balance of a cash account. The first transaction posts the payroll expense and liability postings with an offset to the offset account selected for the bank code in Sage Payroll Services Account Selection. The second transaction creates the Bank Reconciliation check entries and transfers the net postings from the offset account to the bank code. The first transaction can be posted in either detail or summary format, depending on the selection in the Summarize check box on the Sage Payroll Services Account Selection Bank Rec tab. The second transaction, which is the check amount for each employee, is always posted in detail. For more information, see Sage Payroll Services Account Selection - Fields.

 

Posting first transaction in detail (Summarize check box is cleared)

Transaction 1

GL Account	Debit	Credit
Payroll Offset - Check 1		X
Payroll Offset - Check 2		X
Tax & Other Payroll Liabilities		X
Payroll Expenses, Tax Expense, and Other Expense	X

 

Transaction 2

GL Account	Debit	Credit
Payroll Offset - Check 1	X
Payroll Offset - Check 2	X
Cash - Check 1		X
Cash - Check 2		X

 

Posting first transaction in summary (Summarize check box is selected)

Transaction 1

GL Account	Debit	Credit
Payroll Offset - Checks 1 & 2 Summarized		X
Tax & Other Payroll Liabilities		X
Payroll Expenses, Tax Expense, and Other Expense	X

 

Transaction 2

GL Account	Debit	Credit
Payroll Offset - Check 1	X
Payroll Offset - Check 2	X
Cash - Check 1		X
Cash - Check 2		X