CIC Solutions Forums
Certified Independent Consultant Solutions Forums for
LexisNexis® Practice Management Products
Time Matters - PCLaw - Billing Matters - Browser Edition - HotDocs

TIP: Sending PCLaw Reports to MS Excel

rated by 0 users
This post has 1 Reply | 0 Followers

Top 100 Contributor
Posts 27
.CIC
PCL CIC
Steven J. Best Posted: Sat, Jun 24 2006 3:48 AM

SEND PCLaw/PCLaw Pro Reports to Excel

Most PCLaw Reports can now be sent to Microsoft Excel.  When you are ready to run a PCLaw report, you have the option now of sending the output to Excel where further calculations, manipulation and/or the spreadsheet data can be used in more expansive reports (such as Access).  PCLaw added this new flexibility with version 7.5x and higher.

On the COMMON screen of most reports (some reports do not export to Excel), you should direct your report Output to the EDITOR.  When you click [OK] to run the report, PCLaw will compile the report and then ask you to where you wish to save it.  At the Save As window, select EXCEL as the Save As FORMAT.  Save the report in EXCEL format anywhere you wish (such as your DESKTOP) and then double click on the ICON.  Your report will be beautifully columnar in MS Excel.

Steven J. Best, Esq.
PCLaw/HotDocs CIC
Best Law Firm Solutions, Inc.
Tel. 770-998-3800
stevenbest@bestlawfirm.com

Steven J. Best, Esq. HotDocs, Time Matters, and PCLaw CIC Best Law Firm Solutions, Inc. Tel. 770.998.3800 Reply to: steve@bestlawfirm.com
Top 100 Contributor
Posts 23
The following is the list of reports that can be exported to Excel:

Time Listing
Client Summary
Billed Fees Journal
Invoice Journal
Payment Allocation listing
Receivables by Client
Receivables By Lawyer
General Ledger
Financial Statements
General Bank Journal
Trust Listing


John Heckman TM/BM / PCLaw CIC Heckman Consulting Jersey City, NJ heckman@heckmanco.com www.heckmanco.com
Page 1 of 1 (2 items) | RSS