Transcription of Financial Reporting Using Microsoft Excel - Bold Group
{{id}} {{{paragraph}}}
Financial Reporting Using Microsoft Excel Presented By: Jim Lee 2014 SedonaOffice Users Conference Financial Reporting Using Excel Marco Island, Florida Presented By: Jim Lee Page 2 of 34 Table of Contents Financial Reporting Overview .. 4 Reporting 4 Microsoft Excel .. 4 SedonaOffice General Ledger Structure .. 5 Invoice Example .. 5 General Ledger Account Code .. 6 Branch Code .. 6 Category Code .. 7 Fiscal Year .. 7 Monthly Period .. 7 GL Mask .. 7 Extracting the GL Data from SedonaOffice to Excel .. 8 The GL Summary Table .. 8 GL Summary Update 8 Importing the SedonaOffice GL Data into Excel .
Microsoft Excel All the reports as reviewed within this guide are created using Microsoft Excel. For purposes of this guide Microsoft Excel 2007 has been used. Excel 2007 or higher is highly recommended as it has expanded capabilities to handle over one million rows of data.
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}