Profit & Loss Report Deal with Redundant P&L links - Screen BS410S06
To display this screen: In screen BS410S01, click the Show button The Show button becomes
visible only when there are redundant transactions
In this section:
About Redundant links
Redundant links are caused when you
change the selection criteria of a P&L report.
Example 1 You may have initially created a P&L report by selecting Bank A, Bank B and Bank C. You may then
have used the Analyse button and the features in the screen it leads to (BS401) to link the selection of transactions to P&L groups. If you then change the selection of
Banks to Bank A and Bank B, then the linked transactions belonging to Bank C are left in limbo - here described as Redundant.
Since this change could be done
accidentally, Bank Genie does not automatically unlink redundant records - in all the examples described.
Example 2 A similar result occurs when you change your
selection criteria by deselecting a Category of transactions which are linked to a P&L report. The linked transactions belonging to the deselected Category are rendered
Redundant.
Example 3 A similar result occurs when you change your selection criteria by deselecting a Tag of transactions which are linked to a P&L
report. The linked transactions belonging to the deselected Tag are rendered Redundant.
In this screen (BS410S06) you can view the redundant records and make
decisions about how to handle them. If they are caused by a criteria selection error, you can examine (Edit/View) individual transactions, and identify the cause. If
they are unwanted, they can be unlinked using the tools available in this screen.
Note that there could be a number of redundant record types - e.g. in an extreme case,
caused by each of the cases described in Examples 1, 2 and 3 above. Transactions of any one record type are shown under a brief in-line header giving a brief indication of
the record type Click on any header or any transactioon, then click the Help button. The program will show more information which is specific to the record type selected
(clicked), how the redundant records may have been caused, and describe the options on how to deal with them.
Tip: You should always use the Save Settings button
after making a selection of Banks, Categories and Tags to extract the transactions for a P&L report. Bank Genie will automatically restore the settings next time you
select that report, possibly eliminating Redundant Links problems
Targeted help is available for each type of Redundant transaction. Click on a line showing a Redundant transaction, and try again
Redundant records- Related to your BANKS selection Cause: The
Bank for these transactions does exist. However, the Bank has NOT been selected in the Banks Selection screen in BS410S01
Solutions: Observe the names of the
Banks in the list of transactions
- If you do not wish to include transactions from this Bank in your P&L report, then click the Unlink button
- Change the selection criteria - Select the missing Bank(s) in screen BS410S01
YOU MAY CLICK THE UNLINK BUTTON TO UNLINK THE LIST OF TRANSACTION ELEMENTS FROM THE REPORT, THUS ELIMINATING THE PROBLEM
Redundant Transactions Related to your Categories selection These transaction elements are linked to
a Category which is not linked to a P&L Group for this P&L Year.
Possible cause: You may have linked the wrong element of a transaction to a P&L
Group
Solution (in order of most likely reason for the redundant record): Either
- Click the "Edit Link" button to examine the details.
1a) Has the transaction more that one element (split)? If yes, have you linked the correct element to
a P&L Group?
1b) Check the Category used by the transaction element. Has the Category been selected in the initial screen of this program?
1c) Is the
Category known to be one of the Categories associated with the P&L Groups for this P&L year? (as defined using the program P&L Years and Groups-BS409) If
no, unlink the transaction element from the P&L Group
- Use the program P&L Years and Groups-BS409 to add the Category used by this transaction to a P&L Group for this P&L year.
IN ALL CASES, YOU MAY CLICK THE UNLINK BUTTON TO UNLINK THE LIST OF TRANSACTION ELEMENTS FROM THE REPORT, THUS ELIMINATING THE PROBLEM
Redundant records- Related to your TAGS selection These transaction elements may have been made
redundant for a variety of reasons:
Possible cause: Having linked transactions to P&L Groups, you have subsequently changed your selection criteria in the
initial screen of this program (BS410S01).
Case a) You may NOT have had any Tags selected in your initial stages. You may have selected a new Tag(s) which has
reduced the number of transactions for inclusion in your P&L report. This would cause a number of transactions to be excluded from your P&L report. This list of
transactions do not match the current Tag selection, and are redundant.
Case b) You HAD more than one Tag selected in your initial stages. You may have changed the
Selection criteria in the initial screen (BS410S01) by deselecting one or more Tags, yet leaving one or more Tags in the selected status. Transactions linked to the Tag
you deselected were once part of this P&L report. Once a Tag is deselected, any transactions that do not match the selection criteria of the remaining Tags will be
excluded. This list of transactions do not match the new Tag selection, and are redundant.
Solution (in order of most likely reason for the redundant
record): Click the "Edit Link" button to examine the details. a) Check the Tag used by the transaction element. If it is linked to a Tag, has the Tag been
selected in the initial screen of this program?
b) If the transaction element has NOT been linked to a Tag, and you have selected a Tag in the initial screen of this
program, then it will not match the new selection criteria. It will be made redundant by exclusion from the transaction listing making up the P&L report.
c) Has the
transaction more that one element (split)? If yes, have you linked the correct element to a P&L Group?
IN ALL CASES, YOU MAY CLICK THE UNLINK BUTTON TO UNLINK
THE LIST OF TRANSACTION ELEMENTS FROM THE REPORT, THUS ELIMINATING THE PROBLEM
Screens (leading to screenshots) for program BS410
- Screen BS410S01 - The initial screen
- Screen BS410S02 - Working with Marginal transactions
- Screen BS410S03 - Manually linking Transactions to P&L Groups
- Screen BS410S04 - Configuring the P&L report
- Screen BS410S05 - Analyse and auto-link transactions
- Screen BS410S06 - Deal with Redundant P&L Links - THIS PAGE
|