- Adjusting Journal Entries
- Creating an Adjusting Journal Entry
- Adjusting Entry Detail
- Adjusting Journal Entries Interface
- Adjusting Journal Entry History Dialog
- Calculation Dialog
- Customize Adjusting Journal Entries Dialog
- New Tax Code dialog
- Recurrence dialog
- Type Letters For Quick Lookup
- Creating a Calculated Adjusting Journal Entry
- Creating an Other Adjusting Journal Entry
- Editing an existing adjusting journal entry
- Record Other Basis Adjustments
- Previewing or Printing an Adjusting Journal Entry
- Renumbering Adjusting Journal Entries
- Recording adjusting journal entry history events
- Creating Adjustments Quickly
Calculation Dialog
Working Papers allows you to create an adjustment where the balance is the result of a calculation rather than an entered value. A calculated journal entry takes values from existing categories (i.e, accounts, mappings, groupings, etc.) to determine the journal entry balance. Any changes made to elements of the calculation will automatically update the calculated adjusting journal entry.
Click on a field in the screen shot below to view its description
Category
Lists the available categories for use in calculated fields.
Displays engagement properties values that have been set in Engagement | Properties.
Contact 1
Title: |
CLP15 |
||
First Name: |
CLP20 |
|
|
Middle Name: | CLP416 | ||
Last Name: |
CLP21 |
|
|
Designation: |
CLP25 |
Position: |
CLP29 |
Bus Phone #: |
CLP18 |
Bus Fax #: |
CLP19 |
Mobile Phone #: |
CLP271 |
|
|
Home Phone #: |
CLP272 |
|
|
Email Address: |
CLP14 |
|
|
Contact 2
Title: |
CLP15 |
||
First Name: |
CLP20 |
|
|
Middle Name: | CLP416 | ||
Last Name: |
CLP21 |
|
|
Designation: |
CLP25 |
Position: |
CLP29 |
Bus Phone #: |
CLP18 |
Bus Fax #: |
CLP19 |
Mobile Phone #: |
CLP271 |
|
|
Home Phone #: |
CLP272 |
|
|
Email Address: |
CLP14 |
|
|
Name/Address
Client: |
Client No. |
CLP257 |
Client Name |
CLP256 |
Engagement: |
Engagement Type |
CLP258 |
Engagement Description |
CLP259 |
Operating Name: |
CLP2 |
|
|
|
Address: |
CLP3 |
|
|
|
Address 2 (blank) |
CLP4 |
|
|
|
City: |
CLP5 |
|
Prov/State: |
CLP6 |
Postal/Zip Code: |
CLP7 |
|
Country: |
CLP149 |
Phone #: |
CLP106 |
|
Fax #: |
CLP107 |
Home Page: |
CLP16 |
|
|
|
S.I.C.: |
CLP23 |
|
A.I.C.: |
CLP24 |
Tax Jurisdiction: |
CLP28 |
|
Tax Entity: |
CLP97 |
Engagement Type: |
CLP125 |
|
Client #: |
CLP145 |
E.I.N./B.N.: |
CLP253 |
|
Tax Vendor: |
CLP96 |
Period Balances
CLP198=blank |
Allow entry of period balances in Working Trial Balance (Other Entries will be disabled) |
CLP198=X |
Allow transaction entry in Other Entries screen (period balances will be calculated) |
Period Date Sequence for Other Entries Screen: |
CLP199 |
Current Active Period for Other Entries Screen: |
CLP200 |
CLP230 |
Display and enter period balances as year-to-date balances |
Reporting Dates
Year End Date: |
CLP13 |
Year Begin Date: |
CLP62 |
CLP151 |
13 Periods |
|
|
CLP152 |
Monthly |
|
|
CLP153 |
Bi-Monthly |
Compute bi-monthly balances from: |
CLP163 |
CLP154 |
Quarterly |
Compute quarterly balances from: |
CLP164 |
CLP155 |
Thirdly |
Compute thirdly balances from: |
CLP165 |
CLP156 |
Semi-Annual |
Compute semi-annual balances from: |
CLP166 |
CLP157 |
Yearly |
Compute yearly balances from: |
CLP167 |
CLP158 |
Random |
|
|
Current Period Date Sequence: |
CLP17 |
Current Active Period: |
CLP22 |
Displays document information values such as description, role completion information and sign off dates. The calculation syntax based on the item selected are the following:
Item | Syntax |
Document Description |
Isdesc("Document#","0") |
Extended Description | Isdesc("Document#","2") |
Sign off User | field("SH", "User#", "Document#") |
Sign off Date | sdate(field("SH","AD1","Document#")) |
Displays user defined values(ud1 to ud15) that are set in CaseView from Tools | User Defined Data. The calculation syntax based on the item selected are the following:
Displays class type values such as assets, liabilities, revenues, equity, and expenses. The calculation syntax based on the item selected are the following:
Item | Syntax |
Class Type Value | Class("BalanceType","Identifier") |
Displays account values that are entered in the Working Trial Balance. The calculation syntax based on the item selected are the following:
Item | Syntax |
Account Description | desc("Account#",0) |
Extended Description | desc("Account#", 2) |
Account Value | act("BalanceType","Account#") |
Displays mapping values that are entered in the Engagement | Mapping interface. The calculation syntax based on the item selected are the following:
Item | Syntax |
Map Description | mapdesc("map#", "0") |
Extended Description | mapdesc("map#","2") |
Map Value | map("BalanceType","Account#") |
Displays group/ LS values that are entered in the Engagement | Grouping interface. The calculation syntax based on the item selected are the following:
Item | Syntax |
Description | grpdesc("Group#", "Number","0") |
Extended Description | grpdesc("Group#", "Number","2") |
Value | grp("Group#", "BalanceType", "Number") |
Displays tax export code values. The calculation syntax based on the item selected are the following:
Item | Syntax |
Description | grpdesc("T", "Number","0") |
Value | grp("T", "BalanceType", "Number") |
Displays CaseView data values. The calculation syntax based on the item selected are the following:
Item | Syntax |
CaseView Value | cvdata("Group", "Form","Identifier") |
Entity
Select the entity in a consolidated file.
Parent Only Balances
Click to include only balances for the specified entity. Sub-entity balances are ignored.
Period
Select the specified reporting period. Period options include the following:
Opening - Links to the opening balances for accounts, map numbers, or groups for the year (not a specific period).
Default Period - Links to the current reporting period as defined in Working Papers.
Reporting periods as defined in the client file under Engagement| Properties | Reporting Dates.
Fiscal Year
Select to display current or prior year values for the basis of the adjustment value.
Balance Type
Select to refine the value of balances according to specified balance type. Balance type include the following:
Balance Type | Results |
---|---|
Unadjusted Balance | Balance without adjustments. |
Adjusted Balance | Balance including Normal adjustments. |
Report Balance | Balance including Normal and Reclassifying adjustments. |
Consolidated Balance | Balance including Normal, Reclassifying, and Eliminating adjustments. |
Federal Tax Balance | Balance including Normal, Reclassifying, Eliminating, and Federal Tax adjustments |
In addition to the various balance types above are the adjusting journal entry balance types that may be applied to the linked account, map, or group number. Selecting an adjusting journal entry balance type will display only the adjustment amounts in the results pane, not including the base balances (such as the opening balance and period movement). Specific adjustment balance types include:
- Normal Adjustments
- Eliminating Adjustments
- Reclassifying Adjustments
- Unrecorded Adjustments
- Federal Tax Adjustments
- State Tax Adjustments
- City Tax Adjustments
- Other Basis Adjustments
Balance Name
Select to filter the results according to the budget, forecast, or custom balance, if applicable.
Use Sign
Select to change the sign (+/-) of the displayed values according to the account Sign property in the client file. The following describes the different options:
Option | Description |
---|---|
No | Uses the RAW balance of the account. |
Yes | Uses the sign that is used in the formula. |
Use CV Default | Uses the sign that is currently set in CaseView. |
Note: This field is only enabled for Accounts, Mappings, Groups 2-10 and Tax Export Codes categories.
Period Only Balances
Click to filter values based on the specified period. Select this option to include only the period movement or activity of the specified period, instead of the default year to date balance. For example, choose to display only the second quarter transactions for sales.
Foreign Exchange
Click to apply foreign exchange to the listed values.
Include Sub-Balances
Click to include sub-account or sub-map number balances in the top level account/map number balance. For example, when selecting a balance for map number 170, this option will dictate whether or not to include 170.100, 170.200, and 170.300 in the balance.
Other Basis Adjustments
Click to include other basis adjustments in the listed values.
Account Rounding
Select whether or not to apply rounding to the value. Options include the following:
- No Rounding - Balances are not rounded.
- Round (RND) - Final balances are rounded to the nearest whole number. When rounding a group of accounts, this option sums all of the accounts and then rounds the sum of the group.
- Round By Account (RNDACT) - Each account is individually rounded to the nearest whole number. When used within a group, each account is rounded and then the grouping is totaled.
Hide Zero Values
Click to filter the listed values in the results pane to exclude zero values.
Equation Bar
Enter an expression to be used to calculate an adjustment value.
Accept
Click this button to save and apply the calculation.
Cancel
Click this button to cancel and clear the values in the equation bar.
Results
Displays the output of the expression entered in the equation bar.
Value Parameter List
Displays the items from the selected category that can be used in a calculated adjusting journal entry. Column headings in bold represent elements that can be linked. .
Hovering over a value in the list will open a tooltip window showing the potential formula and resulting value:
Tips
Right clicking on an element in a column that can be linked will display a context menu that may include the following:
- Link Formula - selecting this option will link the element into the formula.
- Link Data - selecting this option will link the actual data and not a formula.
Related Topics
Legal