TurboCASH Accounting Software TurboCASH United Kingdom
Select your Country
OPEN SOURCE ACCOUNTING SOFTWARE
HomeFeatures & ScreenshotsShop onlineCompareFAQForumRegisterContact
Community
Free Downloads
Shop
Other Titles

Using TurboCASH

 







USER REPORTS
CREATE OR EDIT USER / CUSTOM REPORTS
  
This option allows you to design write and edit your own reports, using the REPORT WRITER. The Report Writer works on a similar basis to any spreadsheet. There are columns and rows in which you can enter information or do calculations.

All you need to do is set up the report headings, what information you require in each row and the column headings. When you print the report, TurboCASH automatically extracts the amounts from the accounts or reporting groups you have specified, and does any calculations, which you have set up.

In addition to the standard reports, which TurboCASH provides for on the Reports menu option, the program provides you with the powerful facility to create and customise your own reports to meet your requirements. The Report Writer, if used correctly, can supply you with information such as:
  • Balance sheets

     

  • Income statements

  • Profit and Loss reports tailored to meet your requirements

  • Quarterly reports

  • Half yearly reports

  • Monthly income statements

  • This year versus last year comparisons

  • Budget versus actual comparisons

  • And a host of others.
The Report Writer allows for up to 15 columns if you are using wide paper, and 7 columns if you are using A4 paper. The Report Writer works similarly to a Lotus spreadsheet, whereby you have columns and rows. Values, formulae and references may be entered into cells. The columns are numbered from "A" to "H" (if 7 columns are required) and "A" to "O" for the wider paper. The number of rows downwards are infinite.

If you have ranged your accounts using the Groups Facilities in the Setup menu, then numerous reports may be written.

To write an Income / Expenses report:
Click on the Edit - User Reports menu option or press the and and keys on your keyboard. The Select a user report screen will be displayed listing the New option and any available user reports, if any user reports were set up.

Title bar. Close button - click to close or exit this screen. Vertical scroll bar - move up or down to view more rows or lines, if necessary. Select New to create a new User report or select an report from the list to edit. Click to open the selected option or report. Click to cancel and exit or close this screen.
Select the New option and click on the button. If you wish to edit an existing report, you may select the report to edit and click on the button. The Report Writer screen will be displayed.

Title bar - double-click to display the screen in full size or to return to the normal size. Minimise button - inactive. Restore button - click to restore the program to the original size. Close button - click to close or exit this screen. Enter a name for the report. You need to select this name to generate, edit or delete the User report. Enter a title for the report. Enter the number of columns from 1 to 7 if A4 paper is used or up to 15 columns for wider paper. Select to display decimals for amounts. Select to compress the print. Will be activated when the cursor is in the Column fields. Select This Year, Last Year, Budget or Formula. The number of columns will be displayed as specified. Will be activated when the cursor is in the Column fields. Enter Headings for the selected column. Will be activated when the cursor is in the Column fields. Select Absolute to select dates or select relative. Relative is dependant on the date specified. Will be activated when the cursor is in the Column fields. Select the Dates if Absolute is selected. If Relative is selected the description for these fields will change to Relative from and To. Select the Type for the row or line - Account, Blank, Column Line, Group 1, Group 1 Detail, Group 2, Group 2 Detail, Single Line or Text. Click to delete a line or row. Click on the down arrow to export, import or print a user report in a comma separated value (CSV) file format. Click to insert a line or row. The selected Account, Group Heading or Group Detail will be displayed. If the Text is selected, you may enter the text. Select to print the Sub-accounts. Select to print. The description of a selected account or text as entered will be displayed. Displays the row number, in which values or a formula is entered. Click to preview the report. Enter or select the date of the report. Click to save the report and to exit or close this screen. Click to cancel and exit or close this screen. Vertical scroll bar - move up or down to view more rows or lines, if necessary.
The Report Writer screen consists of 4 basic sections, i.e.

  1. Report Header: This section is on the top left-hand side of the screen and is used to define the name, titles and properties of the report.

    • Name of the report (used to edit, delete or generate reports).

    • Report Title 1: This is your main heading The Heading or title of the report, (e.g. Income & Expense Report, Income Statement, Balance Sheet, etc.).

    • Report Title 2: This is the sub-heading e.g. "for the period ending #E", the #E will mean that TurboCASH will recognise the date you require when you print your report.

    • Number of Columns - This will insert the number of columns (up to 15 columns if you are using wide paper, and 7 columns if you are using A4 paper). You need to set or define the headings and properties for each column.

    • Decimals - to display decimals or not to display decimals for any amounts or formulas displayed in the report.

    • Compress print

  2. Report Row Details: This section is on the bottom left-hand side of the screen and is used to define the information and properties, which will be displayed on the report. The following types of row info are available:

    • Account the value of the account you specify and its sub-accounts will be printed, if this option is chosen.

    • Blank you can specify the number of rows you would like blank.

    • Column line prints a line in the column rows. You may specify a single line (_) or a double line (=)

    • Group 1/2 the sum of the balances of the accounts in the reporting group you specify.

    • Group Detail 1/2 all individual accounts for the reporting group you specify will be printed with their balances.

    • Single line prints a single line across all the columns.

    • Text Details typed by the user.

    • Column Header: This section is on the top right-hand side of the screen. It is used to define the type of the column, name, titles and properties of the columns in which the balances and or figures are displayed or formulas are calculated for each column.

      • Column Type - This sets the global properties for a column, i.e. This Year figures or balances, Last Year figures or balances, Budget figures or formulas.

      • Column Header - Description which will be displayed as a heading for the column.

      • Method - Absolute in which the specific reporting dates (This Year or Last Year) may be selected, depending if the Column Type is selected as This Year or Last Year. Absolute returns the balances for the months specified, irrespective of the date of the report. Relative is dependant on the date specified.

    • Column Details: This section is on the bottom right-hand side of the screen and is used to define the information and properties and formulas, which will be displayed on the report.

    Click on the button to save your changes and to exit or close this screen.

    You may click on the button at any time, while designing or creating the report, to preview the user report.

    It is important that you plan your reports carefully to ensure that the correct reports are generated. The following is an example of a User Report as created:

    Row Row Type Description Column A Column B
    1 Text Enter Income
    2 Account Select Sales Account
    3 Cost of Sales Select Cost of Sales Account This step can be ignored if you do not require a gross profit.
    4 Column Line Enter _
    5 Text Enter Gross Profit A2+A3 B2+B3
    6 Text Less Expenses
    7 Group Detail 1 Select Expenses
    8 Column Line Enter _
    9 Text Enter Total Expenses A5+A7 B5+B7
    10 Column Line Enter _
    11 Text Enter Net Profit A5-A9 B5-B9
    12 Column Line Enter =


    To generate a custom or user report, click here.