Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...


Press the Show Lines button  to edit your report. 
If you would like to design a new report but do not want to start from scratch, use the Report Assistant to pull up a generic report to use as a starting point. 

...

Macro Report Design

...


When designing a report from scratch, it is necessary to decide on the macro design. This is done in the first screen of the Design Financial Statement editor. The report number is the number or alpha characters that you will use to pull up the report (the report name). After naming the report, enter the Report Title. The report title will display (generic titles usually work best i.e. Balance Sheet, Income Statement, etc.). The report title section allows you to set important universal parameters like the divisor. Larger companies will usually display their G/L amounts in thousands or millions for the sake of readability. Check the Exclude Zero Lines box if you do not want G/L line items to display that have zero balances.

...

  • G/L Data – will display the GL G/L data for the date range selected based on the line definitions.

  • Budget Data – pulls for the GL G/L Budget data and allows for comparison of budget vs. actual.

  • Variance – allows a comparison of two existing columns and expresses the difference in a dollar amount.

  • Variance as a %- allows a comparison of two existing columns and expresses the difference as a percentage.

  • % of Total – is typically used to express all items as a % of total sales. For example, the user can identify the Total Revenue line as the base row and the G/L Data column as the base column and the report will express all income and expenses as a percentage of sales.

The Default Dates range defines the time frame of the report. They are not the actual dates they just represent the range to use. The actual dates populate when the report is printed. Date range options are as follows:

Balance sheet ranges

  1. As of...- leaves the beginning date blank and fills the ending date with the current period.

  2. As of Period End Prior year – allows the comparison of balance sheets: this year vs. last year.

  3. As of Prior Year End – Allows the current balance sheet to be compared to the prior year-end balance sheet.

*Note: All balance sheets must have the beginning date blank to run properly since the balance sheet runs from the beginning of time, leave the date blank to pick up all activity. ****

...

  • Budget – if the column type is budget data, the user needs to identify which budget to print.

  • Base Column – if this column type is a % of TotalVariance or Variance as % the user needs to identify the first column for comparison. In the % of Total column type only the base column is needed.

  • Base Column 2 – if this column is a Variance or a Variance as %, select from the drop down list the second column that will provide the number to calculate the difference.

  • Base Row – if the column type is % of Total, select the line that contains the total on which to base the percentage. This is usually the Total Revenue line of Income statements.

Defining and editing line detail

Once in the report editor your can add lines using the add line button  or delete them with the delete line button  . 

...

  • G/L Data – will pull G/L data directly from the general ledger totals.

  • Totals - assigns a G/L range you would like to total.

  • Blank Line – leaves the line blank.

  • Text – will allow you to enter text into the description and will not pull GL G/L data.

  • Add two lines – you can define what two lines to add in the formula tab.

  • Sub two lines – subtract two lines that you define in the formula tab.

  • Sum line range – will allow you to get a summation of a column, defined in sum tab.

  • Retained Earnings – indicate the retained earnings for the range entered.

  • Net income – indicates net income for the range entered.

  • Non-Fin Data – indicates the range entered is non-financial data.

...

 
If the line type you are adding is a G/L data type, you will be sent to the GL G/L Accounts tab next. Here you will be able to assign the GL G/L account range that you would like to show up on the report you are creating. 
When the Print Account Number box is checked the G/L account number will display before the description on the report.

...

 
At this point you have created a formatted balance sheet.

  • Text Line headings

  • GL G/L ranges

  • Totals Lines

  • Summation lines

  • And formulas

...