|
Starting the program
On the Main Menu, click the Transactions tab then click
Transaction Analyser - BS408
In this section:
About the Program
This is the main reporting program in the Bank Genie system.
The program allows you to analyse your data with great flexibility.
You can produce detailed and summarised listings based on selectable parameters.
Having isolated a set of data to your specifications, you can produce hard copy reports or output to data files in other file formats.
You can also create Stored Reports - making it easy to run similar reports at a later date.
Using the Program
The Transaction Analyser program (BS408) has two tabs,
Transactions for this Selection and Selection Screen.
When you start the program, the Transactions for this Selection tab is selected and all transactions which you have entered (using BS421) for the current year are listed
The data shown by the program
The Transaction Analyser program displays individual elements of transactions.
Thus if a transaction has been created with three elements, each element will be listed individually.
This is necessary to allow analysis by Category and/or Tab, since in the example, each element may have a different Category or Tab.
Note: In contrast, the program
Manage Transactions - BS421 displays transaction summary
Controls on the Selection Screen tab
When you click on this tab, you can use the controls to manipulate the display of transactions in a number of ways
- Date Range and Date Range buttons
Use the two date pickers to change the From Date and To Date
Click on one of the Quick Date Navigation buttons.
There are 12 Quick Date Navigation buttons which you can configure to your exact requirements.
Tax Year buttons (the <TYR and TYR> buttons)
Financial Year buttons (the <YR and YR> buttons)
Financial Quarter buttons (the <Q and Q> buttons)
Month buttons (the <Mo and Mo> buttons)
Pay period buttons (the <P and P> buttons)
Equal increment buttons (the < and > buttons)
- Bank Groups
Click the Selection Screen tab
Notice the popup on the top left.
This pop-up is filled with Bank Groups which are specified using the program Bank Groups - BS415.
Bank Groups are optional.
When you click
on this popup and select a Bank Group, the Bank Selection list will display ONLY the banks in that Bank Group.
The main purpose of creating Bank Groups is to make it very
quick and easy to analyse your transactions here in BS408.
- Bank selection list
Click the Selection Screen tab
Notice the list on the left with the title Bank Selection List
Select All
Banks, Bank Groups, One Bank or any random selection of Bank Accounts (i.e. you can multi-select Bank Accounts).
You can add new Bank Accounts using the program My Bank Accounts - BS403
Click once on a line to select a Bank Account for analysis.
The Bank Account then appears in the Banks Selected
list, and three stars (***) appear at the end of the line to signify that the Bank Account is selected.
Click once on the line to De-select, in a toggle action.
Click on the "GO" button when you are ready to analyse transactions for your selection.
- Category Groups
Click the Selection Screen tab
Notice the popup on the top right.
This pop-up is filled with Category Groups which are specified using the program Category Groups - BS416
Category Groups are optional
When you click on this popup and select a Category Group, the Categories List will display ONLY the Categories in that Category Group.
- Categories List
Click the Selection Screen tab
The Categories List
contains the Categories you defined (or can define) using program My Categories - BS420
Click once on a line to select a Category for analysis.
The Category appears in the Categories Selected list, and three stars (***) appear at the end of the line to signify that the Category is selected.
Click once on the line to De-select, in a toggle action.
Click on the "GO" button when you are ready to analyse transactions for your selection.
- Tags
Click the Selection Screen tab
Notice the list box on the lower right with the title Tags Selected.
This control will list the tags you define in BS421
- The "Include" and "Exclude" radio buttons
These buttons relate to the codes already selected and
displayed in the "Categories Selected" list.
The default setting is "Include".
First, select one or more Categories to analyse.
Leave the setting at Include to analyse all transactions which have been linked to the selected Categories.
Change the setting to Exclude
to omit transactions which have been linked to the selected Categories in your results.
Example 1
The most common application of the "Exclude"
button is to exclude transactions which have been coded to "TRANSFER" since they are not true expenditure.
Editing and deleting transactions
Double Click on a line to edit a transaction.
The transaction is displayed in the familiar Screen BS421S03. You can change any aspect of the transaction. You can also Delete the transaction if necessary.
If activated, Security and Date protected account settings apply when editing or deleting.
Cheque Dates / Bank Dates Radio button
These buttons relate to the To and From dates
Best explained by example
You have a cheque, written on 31st Dec 2005 (This is the Cheque date)
In your Bank Statement, the cheque showed up as 2nd Jan 2006 (This is the Bank Date)
If you
a) key in a From date= 1st Jan 2006 and a To Date= 5th Jan 2006
and
b) click the "Cheque dates" radio button:
Result: The above cheque will NOT show up in the listing.
If you
a) keep the dates at the same settings
and
b) click the "Bank dates" radio button:
Result: The above cheque WILL show up in the listing.
Thus, you will get a different total when you change the radio button settings.
The Net worth program uses Bank Dates in its calculations. If you use that program, it is
important to keep your Bank Dates accurate.
The layout in this display now shows both Cheque Date and Bank date to help you do that.
You can double click on transactions
and make corrections in this program, making it quite easy to correct any date errors, and to make corrections to Categories.
Display Order
You can display the transactions selected above in numerous ways.
Click on the Display Order popup at the bottom right of the screen to reveal the options.
Printing
The Print button is located bottom right of the initial screen BS408S01
Having made your selection of data using the controls described above, use the Print button for a hard copy print.
Output to file
Having made your selection of data using the controls described above, RIGHT-CLICK on a transaction in the listing.
A shortcut menu appears with options to allow you to:
Export as Excel file
Export as Text file
Stored Reports
This feature allows you to save the settings used to generate a report for future use.
Help Balloons
When you first start the program, Help Balloons will be ON.
Read more about Help Balloons
|
