Why does my NETINC not match my Income Statement profit

There are a few reasons why the automatic NETINC account in CaseWare may not balance with the Profit in the Income Statement.

- The Trial balance has been modified.

- The Income Statement has been modified.

- Custom map numbers may have been created

- The Trial balance has been modified

When user maps accounts from their client trial balance to a CaseWare mapping number, there are a number of properties assigned to these accounts. One of these properties is the Type which is then used to calculate the NETINC account. 

The NETINC account totals up all the Income Statement (IS) types to produce the total calculation. If the Type for any account is modified, then this can impact upon the NETINC calculation. Users have the ability to check if these properties have been modified through the use of the CaseWare Diagnostic utility.

1. From the Tools tab, select Diagnostics. The 'Diagnostics' dialog will appear.

2. Select Mapping Structure and tick the fields; TYPE and SIGN.

3. Click OK. If there is a problem, an error report will appear like the one below. If there is nothing wrong with the trial balance, this report will be empty.

4. Once you have established a problem, you can use the above report to fix each of the accounts.

Note: Ref to the FAQ below regarding the Auto-fill now to see how you can resolve all these errors at once.

- The Income Statement has been modified

- Inconsistencies between the Income Statement and NETINC can also be caused by custom changes to the income statement itself.

A good way to check is to reinsert a fresh Income Statement into the Financials and see if that resolves the problem.

Note: Any custom changes made to the statement will be lost.

1.    Make sure you backup your engagement before proceeding (File | Backup).

2.    Within the 'Financials ribbon' select the Insert tab | from the Statements area > Income Statement.  

3.    Tick the same Income Statement already selected and click OK.

4.    Click Yes replace the current Income Statement.

Custom map numbers may have been created

Custom map numbers can be the silent culprit for these two items not balancing. If a user or firm have created custom map numbers, they may have forgotten to select the correct properties for the map number.

For example, a new map number may have been created for Travel expenses but the Type was setup to be a Balance Sheet item. This can be a real problem because the Diagnostic utility in CaseWare will not pick up this error.

Warning: Please do not create any custom map numbers. Please refer to our mapping guide for further information.

• Related Articles

• Different formats of the Statement of Comprehensive Income

  CaseWare Australia & New Zealand has provided three different formats of the Statement of Comprehensive Income.  Summary Statement of Comprehensive Income (Default) Statement of Comprehensive Income - Single Statement by Nature* Statement of ...

• How to Insert a Detailed Profit & Loss Statement into the Financial Statements?

  To insert a Detailed Profit & Loss Statement into the Financial Statements ensure Schedules have been activated under Areas Required of the Financial Statements: 1. From the ribbon, select the Entity Information| in the  Report Details group> Areas ...

• How do I Sort Content Within the Financial Statements?

  The Document Map provides the ability to navigate around the financial statements, however, it is also used to sort both statement areas and notes to the financial statements. To sort content within the financial statements, complete the following ...

• Mapping Guide

  This guide attached below is designed to assist CaseWare users with the mapping process. It covers frequently asked questions about mapping and provides guidance on where to map accounts for the key financial statement areas and different entity ...

• How to use the Agile Audit Balance Sheet and Income Statement?

  Agile Audit engagements provide a couple of financial statement documents, such as, Income Statement (4-450) and Balance Sheet (4-455) to review the variance amount and percentage changes between the current and prior year. Watch the video below to ...