Financial Statement

by Ivan Radenkovic

ENVIRONMENT

Microsoft Excel
Microsoft Word

Working as senior financial analyst I had to create financial statements for auditing purposes. I’ve decided to import accounting balances from company’s ERP into excel file and to add two language support. There were lots of text description related to tables figures so I’ve realized Excel itself wont be enough to support this - that part is ideal to be done in Word so there it is. Final point will be MS Word document, and Accounting Ledger imported in Excel as starting point (This starting point could be move yet ahead - in a way that Excel could be linked directly to accounting ledger view on accounting SQL server but it assume close cooperation between finance and it department within company and it’s not so portable to other system without basic knowledge of SQL querying and administrating). Here come word document screen shot for better understanding: