Microsoft Dynamics GP Excel Refreshable Reports Profit & Loss Statement

If all you need is a very simple P&L Statement, Excel Refreshable Reports will do the trick. The only part that is a bit weird is that Expenses will show as a negative and Income as a positive OR Credits show as a negative and Debits show as a positive. You decide.

This video works with my blog posting for a GL Trial Balance using Excel Refreshable Reports:

GL Summary Trial with Excel Refreshable Reports

I’m not saying is always the best tool to use for financial statements, but if you know it…

http://www.youtube.com/watch?v=Wa1qFFJKefE&feature=player_embedded