Open topic with navigation

Transactional management reports

To help you to monitor your business performance, you can use the transactional management reports to produce a balance sheet, profit and loss or trial balance that meets your exact requirements. You can run reports for specific departments to see how they are performing and you can also monitor trading progress for any date range.

This added flexibility gives you much greater control over the information you produce, making it easier for you to make decisions that are vital to your business.

The following transactional-based reports are available in Modules > Financials > Reports:

• Transactional balance sheet
• Transactional profit and loss
• Transactional trial balance

How transactional management reports calculate values

Transactional management reports look similar to period based management reports. The difference is in the way that the figures are calculated. Period based reports use monthly ranges, for example, you could run the profit and loss report from month 1 to 3, or month 4 to 7.

You can run the transactional reports for any date range. The figures are generated from the audit trail and transactions are grouped into the following areas:

• Brought forward
• Current period
• Year to date

There are two ways of obtaining these figures:

To use the date to determine your figures, when running your report set the following criteria:

1. Clear the Group by Tran Number check box.

   Note: The Transactional Trial Balance does not display a Group by Tran Number check box and you should proceed to step 2.

2. Transaction date > enter the date range you require.
   
   

To use the transaction number to determine your figures, when running your report set the following criteria:

1. Select the Group by Tran Number check box.

   Note: The Transactional Trial Balance does not display Group by Tran Number or First Transaction of the Year criteria and you should proceed to step 3.

2. First Transaction of the Year > enter your first transaction number of the current financial year.

   Tip: Any transaction numbers lower than this value are treated as brought forward figures.

3. Transaction number > enter the transaction numbers for the current range.

   Tip: From the values you enter here, the current period and year-to-date figures are generated.

Note: If you select the Group by Tran Number check box, date ranges have no effect on the report figures. The transaction numbers determine the figures that are generated.