Whereas balance sheet includes the upper portion of trial balance and gives a good deal of information. Build out our statement structure in Excel. Accounting Cycle Steps Flow Chart Example How To Use Explanation Accounting Cycle Accounting Accounting Course Export the relevant data from our system and get it to Excel. . A particular from a subsidiary book into ledger omitted to post For example a purchase of 500 from Anthony omitted to be. The Trial Balance Mapping Process. Trial balance is prepared. In terms of mapping our Trial Balance to the financial statements we can follow this overall guideline. Trial balance includes the closing balances of all the general ledger accounts. We can use any structured source data to prepare a mapping table for any report.