How to use the Analytical Review (Ratio) workpaper

The Analytical Review (Ratio) document allows you to create your own ratios using the data stored within your client's trial balance. Within the one worksheet, you can create an unlimited amount of ratios, or you can create an unlimited amount of ratio worksheets.

The format of the ratio workpaper is similar to that of the other analytical review documents found in MyWorkpapers. We've broken our instructions down into 3 easy steps:

Step 1 - Setting Your Parameters

The first step to completing your analytical review is to set the details of your analytical review.

You can select the Use external benchmark, Interim values, Initial values, and Final values boxes to display these fields in your ratio table. The Interim, Initial, and Final data ratio is calculated by using the data imported into your trial balance. The Benchmark field is an input cell.

The Display charts chronologically tick box and the Type of Chart menu allow you to format the display of your chart (should you choose to display it). The display chart chronologically button has been ticked as a default and will display the horizontal axis in consecutive order. By unselecting this box, the chart will display in the same order that the ratio table displays the data. The type of chart menu allows you to change the menu type from columns to a line chart.

Step 2 - Completing Your Review

Once you've completed step 1, you can begin your review.

Follow the steps below to calculate your ratio:

Select the Create new ratio button that appears under the ratio table. This will display the ratio editor;
Edit your ratio (see Step 3 to Step 8 for details);
Create a name for your ratio;
Select your account from the drop-down menu (note that you can change between an account group or individual account by selecting either of those buttons);
Then select the add numerator or add denominator, depending on where the account should appear in the calculation;
Continue to repeat Steps 4 and 5 until you have added all of your numerators and denominators;
Next, choose how you would like your ratio displayed and how you would like it rounded by clicking a button from the below options;
Once you're happy with your ratio, you can click the add this ratio button to add it to your worksheet.
The ratio will now display in your table. If you have created a prior year file for this client, the prior year data will also be displayed in your table.
To the right of the table you will see the following ratio options;
You can add comments against your ratio by selecting the comment box icon that appears adjacent to the description of your ratio;
You can also add a comment in the comment box below the chart;