Historical profit and loss

From MediaWiki

(Difference between revisions)
Jump to: navigation, search
(Added hierarchical roll-ups)
Line 1: Line 1:
{{more statistics for|{{CURRENTYEAR}}|profit and loss}}{{note|This report is in development, and data shown on this page may be missing, poorly organized, inaccurate, or flat-out wrong.}}
{{more statistics for|{{CURRENTYEAR}}|profit and loss}}{{note|This report is in development, and data shown on this page may be missing, poorly organized, inaccurate, or flat-out wrong.}}
{{#tag:mysql|
{{#tag:mysql|
-
ITH RECURSIVE xfers AS (
+
WITH RECURSIVE xfers AS (
   SELECT Source AS account,
   SELECT Source AS account,
         0 AS TYPE,
         0 AS TYPE,
Line 23: Line 23:
   LEFT JOIN xfers x ON x.account = acc.ID
   LEFT JOIN xfers x ON x.account = acc.ID
--  WHERE acc.Report = "BS"
--  WHERE acc.Report = "BS"
-
--  WHERE acc.Report = "PL"
+
  WHERE acc.Report = "PL"
   GROUP BY acc.ID
   GROUP BY acc.ID
),
),

Revision as of 06:25, 12 May 2020

Contents

This report is in development, and data shown on this page may be missing, poorly organized, inaccurate, or flat-out wrong.

AccountSuperNameDebitsCreditsNet
4000000Product Income-528581.9714584.48-513997.49
40100004000000Education-53569.616311.52-47258.09
40100014010000Seminar-406.700.00-406.70
40100024010000Event-6110.984654.82-1456.16
40100034010000International Student-42114.9356.70-42058.23
40200004000000Agri-tourism-3447.480.78-3446.70
40300004000000Market Garden-47503.4574.45-47429.00
40400004000000Propagation-17515.93146.81-17369.12
40400024040000Seeds-83.520.00-83.52
40500004000000Dairy-33810.9257.99-33752.93
40500014050000Goats-4738.6050.00-4688.60
40500024050000Hay-351.000.00-351.00
40599994050000Test Income source-10.100.00-10.10
40600004000000Eggs-6481.50288.92-6192.58
40700004000000Fruiticulture-3405.550.00-3405.55
40900004000000Value Added-64609.160.00-64609.16
41000004000000Medicinal Herbs-1646.040.00-1646.04
41100004000000Capital Projects-300.00170.00-130.00
41200004000000Rent-254966.765739.97-249226.79
41200194120000Board Received, Yellow House-340.000.00-340.00
41200734000000Camping-40.008.90-31.10
41201184120000White House-149503.604500.00-145003.60
41201354120000Other-30602.00256.00-30346.00
41201454120000Yellow House-55692.06983.97-54708.09
41300004000000Body Care-40860.821785.14-39075.68
5000000Product Expense-1075.18112913.78111838.60
50100005000000Education-27.667064.957037.29
50100015010000Seminar0.00185.00185.00
50100035010000International Student-27.662191.812164.15
50200005000000Agri-tourism0.00230.00230.00
50300005000000Market Garden-35.00809.98774.98
50400005000000Propagation7.3113855.0113862.32
50400015040000Soil Inputs20.002575.292595.29
50400025040000Seeds0.004732.344732.34
50500005000000Dairy24.9222597.5722622.49
50500015050000Goats0.00111.29111.29
50500025050000Goat Feed-47.8711790.1811742.31
50599995050000Test Expense destination0.001.011.01
50600005000000Eggs1036.0015428.6016464.60
50600015060000Chicken Feed1036.0013151.5714187.57
50700005000000Fruiticulture0.001331.271331.27
50800005000000Energy Production0.00486.39486.39
50800015080000Bio Fuels0.006.586.58
50900005000000Value Added-167.6922111.9521944.26
50900015090000Ingredients-206.6612215.1412008.48
50900025090000Packaging-41.034453.294412.26
51000005000000Medicinal Herbs0.001975.151975.15
51100005000000Capital Projects0.00317.95317.95
51200005000000Rent-881.8012697.4911815.69
51201185120000White House0.002499.382499.38
51201355120000Other0.001064.901064.90
51201455120000Yellow House-881.802020.891139.09
51300005000000Body Care-1031.2614007.4712976.21
6000000Operating Expense-33135.51436248.09403112.58
60100006000000Marketing-226.656455.216228.56
60200006000000Outreach and Recruiting0.0011211.3411211.34
61000006000000Travel-207.9734243.8234035.85
62000006000000Bank Charges-638.311034.95396.64
62000016200000Currency Exchange-519.1715.26-503.91
62500006000000Errors and Exceptions-20349.7213034.97-7314.75
63000006000000Volunteer-329.1686123.9785794.81
63000016300000Volunteer Groceries-1015.7566460.2265444.47
63000026300000Volunteer Lodging349.882498.942848.82
63000036300000Volunteer Gifts80.00710.59790.59
63000046300000Volunteer Stipend-100.002110.162010.16
63000056300000Volunteer Meals468.0512916.0913384.14
64000006000000Employee0.0016621.1816621.18
64000016400000Wages0.0016176.9216176.92
64000026400000Commissions0.00350.51350.51
64000036400000Vacation Pay0.0093.7593.75
66500006000000Insurance-185.0063671.6163486.61
66500016650000Volunteer Medical-35.002878.842843.84
67000006000000Interest-6930.79135397.95128467.16
67100006700000Mortgage Interest0.00119096.39119096.39
67400156000000Accumulated Depreciation, Equipment-1409.420.00-1409.42
67500006000000Professional Fees86.0012117.9212203.92
67501326750000Legal: Pither Suit0.006698.946698.94
67510006000000Dues-Subscriptions-Publications-105.082069.461964.38
68000006000000Business Licenses and Permits190.006971.507161.50
68500006000000Maintenance-809.0033755.6132946.61
68500016850000Water System Maintenance-107.002657.452550.45
68500026850000Tools-Non-Capital0.00100.95100.95
68500036850000Small components-165.523491.473325.95
68500856850000Maintenance, Vehicle0.001175.021175.02
68501186850000Maintenance, White House0.00157.36157.36
68501456850000Maintenance, Yellow House0.00575.63575.63
69000006000000Miscellaneous-1753.784219.192465.41
69000516900000Member/Investor Services0.0042.4442.44
69500006000000Office-466.639059.418592.78
7000000Other Expense-19790.5377551.9057761.37
71100007000000Capital Projects0.0013046.3913046.39
71500007000000Postage-Freight-Shipping-20.301094.551074.25
73500007000000Supplies-28.352230.372202.02
75000007000000Utilities-19741.8861180.5941438.71
75100007500000Telephone0.004411.384411.38
75200007500000Internet0.003506.523506.52
75300007500000Hydro-19710.2347291.8027581.57
75301187530000White House-15888.3922829.896941.50
75301357530000Other0.0049.8849.88
75301457530000Yellow House-522.7718468.0017945.23
75400007500000Heat0.00811.95811.95
75500007500000Dump & garbage0.00380.20380.20
75600007500000Fuel: farm & vehicle-31.653621.403589.75
79110017110000Land Acquisition0.0012638.6412638.64
8000000Other Income-35715.84-53209.45-88925.29
80100008000000Member Dues-10175.001100.00-9075.00
80100028010000Steinman, Jan-2850.00550.00-2300.00
80100038010000Rowe, Cleome-1150.00550.00-600.00
80100048010000Wagner, Carol-1550.000.00-1550.00
80100058010000Cowan, Shannon-900.000.00-900.00
80100068010000Cowan, James-900.000.00-900.00
80100758010000Perry, Adam-75.000.00-75.00
80101248010000Roller, Justin-300.000.00-300.00
80101258010000Roller, Osha-300.000.00-300.00
80101378010000Pobiecke, Penny-300.000.00-300.00
80101388010000Stiffler, Mark-300.000.00-300.00
80101488010000Bartsch, Susie Anne-75.000.00-75.00
80101648010000Lamrock, Morris-75.000.00-75.00
80101658010000Siegers, Rudy-1400.000.00-1400.00
80200008000000Grants-21885.000.00-21885.00
80300008000000Donations-2619.93100.00-2519.93
80400008000000Work Trade0.00646.00646.00
80500008000000Interest-1015.912608.671592.76
80500018050000Rebates and Cash Back-989.310.00-989.31
80600008000000Miscellaneous0.0087.7587.75
89000008000000Retained Earnings0.00-57751.87-57751.87

See Also

Share your opinion


blog comments powered by Disqus
Personal tools
Get our newsletter!
Name:
Email Address:

disturbance
entry points
help (off site)
Environmental jobs, green volunteering, good work! Powered by the wind! This server and other
EcoReality operations
are 100% wind powered.
Powered by Mac OS X Powered by Mac MediaWiki Powered by MariaDB Powered by Valentina Studio Pro