I need to create a 2011 monthly balance sheet and cash flow statement using FRx. I have my 2011 P&L created (in excel). I have not closed 2010 so I understand that will be a challenge. Any input is apprecited.
*This post is locked for comments

I need to create a 2011 monthly balance sheet and cash flow statement using FRx. I have my 2011 P&L created (in excel). I have not closed 2010 so I understand that will be a challenge. Any input is apprecited.
*This post is locked for comments
You'll need a column in your balance sheet for 2010 YTD totals, a column for each month's YTD activity in 2011 to sum with the 2010 YTD figures and a total column to sum the two for each month you haven't closed 2010. You should be able to derive your cash flow from the balance sheet.
Hope this helps,