Just enter the prompt "Create a table from the following bank statement information:". Then copy and paste the statement information from the PDF file.Are you looking for a bank statement Excel template? Download this free template and start tracking your business transactions. Download a free Account Statement Template for Microsoft® Excel®, OpenOffice. Statements can be printed and posted, or emailed to the customer. When emailing the document, you can use the Excel template of this form (download below). In this blog, we'll show you how to automatically categorize bank transactions in Excel using our template which you can download here. I'm going to show you how to create this incredible customer statements complete with dynamic day range. Open a new or existing Excel workbook.