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.


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.


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.
     
     
3. 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.
     
     
4. 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.