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]
The Barclays branch print out format can be extracted using StatementReader although the structure changes depending on the branch that printed it, therefore you will most likely need a new template for your document (even if you have processed similar bank statements before). To obtain the new template you can either create your own (using the File -> New bank layout feature), or request that we create one for you (again using the option from the File menu; we aim to return
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
Selecting the correct template allows StatementReader to extract the transactions from your bank statement accurately. To help with the selection process you should use the template name and the thumbnail image provided; for some templates a full page sample is also available. These can be accessed by right-clicking on the template (from the left side on the main StatementReader window) and selecting ‘view full page sample’. This will then open the image in your default im
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
Initial setup of StatementReader - Download and install the application from here. - Run the application and register your email address. - Click Help -> Example job, to verify the installation. You should see an example bank statement, and then the transactions in Excel. Using your trial account credit - Click Credit -> Join company credit from within StatementReader and enter the code provided by the StatementReader team - Click the button provided to validate the code. T
We recommend that you use these scanner settings to optimise documents for OCR accuracy: Main ’Scan settings’: Original Type -> Text Resolution -> Super fine (400x400 DPI) Scan size -> Auto File type -> Multi-page TIFF Color -> Full color Application -> Frame erase -> Yes Other ’Scan settings’: Quality adjustment -> Background removal -> Bleed removal -> Auto Quality adjustment -> Background removal -> Paper discolouration adj. -> Auto Other settings (not referenced in manual
We recommend that you use these scanner settings to optimise documents for OCR accuracy: Application -> Scan to Folder Scanning -> Image quality -> Best (300DPI colour) Scanning -> Color mode -> Color Scanning -> Image rotation -> Automatic File option -> File format -> PDF File option -> Deselect OCR options Paper -> Paper size -> Automatic detection Compression -> Compression rate low Reference: http://condoroffice.co.uk/manuals/iradv22xx/contents/1T0001827258.html #Scannin
We recommend that you use these scanner settings to optimise documents for OCR accuracy: File format - PDF or multi-page TIF (the latter may not be possible) Colour - Full colour or black and white for TIFF (the latter may be the only option for TIF images) Original type - Text Resolution - 300DPI Scanning size -> Automatic detection Image rotation -> Automatic File option -> Deselect OCR options when creating a PDF document Compression -> Low #Scanning #All
We recommend that you use these scanner settings to optimise documents for OCR accuracy: Main ’Scan settings’: Original Type -> Text Resolution -> 300DPI Scan size -> Auto File type -> Multi-page TIFF Color -> Full color Application -> Frame erase -> Yes Other ’Scan settings’: Quality adjustment -> Background removal -> Bleed removal -> Auto Quality adjustment -> Background removal -> Paper discolouration adj. -> Auto Other settings (not referenced in manual): Compression - N
We recommend that you use these scanner settings to optimise documents for OCR accuracy: Quality Density (Format type): Multi-page TIFF Compression: None or LZW (lossless) Default Content: Text Color: Grayscale Original Size: Auto Resolution: 300DPI Other: Deskew and background removal #Scanning #All