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 to extract transactions from Barclays bank statements that have been printed by a branch

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

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 see a full page sample for bank templates?

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

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 to install and setup StatementReader

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

1 min

What are the recommended scanner settings for a Konica Minolta Bizhub 36 scanner?

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

1 min

What are the recommended scanner settings for a Canon C2225i scanner?

We recommend that you use these scanner settings to optimise documents for OCR accuracy: Resolution: 300DPI Default Content: Text #Scanning #All

1 min

What are the recommended scanner settings for a Fujitsu Document Scanner ScanSnap iX500 scanner?

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

1 min

What are the recommended scanner settings for a Canon C7570i scanner?

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

1 min

What are the recommended scanner settings for a Konica Minolta Bizhub 423 scanner?

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

1 min

What are the recommended general scanner settings?

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