Custom Import Your Soft Cost Expenses

Software such as Lexmark, Ricoh, Canon, Copitrak, Papercut, and Xerox can track certain soft cost expenses, such as photocopies and printing. The software produces .txt files you can download to import the data into the application.

Custom importing your soft costs involves two steps:

Add the import definition.
Import the custom file containing your soft cost expenses.

Import Your Soft Cost Expenses

To import your soft costs expenses:

Add your import definition.
From the left navigation panel, click Billing.
From the Billing menu, click Time/Expense.
From the toolbar atop the Time/Expense screen, click Action > Custom Import.
From the Custom Import wizard Import Types drop-down, click the proper import definition for your data.
In the lower right corner, click Next.
To Select the file you want to import, click Choose File.
Browse for the file you want to import.
Select the file.
The file name populates the field.
In the lower right corner, click Upload.
The import data displays for review.
Check or uncheck items you want, or do not want, to import.
To edit the Expense Name and Description fields, to the far right of the applicable row, click the orange pencil.
Note: All other changes must be made in either the original import file, or in the application after the file import is complete.

Once items are imported into the application, changes must be made individually.
In the lower right corner, click Complete Import.
A message displays: Data has been imported. Please delete the desktop import file used to prevent accidental import of the same data again.The system returns to the Time and Expense screen which displays your imported items.

Errors and Exceptions

The system will prompt you if errors arise.
For example, the designated matter or timekeeper may not exist. You can always cancel the import to make any needed updates within the application before importing.

Import Rules

Follow these import rules to ensure a successful file upload.

Field	Import Rules
Date	Each item can have its own date. If left blank, the application uses today’s date
Timekeeper Initial	If no match is found, the system rejects the entry and the import fails. If left blank, the import will auto-assign the firm’s default timekeeper. If no default timekeeper is set, an error will display.
Expense Code/Name	The application will match based on the expense code or name you assigned under Setup > List Items.
Quantity	If left blank, the import will auto-populate with 1.
Rate	Either Rate or Amount is required.
Amount	If an amount is provided, this will be treated as a final value. If a quantity is also provided, the application will adjust the rate.
Description	If left blank, the application can match the item based on expense name or code.
Tax Status	Y or 1 = Taxable N or 0 = Non-Taxable If left blank, the import will assign the corresponding matter tax setting. If the corresponding matter is Non-Taxable, the import will Ignore this field.

Export Client-Matter

Important: Firm users will will have to manually export their active client-matter on a daily or weekly basis according to the firm’s procedure to share with their printing tool.

To export matter list from the application:

From the left navigation, click Matters.
From the tabs atop the Matters screen, click Export.
On the Export Grid that opens, from the pages drop-down, select Custom.
In the next field, enter the From and To page numbers that you wish to export.
From the Export format drop-down, select CSV(.csv), and click Export.
Open the CSV file and remove all the columns except CLIENT NAME, MATTER NAME, MATTER FILE#, CLIENT ID
Move this file to the designated folder required by your printing tool.

UpdatedJuly 22, 2024

In This Article…

Need Support?