Sample Default Column Specifications
This section contains some standard report formats together with the column specifications that created them.
Example 1: balance this period and last period
This example produces a comparative balance sheet. Column E lists the
current balance, and column
Example 2: this year / last year balances with percentage of total columns
This example produces a comparative balance sheet with four columns
of data. Column G lists the current balances and column I lists the balances
for the corresponding period in the previous year. Columns H and
Note from the formulas in columns H and
Example 3: period and year-to-date expenses
This example produces a comparative expense schedule with two columns of data. Column E lists the expenses this period, and column F lists the expenses year-to-date.
Example 4: current period and year-to-date expenses as a percentage of sales
This example produces a comparative expense schedule, with each current period and year-to-date expense listed as a percentage of sales.
The range of expense accounts is defined in row 13, and uses the default formulas defined in row 11 of the report specification. The total sales calculation is in row 9. Financial Reporter recalculates all formula cell references for the generated report.
Example 5: current period and year-to-date expenses compared to last year
This example produces a comparative expense schedule with six columns of data. Column G lists the current period expense and column H lists the expense for the corresponding period in the previous year. Columns J and K list the year-to-date expenses, and columns I and L compare each amount as a percentage of the amount in the previous year.
Note that the range of expense accounts is defined in row 21 of the report specification, but the formulas in I18 and L18 reference the default formula cells which are used in row 21. Financial Reporter recalculates these cell references for the generated report.
Example 6: side-by-side departmental statements
This example produces a side-by-side departmental comparative balance sheet with three columns of data.
The processing order is set in column A to Account order, and column D indicates that each time the account number changes, the Financial Reporter should create a new line.
Column E lists the name of each account, column F provides the current balance of accounts that meet the criterion of department "A," and column G provides the balance of accounts that meet the criterion of department "B."
See also