Transcription of Financial Reporting Using Microsoft Excel
{{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 .
2014 SedonaOffice Users Conference Financial Reporting Using Excel Marco Island, Florida Presented By: Jim Lee Page 12 of 34 To create the new Data Source: 1) Name the data source appropriately 2) Select ‘SQL Server’ as the driver to connect to the database 3) Press the Connect button a.
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}