{$page} 



Explanation of SQL 



This SQL (Report) can be used to pull the Balance Sheet for any period in an easy-to-export format.



>> Note: **The Retained Earnings balance is not pulled into this report**. The retained earnings amount calculation is shown in a separate SQL below, but is not included as a row in the report



Sample Export 



|| RowID || FormattedName || Balance ||
|| 1 || Assets || NULL ||
|| 2 || > Undeposited Funds || NULL ||
|| 1 || >> Undeposited Cash & Checks ||
|| 1 || >> Undeposited AmEx || 800.00 ||
|| 1 || >> Undeposited Visa_MC || 1024.00 ||
|| 1 || > Inventory Assets || NULL ||
Risk of Data Corruption if Run Improperly 

**None**. This is a selection query and no data is modified in the running of it.



SQL 



[[code_formatsql]]



DECLARE @GLDate datetime;



DECLARE @ShowZero bit;



DECLARE @ShowInactive bit;



--SET @GLDate        ;



--SET @ShowZero      ;



--SET @ShowInActive  ;



SET @GLDate        '12/31/2009 23:59';



SET @ShowZero      1;



SET @ShowInactive  0;



DECLARE @Spacing int;



SET @Spacing  4;



SELECT *



FROM



(



    SELECT



      ROW_NUMBER() OVER(ORDER BY FormattedPath) as Row,



      GLTree.FormattedName,



      coalesce((select sum(Amount) from GL where GL.GLAccountID  GLTree.NodeID and EntryDateTime