The following file format is used whenever an Export Data Format is selected (other than None). The same fields are always extracted and include:

Transaction File List:
Client ID, User ID, Transaction Date (see Date Note), Entry Date (see Date Note), Statement Date, Timekeeper #, Category #, Expense/Advance Switch, Source, Status, Sales Tax Code, Bill Code, Rate Code, Transaction Code #, Tcode Type #, Rate, Units, Hours Worked, Hours to Bill, Amount, Statement # Applied to (payments only), Billing Statement #, Cost Type, Reference Number, Description

Task Code Billing Report:
Client ID, User ID, Transaction Date (see Date Note), Entry Date (see Date Note), Statement Date, Timekeeper #, Category #, Expense/Advance Switch, Source, Status, Sales Tax Code, Bill Code, Rate Code, Phase/Task Code, Activity/Expense Code (fees and costs only), Tcode Type, Rate, Units, Hours Worked, Hours to Bill, Amount, Statement # Applied to (payments only), Billing Statement #, Cost Type (costs only), Reference Number, Description

Fees, payments, and costs are all exported to the same report. All expense and advance transactions will have 0.00 in the Rate and Hours fields. All payment transactions will have 0 in the Timekeeper field and 0.00 in the Hours to Bill and Hours Worked fields. All fee, expense and advance transactions will have 0 in the statement number field. Date fields are exported within double quotation marks (excluding the Fixed format). Statement dates that are mm/dd/yyyy indicate the transaction is in work-in-process as opposed to the archive file. Rich text formatting is stripped out of the Description field and is not included in the output. The entire Description field is exported within double quotation marks for all formats with the exception of the Fixed format. When exporting to the Fixed format, a maximum of 250 characters of the description is exported and the text is not exported within double quotation marks.

The fields in each record are exported as follows:

Client ID 12 character Alphanumeric
User ID 8 character Alphanumeric
Transaction Date (see Date Note) 10 character Date (MM/DD/YYYY)
Entry Date (see Date Note) 10 character Date (MM/DD/YYYY)
Statement Date 10 character Date (MM/DD/YYYY)
Timekeeper # 3 character Numeric (999)
Category 3 character Numeric (999)
Exp/Adv Switch 1 character Alpha (E, A, blank)
Source 1 character Alpha (B,T,A,R,D,P,C,M,Q)*
Status 1 character Alpha (H,P,S,s,U,A)
Sales Tax Code 1 character Numeric (0-9)
Bill Code 1 character Numeric (0-4)
Rate Code 1 character Numeric (0-9)
Transaction Code # 8 character Numeric (999) or (X999X999)
Tcode Type # 1 character Numeric (0-9)
Rate 7 character Dollar (9999.99)
Units (costs only) 7 character Numeric (9999.99)
Hours Worked (fees only) 7 character Numeric (9999.99)
Hours to Bill (fees only) 7 character Numeric (9999.99)
Amount 12 character Dollar (999999999.99)
Statement # (payments only) 9 character Numeric (999999999)
Billing Statement # (payments only) 6 character Numeric (999999)
Cost Type (costs only) 2 character (0-9 or blank)
Reference Number 5 character Numeric (99999), shows "0" for archived transactions
Description up to 4900 characters Alpha (Fixed format = 250 characters only)

The Task Code Billing Report is identical to the Transaction File List with the exception that the following fields are exported instead of the Transaction Code # field. These fields are exported in the same position within the record as the Transaction File List.

Phase/Task Code 5 character Alphanumeric (XX999)
Activity/Expense Code 5 character Alphanumeric (XX999)

* Source Code: B=Billing (Tabs3), T=TAS, A=APS (costs) or Automatic Client Funds Payment (payments), R=Remote, D=Data Capture Device, P or C=PracticeMaster or Tabs3 Connect, M=Manual Client Funds Payment (payment), Q=QuickBooks (costs).

Date Note: When exporting using the Fixed format, the Entry Date is exported before the Transaction Date.

See also:   Microsoft Excel Import Note