Setting Up GLS Integration

 

This topic contains procedures to perform the following :

Enabling GLS Integration

Configuring Integration for Tabs3 Payments

Unapplied Payments

Payments Allocated to Fees

Payments Allocated to Costs

Payments Allocated to Finance Charges

Payments Allocated to Progress Fees

Payments Allocated to Fee Sales Tax

Payments Allocated to Advance Sales Tax

Payments Allocated to Expense Sales Tax

Configuring Integration for Tabs3 Client Funds

Configuring Integration for Tabs3 Costs

Setting up Accrual Posting of Tabs3 & Trust Balances to GLS
 

  To enable GLS Integration

1. Make sure GLS is installed in the same directory as Tabs3.

   1. Make sure GLS journals have been set up.
   2. Make sure the GLS chart of accounts has been defined.
   3. If integrating Tabs3 payments with GLS, make sure an unapplied payments account has been defined in GLS.
   4. If using accrual integration, make sure the appropriate accrual accounts have been defined in GLS as recommended in the Help provided with GLS.
2. From the Tabs3 menu bar, select Utilities and then Customization.
3. Click the Other Systems tab.
4. Select the Integrate with Tabs3 General Ledger check box.
5. Choose the GLS Client to integrate with.
6. Close the Customization window and click Yes to save the changes.

Next, you will need to configure how Tabs3 payment transactions and/or which cost transaction codes will integrate with GLS.

  To configure Tabs3 payment transactions to integrate with GLS

1. From the Tabs3 menu bar, select Maintenance, point to Integration, and select GLS Integration Setup.
2. In the Payment Entries section, click Configure Payment Integration.

3. Set up the following areas of payment integration:

   • Unapplied Payments
   • Payments Allocated to Fees
   • Payments Allocated to Costs
   • Payments Allocated to Finance Charges
   • Payments Allocated to Progress Fees
   • Payments Allocated to Fee Sales Tax
   • Payments Allocated to Advance Sales Tax
   • Payments Allocated to Expense Sales Tax
4. Click the OK button to close the Configure Payment Integration window.
5. Close the GLS Integration Setup tab.

Unapplied Payments

1. Under "Post Unapplied Payments", select a Primary posting method (in the By field), and if desired, a Secondary posting method (in the Then field) by clicking the drop-down arrow next to each field. (Note: Changing the Primary or Secondary allocation method will erase any existing GLS account mappings.)
2. Click the Unapplied Payment Accounts button to configure unallocated payment integration.
3. If an "Erase GLS Accounts Table" message is displayed, click Yes.

4. If using a posting method of Single Debit/Credit, skip this step.

   1. Double-click the All Other row.
   2. Specify a GLS Debit Account, Credit Account, and Journal and click OK.

5. If using a posting method of Single Debit/Credit, skip this step.

   1. Click the New button to add a mapping to the table.
   2. In the Assign GLS Accounts window, specify the desired posting methods (i.e., Timekeeper, Tcode, etc).
   3. Specify a GLS Debit Account, Credit Account, and Journal and click OK.
   4. Repeat step 5 for each item you want to map.
6. If using a posting method of Single Debit/Credit, specify a GLS Debit Account, Credit Account, and Journal and click OK.
7. Once all mappings are added to the table, click OK to close the "GLS Accounts Table for Unallocated Payments" window.

Payments Allocated to Fees

1. Under "Post Payments Allocated to", in the Fees section, select a Primary posting method (in the By field), and if desired, a Secondary posting method (in the Then field) by clicking the drop-down arrow next to each field. (Note: Changing the Primary or Secondary allocation method will erase any existing GLS account mappings.)
2. If Working Timekeeper is specified for the Primary or Secondary posting method and you want to want to post fee compensation amounts to GLS, select the Include Fee Compensation amounts in posting check box.
3. Click the Fee Accounts button to configure fee payment integration.
4. If an "Erase GLS Accounts Table" message is displayed, click Yes.

5. If using a posting method of Single Debit/Credit, or Payment Tcode and None, skip this step.

   1. Double-click the All Other row.
   2. Specify a GLS Debit Account, Credit Account, and Journal and click OK.

6. If using a posting method of Single Debit/Credit, skip this step.

   1. Click the New button to add a mapping to the table.
   2. In the Assign GLS Accounts window, specify the desired posting methods.
   3. Specify a GLS Debit Account, Credit Account, and Journal and click OK.
   4. Repeat step 6 for each item you want to map.
7. If using a posting method of Single Debit/Credit, specify a GLS Debit Account, Credit Account, and Journal and click OK.
8. Once all mappings are added to the table, click OK to close the "GLS Accounts Table for Payments Allocated to Fees" window.

Payments Allocated to Costs

1. Under "Post Payments Allocated to", in the Costs section, select a Primary posting method (in the By field), and if desired, a Secondary posting method (in the Then field) by clicking the drop-down arrow next to each field. (Note: Changing the Primary or Secondary allocation method will erase any existing GLS account mappings.)
2. Click the Cost Accounts button to configure cost payment integration.
3. If an "Erase GLS Accounts Table" message is displayed, click Yes.

4. If using a posting method of Single Debit/Credit, or Payment Tcode and None, skip this step.

   1. If using a posting method with Cost Type, double-click the All Other Advances row and specify a GLS Debit Account, Credit Account, and Journal and click OK.
   2. If using a posting method with Cost Type, double-click the All Other Expenses row and specify a GLS Debit Account, Credit Account, and Journal and click OK.
   3. If using a posting method without Cost Type, double-click the All Other row and specify a GLS Debit Account, Credit Account, and Journal and click OK.

5. If using a posting method of Single Debit/Credit, skip this step.

   1. Click the New button to add a mapping to the table.
   2. In the Assign GLS Accounts window, specify the desired posting methods.
   3. Specify a GLS Debit Account, Credit Account, and Journal and click OK.
   4. Repeat step 5 for each item you want to map.
6. If using a posting method of Single Debit/Credit, specify a GLS Debit Account, Credit Account, and Journal and click OK.
7. Once all mappings are added to the table, click OK to close the "GLS Accounts Table for Payments Allocated to Costs" window.

Payments Allocated to Finance Charges

1. Under "Post Payments Allocated to", in the Finance Charge section, select a Primary posting method (in the By field), and if desired, a Secondary posting method (in the Then field) by clicking the drop-down arrow next to each field. (Note: Changing the Primary or Secondary allocation method will erase any existing GLS account mappings.)
2. Click the Finance Charge Accounts button to configure cost payment allocation.
3. If an "Erase GLS Accounts Table" message is displayed, click Yes.

4. If using a posting method of Single Debit/Credit, or Payment Tcode and None, skip this step.

   1. Double-click the All Other row.
   2. Specify a GLS Debit Account, Credit Account, and Journal and click OK.

5. If using a posting method of Single Debit/Credit, skip this step.

   1. Click the New button to add a mapping to the table.
   2. In the Assign GLS Accounts window, specify the desired posting methods.
   3. Specify a GLS Debit Account, Credit Account, and Journal and click OK.
   4. Repeat step 5 for each item you want to map.
6. If using a posting method of Single Debit/Credit, specify a GLS Debit Account, Credit Account, and Journal and click OK.
7. Once all mappings are added to the table, click OK to close the "GLS Accounts Table for Payments Allocated to Finance Charge" window.

Payments Allocated to Progress Fees

1. Under "Post Payments Allocated to", in the Progress Fees section, select a Primary posting method (in the By field), and if desired, a Secondary posting method (in the Then field) by clicking the drop-down arrow next to each field. (Note: Changing the Primary or Secondary allocation method will erase any existing GLS account mappings.)
2. Click the Progress Fee Accounts button to configure cost payment allocation.
3. If an "Erase GLS Accounts Table" message is displayed, click Yes.

4. If using a posting method of Single Debit/Credit, or Payment Tcode and None, skip this step.

   1. Double-click the All Other row.
   2. Specify a GLS Debit Account, Credit Account, and Journal and click OK.

5. If using a posting method of Single Debit/Credit, skip this step.

   1. Click the New button to add a mapping to the table.
   2. In the Assign GLS Accounts window, specify the desired posting methods.
   3. Specify a GLS Debit Account, Credit Account, and Journal and click OK.
   4. Repeat step 5 for each item you want to map.
6. If using a posting method of Single Debit/Credit, specify a GLS Debit Account, Credit Account, and Journal and click OK.
7. Once all mappings are added to the table, click OK to close the "GLS Accounts Table for Payments Allocated to Progress Fee" window.

Payments Allocated to Fee Sales Tax, Advance Sales Tax and Expense Sales Tax

1. Under "Post Payments Allocated to", in the Fee Sales Tax, Advance Sales Tax and Expense Sales Tax sections, select a Primary posting method (in the By field), and if desired, a Secondary posting method (in the Then field) by clicking the drop-down arrow next to each field. (Note: Changing the Primary or Secondary allocation method will erase any existing GLS account mappings.)
2. Click the Fee Sales Tax Accounts, Advance Sales Tax Accounts or Expense Sales Tax Accounts button to configure payment allocation for the specified sales tax.
3. If an "Erase GLS Accounts Table" message is displayed, click Yes.

4. If using a posting method of Single Debit/Credit, or Payment Tcode and None, skip this step.

   1. Double-click the All Other row.
   2. Specify a GLS Debit Account, Credit Account, and Journal and click OK.

5. If using a posting method of Single Debit/Credit, skip this step.

   1. Click the New button to add a mapping to the table.
   2. In the Assign GLS Accounts window, specify the desired posting methods.
   3. Specify a GLS Debit Account, Credit Account, and Journal and click OK.
   4. Repeat step 5 for each item you want to map.
6. If using a posting method of Single Debit/Credit, specify a GLS Debit Account, Credit Account, and Journal and click OK.
7. Once all mappings are added to the table, click OK to close the GLS Accounts Table window.
8. Repeat steps 1 through 7 for each type of Sales Tax to integrate.

  To configure Tabs3 client funds transactions to integrate with GLS

1. From the Tabs3 menu bar, select Maintenance, point to Integration, and select GLS Integration Setup.
2. Select the Allow posting of Client Funds Transactions check box in the Client Funds Transactions section.
3. Click the Configure Funds Integration button.
4. Select a Primary posting method (in the By field), and if desired, a Secondary posting method (in the Then field) by clicking the drop-down arrow next to each field. (Note: Changing the Primary or Secondary posting method will erase any existing GLS account mappings.)
5. Click the GLS Accounts button to configure client funds integration.
6. If an "Erase GLS Accounts Table" message is displayed, click Yes.

7. If using a posting method of Single Debit/Credit, skip this step.

   1. Double-click the All Other row.
   2. Specify a GLS Debit Account, Credit Account, and Journal and click OK.

8. If using a posting method of Single Debit/Credit, skip this step.

   1. Click the New button to add a mapping to the table.
   2. In the Assign GLS Accounts window, specify the desired posting methods.
   3. Specify a GLS Debit Account, Credit Account, and Journal and click OK.
   4. Repeat step 8 for each item you want to map.
9. If using a posting method of Single Debit/Credit, specify a GLS Debit Account, Credit Account, and Journal and click OK.
10. Once all mappings are added to the table, click OK to close the "GLS Accounts Table for Payments Allocated to Fees" window.
11. Click OK to close the Configure Client Funds Integration window.

  To configure Tabs3 cost transactions to integrate with GLS

1. From the Tabs3 menu bar, select Maintenance, point to Integration, and select GLS Integration Setup.
2. Click the Cost Entry Accounts button in the Cost Entries section.

3. Click the New button to display an "Assign GLS Accounts" window.

   1. In the Tcode field, specify a cost tcode you want to integrate with GLS.
   2. Map a GLS Debit Account, Credit Account and Journal to the tcode. (Tip: When a debit account, credit account and journal are specified, integration to GLS will occur automatically without requiring any user interaction. If desired, you can leave any or all of these fields blank. When fields are left blank, a GLS Integration window will be displayed when a cost transaction is saved allowing the user to manually enter journal entries.)
   3. Click OK.
   4. Repeat step 3 for each tcode you want to integrate with GLS.
4. Click OK to close the GLS Accounts Table.

  To set up the accrual posting of Tabs3 and Trust balances to GLS:

The following procedure requires GLS Integration to be enabled in Tabs3 Customization.

1. From the Tabs3 menu bar, select Maintenance, point to Integration and then select GLS Integration Setup.
2. Select the Allow posting of Accrual Balances in GLS check box.
3. Click the Accrual Accounts button.
4. Double-click an accrual item (i.e., Fee A/R, Expense A/R, etc).
5. Specify a GLS Debit Account, Credit Account, Journal, and Description.
6. Click OK.
7. For each accrual item, repeat steps 4 thru 6.

8. If your firm does not want to post balances by primary timekeeper, skip this step.

   1. In the "Timekeeper Accrual Posting Information" section, click the drop-down arrow next to the Primary Timekeeper field.
   2. Double-click a timekeeper for which you want to map accrual items.
   3. Click the GLS Accrual Information button.
   4. Double-click an accrual item.
   5. Specify a GLS Debit Account, Credit Account, Journal, and Description.
   6. Click OK.
   7. For each accrual item, repeat steps d thru f.
   8. Click OK to close the "GLS Accounts Table for Accrual Posting" window.
   9. Repeat steps a thru g for each primary timekeeper you want to map accrual items.
   10. Click OK to close the "GLS Accounts Table for Accrual Posting - Firm" window.
9. Close the GLS Integration Setup window.

10. If you do not want to post balances for Trust bank accounts, skip this step.

    1. Open Tabs3 Trust Accounting (Trust).
    2. From the Trust menu, point to Utilities and select Customization.
    3. In the "Integration of Payments to Firm" section, make sure the Integrate with Tabs3 (and GLS) option is selected and close the Customization window.
    4. From the File menu, point to Open and select Miscellaneous.
    5. On the Bank Account tab, select the desired bank account.
    6. Click the GLS Accrual Information button.
    7. Select the Post GLS Accrual Balances for this Bank Account check box.
    8. Specify a GLS Debit Account, Credit Account, Journal and Description.
    9. Click OK.
    10. Press Ctrl+S to save the changes to the bank account.
    11. Repeat steps e thru i for each bank account you want balances posted to GLS.
    12. Close the Bank Account window.
11. You are now ready to post accrual journal entries by running the Post Tabs3/TAS Accrual Balances program in GLS.

See also:	GLS Integration Overview
	Integration Guide