The information in this article applies to:
NOTE: For information about comparing Version 12 and 11 Tabs3 report information, please see KB Article R10938, "Comparing Tabs3 Report Information - Version 11".
This article provides guidelines for comparing the information provided on certain Tabs3 reports to the information on other related reports.
Note: This article is designed for best viewing using Microsoft Internet Explorer or Netscape Navigator. However, due to some limitations of Netscape Navigator, Netscape users may experience margin-related issues when printing this article.
At times, it may be desirable to compare information provided on one Tabs3 report to information provided on another report. However, it is easy to make the mistake of trying to compare information from two reports that are based on data from completely separate sources. A thorough understanding of where each report gets its information and how it presents the information is required before attempting to compare any two Tabs3 reports.
There are several reports in Tabs3 that can be directly compared; however, it is important that they be run with the correct criteria and options selected. Listed below are some Tabs3 reports that can be compared directly to each other, along with the criteria that must be used when printing them. You may want to create report definitions that use the criteria listed below for any of the report combinations that you feel might be useful on a regular basis.
Client Ledger Report, Processed Payments Report, Receipt Allocation Report and A/R by Invoice Report
Cash Receipts Report and Payment Transaction File List
Detail Work-in-Process Report and Transaction File List
Recap of Hours Report and Hours on the Worked Portion of the Timekeeper Productivity Report
Recap of Hours Report and Transaction File List
Notes About Reports that Include Archive Data
There are four reports that provide information about the status of a client's balance due. When run with the correct criteria, the Client Ledger Report, Processed Payments Report, Receipt Allocation Report and A/R by Invoice Report will always agree on certain figures. Instructions for printing each report and making these comparisons are provided below.
Note: If the client ledger and/or receipt allocation information has ever been edited, this comparison may not be possible since the data on one or more of the reports may not be correct.
Because this particular set of reports offers one of the most important comparisons in Tabs3, and because these reports are used if it becomes necessary to edit the client ledger or receipt allocation information, the instructions for printing these reports for comparison are provided in a separate Knowledge Base article. KB Article R10773, "Report Criteria for Editing Tabs3 Balance Info - Version 10", contains the details for each of these reports.
The following are examples of each of the reports. For purposes of this article, the items on each report that can be compared to the other reports are highlighted in color. Descriptions of the comparisons are also provided below.
Important: As indicated in KB Article R10773, any work-in-process payments for the client must be put on hold or final-billed and updated before attempting to compare the following reports.
Date: 02/21/04 Tabs3 Client Ledger Report Page: 1
Burns, Jensen & Powers, P.C.
Thru 02/21/04
Payment Apply to
Date Amount Stmt # Fees Expenses Advances Fin Charge Fee Tax Exp Tax Adv Tax Bal. Due Stmt # Ref #
---- ------ ------ ---- -------- -------- ---------- ------- ------- ------- -------- ------ -----
101.01M Barrett/Karen RE: Apartment Management
12/30/03 698.20 2.02 38.50 738.72 1 1
Billing: 2 MLJ 630.00
3 PAM 68.20
Exp 1 Phone 0.97
Exp 2 Photocopies 1.05
Adv 4 Deliveries 38.50
01/06/04 125.00A 613.72 2 2
01/10/04 278.10 5.24 25.00 2.53 924.59 2 3
Billing: 2 MLJ 255.00
3 PAM 23.10
Exp 1 Phone 5.24
Adv 0 Miscellaneous 25.00
02/04/04 200.00F 724.59 3 4
02/21/04 83.75 5.87 10.82 825.03 3 5
Billing: 2 MLJ 56.25
3 PAM 27.50
Exp 0 Miscellaneous 5.87
Subtotal 325.00 1060.05 13.13 63.50 13.35
Billing: 2 MLJ 941.25
3 PAM 118.80
Exp 0 Miscellaneous 5.87
Exp 1 Phone 6.21
Exp 2 Photocopies 1.05
Adv 0 Miscellaneous 25.00
Adv 4 Deliveries 38.50
|
When the Client Ledger Report is run with the correct settings and criteria, the figures shown in color in this example will match with the corresponding figures of the same color on the other reports. Specifically:
Date: 02/21/04 Tabs3 Detail Processed Payments Report Page: 1
Burns, Jensen & Powers, P.C.
Date Ref # Stmt # Pymt Amt Processed Fin Chg Expenses Exp Tax Advances Adv Tax Fee Tax Fees
---- ----- ------ -------- --------- ------- -------- ------- -------- ------- ------- ----
101.01M Barrett/Karen
2 MLJ Apartment Management
01/06/04 2 2 125.00 76.85 13.35 0.00 0.00 63.50 0.00 0.00 0.00
Adv Type 0 25.00
Adv Type 4 38.50
02/04/04 4 3 200.00 200.00 0.00 0.00 0.00 0.00 0.00 0.00 200.00
002 Michael L. Jensen 180.46
003 Paula A. Madison 19.54
S u b t o t a l s
325.00 276.85 13.35 0.00 0.00 63.50 0.00 0.00 200.00
Adv Type 0 25.00 002 Michael L. Jensen 180.46
Adv Type 4 38.50 003 Paula A. Madison 19.54
|
When comparing the Processed Payments Report to the Receipt Allocation Report, there are several fields that will match when the reports are run with the correct criteria. Each of the fields on the Processed Payments Report has a corresponding field on the Receipt Allocation Report. The following table indicates which column totals on the Processed Payments Report will match which fields in the TD Paid column of the Receipt Allocation Report:
Processed Payments Report Column Total |
Receipt Allocation Report Field |
Processed column |
Total for TD Paid column |
Fin Chg column |
Finance Charge |
Expenses column |
Expenses |
Exp Tax column |
Expense Tax |
Advances column |
Advances |
Adv Tax column |
Advance Tax |
Fee Tax column |
Fee Tax |
Fees column |
Fees |
Date: 02/21/04 Tabs3 TD Detail Receipt Allocation Report Page: 1
Burns, Jensen & Powers, P.C.
------ MTD ------- ------ YTD ------- ------- TD -------
Timekeeper Billed Paid Billed Paid Billed Paid Amount Due
---------- ------ ---- ------ ---- ------ ---- ----------
101.01M Barrett/Karen RE: Apartment Management
2 Michael L. Jensen 941.25 180.46 941.25 180.46 941.25 180.46 760.79
3 Paula A. Madison 118.80 19.54 118.80 19.54 118.80 19.54 99.26
------- ------ ------- ------ ------- ------ ------
Fees 1060.05 200.00 1060.05 200.00 1060.05 200.00 860.05
0 Miscellaneous 5.87 0.00 5.87 0.00 5.87 0.00 5.87
1 Phone 6.21 0.00 6.21 0.00 6.21 0.00 6.21
2 Photocopies 1.05 0.00 1.05 0.00 1.05 0.00 1.05
----- ---- ----- ---- ----- ---- -----
Expenses 13.13 0.00 13.13 0.00 13.13 0.00 13.13
0 Miscellaneous 25.00 25.00 25.00 25.00 25.00 25.00 0.00
4 Deliveries 38.50 38.50 38.50 38.50 38.50 38.50 0.00
----- ----- ----- ----- ----- ----- ----
Advances 63.50 63.50 63.50 63.50 63.50 63.50 0.00
Finance Charge 13.35 13.35 13.35 13.35 13.35 13.35 0.00
Total 1150.03 276.85 1150.03 276.85 1150.03 276.85 873.18
Unallocated Payments: 48.15 825.03
|
Date: 02/21/04 Tabs3 Accounts Receivable by Invoice Report Page: 1
Burns, Jensen & Powers, P.C.
Thru 02/21/04
---------------- B I L L E D ---------------- ------------------ D U E -------------------
Date Fees Expenses Advances Fin Chg Total Fees Expenses Advances Fin Chg Total Ref # Stmt #
---- ---- -------- -------- ------- ----- ---- -------- -------- ------- ----- ----- ------
101.01M Barrett/Karen RE: Apartment Management
12/30/03 698.20 2.02 38.50 738.72 498.20 2.02 500.22 1 1
2 MLJ 630.00
3 PAM 68.20
Exp 1 Phone 0.97
Exp 2 Photocopies 1.05
Adv 4 Deliveries 38.50
Last Applied Pymt: 200.00 02/04/04
01/10/04 278.10 5.24 25.00 2.53 310.87 278.10 5.24 283.34 3 2
2 MLJ 255.00
3 PAM 23.10
Exp 1 Phone 5.24
Adv 0 Miscellaneous 25.00
Last Applied Pymt: 27.53 01/06/04
02/21/04 83.75 5.87 10.82 100.44 83.75 5.87 89.62 5 3
2 MLJ 56.25
3 PAM 27.50
Exp 0 Miscellaneous 5.87
Last Applied Pymt: 10.82 01/06/04
------- ----- ----- ----- ------- ------ ----- ------
Subtotal 1060.05 13.13 63.50 13.35 1150.03 860.05 13.13 873.18
2 MLJ 941.25
3 PAM 118.80
Exp 0 Miscellaneous 5.87
Exp 1 Phone 6.21
Exp 2 Photocopies 1.05
Adv 0 Miscellaneous 25.00
Adv 4 Deliveries 38.50
Unapplied Payments: 48.15 Balance Due: 825.03
|
The information provided on the Cash Receipts Report comes from some of the same data files and is selected using the same basic criteria as the information provided on the Transaction File List. If the correct criteria are used when printing the two reports, the information on them can be compared.
Note: See the notes at the end of this article for information about situations that may invalidate this comparison.
Use the following steps to print the Cash Receipts Report:
Use the following steps to print the Transaction File List:
In the following examples of the two reports, the items that can be compared are highlighted in color for the purposes of this article. Descriptions of the comparisons are also provided below.
Date: 02/21/04 Tabs3 Cash Receipts Report Page: 1
Burns, Jensen & Powers, P.C.
Primary Timekeeper: 2 Michael L. Jensen
Regular Fee Expense Advance
Client Name Description Payments Payments Payments Payments Total
------ ---- ----------- -------- -------- -------- -------- -----
101.01M Barrett/Karen Apartment Management 200.00 25.00 125.00 350.00
110.01M Larson/Michael Larson vs. State 325.00 325.00
====== ====== ===== ====== ======
Total Payments for Primary Timekeeper 2: 325.00 200.00 25.00 125.00 675.00
|
When the Cash Receipts Report and the Transaction File List are run with the correct settings and criteria, the figures shown using color in this example will match with the corresponding figures of the same color on the other reports. Specifically, each figure on the Cash Receipts Report will match the total shown in the Transaction File List's Amount column for payments of the same tcode. In the example provided here, the tcodes are configured as follows:
Date: 02/21/04 Summary Payment Transaction File List Page: 1
Burns, Jensen & Powers, P.C.
Amount
------
Subtotal for Tcode # 91 Payments 200.00
-----
Subtotal for Tcode # 92 Payments 25.00
------
Subtotal for Tcode # 93 Payments 125.00
======
Total for Client ID 101.01 Payments 350.00 Apartment Management
------
Subtotal for Tcode # 90 Payments 325.00
======
Total for Client ID 110.01 Payments 325.00 Larson vs. State
======
Grand Totals Payments 675.00
|
The information provided on the Detail Work-In-Process Report (DWIP) comes from some of the same data files and is selected using the same basic criteria as the information provided on the Transaction File List (TFL). Provided that the correct criteria are used when printing the two reports, the information on them can be compared.
Use the following steps to print the Detail Work-in-Process Report:
Use the following steps to print the Transaction File List:
The following are examples of the two reports. For purposes of this article, the items that can be compared are highlighted in color. Descriptions of the comparisons are also provided below.
Date: 02/25/04 Tabs3 Detail Work-In-Process Report Page: 1
Burns, Jensen & Powers, P.C.
Client: 101.01M Barrett/Karen Contact: *Karen Barrett
BARRETT/KAREN Apartment Management Office: 402-466-1234
Home: 402-472-9937
Primary Timekeeper: 4 DHB Category: 25 Real Estate
Secondary Timekeeper: 3 PAM Rate Code: 1 Draft: Draft Final: Recap
Originating Timekeeper: 4 DHB Date Opened: 04/23/03
Prev Balance: 0.00
H T B R Write
Date Tmkr Cat Src P X C C Tcode Ref # Rate Hours Amount Up/Down Description
---- ---- --- --- - - - - ----- ----- ---- ----- ------ ------- -----------
Billable Total: 2 Michael L. Jensen 2.07 258.75
Non-Bill Total: 2 Michael L. Jensen 0.26 32.50
Billable Total: 3 Paula A. Madison 0.41 45.10
------ ----------
Total Billable Fees 2.48 303.85
Total Non-Billable Fees 0.26 32.50
------ ----------
Total Fee Credits -0.40 -50.00
Total Expenses 40.71
Total Non-Billable Expenses 12.18
******** R E C A P ********
Fees: 303.85
Expenses: 40.71 Prev Bal: 0.00
Advances: 00.00 Pymt/Cr: -50.00
Total WIP: 344.56 Bal Due: -50.00 Total: 345.81
A/R: 0-30 31-60 61-90 91-120 121-180 181+
-25.00 0.00 0.00 0.00 0.00 0.00
Client: 110.01C Larson/Michael Contact: Michael Larson
LARSON/MICHAEL Larson vs. State Office: 402-474-4651
Home: 402-474-5421
Primary Timekeeper: 1 RJB Category: 10 Workers' Compensation
Secondary Timekeeper: 3 PAM Rate Code: 1 Draft: Contngcy Final: Contngcy
Originating Timekeeper: 1 RJB Date Opened: 03/05/01
Prev Balance: 99.65
H T B R Write
Date Tmkr Cat Src P X C C Tcode Ref # Rate Hours Amount Up/Down Description
---- ---- --- --- - - - - ----- ----- ---- ----- ------ ------- -----------
Billable Total: 1 Robert J. Burns 8.65 1100.00
Fee Write-Up 27.50
Fee Write-Down -225.00
Billable Total: 2 Michael L. Jensen 6.00 750.00
Billable Total: 3 Paula A. Madison 1.75 200.00
Fee Write-Up 20.00
Fee Write-Down -12.50
Billable Total: 4 Daniel H. Brady 1.00 100.00
Fee Write-Down -25.00
Total Billable Fees 17.40 2150.00
Total Fee Write-Up 47.50
Total Fee Write-Down -262.50
Total Expenses 21.65
Total Advances 75.00
******** R E C A P ********
Fees: 2150.00
Expenses: 21.65 Prev Bal: 99.65
Advances: 75.00 Pymt/Cr: 0.00
Total WIP: 2246.65 Bal Due: 99.65 Total: 2346.30
A/R: 0-30 31-60 61-90 91-120 121-180 181+
0.00 0.00 0.00 0.00 0.00 99.65
|
The descriptions that print on the reports for the fields that can be compared are very similar. If the example reports shown here had been run in full detail rather than in summarized formats, individual transactions would be listed on each report, rather than a total for each transaction type.
Date: 02/25/04 Summary Transaction File List Page: 1
Burns, Jensen & Powers, P.C.
Hours Amount
---- ------
Subtotal for Fees Billable 2.08 253.85
Non-billable 0.26 32.50
Total 2.34 286.35
---- -----
Subtotal for Expenses Billable 0.00 40.71
Non-billable 0.00 12.18
Total 0.00 52.89
==== ======
Total for Client ID 101.01 Billable 2.08 294.56 Barrett/Karen
Non-billable 0.26 44.68 Apartment Management
Total 2.34 339.24
----- -------
Subtotal for Fees Billable 17.40 2150.00
Total 17.40 2150.00
---- -----
Subtotal for Expenses Billable 0.00 21.65
Total 0.00 21.65
---- -----
Subtotal for Advances Billable 0.00 75.00
Total 0.00 75.00
===== =======
Total for Client ID 110.01 Billable 17.40 2246.65 Larson/Michael
Total 17.40 2246.65 Larson vs. State
===== =======
Grand Totals Billable 19.48 2541.21
Non-billable 0.26 44.68
Total 19.74 2585.89
|
Notice that the Detail Work-In-Process Report (DWIP) for Client ID 101.01 has a slightly different fee total than the Transaction File List (TFL). This is because the DWIP shows credit transactions separately from the rest of the work-in-process amounts (like a statement), whereas the TFL includes credit transactions in the net amount shown for each transaction type. The fee amount shown on the DWIP for Client ID 101.01 is $50.00 higher than that shown on the TFL, but the DWIP lists a $50.00 credit separately. The following table illustrates the comparison between a DWIP for a client with work-in-process credit transactions and a TFL for the same client:
Comparison |
DWIP |
TFL |
Amounts Shown |
Hours Amount |
Hours Amount |
Totals |
2.08 253.85 |
2.08 253.85 |
Although the data on the Transaction File List (TFL) comes from different data files than the information on the Timekeeper Productivity Report (TPR), the figures provided on the two reports are based on almost the same criteria. However, the amounts on the TPR do not include write-ups and write-downs (unlike the amounts shown on the TFL). To make an accurate comparison, you must also run a Write-Up/Write-Down Report and add the amounts shown to those on the TPR. The sum of the figures on these two reports can then be compared to the information on the TFL. In order to make the comparison, certain criteria must be used when printing the reports.
Note: If transactions dated beyond the current reporting year have been final billed and updated, the hours and amounts of those transactions are lost to the Worked information on a Timekeeper Productivity Report. For example, if December is the last month of the year and transactions dated in January 2004 are updated while the current reporting month is still December 2003, the worked information on a Timekeeper Productivity Report for January 2004 will not reflect the amounts of those transactions.
Note: See the notes at the end of this article for information about
other situations that may invalidate this comparison.
Use the following steps to print the Transaction File List:
Use the following steps to print the Timekeeper Productivity Report:
Use the following steps to print the Write-Up/Write-Down Report:
The first step in the comparison process is to add the amount shown on the Write-Up/Write-Down Report to the Billable Amount shown on the Timekeeper Productivity Report for the same timekeeper. In the examples below, color has been added to highlight the figures that need to be added for each timekeeper.
Note: The Write-Up/Write-Down Report, when sorted by working timekeeper, will start printing each timekeeper's information on a new page. For purposes of this article, the information has been compressed into one page.
Date: 04/30/04 Tabs3 Write-Up/Write-Down Report Page: 1
Burns, Jensen & Powers, P.C.
Working Timekeeper: 4 Daniel H. Brady
Transaction Date: From 04/01/04 Thru 04/30/04
------- Write-Up ------- ------ Write-Down ------
Client Name Description Fees Expenses Advances Fees Expenses Advances Net
------ ---- ----------- ---- -------- -------- ---- -------- -------- ---
625.00 0.00 0.00 0.00 0.00 0.00 625.00
Working Timekeeper: 5 Julie P. Powers
Transaction Date: From 04/01/04 Thru 04/30/04
------- Write-Up ------- ------ Write-Down ------
Client Name Description Fees Expenses Advances Fees Expenses Advances Net
------ ---- ----------- ---- -------- -------- ---- -------- -------- ---
70.00 0.00 0.00 50.00 0.00 0.00 20.00
|
The Timekeeper Productivity Report, shown below, includes information for the year to date. For the purpose of this comparison, you can disregard the YTD Total column. The amounts to be added to the Write-Up/Write-Down amounts are highlighted in blue for timekeeper 4 and orange for timekeeper 5.
Date: 04/30/04 Tabs3 Timekeeper Productivity Report Page: 1
Burns, Jensen & Powers, P.C.
Apr 04 YTD Total
4 Daniel H. Brady
------------- WORKED --------------
Billable Hrs 162.00 648.00
100.0% 100.0%
Billable Amt 20250.00 81000.00
100.0% 100.0%
Non-bill Hrs 0.00 0.00
0.0% 0.0%
Non-bill Amt 0.00 0.00
0.0% 0.0%
Total Hrs 162.00 648.00
51.6% 51.4%
Total Amt 20250.00 81000.00
59.7% 59.5%
(WIP) Hours: 20.05 Amount: 2596.25 Average Age: 381 Days
----------------------------------
5 Julie P. Powers
------------- WORKED --------------
Billable Hrs 152.00 612.00
100.0% 100.0%
Billable Amt 13680.00 55080.00
100.0% 100.0%
Non-bill Hrs 0.00 0.00
0.0% 0.0%
Non-bill Amt 0.00 0.00
0.0% 0.0%
Total Hrs 152.00 612.00
48.4% 48.6%
Total Amt 13680.00 136080.00
40.3% 40.5%
(WIP) Hours: 7.48 Amount: 906.49 Average Age: 252 Days
----------------------------------
========== GRAND TOTALS ===========
------------- WORKED --------------
Billable Hrs 314.00 1260.00
100.0% 100.0%
Billable Amt 33930.00 136080.00
100.0% 100.0%
Non-bill Hrs 0.00 0.00
0.0% 0.0%
Non-bill Amt 0.00 0.00
0.0% 0.0%
Total Hrs 314.00 1260.00
Total Amt 33930.00 136080.00
(WIP) Hours: 27.53 Amount: 3502.74 Average Age: 348 Days
|
Based on the sample reports shown above, the total dollar amount of all transactions entered for timekeeper 4 with dates in the month of April, 2004 is $20,875 (20,250 + 625).
Based on the sample reports shown above, the total dollar amount of all transactions entered for timekeeper 5 with dates in the month of April, 2004 is $13,700 (13,680 + 20).
Below is an example of the Summary Fee Transaction File List.
Date: 04/30/04 Summary Fee Transaction File List Page: 1
Burns, Jensen & Powers, P.C.
Hours Amount
====== ========
Total for Timekeeper # 4 Billable 162.00 20875.00 Daniel H. Brady
Total 162.00 20875.00
====== ========
Total for Timekeeper # 5 Billable 152.00 13700.00 Julie P. Powers
Non-billable 1.00 90.00
Total 153.00 18700.00
====== ========
Grand Totals Billable 314.00 34575.00
Non-billable 1.00 5000.00
Total 315.00 39575.00
|
The Recap of Hours Report provides daily totals for billable and non-billable hours worked each day, by week. The Timekeeper Productivity Report provides the totals for billable and non-billable hours for the entire month. The Recap of Hours report pulls its data from the fee file and the archive file, whereas the Timekeeper Productivity Report has its own dedicated file for tracking this information. Since the information provided is selected based on the same criteria, it can be especially useful to compare these two reports if there is ever any question about the accuracy of one report or the other. In order to make the comparison, certain criteria must be used when printing the reports.
Note: If transactions dated beyond the current reporting year have been final billed and updated, the hours for those transactions are lost to the Worked information on a Timekeeper Productivity Report. For example, if December is the last month of the year and transactions dated in January 2004 are updated while the current reporting month is still December 2003, the worked information on a Timekeeper Productivity Report for January 2004 will not reflect the hours for those transactions.
Note: See the notes at the end of this article for information about
other situations that may invalidate this comparison.
Use the following steps to print the Recap of Hours Report:
Use the following steps to print the Timekeeper Productivity Report:
The following are examples of the two reports. For purposes of this article, the figures that can be compared between the two reports are highlighted in color. A description of the comparison is also provided below.
Date: 03/21/04 Tabs3 Recap of Hours Report Page: 1
Burns, Jensen & Powers, P.C.
From March 01, 2004 Thru March 21, 2004
#002 Michael L. Jensen
Sun Mon Tue Wed Thu Fri Sat Total
--- --- --- --- --- --- --- -----
Day 3/01
Billable
Non-billable
Total
Day 3/02 3/03 3/04 3/05 3/06 3/07 3/08
Billable 8.25 6.55 6.90 4.00 6.24 31.94
Non-billable
Total 8.25 6.55 6.90 4.00 6.24 31.94
Day 3/09 3/10 3/11 3/12 3/13 3/14 3/15
Billable 1.00 5.27 3.95 10.22
Non-billable
Total 1.00 5.27 3.95 10.22
Day 3/16 3/17 3/18 3/19 3/20 3/21
Billable
Non-billable
Total
Grand Totals Billable 42.16
Non-billable 0.00
Total 42.16
#003 Paula A. Madison
Sun Mon Tue Wed Thu Fri Sat Total
--- --- --- --- --- --- --- -----
Day 3/01
Billable
Non-billable
Total
Day 3/02 3/03 3/04 3/05 3/06 3/07 3/08
Billable 6.50 6.85 3.17 2.80 19.32
Non-billable
Total 6.50 6.85 3.17 2.80 19.32
Day 3/09 3/10 3/11 3/12 3/13 3/14 3/15
Billable 5.65 1.37 2.00 9.02
Non-billable
Total 5.65 1.37 2.00 9.02
Day 3/16 3/17 3/18 3/19 3/20 3/21
Billable
Non-billable
Total
Grand Totals Billable 28.34
Non-billable 0.00
Total 28.34
|
On the Recap of Hours Report, the Billable figure in the Grand Totals for each timekeeper can be directly compared to that timekeeper's Billable Hrs figure for the corresponding month on the Timekeeper Productivity Report.
Date: 03/21/04 Tabs3 Timekeeper Productivity Report Page: 1
Burns, Jensen & Powers, P.C.
Mar 04 YTD Total
2 Michael L. Jensen
------------- WORKED --------------
Billable Hrs 42.16 394.39
100.0% 99.4%
Billable Amt 5632.75 52661.40
100.0% 99.5%
Non-bill Hrs 0.00 2.38
0.0% 0.6%
Non-bill Amt 0.00 317.80
0.0% 0.5%
Total Hrs 42.16 396.77
59.8% 61.6%
Total Amt 5632.75 52979.20
58.7% 60.3%
(WIP) Hours: 47.67 Amount: 6968.75 Average Age: 103 Days
----------------------------------
3 Paula A. Madison
------------- WORKED --------------
Billable Hrs 28.34 361.75
100.0% 100.0%
Billable Amt 3967.60 50645.00
100.0% 100.0%
Non-bill Hrs 0.00 0.00
0.0% 0.0%
Non-bill Amt 0.00 0.00
0.0% 0.0%
Total Hrs 28.34 361.75
40.2% 38.4%
Total Amt 3967.60 50645.00
41.3% 39.7%
(WIP) Hours: 39.15 Amount: 5376.60 Average Age: 100 Days
----------------------------------
|
The Recap of Hours Report and the Transaction File List each provide information regarding the data located in the transaction files and the archive file. The high level of flexibility provided by the Transaction File List makes it an ideal way to corroborate the information provided on the Recap of Hours Report. If purging of the archive data has ever occurred, the information on the two reports may be incorrect, but the reports will still provide matching information.
Use the following steps to print the Recap of Hours Report:
Use the following steps to print the Transaction File List:
The following are examples of the two reports. Ideally, when printing the reports using the criteria provided above, the information will match between the two reports. However, the information is presented in a calendar format on the Recap of Hours Report versus a list format on the Transaction File List. For purposes of this article, examples of the fields that can be compared between the reports are shown in color.
Date: 03/21/04 Tabs3 Recap of Hours Report Page: 1
Burns, Jensen & Powers, P.C.
From March 01, 2004 Thru March 21, 2004
#002 Michael L. Jensen
Sun Mon Tue Wed Thu Fri Sat Total
--- --- --- --- --- --- --- -----
Day 3/01
Billable
Non-billable
Total
Day 3/02 3/03 3/04 3/05 3/06 3/07 3/08
Billable 8.25 6.55 6.90 4.00 6.24 31.94
Non-billable
Total 8.25 6.55 6.90 4.00 6.24 31.94
Day 3/09 3/10 3/11 3/12 3/13 3/14 3/15
Billable 1.00 5.27 3.95 10.22
Non-billable
Total 1.00 5.27 3.95 10.22
Day 3/16 3/17 3/18 3/19 3/20 3/21
Billable
Non-billable
Total
Grand Totals Billable 42.16
Non-billable 0.00
Total 42.16
#003 Paula A. Madison
Sun Mon Tue Wed Thu Fri Sat Total
--- --- --- --- --- --- --- -----
Day 3/01
Billable
Non-billable
Total
Day 3/02 3/03 3/04 3/05 3/06 3/07 3/08
Billable 6.50 6.85 3.17 2.80 19.32
Non-billable
Total 6.50 6.85 3.17 2.80 19.32
Day 3/09 3/10 3/11 3/12 3/13 3/14 3/15
Billable 5.65 1.37 2.00 9.02
Non-billable
Total 5.65 1.37 2.00 9.02
Day 3/16 3/17 3/18 3/19 3/20 3/21
Billable
Non-billable
Total
Grand Totals Billable 28.34
Non-billable 0.00
Total 28.34
|
The daily hours shown on the Recap of Hours Report, above, will match the totals in the Hours column for the corresponding dates. Listed below are the specific figures that can be compared between the two reports. In the sample reports provided, the figures for 03/03/04 and the totals for the reports are each shown in a different color for each timekeeper.
Date: 03/21/04 Summary Fee Transaction File List Page: 1
Burns, Jensen & Powers, P.C.
Hours Amount
---- -------
Subtotal for 03/03/04 Billable 8.25 1031.25
Total 8.25 1031.25
---- ------
Subtotal for 03/04/04 Billable 6.55 818.75
Total 6.55 818.75
---- ------
Subtotal for 03/05/04 Billable 6.90 862.50
Total 6.90 862.50
---- ------
Subtotal for 03/06/04 Billable 4.00 600.00
Total 4.00 600.00
---- ------
Subtotal for 03/07/04 Billable 6.24 936.00
Total 6.24 936.00
---- ------
Subtotal for 03/12/04 Billable 1.00 150.00
Total 1.00 150.00
---- ------
Subtotal for 03/13/04 Billable 5.27 740.50
Total 5.27 740.50
---- ------
Subtotal for 03/14/04 Billable 3.95 493.75
Total 3.95 493.75
===== =======
Total for Timekeeper # 2 Billable 42.16 5632.75 Michael L. Jensen
Total 42.16 5632.75
---- ------
Subtotal for 03/03/04 Billable 6.50 910.00
Total 6.50 910.00
---- ------
Subtotal for 03/04/04 Billable 6.85 959.00
Total 6.85 959.00
---- ------
Subtotal for 03/05/04 Billable 3.17 443.80
Total 3.17 443.80
---- ------
Subtotal for 03/06/04 Billable 2.80 392.00
Total 2.80 392.00
---- ------
Subtotal for 03/10/04 Billable 5.65 791.00
Total 5.65 791.00
---- ------
Subtotal for 03/11/04 Billable 1.37 191.80
Total 1.37 191.80
---- ------
Subtotal for 03/12/04 Billable 2.00 280.00
Total 2.00 280.00
===== =======
Total for Timekeeper # 3 Billable 28.34 3967.60 Paula A. Madison
Total 28.34 3967.60
===== =======
Grand Totals Billable 70.50 9600.35
Total 70.50 9600.35
|
There are two things to keep in mind when making comparisons involving reports that can include archive data (i.e., the Transaction File List, the Recap of Hours Report and the Write-Up/Write-Down Report):
THE INFORMATION PROVIDED IN THE SOFTWARE TECHNOLOGY, INC. KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. SOFTWARE TECHNOLOGY, INC. DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL SOFTWARE TECHNOLOGY, INC. OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF SOFTWARE TECHNOLOGY, INC. OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.
© 1999-2007 Software Technology, Inc. All rights
reserved. Terms of Use
The maker of Tabs3 and PracticeMaster
e-Mail Suggestions for the Knowledge Base to: kb@Tabs3.com
Technical Support via e-mail is not available.
Knowledge Base: http://support.Tabs3.com
Web Site: http://www.Tabs3.com