| GL Integration Overview |
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:
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:
Once the integration is configured, journal entries for payments are posted to GL when the following occurs:
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:
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:
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 |