Can Excel data be incorporated into the analysis of scanned bank statements?
Yes, to do this the user must configure the ‘Data structure’ section of the analysis options when the job is being processed; this includes setting the column mapping (e.g. for the date, description, amount and balance columns) and browsing for the Excel file containing the additional data.
Recent Posts
See AllRevisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo