Bank Statement PDF to Excel Spreadsheet【银行账单PDF格式转Excel格式】
Excel for Bank Recon
-Use AI to convert PDF statement into Table
-Copy the table into Excel
-Edit the table content
-Save and rename with details for document storage
Prompt:
Read this bank statement pdf, and convert ALL the data dated from first transaction to last transaction into one table.
Show this in markdown table format, without using a code box.
Transaction ascending order according to date.
Ignore Balance,
A withdrawal will result in negative in amount; while the deposits will be positive in amount.
I want to convert this table into my set of field and arrange into table where I can copy into excel spreadsheets.
Do not show instruction just table
With field according to:
Date (MM-DD-YY):
Journal:
Partner Name:
Amount:
Currency:
Amount Currency:
Label:
Bank Account:
There are no comments for now.
Share This Content
Share Link
Share on Social Media
Share by Email
Please login to share this Video by email.