Balance Sheet Analysis

Sets what is analysed. Press Refresh after changing any of these.

Store

Limits the analysis to one store. Leave empty to consolidate every store, which is the usual choice when reviewing the company position.

As at Date

The date the balances are struck at. A balance sheet is a snapshot rather than a period total, so this single date determines every figure on the Drill-down tab.

Date Range

Preset range used by the Comparison tab, filling in From and To below.

From

Start of the comparison period.

To

End of the comparison period.

Period

How the comparison period is divided: Day, Week, Month, Quarter, or Year. This sets the granularity of the movement shown on the Comparison tab.

Breadcrumb

Shows how far you have drilled — account type, then account, then transactions. Read it to keep track of which subtotal the current list belongs to.

Opens at account type level. Double-click a row to go one level deeper; Back returns. At the deepest level the list shows the individual transactions making up the balance, so a figure can be traced to the documents that produced it.

Drill-down List

The current level of the analysis.

At transaction level the list expands to show the document detail:

Sets balances from one period against another so movement stands out. The percentage column is what makes an unexpected shift obvious — a large Diff % on an account that should be stable is the usual reason to switch back to Drill-down and investigate.

Comparison List

Period-over-period figures for each account or type.

Refresh

Rebuilds the analysis with the current criteria, returning to the top level.

Back

Moves up one drill-down level, following the breadcrumb.

Print

Prints the list currently displayed, at whatever level you have drilled to.

Close

Closes the screen.