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 [2022/12/08 14:16] – Updated to include all transactions through 7 December 2022 sr.gray
@@ Line 5: / Line 5: @@
 Sunbeam City reserves the right to modify & update these statements as data & comprehension of IFRS and accounting principles improve.
+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.
 ===== 2022 Income Statement (Draft) =====
-|         As of 26 November 2022         ||||
+|         As of 7 December 2022         ||||
 | | | | |
-|Revenues | | | |
+^Revenues | | | |
-| |Monthly Membership Revenue|    €171.00| |
+| |Monthly Membership Revenue|    €189.00| |
-| |Annual Membership Revenue|    €216.00| |
+| |Annual Membership Revenue|    €255.00| |
-| |One-Time Donation Revenue|    __€10.00__|    €397.00|
+| |One-Time Donation Revenue|    __€10.00__|    €454.00|
-|Variable Expenses | | | |
+^Variable Expenses | | | |
-| |Payment Processor Expenses|    €31.35| |
+| |Stripe Processor Expenses|    €26.41| |
-| |Open Collective Host Expenses|    __€23.82__|    __€55.17__|
+| |Paypal Processor Expenses|    €3.85| |
-|Gross Income| | |    €341.83|
+| |Uncategorized Processor Expenses|    €5.69| |
+| |Open Collective Host Expenses|    __€27.24__|    __€63.19__|
+^Gross Income| | |    €390.81|
 | | | | |
-|Fixed Expenses | | | |
+^Fixed Expenses | | | |
 | |Discourse Server Expenses|    €71.90| |
 | |Server Expenses|    __€226.36__|    __€298.26__|
-|EBIT (Operating Income)| | |    €43.57|
+^EBIT (Operating Income)| | |    €92.55|
 | | | | |
 |Interest| | |    __€0.00__|
-|IBT| | |    €43.57|
+^IBT| | |    €92.55|
 | | | | |
 |Taxes| | |    __€0.00__|
-|Net Income| | |    €43.57|
+^Net Income| | |    €92.55|
-===== 2022 Monthly & Annual Cash Flow (Draft) =====
+===== 2022 Annual Cash Flow (Draft) =====
-Coming soon
+|    January 1, 2022 - December 7, 2022    |||
+| |||
+| | ^  2022  |
+^Cash from Operating|||
+|Donations| |    €419.59|
+|Expenses| |    __€172.63__|
+|Net Cash Flow from Operating| |    €246.96|
+| |||
+^Cash Balance |||
+|Previous Period| |    €646.26|
+|Increase (Decrease)| |    __€246.96__|
+|Ending Balance| |    €893.22|
-===== 2022 Balance Sheet (Draft) =====
+Note: Payment Processing Expenses are excluded from operating cash revenues & expenses, as they are deducted automatically before funds are added to the OpenCollective Account.
+===== 2022 Monthly Cash Flow (Draft) =====
+|    January 2022 - December 7, 2022    |||||||||||||
+| |||||||||||||
+| | ^  Jan  ^  Feb  ^  Mar  ^  Apr  ^  May  ^  Jun  ^  Jul  ^  Aug  ^  Sep  ^  Oct  ^  Nov  ^ Dec |
+^Cash from Operating||||||||||||||
+|Donations| |    €12.10|    €66.23|    €24.22|    €44.64|    €14.04|    €15.98|    €15.98|    €15.98|    €15.98|    €14.04|    €130.31|    €50.09|
+|Expenses| |    __€0.84__|    __€4.20__|    __€1.62__|    __€2.82__|    __€146.35__|    __€1.08__|    __€1.08__|    __€1.08__|    __€1.08__|    __€0.96__|    __€8.28__|    __€3.24__|
+|Net Cash Flow from Operating| |    €11.26|    €62.03|    €22.60|    €41.82|    (€132.31)|    €14.90|    €14.90|    €14.90|    €14.90|    €13.08|    €122.03|    €46.85|
+| ||||||||||||||
+^Cash Balance ||||||||||||||
+|Previous Period| |    €646.26|    €657.52|    €719.55|    €742.15|    €783.97|    €651.66|    €666.56|    €681.46|    €696.36|    €711.26|    €724.34|    €846.37|
+|Increase (Decrease)| |    __€11.26__|    __€62.03__|    __€22.60__|    __€41.82__|    __(€132.31)__|    __€14.90__|    __€14.90__|    __€14.90__|    __€14.90__|    __€13.08__|    __€122.03__|    __€46.85__|
+|Ending Balance| |    €657.52|    €719.55|    €742.15|    €783.97|    €651.66|    €666.56|    €681.46|    €696.36|    €711.26|    €724.34|    €846.37|    €893.22|
+Note: Payment Processing Expenses are excluded from operating cash revenues & expenses, as they are deducted automatically before funds are added to the OpenCollective Account.
+===== 2022 Balance Sheet (Draft) =====
-Coming soon
+|    As of 7 December 2022    |||||
+| |||||
+|OpenCollective Cash|    €893.22| |Accounts Payable|    €154.41|
+|Accounts Receivable|    €0.00| |Deferred Taxes|    __€0.00__|
+|Inventories|    __€0.00__| |Total Current Liabilities|    €154.41|
+|Total Current Assets|    €893.22| | | |
+| | | |Long Term Debt|    €0.00|
+|Property, Plant, and Equipment|    __€0.00__| | | |
+| | | |SBC Equity|    €646.26|
+| | | |2022 Retained Earnings|    __€92.55__|
+| | | |Total Equity|    __€738.81__|
+| |||||
+^Total Assets|    €893.22| ^Liabilities & Equity|    €893.22|