JZ074 Using the draft statements to diagnose issues in the Jazzit financial statements
Here are two common issues that come up when working with the Jazzit financial statements. They are significant rounding differences caused by:
-
Balance sheet not balancing.
-
Net income per the Jazzit financial statements does not agree with Net income per CaseWare
Solution
Consider adding the draft financial statements by map number to your client document manager. These statements require no extra setup as the layout is included when you copy in your Jazzit mapping structure.
There are two documents that we recommend using to assist with diagnosing the causes of these issues
-
Balance sheet by map draft (document 1.2 in FULMST)
-
Income statement by map draft (document 1.3 in FULMST)
The FULMST master file already contains the above documents. Use CaseWare's Copy Components function (File > Copy Components). If FULMST is not available, please use the following instructions.
Creating the Balance sheet by map draft
-
In CaseWare, locate the financial statements in the document manager. Right-click on the financial statement and select
New > Automatic document.
-
This will open the
New Automatic document window.
-
Set the window using the following settings:
-
Enter
Balance sheet by map draft into the name field.
-
Set the
Document Type to
Financial statements – Balance sheet.
-
Set
Format to
Active year to date/prior year to date.
-
-
Click
OK and the newly created document will be added to the document manager.
Creating the Income statement by map draft
-
Right-click on the newly created Balance sheet by map draft and select
New > Automatic document. This will open the
New Automatic document window.
-
Set the window using the following settings:
-
Enter
Income statement by map draft into the name field.
-
Set the
Document Type to
Financial statements – Income statement.
-
Set
Format to
Active year to date/prior year to date.
-
-
Click
OK and the newly created document will be added to the document manager.
Diagnosing issues in the financial statements using the above documents
BS not balanced
If the Balance Sheet, check to see if the ending current year Retained earnings agrees to the beginning prior year Retained earnings. It can be checked by opening the Balance Sheet by map draft.
If they do not agree, determine which balance is correct. You may have to post adjusting entries to correct either the prior period ending balance or the current period opening balance. This issue often occurs when a client has posted year-end adjustments to the wrong year.
If the Net income line is absent from the equity section, this may indicate that the Net Income account has not been mapped.
Use CaseWare’s Assign Mappings function (Account > Assign Mappings) to map the net income account.
Using the Income statement by draft
A rounding difference in the income statement occurs when the Net income per the Jazzit financial statement does not agree with the Net income per CaseWare. The Net income per CaseWare can be found at the bottom right corner of the CaseWare window or in the Jazzit income statement rounding panel.
-
Open the income statement by map draft. You may notice, for example, the Net Income per draft differs from what is reported by CaseWare in the Status Bar below. In this particular case, the amount reported in the Status Bar agrees with the amount before income taxes, which indicates there is possibly something wrong with the Income Tax account.
-
To investigate further, we open CaseWare’s Working Trial Balance to discover that the Income taxes – current account is assigned the wrong type (Balance Sheet), instead of Income Statement.
-
Switch it back to Income statement (I). Alternatively you can use
Tools > Options > Autofill to reset any account property that differs from the mapping structure.
The Net Income now agrees to CaseWare’s. This is just one example of an issue the Income Statement by map draft could help you resolve.
