Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
balance_sheet_sql_report [2019/01/30 15:59] kcifreo |
balance_sheet_sql_report [2019/01/30 16:00] kcifreo [Explanation of SQL] |
||
---|---|---|---|
Line 3: | Line 3: | ||
This SQL (Report) can be used to pull the Balance Sheet for any period in an easy-to-export format. | 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 ===== | ===== Sample Export ===== | ||
|RowID||FormattedName||Balance|| | |RowID||FormattedName||Balance|| | ||
|1||Assets||NULL|| | |1||Assets||NULL|| | ||
- | |2||> Undeposited Funds||NULL|| | + | |2||Undeposited Funds||NULL|| |
- | |1||>> | + | |1||Undeposited Cash & Checks|| | | |
- | |1||>> | + | |1||Undeposited AmEx||800.00|| |
- | |1||>> | + | |1||Undeposited Visa_MC||1024.00|| |
- | |1||> Inventory Assets||NULL|| | + | |1||Inventory Assets||NULL|| |
+ | |||
+ | \\ | ||
===== Risk of Data Corruption if Run Improperly ===== | ===== Risk of Data Corruption if Run Improperly ===== |