Populating daily cash sheet from statement

Question

I have multiple bank statements that I need to pull the detail from and place into a daily cash sheet.

The bank statements come in various formats (I only attached one for display)

I receive the bank statements daily, but could have them sent MTD if that is easier to configure.

I need to pull the data in by date and account

Sample output:

Cash Sheet report scenario.xlsx

mbarone · Answer

What have you tried so far?  What does your input configuration look like?  Have you looked at any of the preparation tools (Filter, formula, etc.)?  Have you watched any of the instructional lessons in the Academy ?