Differences

This shows you the differences between two versions of the page.

--- financial_statements [2022/11/27 15:13] – created, 2022 income statement sr.gray
+++ financial_statements [2023/01/24 14:36] (current) – Updated to include transactions through 23 Jan 2023 sr.gray
@@ Line 6: / Line 6: @@
 Sunbeam City reserves the right to modify & update these statements as data & comprehension of IFRS and accounting principles improve.
-===== 2022 Income Statement (Draft) =====
+We would like to apologize in advance to those utilizing a screen reader. Tables were used in the construction of these sheets and we understand they are not particularly accessible. Please contact [[https://sunbeam.city/@srgray|@srgray@sunbeam.city]] if you know of a better way to present this financial data while still adhering to GAAP requirements.
-|         As of 26 November 2022         ||||
+Also see [[2022 Financial Statements|2022 Financial Statements]]
+===== 2023 Income Statement (Draft) =====
+|         As of 23 January 2023         ||||
 | | | | |
-|Revenues | | | |
+^Revenues | | | |
-| |Monthly Membership Revenue|    €171.00| |
+| |Monthly Membership Revenue|    €19.00| |
-| |Annual Membership Revenue|    €216.00| |
+| |Annual Membership Revenue|    €60.00| |
-| |One-Time Donation Revenue|    __€10.00__|    €397.00|
+| |One-Time Donation Revenue|    __€0.00__|    €79.00|
-|Variable Expenses | | | |
+^Variable Expenses | | | |
-| |Payment Processor Expenses|    €31.35| |
+| |Stripe Processor Expenses|    €4.46| |
-| |Open Collective Host Expenses|    __€23.82__|    __€55.17__|
+| |Paypal Processor Expenses|    €0.00| |
-|Gross Income| | |    €341.83|
+| |Uncategorized Processor Expenses|    €0.00| |
+| |Open Collective Host Expenses|    __€4.74__|    __€9.20__|
+^Gross Income| | |    €69.80|
 | | | | |
-|Fixed Expenses | | | |
+^Fixed Expenses | | | |
-| |Discourse Server Expenses|    €71.90| |
+| |Discourse Server Expenses|    €0.00| |
-| |Server Expenses|    __€226.36__|    __€298.26__|
+| |Server Expenses|    __€0.00__|    __€0.00__|
-|EBIT (Operating Income)| | |    €43.57|
+^EBIT (Operating Income)| | |    €69.80|
 | | | | |
 |Interest| | |    __€0.00__|
-|IBT| | |    €43.57|
+^IBT| | |    €69.80|
 | | | | |
 |Taxes| | |    __€0.00__|
-|Net Income| | |    €43.57|
+^Net Income| | |    €69.80|
+===== 2023 Annual Cash Flow (Draft) =====
+|    January 1, 2023 - January 23, 2023    |||
+| |||
+| ^  2023  ^  2022  |
+^Cash from Operating|||
+|Donations|    €79.00|    €491.19|
+|Expenses|    __€9.20__|    __€177.13__|
+|Net Cash Flow from Operating|    €69.80|    €314.06|
+| |||
+^Cash Balance |||
+|Previous Period|    €960.32|    €646.26|
+|Increase (Decrease)|    __€69.80__|    __€314.06__|
+|Ending Balance|    €1030.12|    €960.32|
+Note: For 2022, Payment Processing Expenses are excluded from operating cash revenues & expenses, as they are deducted automatically before funds are added to the OpenCollective Account. These values are included in 2023 and an update to 2022's values will be implemented before the end of the 1st quarter.
+===== 2023 Monthly Cash Flow (Draft) =====
-===== 2022 Monthly & Annual Cash Flow (Draft) =====
+|    1 January 2023 - December 31, 2023    |||||||||||||
+| |||||||||||||
+| | ^  Jan  ^  Feb  ^  Mar  ^  Apr  ^  May  ^  Jun  ^  Jul  ^  Aug  ^  Sep  ^  Oct  ^  Nov  ^ Dec |
+^Cash from Operating||||||||||||||
+|Donations| |    €79.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|
+|Expenses| |    __€9.20__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|
+|Net Cash Flow from Operating| |    €69.80|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|
+| ||||||||||||||
+^Cash Balance ||||||||||||||
+|Previous Period| |    €960.32|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|
+|Increase (Decrease)| |    __€69.80__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|    __€0.00__|
+|Ending Balance| |    €1030.12|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|    €0.00|
-Coming soon
-===== 2022 Balance Sheet (Draft) =====
+===== 2023 Balance Sheet (Draft) =====
+|    As of 23 January 2023    |||||
+| |||||
+|OpenCollective Cash|    €1030.12| |Accounts Payable|    €154.41|
+|Accounts Receivable|    €0.00| |Deferred Taxes|    __€0.00__|
+|Inventories|    __€0.00__| |Total Current Liabilities|    €154.41|
+|Total Current Assets|    €1027.65| | | |
+| | | |Long Term Debt|    €0.00|
+|Property, Plant, and Equipment|    __€0.00__| | | |
+| | | |SBC Equity|    €805.91|
+| | | |2023 Retained Earnings|    __€69.80__|
+| | | |Total Equity|    __€875.71__|
+| |||||
+^Total Assets|    €1030.12| ^Liabilities & Equity|    €1030.12|
-Coming soon
+[[2022 Financial Statements|2022 Financial Statements]]