If EODFromDayOne_1_0 is set to 1, then the opening balance is used as the EOD balance from the 1st of month 1 of the analysis, and the closing balance is used for the EOD balance to the last day of the final month of the analysis. #All #Transactionsummary
If BouncedFlagEOD_1_0 is set to 1, transactions within the ‘bounced’ tab are removed from the EOD balances for the day in which they occur.
If BouncedFlagTO_1_0 is set to 1, transactions within the ‘bounced’ tab are removed from the debits and credits total and count summary area for the month in which they occur. In addition, transactions within the ‘bounced’ tab are removed from the debits and credits proportions (1st half and 2nd half) summary area for the month in whic
If ExclusionFlagEOD_1_0 is set to 1 and ExclusionFlagEOD_type is set to ‘normal’, excluded transactions are removed from all EOD balances on or after the date of the excluded transaction.
If ExclusionFlagEOD_1_0 is set to 1 and ExclusionFlagEOD_type is set to ‘exists’, all transactions are removed from the EOD balance for the date of any excluded transaction.
If ExclusionFlagTO_1_0 is set to 1, transactions within the ‘excluded’ tab are removed from the debits and credits
When analysing transactions from an Excel document, you can select multiple input Excel files from the file browser window (where each file is located within the same folder); these files are then separated as separate accounts during the analysis process and are placed into Transactions1/2/3 tabs, as required, depending on the number of input Excel files that were selected. #All #Transactionsummary
Certain words can be located within the narrative (separate from the other analysis features such as categories) and the existence of any of these words can be flagged to the user within the summary tab. This feature is enabled by selecting the ‘identify missing words’ checkbox. The specified words can be found as separate words or as part of other words, as required, by selecting the ‘find as separate words’ checkbox. #All #Transactionsummary #Features
‘Rolling average’ is defined as the 3 month rolling average of daily total activity (credits+debits), this generates 3 (‘X') values for each month (where that month is in order number 1, number 2, number 3 of each rolling average calculation)
‘Distance to rolling average’ is defined as the difference between one day's total activity (credits+debits) and the ‘rolling average’, which uses the largest difference (when the daily total is compared to each ‘X’ value from above).
Bounced transactions can be identified in a similar way to other categories, i.e. as receipts, payments or both that contain the specified keywords in the narrative. In addition, bounced transactions can be identified as being reversed within  days and a difference of up to [CURRENCY100] where [neither, one or both] of these is in [Cash] category. Also, transactions can be listed from the 'fee' category (must exist) within [E] days and with a value less than [CURRENCY100]
All options set from the Options -> Analysis options window will be used as default the next time the user runs an analysis. In the ‘General’ area you can set whether the analysis options opens for the user just before the analysis runs; these changes are applied to that analysis only. I suggest that you set the options to include most generic categories that you will need, and turn on the option to tweak this before an analysis is generated; also you can use analysis profi
First, click Options -> Analysis options, then select the ‘categories’ area. Here you can see all categories and, when one is selected, the other settings that have been configured (including the keywords, whether the category is output as a separate tab in Excel, and also whether the transactions matching the keywords are restricted to receipts/payments/both). Additionally, you can set the order of priority incase more than one category matches against a single transaction
Yes, analysis profiles can be selected, created, changed and deleted from the Options -> Analysis options window. The dropdown box shows available analysis profiles that can be selected. Use the File menu to manage your profiles; read only analysis profiles can also be configured, contact us for more information. #Transactionsummary #All
Each bank summary shows the month on month trend percentages for total amounts, debits and credits. Months are highlighted in this section if the total monthly credit change exceeds a set percentage. This percentage can be set by changing the named value ‘CreditsMonthlyChangePercentage’ within Excel (Formulas -> Name manager); this should be set between 0 and 100 (e.g. 10% would be set as the value 10). The default value is 30, for 30%. #Transactionsummary #All
Yes, to do this the user must click ‘New bank analysis’ from the File menu within StatementReader and configure the ‘Data structure’ section of the analysis options; this includes setting the column mapping (e.g. for the date, description, amount and balance columns) and browsing for the Excel file containing the transactions. #Transactionsummary #Features #All
Other options available are: - Show options window to user before the analysis is processed for temporary changes to be made (e.g. add account specific keywords [See ‘General’ within the analysis options window] -Once completed, automatically save the analysis output to a specified directory [See ‘General’ within the analysis options window] #Transactionsummary #Features #All
Yes, see the ‘general’ section of the analysis options to control whether the user can make temporary changes to the analysis parameters (e.g. add account specific keywords) at ‘runtime’. #Features #Transactionsummary #All
Categories can be identified as receipts, payments or both that contain user defined keywords (either as a whole or part of a word); the transactions matching this rule and the specified keywords can be displayed in a separate tab. If the keywords for more than one category are found in a single transaction narrative, then the order of priority from the ‘Categories’ are of the options window will be applied. #Transactionsummary #All
The user can decide to ignore the transactions identified on the ‘Excluded’ tab by changing the named value ‘ExclusionFlag_1_0’ within Excel (Formulas -> Name manager); this accepts 0 or 1 (0 to ignore, 1 to add back excluded payments and deduct excluded receipts). #Transactionsummary #All
Yes, see the ‘General’ section of the analysis options to configure this feature. This allows for sorting at bank template, page and transaction level. Also, once the transactions are in ascending order, missing balance figures can also be completed (again, see the ‘General’ section). #Features #Transactionsummary #All