Format CSV files in Excel to get bank transactions into QuickBooks ; connecting your bank and credit card accounts to QuickBooks, you can upload them manually. 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). Just enter the prompt "Create a table from the following bank statement information:". Then copy and paste the statement information from the PDF file. The first thing you will need to do is label all fields in the rows and columns. These should correlate with the fields on your bank statement. You can create a spreadsheet with separate tabs for each bank account and simply copy and paste into Batch Create and maintain all your banking transactions. This bank reconciliation statement template shows you how to calculate the adjusted cash balance using the bank statement and a company's accounting record.