Trust Accounting Sample Reports - Tabs3

1 Trust Accounting Sample ReportsCopyright 1983-2015 Software Technology, Cushman DriveLincoln, NE 68512(402) copyright Microsoft CorporationTabs3, PracticeMaster, and the pinwheel symbol () are registered trademarks ofSoftware Technology, 17 (January 2014) Tabs3 Trust Accounting SoftwareSample ReportsPurposes & Benefits of TAS ReportsThe following table shows the various Reports in TAS including their purposes and Reports for TAS Version 171 PURPOSES & BENEFITS OF TAS REPORTSR eportPurposeBenefitWhen to RunBank Account ListProvides a list of bank accountsincluding their current balanceand last check number used. Alsoincludes GLS account numbersand Tabs3 transaction codes forintegration access to bank ListProvides a list of payees andaddresses in alphabetical to review addressinformation, Federal ID numbersand which 1099 box is set up forthe Account ListProvides a list of Trust accountswith their respective balancesand grand totals in detail orsummary format.

2 Flexiblesubtotaling options allowsubtotaling by bank account orattorney or both. Use currentbalances or specify balances as ofa selected totals only report can beprinted. Zero balance trusts canbe excluded and a list of trustaccounts whose balances fallbelow the desired minimumbalance can be include dates of lastdeposit, check and Entry ListThe Transaction Entry Lists isused to provide Trust transactionsthat can be accessed using thetransaction entry entry lists can be printedaccording to your View the ability to instantlyprint the items in yourTransaction Entry List withoutleaving the transaction ListProvides a paper audit trail of alltrust transactions entered from allsources in bank account or entryorder. Changes and deletions arealso included. Separate lists aremaintained for each User the data entry operator tocheck his/her work after eachdata entry after each data entrysession.

3 TAS can be configuredto not allow deletion of theverification lists unless they havebeen ReportShows reconciled trusttransactions, unreconciled trusttransactions or both in a summaryor detail format. Option toinclude checks, deposits, EFTs orall Trust a paper listing of alltrust transactions reconciledduring the current useful tool for determiningwhere discrepancies reside whennot in Check ListIncludes checks that have beenvoided since the last timetransactions were an audit trail of voidedchecks that includes the date thecheck was needed and before running thePurge Transactions Reports for TAS Version 17 PURPOSES & BENEFITS OF TAS REPORTSR eportPurposeBenefitWhen to RunCheck Register by TrustAccountIncludes activity by individualtrust account for a range of trustaccounts. Transactions areprinted in date order. Voidedchecks are review activity for trustaccounts.

4 Includes referencenumbers for editing Register by CheckNumberProvides a listing of checks,deposits and EFTs for a specifieddate range. Include or excludevoided a complete list ofchecks in check number orderwith an optional running to spot missing and as Register by PayeeProvides a listing of all checksand EFTs for specified or exclude determine if checks orEFTs have been written to apayee and what Trust account itwas Trust LedgerIncludes activity by Trust accountfor a range of Trust are printed in dateorder. Voided checks are notincluded. Optionally excludezero balance trusts or no a running balance aftereach transaction. This report canbe given to the client as a recordof all activity on the ReportVerify 1099 information beforeprinting forms or preparing APSmerge file. Provides a list of trustaccounts who have paid payeesmore than a specified amount in acalendar year.

5 Optionally includedetailed information for determine if Federal IDnumbers are entered and verifywhich 1099 box is set up for and as FormFulfills IRS manual preparation offorms. Streamlines mandatoryannual and as ReportsSample Reports for TAS Version 173 Table of Contents1099 221099 21 Attorney 5 Bank Account 5 Bank Account Reconciliation 12 Check List, 18 Check Register By Check 13 Check Register By 14 Check Register By Trust 15 Client Trust 19 Criteria 7 Detail Reconciliation 17 Ledger, TAS Client 19 Payee 6 Reconciliation 17 TAS Client Trust 19 TAS Transaction Verification 10 Trust 1099 21 Trust Account 8-9 Trust 19 Trust Transaction Entry 7 Trust Transaction Verification 10 Verification 10 Voided Check 184 Sample Reports for TAS Version 17 Standard Program Tabs for ReportsThe selection criteria for many Reports are broken down into program tabs.

6 Program tabs include theTrust Accountstab,Transactionstab,Optionstab andSorttab. The program tabs classify the selection criteria in a consistent format, making it easy for the operator to select thedesired information on theTrust Accounts,TransactionsandSorttabs is the same for all Reports that use these tabs. The exception to this isthe Trust Account List which has a uniqueSorttab. Examples of the three standard program tabs are shown above. The information on theOptionstab is unique for each report that uses following descriptions of each report include the program tabs that are used by the report. If the report uses theOptionstab, then theparameters that can be selected on this unique program tab are AccountsTabStandardTransactionsTabStanda rdSortTabOptional Report FooterThe software can be configured to include an optional footer on the Reports .

7 The footer includesthe day of the week, date, and time the report is printed. You can optionally include a horizontalruling line and the initials of the User ID who prints the footer is configured at the printer level for each workstation in the Advanced PrintingOptions window(File | Print Setup | Advanced Printing Options).The following is an example of a footer with the user initials and horizontal ruling 10/16/2014 1:55pmSample Reports for TAS Version 175 Attorney ListThe list shown below is an Attorney List. It shows the information in the attorney file. Each line of the report consists of the attorneynumber, initials and name. An * next to the Attorney s name indicates the Attorney is marked inactive. A Responsible Attorney is assignedto each Trust account thereby allowing Reports to be printed by attorney. The list can be sorted alphabetically by attorney initials ornumerically by attorney Account ListThe Bank Account List shown below displays the information in the bank account AcctBank account number defined in TAS.

8 Up to 99 different bank accounts can be BalanceCurrent balance of all Trust accounts in the bank account. The current balance does not include unpaid Check #The last check number used. This field is used to determine the default check number when printing checks oradding a check that has already been printed. The default check number is determined by adding 1 to thenumber in this NegThis field determines whether a negative balance is allowed for the individual Trust accounts in the bank :The following information prints only if you are integrating with Tabs3 General Ledger Software (GLS) and/or GLS AccountThe Debit GLS Account represents the GLS account that is debited for the transaction (typically a GLS cashaccount).JrnlGLS journal number. All GLS journal entries are posted to this GLS Pymt, Fee Pymt,Exp Pymt and AdvPymt GLS AccountsThese account numbers represent the GLS accounts that can be credited for the check or EFT to the payee of FIRM.

9 Reg Pymt, Fee Pymt,Exp Pymt and AdvPymt Tabs3 TcodesThese Tabs3 transaction code numbers represent the Tabs3 payment transactions that can be posted for the checkor EFT to the payee of FIRM .Date: 11/17/2014 TAS Attorney ListPage: 1 Burns, Jensen & Powers, J. Burns2 MLJM ichael L. Jensen3 PAMP aula A. Madison4 DHBD aniel H. Brady5 JPPJ ulie P. PowersDate: 11/14/2014 TAS Bank Account ListPage: 1 Jensen, Martin, Hilde & Anderson, #Neg1 First Bank IOLTA Statement/WIP TerminologyBalance:Your retainer balance isOpening Balance:Opening retainer balanceClosing Balance:Closing retainer balanceBill Remit Amount:As per our agreement please remit:Target Remit Amount:To meet your minimum retainer balance, pleaseremit:Reg PymtFee PymtExp PymtAdv PymtTabs3 Tcodes:900 GLS Accrual PostingDate: 11/14/2014 TAS Bank Account ListPage: 1 Jensen, Martin, Hilde & Anderson, #Neg1 First Bank IOLTA Statement/WIP TerminologyBalance:Your retainer balance isOpening Balance:Opening retainer balanceClosing Balance:Closing retainer balanceBill Remit Amount:As per our agreement please remit:Target Remit Amount:To meet your minimum retainer balance, pleaseremit.

10 Reg PymtFee PymtExp PymtAdv PymtDebitJrnlGLS Accrual PostingExample of informationshown when integrating withGLSandTabs3 Example of informationshown when integrating withGLSwithoutTabs36 Sample Reports for TAS Version 17 Payee ListThe list shown above represents the information in the payee file. The payee file saves you time by allowing you not to have to enter thesame payee name and address repeatedly. A special payee called FIRM allows General Ledger Software journal entries and Tabs3payments to be created and posted automatically when integrating with GLS and Tabs3 . When using FIRM as a payee, the firm s name isretrieved from the Firm Information file in System Configuration and is printed on checks and Reports . You have the ability to select abeginning and ending payee when printing this list. You can optionally print the list in Federal ID # ID #This number represents the Federal ID Number or Social Security Number of the payee if an IRS Form1099-MISC is desired for the BoxIndicates whether the payee will have a 1099-MISC form printed and the box in which the information will print.