Tabs3 Billing optionally integrates with Tabs3 General Ledger (GL). Integration is enabled at the system level in Tabs3 Customization. Once integration is enabled at the system level, integration is configured using the GLS Integration Setup window and can optionally consist of the following for a single GL client:

Integration of Tabs3 Billing Payments

Tabs3 Billing and GL payment integration is very sophisticated and flexible. It allows you to configure the integration according to how a payment is allocated to due amounts by specifying a payment posting method in the GLS Integration Setup window. Once a payment posting method is specified, GL accounts and journals can be mapped in an integration table. Tabs3 Billing can be configured to create journal entries for payments based on one of the following posting methods:

  • Single Debit/Credit
  • Working Timekeeper (for fees) / Cost Type (for costs)
  • Client Category
  • Client Location
  • Payment Tcode
  • Primary Timekeeper
  • Secondary Timekeeper
  • Originating Timekeeper

Or, Tabs3 Billing can be configured to create journal entries based on a combination of any two of the above methods. The following are just a few examples of combinations of posting methods:

  • Client Location & Client Category
  • "Working Timekeeper / Cost Type" & Client Location
  • Client Category & "Working Timekeeper / Cost Type"
  • Client Location & Payment Tcode
  • and more!

Once the integration is configured, journal entries for payments are posted to GL when the following occurs:

  • Payment Entry - A payment transaction is added, changed or deleted in Tabs3 Billing.
  • Update Statements - An unallocated payment is allocated to an amount due. A client funds payment to firm is updated.
  • Payment Adjustment - A payment transaction is reversed or refunded.
  • Undo Updated Statements - An allocated payment is unallocated from an amount due.

Unapplied Payments: Before payments can be entered, Tabs3 Billing requires that GL debit and credit accounts and a journal number be configured for unapplied payments. This allows Tabs3 Billing to post unapplied payments to a "holding" account in GL until the payment is allocated. Once the payment is allocated, Tabs3 Billing will post journal entries that transfer the allocated amount from the holding account to the account(s) designated for the final payment allocation. Journal entries are created using the payment allocation date.

Note: When an unallocated payment becomes allocated, Tabs3 Billing will post journal entries that transfer the allocated amount from the holding account that is currently defined, regardless if that is the same account that the original entries were created for. In order to maintain accurate records in GL for payments that were unallocated and later become allocated, it is not recommended that the GL holding account defined in the GLS Integration Setup for unapplied payments be changed. Changing this account may require manual adjusting journal entries to be created.

Note: Making changes to a payment for which there are associated GL journal entries may result in an Error Report being generated. This typically occurs when a change is made that affects a journal entry that is marked in GL as cleared, deposited, or reconciled.

Integration of Tabs3 Billing Client Funds

Tabs3 Billing allows you to optionally configure client funds transactions to integrate with GL by specifying a posting method in the GLS Integration Setup window. Once a posting method is specified, GL accounts and journals can be mapped in an integration table. Tabs3 Billing can be configured to create journal entries for client funds transactions based on one of the following posting methods:

  • Single Debit/Credit
  • Client Category
  • Client Location
  • Primary Timekeeper
  • Secondary Timekeeper
  • Originating Timekeeper

Or, Tabs3 Billing can be configured to create journal entries based on a combination of any two of the above methods.

Once the integration is configured, journal entries for client funds are posted to GL when the following occurs:

  • Deposit Entry - A Deposit or Credit Card client funds transaction is added, changed or deleted in Tabs3 Billing.
  • Withdrawal Entry - A Withdrawal client funds transaction is added, changed or deleted in Tabs3 Billing.
  • Update Statements - A client funds Payment to Firm is updated.
  • Undo Updated Statements - A client funds Payment to Firm is unupdated.

Withdrawals: Client funds Withdrawal transactions use the same GL account mappings as Deposit transactions; however, the GL journal entries are reversed (i.e., a credit journal entry is added to the Debit Account specified, and a deposit entry is added to the Credit Account).

Payments to Firm: Client funds Payment to Firm transactions use the current Payment Allocation account mappings.

Unapplied Payments: If client funds integration is enabled, before client funds transactions can be entered, Tabs3 Billing requires that GL debit and credit accounts and a journal number be configured for unapplied payments. This allows Tabs3 Billing to post unapplied payments created by Payment to Firm client funds transactions to a "holding" account in GL until the payment is allocated. Once the payment is allocated, Tabs3 Billing will post journal entries that transfer the allocated amount from the holding account to the account(s) designated for the final payment allocation. Journal entries are created using the payment allocation date.

Integration of Tabs3 Billing Costs

Tabs3 Billing allows you to configure exactly which costs integrate with GL by adding cost tcodes to an integration table via the GLS Integration Setup window. Mapping a debit account, credit account and journal number to the tcode allows journal entries to be created automatically when a cost transaction is saved (i.e., no user intervention). When a tcode is added to the integration table without a debit account, credit account or journal number, the GL integration Journal Entry window will be displayed at the time the cost entry is saved, thus allowing the user to manually enter the required information.

Once the integration is configured, journal entries for costs are posted to GL when the following occurs:

Integration Note: If using the Advanced Client Costs Report in GL, all advances must be entered in Tabs3 Accounts Payable (AP) to create balanced transactions on the report. To prevent discrepancies, integration of advance cost tcodes should not be configured in this window and instead be handled by AP.

Integration of Advanced Client Costs Write Offs and Write-Downs

Tabs3 Billing allows you to configure how write offs, write-downs, and other adjustments to advances integrate with GL by adding advance cost types to an integration table via the GLS Integration Setup window. Mapping a debit account and journal number to the cost type allows journal entries to be created automatically when an advance amount is adjusted (i.e., no user intervention).

Once the integration is configured, journal entries for advance cost adjustments are posted to GL when the following occurs:

AP Note: Journal entries for cost transactions created in Tabs3 Accounts Payable (AP) are handled by AP. Adjustments to these costs in Tabs3 Billing will create journal entries in GL.

Accrual Integration

As an option, you can periodically post GL journal entries for various Tabs3 Billing balances, thus providing the ability to print accrual basis financial statements. A posting utility in GL lets you post journal entries for accounts receivable balances, work-in-process balances and client funds balances. These journal entries can be firm wide or by primary reporting timekeeper and are broken down by fees, expenses, advances, and finance charges. The same GL posting utility can also post journal entries for bank account balances from Tabs3 Trust Accounting (Trust).

Note: The Tabs3 Billing and GL integration is designed primarily for firms on a cash basis or modified cash basis of accounting. This Accrual Integration option simply provides the ability to post net change journal entries to accrual accounts that are not normally included on the Balance Sheet and Income Statement. This Accrual Integration option does not provide transaction-based postings for true accrual accounting.

See also:   Overview of GL Integration for Payments
  Overview of GL Integration for Client Funds
  Overview of GL Integration for Costs
  Overview of GL Integration for Write Offs
  GL Accrual Integration Overview
  Setting Up GL Integration
  GL Integration Setup
  GL Integration Setup Report
  Knowledge Base Article R11139 - Integration from Tabs3 Billing to Other Tabs3 Applications
  Integration Guide