Create / Edit User Reports

Parent Previous Next

Bug - Budgets

1.Tools → Old Reports → General Ledger → Trial Balance - Budget figures does not print.

2.Tools → Old Reports → General Ledger → Income Statement - Budget figures does not print.

3.Tools → Old Reports → User Report - Budget figures does not print.

4.Tools → Old Reports → General Ledger → Budget Performance - Budget figures for the year includes an extra month's budget figure. For example, it the total budget figure is entered as 120000 (10000 x12), the total is displayed as 130000 (13 periods) instead of 120000 (12 periods). The budget report on the T-Account Viewer is displayed correctly.

The Report Writer works on a similar basis to any spreadsheet. There are columns and rows in which you enter information or do calculations.

All you need to do, is to set up the report headings and 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 have been set up.

The Report Writer allows for up to 15 columns if you are using wide paper and seven columns if you are using A4 paper. The Report Writer works similarly to any spreadsheet where you have columns and rows. Values, formulae and references may be entered into cells. The columns are numbered from "A" to "H" (if seven 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 → System parameters → Groups menu, then numerous reports may be written.

To Write an Income / Expenses Report:

1.Click on the Tools  → Old Reports → User Reports menu.

The Select a User Report screen, will be displayed, listing the New option and any available user reports, if any user reports have previously been set up:

2.Select the New option, and click on the OK button.

If you wish to edit an existing report, you may select the report to edit, and click on the OK button.

3.The Report Writer screen is displayed:

4.The Report Writer screen consists of four basic sections in which you need to enter and / or select a few options, i.e.:

a)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.

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

ii)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.).

iii)Report Title 2 - This is the sub-heading e.g. "For the period ending #E". The "#E" means that TurboCASH will recognise the date you require, when you print your report.

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

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

vi)Compress print.

b)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:

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

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

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

iv)Group 1/2 the sum of the balances of the accounts in the reporting group, you specify.

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

vi)Single Line prints a single line across all the columns.

vii)Text Details typed by the user.

c)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.

i)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.

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

iii)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.

d)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.

5.Click on the OK button to save your changes and to exit (close) this screen.

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

You may also click on the Data File button to export your User Reports to a Text Comma Separated Variable (*.csv file format) file. You may then import the saved or exported file, if necessary. This will save you time to re-create the User Report in the event of losing data for some unforeseen reasons.

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

Row

Row Type

Description

Column A

Column B

1

Text

Enter “Income”.



2

Account

Select “Sales”account



3

Account

Select “Cost of Sales” account



4

Column Line

Enter “=”.



5

Text

Enter “Gross Profit”.

A2+A3

B2+B3

6

Text

Enter “Less Expenses”.



7

Group Detail 1

Select “Expenses”.



8

Column Line

Enter “_”.



9

Text

Enter “Total Expenses”.

A7

B7

10

Column Line

Enter “_”.



11

Text

Enter “Nett Profit”.

A5+A9

B5+B9

12

Column Line

Enter “=”.




Created with the Personal Edition of HelpNDoc: Write eBooks for the Kindle