Below is a list and brief description of all the main reports.

Customer/Supplier ListProvides a listing of all Customers/Suppliers held on file. The report has options such as to include financial information, or to show full account details.

Statements These are produced for every Customer/Supplier where a transaction has been entered in the current period or there is an unallocated transaction from a previous period.

The Statement can show the outstanding balance on each transaction, or a running cumulative total for transactions, and it has an Aged Analysis at the bottom.

You can select to use Home Values, Currency Values or Euro Values.

Aged Debtors/Creditors This includes all Customers/Suppliers where there is a current balance on the account and shows the total Debt/Credit aged over the previous three (or four) months.

If you have the privilege of posting to future Periods, there is an extra option: Multiple Period. When this is selected, the Period menu is displayed. This enables you to select the end of the ageing period.

Debtors Letters Offers three user definable letters that can be printed for Sales transactions that are overdue for payment. The letters can include or exclude transaction detail so they can be used for promotional purposes in addition to debt collection.

Mailing Labels Will print labels for any or all of the addresses stored for each Customer/Supplier with or without contact names and salutation.

Customer/Supplier Balances A detailed report by Customer/Supplier showing Opening Balance, Transactions and a Closing balance for the period selected.

The print selection window enables you to select the Year and Period for which you wish to produce the report. The Simple Search and Select Search options are available. These enable you to specify the search criteria that you want to use to refine this report.

Sales/Purchase Analysis Provides a list of all Sales/Purchase Codes held within the system. report can show turnover on account, net VAT for current period, and year to date or periods individually 3 years.

Bank Analysis Provides a list of all Bank Analysis Codes held within the system. The report can show the movement on the Bank Account, for the current period and for the year to date or for all periods individually for 3 years.

Account List Lists the Opening Balance plus the Turnover, and lists the general information held for each Nominal Account.

Trial Balance The Trial Balance, Profit & Loss and the Balance Sheet reports are based on Opening Balance plus the Turnover.

If using Currency, there is an option to Revalue the Currency values. You can select the Currency and Exchange Rate to be used.

Profit and Loss See above

Balance Sheet See above

Nominal Account Detail Report Produces a simple and clear report on Nominal Ledger Accounts, with the Transactions per account and Opening and Closing balances for the Period on which you are reporting.

The report has a Simple Search facility and it is important to limit the size of the report by selecting the period you wish to report on and also limiting the range of Account Codes covered by the report.

Auditors Export File This report is required when using the following third party applications to produce formal accounts: IRIS Software from the Iris Group Ltd; ProCap software from ProAcc Systems; Viztopia software from Solution 6.

Major Headings Lists the currently defined Major Heading titles.

Categories Lists the currently defined Category Headings that you have entered.

Budget Transaction Report This report lists Nominal Accounts that have a non-zero Budget, and shows the Transactions that have been posted to them.

Stock List Lists all Stock Records stored. There are many options to expand the report from a single line to a full page per record that includes all known information.

Selecting Base Prices only enables a landscape Price List to be printed.

Stock Check List Provides an easy means of capturing physical stock take quantities.

Sub Analysis List Provides key information for each sub analysis of the records, sorted and sub totalled by Stock Record.

Levels and Availability Shows full details of physical, On Order and Free stock quantities, and provides a recommendation of any stock that requires reordering.

Valuation Offers a choice of valuation by multiplying the physical stock quantity by the latest cost price or the average cost price. Another format of the same report shows proper FIFO (First In, First Out) valuation.

Margins Provides a choice of two different margin calculations for all ten selling prices.

Serial Numbers Lists all of the Serial Numbers that have been entered into the system. You may choose to list Serial Numbers that are in stock, those that have been bought, or just those that have been sold, or all Movements.

Assemblies Details the Sub-assemblies and Components, and the Components of each Sub-assembly, and shows the availability of Assemblies based on Components available.

Price Matrix List Lists all of the special prices that are unique for each combination of customer and Stock record, (or Matrix Code).

Scheduled Orders Shows projected Stock availability for weeks and months ahead, based on the current Physical Stock, and for forward Sales and Purchase Orders, the Required By dates and Quantities.

Price List Lists the Price records, and can be enhanced to include Price, Full Details, and Notes. Note that the Price information will NOT be printed unless you select the Option Prices.

Customer List Lists all the Customers on the file. The report has options such as to include financial information, or to show full account details.

Customer Statements These are produced for every Customer/Supplier where a transaction has been entered in the current period or there is an unallocated transaction from a previous period.

The Statement can show the outstanding balance on each transaction, or a running cumulative total for transactions, and it has an Aged Analysis at the bottom.

You can select to use Home Values, Currency Values or Euro Values.

Aged Debtors This includes all Customers/Suppliers where there is a current balance on the account and shows the total Debt/Credit aged over the previous three (or four) months.

If you have the privilege of posting to future Periods, there is an extra option: Multiple Period. When this is selected, the Period menu is displayed. This enables you to select the end of the ageing period.

Debtors Letters Offers three user definable letters that can be printed for Sales transactions that are overdue for payment. The letters can include or exclude transaction detail so they can be used for promotional purposes in addition to debt collection.

Customer Balances A detailed report by Customer showing Opening Balance, Transactions and a Closing balance for the period selected.

The print selection window enables you to select the Year and Period for which you wish to produce the report. The Simple Search and Select Search options are available. These enable you to specify the search criteria that you want to use to refine this report.

Contact List Provides a comprehensive list of the contact details of all the customers.

Payments Promised Prints a list of all the due payments with the balances in Home values, Home and Currency or Currency Values. Notes and User Keys can also be included in the report.

Supplier List Lists all the Suppliers held on the file. The report also has options such as to include financial information, or to show full account details.

Project Lists all the Project Records held on file.

Project WIP Lists all the Work in Progress for Projects.

Cost Centre Lists all the Cost Centres in use within the System.

Groups Totals Cost Centres by Group levels.

Resource List Lists all Resources that have been entered.

Difference Offers a wide variety of Budget comparisons including or excluding Cost Centre information.

Scheduling Calculates and displays the latest start time for Projects and Cost Centres based on the Required By Dates and Duration you have entered. Cashflow Tabulates all of the key financial information for each Project including cash actually expended and received for each Project (and Cost Centres).

These contain details of the activity of the system.

Audit This is the only report in the Sales or Purchase Ledger that the system insists you print to printer prior to Period End.

There is an option in General Options that can be set to allow you to do a Period End without first printing the Audit Report.

Not Yet Printed This lists all the transactions that have been input since the last Not Yet Printed report, for this unit, was printed TO A PRINTER, (or which have not yet been printed as a ‘Document’). The system displays a message OK to Update for your confirmation that transactions have printed successfully so that they can be flagged as printed. This prevents them being printed twice.

Current Batch Lists just those transactions that are currently held in the Batch queue waiting to be posted. They will stay there until they have been posted using the Post Batch function.

Current Period Prints all Orders that have been entered into the System in the current period.

All Transactions Can list all live Transactions of all types, that are held on the System for all years.

You can enhance the basic report by selecting extra data, make it selective, and change the Sorting and Sub-totalling.

If you select Analysis Detail, the individual Transaction Detail lines will be printed, otherwise, only the Transaction Headers will be shown.

Fast Report Lists data from Transaction Headers in the order they were entered with no searching facility. Transaction Detail lines are not referred to, hence the report is faster than when Detail lines are involved.

Wide Report Prints live Transactions on 14" wide paper with dot matrix printers, and landscape on Postscript Laser Printers if the report is scaled down to 75%. This report includes on one line what may require more than one line when printed as 'Portrait'.

Overdue Invoices This report lists all those live Invoices which are now overdue for Payment/Receipt, i.e. their Due Date has been exceeded, and have not been Allocated.

Sales Ledger Invoices are for monies that you are owed.

Purchase Ledger Invoices are for monies that you owe!

The report shows the customer/Supplier, the Transaction Date and Period, the Due Date, and the Days Late, the Anticipated Payment/Receipt, the Reference, Gross Value and Audit Number.

Run Cash Book reports from the Reconciliation window by clicking on the Print button.

Reconciliation Report This prints a formatted report for the currently selected Nominal Account, showing:

The Opening Balance* for the current Period#

Total Receipts* for the current Period

Total Payments* for the current Period

Closing Balance* for the current Period calculated from the figures above.

Then it shows the Reconciled Balance* (i.e. the amount that has been reconciled). If negative, this indicates a Credit balance.

Below this part of the report, the following are listed:

The Unreconciled Payments

The Unreconciled Receipts

Followed by:

The calculated Balance of the Unreconciled Payments and Receipts*

The Cash Book Balance* (in this case = Closing Balance)

This is the balance of the Reconciled and Unreconciled values.

* These figures on the right of the report should match the equivalent figures on the main Cash Book window.

# This represents the last Period's Closing Balance, and will include postings to future periods.

Statement Report This prints a report showing Reconciled Transactions for a specific Statement Reference.

For this report, you should enter the details in the fields shown below:

The Statement Ref. enables you to report on specific Statements

The Opening Balance enables you to view the effect of that Statement’s Transactions on whatever figure that you enter.

Using the Subtotal menu you can select various levels of subtotalling.

Full Reconciled Audit Lists the Reconciled Transactions for the Year you have selected, and/or for the Statement Reference you enter in the field shown below:

This should match the Transactions on the Reconciliation list window with the same year selected, when Unreconcile is selected on that window.

This is useful for checking that Reconciled figure agrees with the Transactions.

Full Unreconciled Audit A similar report but for Unreconciled Transactions only. Only the Year selection menu is displayed.

This should match the Transactions on the Reconciliation list window with the same year selected, when Reconcile is selected on that window.

Displayed Transactions Lists just the Transactions currently displayed in the reconciliation list, but without any subtotalling.

Journal Reports Include all Transactions from all Ledgers; these Reports can be sorted by Date of entry or by Account Code etc.

Audit As above.

Current Batch As above.

Current Period As above.

All Transactions As above.

Fast Report As above.

Wide Report As above.

Detailed Trial Balance This is based on the Opening Balances for each Account, plus the Transactions included in the Turnover.

You can select the Account or range of Accounts that you wish to print, and the level of detail.

Suppress Other Ledgers

Calculates the value of Transactions from the Sales and Purchase Ledgers that update each Account and prints a single Detail line that summarises them. If this option is not crossed then all of the individual Sales and Purchase Detail lines are printed for each Account - this can take a long time.

This report can be printed ‘As at’ any period, for Last, Current or Next Years. Alternatively, it can be printed for:

Single Period only

This will print the report for just one period.

In this instance the System has to calculate the Period Opening Balance for each Account before it can start printing.

Voucher Reports Only includes Transactions entered directly into the Nominal Ledger, each Voucher is printed in the order it was entered.

The following options are only available for Voucher Reports :

Non-recurring Journals Prints the Journals that have not been flagged as Recurring Journals.

Recurring Journals Prints the Journals that have been flagged as Recurring Journals but excludes Reversing Journals.

Reversing Journals Prints the Recurring Journals that have been flagged as Reversing Journals but excludes Recurring Journals that have not been flagged as Reversing Journals.

Accounts that have the Exclude from Journal Reports box ticked will not be included in any of these reports.

Current Batch As above.

Current Period As above.

All Transactions As above.

Fast Report As above.

Wide Report As above.

Not Yet Printed As above.

Current Batch As above.

Current Period As above.

All Transactions As above.

Fast Report As above.

Wide Report As above.

Outstanding Orders This report lists outstanding Sales and Purchase Orders for Stock items.

Optional data may be added to the report, and the normal Searching, Sorting and Sub-totalling options are available.

Variance Report This report shows the difference between the Delivered value and the Invoiced value on Purchase Orders. It is only available if the System option Update Stock to Nominal has been selected. The report will enable you to reconcile Stock valuations to Balance Sheet Accounts

Confirmations This report and POP Order Documents can be produced in a variety of formats so that the report can be used for a range of different functions.

The basic report shows the quantity ordered on each line of the Order without any other detail.

Show Outstanding to Deliver - Will add an extra line of information to each detail line of the order, showing the quantity that remains to be delivered.

Show Outstanding to Invoice - Will add another detail line showing the quantity that remains to be invoiced.

Show Values - Will print the value of each detail line, if this option is used in conjunction with the two Show Outstanding... options then the System will display a value outstanding to be delivered and/or invoiced.

Notes - Will display the free format text entered on each detail line (the text held for Price Records and Text only entries, is always printed).

The search options for Confirmations defaults to printing just those orders that have not yet had a Document printed. This makes it extremely easy to make sure you print a Document for every Order without accidentally printing duplicates.

The Not Yet Printed menu displays a list of options. Choosing any of the options other than the Not Yet Printed will activate the Simple Search button.

Orders

Not Yet Printed As above.

Current Batch As above.

Current Period As above.

All Orders As above.

Pro Forma Prints details of Orders that are awaiting processing in the Pro Forma batch.

The list may show both Pro Forma and Progress Claims.

Estimate Prints details of Orders that are awaiting processing in the Estimate (or Quote) batch.

Profit Prints the profit element of Orders in total, or for each detail line.

Fast Report This reports on the Profit figures stored in the Stock, Price or Customer records. It just shows the Profit and the Margin %. There are no other options.

A Menu allows you to choose whether to report on Stock, Price or Customer Records.

Transactional The System will compare the Actual Sales Price for each Order (or if Analysis Detail is selected, each Detail line), to the Cost Price selected below.

The Latest Cost menu enables you to select whether to use FIFO, Latest Cost, or Average Cost.

Profit on Serialised Stock items is always calculated at Actual Purchase price, while for other Stock items you may select to have Profit calculated from Transaction Cost, FIFO, Average Cost, Latest Cost, or Comparable Price Line.

The Profit will only be calculated on Order lines for Stock and Price Records, as the cost for Text items is unknown and therefore income from these lines is ignored.

You may choose the basis for the Profit calculation between:

Order Value Which may include Orders which have not yet been Invoiced.

Invoice Value Which will only include Orders that have been Invoiced.

You can also enhance the report with:

Analysis Detail This will add the Transaction Detail Lines.

Full Details This will add all available detail.

Full Descriptions Includes the full Descriptions held.

Notes Includes the Notes fields.

Adjustment Selecting this report will immediately display the print destination selection window - there are no other options. This report shows the Sales and Cost Values, the actual Profit and the Margin for Orders, and then for the amounts on those Orders actually Invoiced and Delivered. The following fields are printed on the report :

Mail Order Schedule - prints receipts that have been processed using the Mail Order unit. The report is sorted and sub-totalled by the Bank Account selected for each Receipt. The bank accounts should represent different credit cards, therefore it is necessary to have a separate Analysis Code for each credit card company to facilitate the administration as well as to determine the Nominal Accounts to which they will post. The report helps to identify money that should be received from, and commissions that will be charged by, the credit card companies.

Order Documents You can select different formats of Order report.

One of the options replicates the format of the Purchase Orders, that can be printed as Orders are being entered and saved.

Other options provide status reports with details of outstanding quantities to be Received or Invoiced.

Not Yet Printed As above.

Current Batch As above.

Current Period As above.

All Orders As above.

Authorisation report This report is similar to the Current Batch report, except that it only shows Purchase Orders or Goods Returned Notes (Credit Notes) that have been Authorised or that need to be Authorised. Using the Simple Search, you can select whether or not to include Authorised, Unauthorised and/or Rejected Orders.

Cash Flow Forecast This reports the overall incoming and outgoing cash flow of your company.

Forecast Cash In Provides forecast analysis for incoming cash.

Overdue Sales Invoices Lists all those live invoices which are now overdue for payments because their Due Date has been exceeded.

Debt Status Provides a list of Due and Overdue debt statuses for different customers.

Bad Debts Written Off Lists all the written off bad debts.

Bad Debt Reversals Provides a report of all the bad debt reversals.

Not Yet Printed As above.

Current Batch As above.

Current Period As above.

All Transactions As above, except that you can select whether to print All Transactions, or all Sales Transactions, or all Cost Transactions.

Fast Report As above.

Wide Report As above..

Various reports are available from the System control functions. Normally these will only be produced by/for the System Administrator. They are mentioned in the System Control section of this manual, but this summary is included here to help you find what is available.

The reports are described under the System Control menu headings.

Snapshot

Chase Overdue Invoices list

Cash Flow Forecast Cash Flow forecast, as from the Cash Flow unit.

Changes Report Details of any new records or changes to existing records, analysed by User ID.

VAT Return This is the official VAT return.

EC Reports

VAT Return Audit This report has two Audit formats. Summary Audit (wide) which shows the boxes on the VAT Return that are updated by each Transaction and Detailed Audit (wide) which shows Country Codes, VAT Codes, Intrastat EC VAT values, Exchange Rates and Currency values.

EC Sales List This is a Report required in a special format by HMRC from all UK Companies selling more than a set value per annum to foreign EU States. This report prints one line of information for each Customer consolidating all of their Invoices together.

EC Sales List Audit This is an Audit Report to show the Detail behind the EU Sales List.

Intrastat (aggregated) This report has two formats. Dispatches, a Report required in a special format by HMRC from all UK Companies where Sales exceed a set value per annum to foreign EU States. Arrivals, is a similar Report based on Purchases from foreign EU States where Purchases exceed a set value per annum.

Intrastat CSV File (aggregated) Intrastat output in CSV file format

Intrastat Audit Audit trail for the Intrastat aggregation

Intrastat EDI File (aggregated) Intrastat output in EDIFACT file format based on Official HMRC specifications

Rate Maintenance Listing of Rates

Reports

Country Report This lists the details set up for each Country.

Trading Currencies Report This lists the Trading Currencies, and you should normally select the option:

Currency Rates, and then select Rate Detail

User Record Listing of Users

System Options - Sub Ledger Listing of the current Sub Ledger details.

Aged Debt/Creditors Update and Listing of the Aged Debt or Credit situation.

Automatic Reports A wide variety of standard reports can be printed (and updated where necessary) from this function.