Converting Corporate Bank Statements to Financial Statements: A last-resort, spreadsheet-based method

The purpose of this document is to illustrate a spreadsheet-based method to assist in compiling financial statements from corporate bank account data. Use of this method may be appropriate in cases where a corporation has fallen behind on its accounting responsibilities; is undergoing a corporate tax or trust exam audit with lost, incomplete or erroneous records; or when an inactive corporation has few transactions in a reporting period and requires financial statements in short order.