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