Just enter the prompt "Create a table from the following bank statement information:". Then copy and paste the statement information from the PDF file.You can open the file in Excel using the built in filter then use the "Save As" option to convert the file to an Excel file. Enter in the month, year, and previous balance and the rest will automatically YEAR ENDING BALANCE TOTAL WITHDRAWLS statement calculate. Statements of Information, Common Interest Development Statements and Publicly Traded Disclosure Statements can be filed online at bizfileOnline.sos.ca.gov. We have a free template you can download and use. This post will show you why you may need a bank statement template and what it should include. A, B, C. 1, La Paz County. Download a free Account Statement Template for Microsoft® Excel®, OpenOffice. A: Use spreadsheet software like Excel or Google Sheets.