...
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
As of...- leaves the beginning date blank and fills the ending date with the current period.
As of Period End Prior year – allows the comparison of balance sheets: this year vs. last year.
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. ****
...
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
...