Template:Monthly expenses for

From MediaWiki

Jump to: navigation, search

Usage

This template is used to display expenses information for a given year and month.

Parameters

  1. the year and month in "YYYY-MM" format.

Example

as entered 
{{monthly expenses for|2011-08}}
as displayed 

Contents


Expenses are in the process of being moved into MariaDB from QuickBooks. Data shown here may not be accurate.

Click on the arrows in any column header to sort by that column.

Vehicle Expenses

Note: vehicle expenses are not included in other tables below.

by Profit Centre

IDProfit centreAmount%FromTo
11Capital Projects$38.7213.0%2011-08-122011-08-30
5Dairy$88.2029.7%2011-08-102011-08-27
6Eggs$7.482.5%2011-08-012011-08-01
8Energy$3.961.3%2011-08-262011-08-26
3Market Garden$3.851.3%2011-08-302011-08-30
0Overhead$154.5852.1%2011-08-022011-08-31
0TOTAL:$296.79100.0%2011-08-012011-08-31

by Vehicle

IDVehicleAmount%FromTo
1Blue Jetta$144.7648.8%2011-08-012011-08-31
5Bubba$27.399.2%2011-08-062011-08-30
3Sunshine$124.6442.0%2011-08-022011-08-30

by Driver

IDDriverAmount%FromTo
4Carol Wagner$94.0531.7%2011-08-012011-08-30
2Jan Steinman$202.7468.3%2011-08-022011-08-31

by Project

IDProjectAmount%FromTo
126Commercial propagation greenhouse$38.7213.0%2011-08-122011-08-30
63Dairy$88.2029.7%2011-08-102011-08-27
23Heating$3.961.3%2011-08-262011-08-26
45Market garden$3.851.3%2011-08-302011-08-30
18Poultry Production$7.482.5%2011-08-012011-08-01
85Vehicle Management$11.003.7%2011-08-312011-08-31
157Vending$133.6445.0%2011-08-022011-08-30
19Visitor/Volunteer Services$3.521.2%2011-08-202011-08-20
130Water system maintenance$6.422.2%2011-08-062011-08-06

by Profit centre

Profit centre#Total%FromTo
Dairy21$-1,687.002011-08-02 00:00:002011-08-30 00:00:00
Education5$-350.502011-08-02 00:00:002011-08-16 00:00:00
Market Garden18$-4,210.382011-08-02 00:00:002011-08-30 00:00:00
Overhead26$-21,202.742011-08-01 00:00:002011-08-31 00:00:00
Rental1$-200.002011-08-05 00:00:002011-08-05 00:00:00
Transplant Propagation1$-23.212011-08-16 00:00:002011-08-16 00:00:00
TOTAL:72$-27,673.832011-08-01 00:00:002011-08-31 00:00:00

by Project

IDProject#Total%FromTo
97Administration7$-11,047.112011-08-02 00:00:002011-08-31 00:00:00
127Cheese workshop3$-239.602011-08-02 00:00:002011-08-16 00:00:00
10Computing Environment1$-199.692011-08-04 00:00:002011-08-04 00:00:00
63Dairy21$-1,687.002011-08-02 00:00:002011-08-30 00:00:00
49Education2$-110.902011-08-02 00:00:002011-08-02 00:00:00
5Grounds Maintenance1$-8.962011-08-02 00:00:002011-08-02 00:00:00
43Land Acquisition6$-8,350.142011-08-01 00:00:002011-08-19 00:00:00
89Leashold Maintenance1$-2.792011-08-16 00:00:002011-08-16 00:00:00
45Market garden18$-4,210.382011-08-02 00:00:002011-08-30 00:00:00
51Member Services5$-717.452011-08-02 00:00:002011-08-19 00:00:00
136Necessary changes in involvement in EcoReality2$-638.852011-08-12 00:00:002011-08-15 00:00:00
135Rental1$-200.002011-08-05 00:00:002011-08-05 00:00:00
141Transplant Propagation1$-23.212011-08-16 00:00:002011-08-16 00:00:00
157Vending1$-8.502011-08-23 00:00:002011-08-23 00:00:00
130Water system maintenance2$-229.252011-08-02 00:00:002011-08-02 00:00:00

by Source

Source#Total%FromTo
Assets, Current Assets, PayPal1$-199.692011-08-04 00:00:002011-08-04 00:00:00
Assets, Current Assets, ISCU Chequing18$-4,414.512011-08-01 00:00:002011-08-23 00:00:00
Assets, Current Assets, ISCU Restricted Funds1$-11,000.002011-08-25 00:00:002011-08-25 00:00:00
Assets, Current Assets, CCEC3$-3,148.282011-08-01 00:00:002011-08-02 00:00:00
Assets, Receivables, Shareholder Loans, Pither, Ron5$-2,503.582011-08-12 00:00:002011-08-15 00:00:00
Liabilities, Payables, Steinman, Jan1$-1,652.902011-08-19 00:00:002011-08-19 00:00:00
Liabilities, Payables, Wagner, Carol1$-1,652.902011-08-19 00:00:002011-08-19 00:00:00
Equity, Shareholder, Class D18$-1,470.002011-08-02 00:00:002011-08-30 00:00:00
Product Income, Education, Seminar4$-200.502011-08-02 00:00:002011-08-16 00:00:00
Product Income, Market Garden7$-757.672011-08-02 00:00:002011-08-30 00:00:00
Product Income, Dairy1$-38.002011-08-19 00:00:002011-08-19 00:00:00
Product Income, Dairy, Hay3$-217.002011-08-02 00:00:002011-08-15 00:00:00
Product Income, Rent, Other1$-200.002011-08-05 00:00:002011-08-05 00:00:00
Operating Expense, Errors and Exceptions1$-1.202011-08-12 00:00:002011-08-12 00:00:00
Operating Expense, Interest3$-2.632011-08-31 00:00:002011-08-31 00:00:00
Operating Expense, Miscellaneous1$-39.972011-08-02 00:00:002011-08-02 00:00:00
Other Income, Member Dues, Steinman, Jan1$-75.002011-08-02 00:00:002011-08-02 00:00:00
Other Income, Member Dues, Wagner, Carol1$-75.002011-08-02 00:00:002011-08-02 00:00:00
Other Income, Member Dues, Siegers, Rudy1$-25.002011-08-05 00:00:002011-08-05 00:00:00

by Destination

Destination#Total%FromTo
Assets, Current Assets, ISCU Chequing43$-17,904.022011-08-02 00:00:002011-08-31 00:00:00
Assets, Current Assets, ISCU Restricted Funds2$-2.602011-08-31 00:00:002011-08-31 00:00:00
Assets, Current Assets, CCEC1$-1,896.062011-08-01 00:00:002011-08-01 00:00:00
Liabilities, Payables, Wagner, Carol3$-189.972011-08-02 00:00:002011-08-02 00:00:00
Liabilities, CCEC Mortgage1$-643.842011-08-01 00:00:002011-08-01 00:00:00
Liabilities, Taxes Accrued, Taxes, GST/HST1$-2.792011-08-16 00:00:002011-08-16 00:00:00
Product Expense, Education1$-150.002011-08-02 00:00:002011-08-02 00:00:00
Operating Expense, Marketing3$-157.902011-08-02 00:00:002011-08-23 00:00:00
Operating Expense, Volunteer, Volunteer Groceries1$-504.452011-08-19 00:00:002011-08-19 00:00:00
Operating Expense, Volunteer, Volunteer Lodging4$-1,382.502011-08-15 00:00:002011-08-19 00:00:00
Operating Expense, Volunteer, Volunteer Gifts1$-18.002011-08-19 00:00:002011-08-19 00:00:00
Operating Expense, Volunteer, Volunteer Meals4$-2,052.532011-08-02 00:00:002011-08-19 00:00:00
Operating Expense, Interest, Mortgage Interest2$-2,504.442011-08-01 00:00:002011-08-02 00:00:00
Operating Expense, Maintenance, Water System Maintenance3$-252.462011-08-02 00:00:002011-08-16 00:00:00
Operating Expense, Miscellaneous1$-8.962011-08-02 00:00:002011-08-02 00:00:00
Other Expense, Postage-Freight-Shipping1$-3.312011-08-02 00:00:002011-08-02 00:00:00

by Buyer

IDBuyer#Amount%FromTo
4Carol Wagner15$-5,866.992011-08-02 00:00:002011-08-19 00:00:00
272Claire Ryder1$-50.002011-08-23 00:00:002011-08-23 00:00:00
1EcoReality Co-op8$-4,564.302011-08-01 00:00:002011-08-15 00:00:00
266Frances Carere2$-89.602011-08-16 00:00:002011-08-16 00:00:00
2Jan Steinman4$-256.712011-08-02 00:00:002011-08-23 00:00:00
228Kent Shaw1$-200.002011-08-05 00:00:002011-08-05 00:00:00
262Laurent Dubois2$-50.002011-08-05 00:00:002011-08-19 00:00:00
248Linda Evans1$-100.002011-08-02 00:00:002011-08-02 00:00:00
252Nader Nazi1$-50.002011-08-12 00:00:002011-08-12 00:00:00
200Natalia Mainprize1$-150.002011-08-19 00:00:002011-08-19 00:00:00
261Neil Mark1$-50.002011-08-02 00:00:002011-08-02 00:00:00
255Nina Raginsky1$-50.002011-08-12 00:00:002011-08-12 00:00:00
207Rachel Hughes1$-100.002011-08-23 00:00:002011-08-23 00:00:00
132Ron Pither5$-2,981.352011-08-12 00:00:002011-08-15 00:00:00
254Rosemary Partridge1$-50.002011-08-05 00:00:002011-08-05 00:00:00
165Rudy Siegers2$-225.002011-08-05 00:00:002011-08-05 00:00:00
269Sarah Walsh1$-200.002011-08-23 00:00:002011-08-23 00:00:00
216Sofya Raginsky1$-150.002011-08-02 00:00:002011-08-02 00:00:00
229Susan Charlet1$-100.002011-08-02 00:00:002011-08-02 00:00:00
251Teresa Hitch3$-98.002011-08-12 00:00:002011-08-30 00:00:00
0Undefined User19$-12,291.882011-08-02 00:00:002011-08-31 00:00:00

by Seller

Seller#Total%FromTo
(not in system)31$-18,317.382011-08-01 00:00:002011-08-31 00:00:00
Brian Paterson1$-100.002011-08-02 00:00:002011-08-02 00:00:00
CCEC Credit Union1$-643.842011-08-01 00:00:002011-08-01 00:00:00
EcoReality Co-op20$-7,180.432011-08-02 00:00:002011-08-31 00:00:00
Jan Steinman11$-549.602011-08-02 00:00:002011-08-30 00:00:00
Leonie Muldoon1$-10.002011-08-05 00:00:002011-08-05 00:00:00
Ron Pither3$-662.182011-08-12 00:00:002011-08-15 00:00:00
Slegg Building Materials, Limited3$-160.402011-08-12 00:00:002011-08-16 00:00:00
Undefined User1$-50.002011-08-12 00:00:002011-08-12 00:00:00

by Payment Type

CodeType#Total%FromTo
3Cash28$-2,508.502011-08-02 00:00:002011-08-30 00:00:00
4Cheque34$-8,660.892011-08-02 00:00:002011-08-30 00:00:00
11Xfer10$-16,504.442011-08-01 00:00:002011-08-31 00:00:00

by Day of Week

Day#Amount%FromTo
Tuesday31$-3,614.342011-08-02 00:00:002011-08-30 00:00:00
Thursday2$-11,199.692011-08-04 00:00:002011-08-25 00:00:00
Wednesday3$-2.632011-08-31 00:00:002011-08-31 00:00:00
Monday11$-7,314.122011-08-01 00:00:002011-08-15 00:00:00
Friday25$-5,543.052011-08-05 00:00:002011-08-19 00:00:00

by Date

Date#Total%
1, Monday3$-3,792.12
2, Tuesday20$-2,974.84
4, Thursday1$-199.69
5, Friday7$-598.50
12, Friday8$-516.10
15, Monday8$-3,522.00
16, Tuesday4$-115.60
19, Friday10$-4,428.45
23, Tuesday5$-453.20
25, Thursday1$-11,000.00
30, Tuesday2$-70.70
31, Wednesday3$-2.63

Records

1 to 0 of 0
DateTypeSourceDestinationProfit centreProjectBuyerSellerQuantityUnitItemAmountTotalNote
2011-08-01 00:00:0011ISCU ChequingCCECOverheadLand AcquisitionEcoReality Co-opCCEC1.000eachmortgage payment$-1,896.06$-1,896.06
2011-08-01 00:00:0011CCECMortgage InterestOverheadLand AcquisitionEcoReality Co-opCCEC1.000eachmortgage interest$-1,252.22$-3,148.28
2011-08-01 00:00:0011CCECCCEC MortgageOverheadLand AcquisitionEcoReality Co-opCCEC Credit Union1.000eachon principle$-643.84$-3,792.12
2011-08-02 00:00:004ISCU ChequingMarketingMarket GardenMarket gardenCarol WagnerCarol Wagner1.000eachBooth fee$-15.00$-3,807.12Booth fee
2011-08-02 00:00:004ISCU ChequingVolunteer MealsMarket GardenMarket gardenCarol WagnerEcoReality Co-op1.000eachFood for farm labourers$-100.03$-3,907.15Food for farm labourers
2011-08-02 00:00:004CCECMortgage InterestOverheadLand AcquisitionCarol WagnerCCEC1.000eachMortgage payment$-1,252.22$-5,159.37Mortgage payment
2011-08-02 00:00:003Market GardenISCU ChequingMarket GardenMarket gardenUndefined UserCash1.000eachmarket produce$-243.20$-5,402.57
2011-08-02 00:00:003HayISCU ChequingDairyDairyUndefined UserCash1.000eachhay$-172.00$-5,574.57
2011-08-02 00:00:003Class DISCU ChequingDairyDairyEcoReality Co-opBrian Paterson1.000eachClass D Shares 2011-07-30$-100.00$-5,674.57
2011-08-02 00:00:003Class DISCU ChequingDairyDairyLinda EvansJan Steinman1.000eachClass D Shares 2011-07-30$-100.00$-5,774.57
2011-08-02 00:00:003Class DISCU ChequingDairyDairyNeil MarkJan Steinman1.000eachClass D Shares 2011-07-30$-50.00$-5,824.57
2011-08-02 00:00:004Class DISCU ChequingDairyDairySofya RaginskyEcoReality Co-op1.000eachClass D Shares$-150.00$-5,974.57
2011-08-02 00:00:004Class DISCU ChequingDairyDairySusan CharletJan Steinman1.000eachClass D Shares$-100.00$-6,074.57
2011-08-02 00:00:004SeminarISCU ChequingEducationEducationUndefined UserParticipants1.000eachCheese class$-77.30$-6,151.87
2011-08-02 00:00:004SeminarISCU ChequingEducationEducationUndefined UserParticipants1.000eachGST on cheese class$-33.60$-6,185.47
2011-08-02 00:00:004MiscellaneousWagner, CarolOverheadAdministrationCarol WagnerCarol Wagner1.000eachPaypal withdrawal error$-39.97$-6,225.44
2011-08-02 00:00:004ISCU ChequingWater System MaintenanceOverheadWater system maintenanceCarol WagnerCarol Wagner1.000eachWell Maintenance$-73.27$-6,298.71
2011-08-02 00:00:004ISCU ChequingPostage-Freight-ShippingOverheadAdministrationCarol WagnerCarol Wagner1.000eachpostage$-3.31$-6,302.02
2011-08-02 00:00:004ISCU ChequingMiscellaneousOverheadGrounds MaintenanceCarol WagnerCarol Wagner1.000eachGarbage$-8.96$-6,310.98
2011-08-02 00:00:004Wagner, CarolWagner, CarolOverheadMember ServicesCarol WagnerCarol Wagner3.000eachdues: 7/5 dep - post for Oct - Dec 2011$-75.00$-6,385.98
2011-08-02 00:00:004ISCU ChequingWater System MaintenanceOverheadWater system maintenanceCarol WagnerCarol Wagner1.000eachPump parts$-155.98$-6,541.96
2011-08-02 00:00:004ISCU ChequingEducationEducationCheese workshopJan SteinmanJan Steinman1.000each2 cheese classes$-150.00$-6,691.96
2011-08-02 00:00:004Steinman, JanWagner, CarolOverheadMember ServicesJan SteinmanCarol Wagner3.000eachdues: 7/5 dep - post for Oct - Dec 2011$-75.00$-6,766.96
2011-08-04 00:00:0011PayPalISCU ChequingOverheadComputing EnvironmentUndefined UserPaypal1.000each$-199.69$-6,966.65
2011-08-05 00:00:003Market GardenISCU ChequingMarket GardenMarket gardenUndefined UserCash1.000eachMarket 8/2/11$-103.50$-7,070.15
1 to 0 of 0

Template

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