Excel as a Reporting Tool- not a new idea… but a good one

Microsoft Excel is becoming one of the most popular reporting tools.  Sage 300 uses Microsoft Excel with it Intelligence Reporting module to create financial statements and pivot table for sales, purchasing and inventory reporting.

Using Excel for creating financial statements is very flexible.  Users can select many different types of reports.  Examples are rolling twelve months, or rolling four quarters, or quarterly except for the current quarter use monthly.  Since the reports are in Excel, you have the full capability of the spreadsheet to make any additional calculations.  You may want to show Gross Profit Percentage, or maybe marketing expense as a percent of total revenue.  Whatever numbers that are meaningful are available when using Excel for financial reporting.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *