Firm Template | Document Manager

  Instructions:

This article covers the following topic:

1. The Document Manager
2. Leadsheets - Viewing/changing the properties of a lead sheet
3. SOFP - Multi-Column Reporting
4. Leadsheets - Showing/Hiding columns
5. Leadsheets - Header Freeze
6. Creating a new automatic document
7. Making CaseView documents read only after sign-off

The Document Manager

• Double-click on a folder to expand or collapse.
• Double-click on a document to launch the application and open the document.

	Folders – use folders to organise documents in the Document Manager.  Double - click on a folder to open it or close it.
	Automatic documents – predefined documents automatically populated by CaseWare Working Papers, e.g. lead sheets, schedules, checklists, etc.  These have been pre-configured in the templates.  Users can also create their own documents as well. Data in automatic documents cannot be manually overwritten, unless adjusting journals are posted.  Annotations (tick marks, notes and references) and comments can be added to the documents.  For help of type of automatic documents, press F1 – Help
	CaseView documents – documents created by the CaseWare Working Papers word processor, CaseView, e.g. financial statements, information store.
	Manual document references – placeholders in the client file for manually prepared working papers.
	Microsoft Word documents – opens a new Microsoft Word document and stores the document in the CaseWare Working Papers client file folder.  Word documents created in this way must be opened from within the CaseWare Working Papers Document Manager in order to save any changes made to the document.
	Microsoft Excel documents – opens a new Microsoft Excel document and stores the document in the CaseWare Working Papers client file folder.  Excel documents created in this way must be opened from within the CaseWare Working Papers Document Manager in order to save any changes made to the document.
	Document links – documents created by another programme.  Double-click on the icon to launch the application in which the document was created.
	New from document library – Existing document libraries containing useful working papers used within the company can be added to the Document Library within CaseWare Working Papers. This allows instant access to these documents and these documents can be added to the Document Manager using the New from document library.

Leadsheets

A lead sheet is an automatic document created within the Document Manager. It is a document created for the purpose of viewing specific Lead sheet number(s) or Mapping Numbers. A Lead sheet is generated from predefined or user defined settings automated by the CaseWare client data base properties. CaseWare has created default Lead sheets within the Document Manager to assist users in completing the engagement. These Lead sheets can however be customised. 

Viewing/changing the properties of a lead sheet

The properties (or configuration) of any automatic document can be viewed or changed:

• There are various ways of accessing the document Properties:
  • From the Document Manager, right – click on the document and click on Properties.
    • Or you can select the document in the Document Manager and from the CaseWare Ribbon, go to Document | Properties. 
    • Alternatively use the Alt + Enter hot key.

• Number: Shows the document reference in the Document Manager.
• Name: Shows the document name.  
• Document Type:  Shows the type of the current automatic document. 
• Format: Each automatic document has different formatting options, depending on what level of detail is required.
• Settings: The settings determine what data will be pulled through to the automatic document.

SOFP - Multi-Column Reporting

• In the financial statements template (CaseView): From the Freeze Pane toolbar, select Options | Lead sheet setup | 3 years.
• Two new columns will appear on the right of every lead sheet showing Prior Year 2 data and a calculation of the percentage movement between prior years 1 and 2. 

Leadsheets - Showing / hiding columns

• To view additional hidden columns, open the lead sheet by double-clicking on it and right-click anywhere on it. 
• From the right-click menu, select Reorder Columns.
• The Reorder Table Columns dialogue appears
• Use the below buttons to reorder active columns
  • .
• Use the below buttons to add hidden columns to the view or remove unwanted columns.
  • 
• Select Default to restore the default columns to the view.
• Select OK to save the settings and close the dialogue box

Leadsheets - Header Freeze

• Right–click in the open Automatic Document. 
• Select Freeze from the menu. 

1. None – No headers will freeze when scrolling through the Automatic Document. 
2. Column Header – Only the column headings will freeze when scrolling through the Automatic Document. 
3. Full Header – Freezes the whole header (document heading as well as column headings) as you scroll through the automatic document.  

Creating a new automatic document

• Option 1 - Right – click in the relevant section where the document should be inserted and select New | Automatic Document 
• Option 2 - Select the appropriate document toolbar from the Home category on the CaseWare Ribbon

• Option 3 - Select Document | New from the CaseWare Ribbon and select the relevant document type from the list.

• The New Automatic Document dialogue appears:

• Number: Enter the document number. Each document on the Document Manager must have a unique number.
• Name: Enter a brief description of the document. 
• Document Type: Select the type of automatic document to create.
• Format: Select the format for the automatic document.
• Check boxes: Either keep as default or select the desired check boxes that should apply to the document.

Complete the settings portion of the screen and click on the OK button.

ℹ For more information on Automatic Documents, refer to F1 (Help) in CaseWare Working Papers.

 

Flagging documents after sign-off

CaseView and external documents can be flagged when changes have been made after a certain sign off role. This can be setup in the Company Template. 

• From the CaseWare Menu, go to Tools | Options | Roles.

• Select after which role(s) the documents should be tagged and select OK

• The CaseView and external documents will be flagged with a warning symbol 

• indicating that the document has been modified. Hover over the warning symbol to see which user it was modified by and when.

Making CaseView documents read only after sign-off

• From the CaseWare Menu, go to Options | Roles.

• Select after which role(s) the documents should be made read only and select OK. 

• The CaseView will become read only. The LOCKED indicator will appear in the Status Bar of the selected CaseView document.

   Related Articles