Account analysis working paper

slider-account-analysisThe Account analysis working paper helps preparers analyze changes in the trial balance over a maximum of 5 periods. The working paper will calculate period to period changes in percentages and amounts. A number of presentation options are available, including settings that prepare the working paper for client presentation or internal use.


Overview

The working paper comes pre-populated with Balance sheet and Income statement map numbers. Any of these lines can be changed to display any amount from the trial balance.

news-account-analysis-01 intro


Presentation Options

Click on the small folder next to ‘Account analysis options’ to reveal options for the working paper.

news-account-analysis-02 options


Report Options:

Format

The format option has 2 presets that allow the working paper to be presented to clients (Client version) or internal use (Working paper). 

Setting the Format to Client version will set the: Link number, Annotations, and reference columns to Display only, preventing them from printing. It will also prevent the sign off boxes found at the top or bottom from printing.

Setting the Format to Working Paper will set the: Link number, Annotations, and reference columns to Display and Print. The sign off boxes will print on the top and bottom of the working paper.

news-account-analysis-03 client-version

Link number, Annotations, and reference settings can also be set individually regardless of the Format setting. 

With working paper enabled 

news-account-analysis-04 WP-enabled 

When set to Client version 

news-account-analysis-05 client-version-enabled

Page size and Page orientation

Page size enables the preparer to choose between letter and legal size paper. Page orientation gives the choice between Landscape and Portrait orientations. 

The number of columns enabled in this working paper may not fit in the desired size and orientation configurations. Please check print preview to ensure that the working paper content fits properly on the page. The preparer will receive warnings of this when attempting to switch to smaller size options (portrait or letter).

news-account-analysis-06 fits


Balance sheet and Income Statement

The Account Analysis working paper is divided into the Balance Sheet and Income sections which can be switched off/on. 

 

Display columns

Display and print settings for support columns in the working paper. 

  1. Link number – Set the Link number column to print or skip.
  2. Vertical dividers – Turn off or on the column dividers. The dividers will show when printing.
  3. Annotations / tickmarks – Set column to display, display and print, or be hidden entirely.
  4. WP Ref column - Set column to display, display and print, or be hidden entirely.
  5. Draft stamp – Set draft stamp on/off. Specify content of draft stamp using the dropdown. Custom stamp content can be typed into the dropdown. Note: draft stamp only shows in print preview or when printing the working paper.

news-account-analysis-07 display-columns

Column selection

Choose which columns to display or hide. There are a total of 5 periods with 3 types of columns for each period, with the exception of period 5 that only has 1 column type. Each individual column can be displayed or hidden as required. 

news-account-analysis-08 column-selections

Period Options

Period Options works similarly to the column options found in various statements and schedules in the Jazzit financial statements. Please refer to this video or this PDF  for examples on how the period options function.

news-account-analysis-09 period-options

Threshold settings

With threshold settings the working paper will automatically hide any line items below a certain % and/or amount change between columns (periods) 1 and 2. This is useful for focusing only on items that have significant variances between columns 1 and 2. 

The button next to “Threshold settings” toggles the threshold function on/off. 

    • “Hide rows below threshold” = on
    • “Show all rows” = off

If nothing is filled for either Threshold % or Threshold amount all lines will show even if the function is on. The “and/or” condition between the % and amount threshold can be set with the available dropdown.

Note: Entering either a threshold amount or % will disable subtotals and grand totals.

news-account-analysis-10 threshold-settings

Linkage options 

Like the Jazzit financial statements the working paper links based on map number. This can be changed on a per line basis using the Link type column. Set Apply global link setting to ‘No’ in order to reveal the Link type column. The dropdowns in the Link type column will allow lines to be linked by: account #, L/S, and group #.

news-account-analysis-11 global-link-set-no

When the same option is set to ‘yes’, all lines will follow the same link type. The global link type can be set using the dropdown that appears.

news-account-analysis-12 global-link-set-yes

Rounding

The balance sheet section of the working paper has support for rounding. The rounding difference is automatically calculated and shows at the top of the balance sheet in orange cells.

news-account-analysis-13 rounding-differences

Right-click on the express button of the line item you want to use as your rounding line. The rounding difference will be applied to that line. Its express button will change in appearance to denote that rounding is being currently applied to that line. The orange cells disappear and the rounding difference will show in the yellow cells.

news-account-analysis-14 rounding-applied

To deactivate rounding, click on the `Clear ‘button.