Knowledge base

1 min

How can I change the date of the opening and closing balance?

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

1 min

What do the summary graphs show?

The graphs displayed in the summary tab show the total monthly amounts (split by debits and credits) and the monthly balance mid-points (highest-lowest/2). #All #Transactionsummary

1 min

How do bounced transactions affect other analysis areas?

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

1 min

How do excluded transactions affect other analysis areas?

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

1 min

How do I analyse transactions for multiple bank accounts together?

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

1 min

How do I identify missing words from the transaction narrative?

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

1 min

What does the rolling average section of the analysis show?

‘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).

1 min

How are bounced transactions identified?

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 [2] 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]

1 min

How do I set up the analysis options and switch between profiles?

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

1 min

Step by step guide to categorising transactions automatically with StatementReader

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

1 min

Can I save the analysis options to a profile?

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

1 min

How do I change the minimum percentage for identifying month on month credit trends?

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

1 min

Can Excel transactional data be analysed in Excel without data from scanned bank statements?

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

1 min

What other settings are available for advanced configuration of the transaction summary?

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

1 min

What is available in the summary tab (for each account, where multiple accounts are analysed)?

- weighted average - month on month change - category totals (including transactions specified on the ‘additional income’ tab) - fortnightly turnover analysis - monthly balance analysis - monthly category analysis #Transactionsummary #Features #All

1 min

Can I change the analysis options before the analysis is processed?

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

1 min

How are categories identified by StatementReader?

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

1 min

What rules are used to define the reference number?

The reference number is compiled of the first number with more than 3 consecutive digits from the transaction narrative. #Transactionsummary #All

1 min

How do I remove or include the excluded transactions from the balance and turnover figures in Excel?

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

1 min

Can the transactions be sorted in ascending order?

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