Preparing journal adjustments and linking to the WTB

You now need to address the adjustments in Part 3 of the requirements:

1. Create a new worksheet and rename it JNLs. Prepare your journal adjustments in the following manner:

Figure 12.22 – Template for journals

2. Enter the DR amount, then for the CR value, enter – (minus) in the cell with the DR value. This way, you reduce the exposure to typographic errors and ensure that your journals balance.

Note that the account name you use is from ACC DESCRIPTION and not ACC GRP.

Now, go to the AUDIT JOURNAL column of the WTB and enter the following formula in the first record in a cell:

Figure 12.23 – Syntax for SUMIF

The SUMIF function has three arguments:

• Range – This refers to the range Excel will search for records matching the criteria. In this case, all of column C on the JNLs worksheet.
• Criteria – All occurrences...