In this video, I'll guide you through multiple steps to create an account statement in Excel. Just enter the prompt "Create a table from the following bank statement information:".Then copy and paste the statement information from the PDF file. 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. Log in at file.dos.pa. Gov and search for your company name under "Business Search. Accounts and fill in the top of the blank ledger forms for each account. As you select the accounts that your Municipality needs, remember to include Other. Download a free Account Statement Template for Microsoft® Excel®, OpenOffice.