Data-Basics' GL Reporting and Layout tool supports strategic enterprise planning by providing integrated financial and performance data:
Supports arithmetical operations: percentages & variances can be reported
Allows for "what if" modeling
Empowers your accounting staff to design and generate their own special use reports:
Income statement with expenses as a percentage of total expense or income
Cash Flow Analysis
Comparative Financial Statements
Ratio Analysis
Customized Expense
Export to CSV: The GL Reporting Tool allows users to save previewed Reports as CSV (delimited) for import into Excel. This enhancement segments lines so that fields are distinct when saving as CSV so that files will reasonably formatted in Excel.
GL Reports are comprised of the following components:
A Column Layout. This defines the layout of the columns which will be printed for the report. All lines of the generated report will follow this column layout.
A Row Layout. This defines the set of row definitions that define the lines that will appear on the report. There are several types of rows that can be specified. These will be described below.
A Report Definition. This is the ‘glue’ that binds a Column Layout and a Row Layout together to define a specific report. The Report Definition also provides for setting certain report formatting information. Note that you can define multiple reports with the same Column Layout and different Row Layouts, and multiple reports with the same Row Layout and different Column Layouts.
Go to the Folder Viewer and select the General Ledger tab from the Accounting topic. Click the ‘Layout GL Report Columns’ button. This will open a parent/child viewer.
The parent window is used only to define the Column Layout’s ID and Name. In the child window, you can enter the column definitions needed for the report. For each column you can define the column’s width, a heading for the column, and what information is to print in the column.
For details on creating a Column Layout, click GL Report Column Layout .
Go to the Folder Viewer and select the General Ledger tab from the Accounting topic. Click the ‘Layout GL Report Rows’ button. This will open a parent/child viewer.
The parent window is used only to define the Row Layout’s ID and Name. In the child window, you can enter the row definitions needed for the report. Again, there are several types of rows that can be defined and these will be described below.
For details on creating a Row Layout, click GL Report Row Layout .
Go to the Folder Viewer and select the General Ledger tab from the Accounting topic. Click the ‘View/Print User Defined Report’ button. Enter a Row Layout Id and a Column Layout Id in the fields provided for. Fill out the remainder of the parent window with additional report options.
Bring up the desired report via the GL Reports Viewer and press the ‘Show Report’ button.
The ‘ranges’ area on the Report Options is taken into account is selecting entities to be reported.
The GL Report will now contain a line for each entity posted. This behavior can be overridden by checking the ‘Consolidated Report’ field on the Report Options screen.
Zero Line Suppression. If all the numeric columns of a report line contain zeroes, that line will no longer be printed. This behavior can be overridden by checking the ‘Include Zero Lines’ field on the Report Options screen.
A GL Report can now be set up as a User-Defined Function. This works just like setting up a User Defined Report except the user fills in the GL Report Id field instead of the Report Id field.