<div dir="ltr"><div>I can plug dates into that spreadsheet for the amounts received. I'm not sure why I hadn't done that in the first place.</div><div><br></div><div>Mark<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Mar 28, 2023 at 12:45 PM Misty Bromley <<a href="mailto:misstea@misstea.ca">misstea@misstea.ca</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg-861416430995037890">
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
I don't think the QB transactions will be terribly helpful. I've been looking at the
<a href="https://docs.google.com/spreadsheets/d/1touKIzOIl-1PDf0gelLat5w5pAch07v8X8EolD0axwc/edit#gid=0" title="https://docs.google.com/spreadsheets/d/1touKIzOIl-1PDf0gelLat5w5pAch07v8X8EolD0axwc/edit#gid=0" id="m_-861416430995037890LPlnkOWALinkPreview" target="_blank">
Grant Tracking Spreadsheet</a>.</div>
<div>
<div id="m_-861416430995037890LPBorder_GTaHR0cHM6Ly9kb2NzLmdvb2dsZS5jb20vc3ByZWFkc2hlZXRzL2QvMXRvdUtJek9JbC0xUERmMGdlbExhdDV3NXBBY2gwN3Y4WDhFb2xEMGF4d2MvZWRpdCNnaWQ9MA.." style="width:100%;margin-top:16px;margin-bottom:16px;max-width:800px;min-width:424px">
<table id="m_-861416430995037890LPContainer778171" role="presentation" style="padding:12px 36px 12px 12px;width:100%;border-width:1px;border-style:solid;border-color:rgb(200,200,200);border-radius:2px">
<tbody>
<tr style="border-spacing:0px" valign="top">
<td>
<div id="m_-861416430995037890LPImageContainer778171" style="margin-right:12px;height:126px;overflow:hidden;width:240px">
<a id="m_-861416430995037890LPImageAnchor778171" href="https://docs.google.com/spreadsheets/d/1touKIzOIl-1PDf0gelLat5w5pAch07v8X8EolD0axwc/edit#gid=0" target="_blank"><img id="m_-861416430995037890LPThumbnailImageId778171" alt="" style="display: block;" src="https://lh5.googleusercontent.com/TG4HaBJZtEgiS2DLH7AZczTC4uMf6ZzwVg6dyj_-NFw_I-1UTLlNT-BGZ8ReRcnhQ33WOpWiYT6Seg=w1200-h630-p" width="240" height="126"></a></div>
</td>
<td style="width:100%">
<div id="m_-861416430995037890LPTitle778171" style="font-size:21px;font-weight:300;margin-right:8px;font-family:wf_segoe-ui_light,"Segoe UI Light","Segoe WP Light","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif;margin-bottom:12px">
<a id="m_-861416430995037890LPUrlAnchor778171" href="https://docs.google.com/spreadsheets/d/1touKIzOIl-1PDf0gelLat5w5pAch07v8X8EolD0axwc/edit#gid=0" style="text-decoration:none" target="_blank">BW 2022 Grant Reconciliation Tracking</a></div>
<div id="m_-861416430995037890LPDescription778171" style="font-size:14px;max-height:100px;color:rgb(102,102,102);font-family:wf_segoe-ui_normal,"Segoe UI","Segoe WP",Tahoma,Arial,sans-serif;margin-bottom:12px;margin-right:8px;overflow:hidden">
Summary 2500,Matching Sources Grant,Maximum Grant Amount,Grant Amount Recieved To Date,Earned Amount,Corrections on Earned Amount,Max Admin Fee %,Earned Admin Fees,Available Funds,Amount Receiveable,Additional Grant Amounts Avaliable,Matching Requirement,Bike
Winnipeg,BSC ODG,E.D. labour budgete...</div>
<div id="m_-861416430995037890LPMetadata778171" style="font-size:14px;font-weight:400;color:rgb(166,166,166);font-family:wf_segoe-ui_normal,"Segoe UI","Segoe WP",Tahoma,Arial,sans-serif">
<a href="http://docs.google.com" target="_blank">docs.google.com</a></div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<br>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<span style="color:rgb(0,0,0);font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt">I need to reconcile to that, I think. </span><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<span style="color:rgb(0,0,0);font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt"><br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<span style="color:rgb(0,0,0);font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt">At least I remember getting those payments, so that helps.</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<span style="color:rgb(0,0,0);font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt"><br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<span style="color:rgb(0,0,0);font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt">Misty</span></div>
<div id="m_-861416430995037890appendonsend"></div>
<hr style="display:inline-block;width:98%">
<div id="m_-861416430995037890divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> Finance <<a href="mailto:finance-bounces@lists.bikewinnipeg.ca" target="_blank">finance-bounces@lists.bikewinnipeg.ca</a>> on behalf of Mark Cohoe <<a href="mailto:mark.e.cohoe@gmail.com" target="_blank">mark.e.cohoe@gmail.com</a>><br>
<b>Sent:</b> Tuesday, March 28, 2023 11:37 AM<br>
<b>To:</b> Finance Committee <<a href="mailto:finance@lists.bikewinnipeg.ca" target="_blank">finance@lists.bikewinnipeg.ca</a>><br>
<b>Subject:</b> Re: [BW_Finance] Finance committee meeting tonight</font>
<div> </div>
</div>
<div>
<div dir="ltr">
<div>Thanks Misty,</div>
<div><br>
</div>
<div>7:30 pm should work for me, although I am working tonight at the WECC. I can try and send something in advance to discuss the unallocated grants as well. I did a bit of work on it last night. I exported the transitions on that account and started to match
things up. I'm not too familiar with QuickBooks. If I were to generate a spreadsheet of all grant payments and dates, would that be helpful?</div>
<div><br>
</div>
<div>Cheers,</div>
<div>Mark<br>
</div>
</div>
<br>
<div>
<div dir="ltr">On Tue, Mar 28, 2023 at 10:48 AM Misty Bromley <<a href="mailto:misstea@misstea.ca" target="_blank">misstea@misstea.ca</a>> wrote:<br>
</div>
<blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
Hello everyone,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
Tonight is our monthly finance meeting, and hopefully the last one I will chair.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
I'd like to push the start time back to 7:30 so that Luke can get his kids to bed.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
The main thing we need to discuss is the grant allocation for the 2022 financial statements. </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
The CIVICRM and Bikeshare research are the only grants that spill into 2023, as far as I know.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
We have the West Broadway Study, Chalmers Study, Local Bike Groups through Canada Summer Jobs, and the Strategic Planning, which was funded by Red River Co-op and ???. </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
There's the CAA quadrennial poll and a possible receivable from the City for the Bike Valet Expansion project (which is straight revenue, as all expenses have been incurred).</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
That's just going from memory, so I am sure I am missing something.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
Here's the<a href="https://us02web.zoom.us/j/81188389156?pwd=elhiVCs0QmlCcUhOeElRbk9ZS0NIZz09" title="https://us02web.zoom.us/j/81188389156?pwd=elhiVCs0QmlCcUhOeElRbk9ZS0NIZz09" id="m_-861416430995037890x_m_6013628942754521316LPlnkOWALinkPreview" target="_blank"> Zoom</a> link
and here's a link to the <a href="https://docs.google.com/document/d/1iDQ4ydwxKzYqNBOyK_lA84fyaAkTjo0X5eAY9aDmNns/edit" title="https://docs.google.com/document/d/1iDQ4ydwxKzYqNBOyK_lA84fyaAkTjo0X5eAY9aDmNns/edit" id="m_-861416430995037890x_m_6013628942754521316LPlnkOWALinkPreview_1" target="_blank">
agenda </a>- I didn't change too much from last month.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
Misty</div>
<div>
<div id="m_-861416430995037890x_m_6013628942754521316LPBorder_GTaHR0cHM6Ly9kb2NzLmdvb2dsZS5jb20vZG9jdW1lbnQvZC8xaURRNHlkd3hLellxTkJPeUtfbEE4NGZ5YUFrVGpvMFg1ZUFZOWFEbU5ucy9lZGl0" style="width:100%;margin-top:16px;margin-bottom:16px;max-width:800px;min-width:424px">
<table id="m_-861416430995037890x_m_6013628942754521316LPContainer436128" role="presentation" style="padding:12px 36px 12px 12px;width:100%;border-width:1px;border-style:solid;border-color:rgb(200,200,200);border-radius:2px">
<tbody>
<tr style="border-spacing:0px" valign="top">
<td>
<div id="m_-861416430995037890x_m_6013628942754521316LPImageContainer436128" style="margin-right:12px;height:126px;overflow:hidden;width:240px">
<a id="m_-861416430995037890x_m_6013628942754521316LPImageAnchor436128" href="https://docs.google.com/document/d/1iDQ4ydwxKzYqNBOyK_lA84fyaAkTjo0X5eAY9aDmNns/edit" target="_blank"><img id="m_-861416430995037890x_m_6013628942754521316LPThumbnailImageId436128" alt="" style="display: block;" src="https://lh5.googleusercontent.com/qUjhovw6lYRusWcU3NzWfLTIqAd1AgjaAjoL5vNJKu_5qjn0m7rh-2Z0grrdOKMWlE1iOXODxwtl3A=w1200-h630-p" width="240" height="126"></a></div>
</td>
<td style="width:100%">
<div id="m_-861416430995037890x_m_6013628942754521316LPTitle436128" style="font-size:21px;font-weight:300;margin-right:8px;font-family:wf_segoe-ui_light,"Segoe UI Light","Segoe WP Light","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif;margin-bottom:12px">
<a id="m_-861416430995037890x_m_6013628942754521316LPUrlAnchor436128" href="https://docs.google.com/document/d/1iDQ4ydwxKzYqNBOyK_lA84fyaAkTjo0X5eAY9aDmNns/edit" style="text-decoration:none" target="_blank">BW finance 2023.03.28</a></div>
<div id="m_-861416430995037890x_m_6013628942754521316LPDescription436128" style="font-size:14px;max-height:100px;color:rgb(102,102,102);font-family:wf_segoe-ui_normal,"Segoe UI","Segoe WP",Tahoma,Arial,sans-serif;margin-bottom:12px;margin-right:8px;overflow:hidden">
Bike Winnipeg Finance Committee Meeting March 28, 2023 7:30 pm\u000BLocation: Zoom Meeting chair: Misty\u000BNotes: Everyone\u000BIn attendance: Regrets: Governing documents: Bylaws / Policies / Strategic Plan / 2022 Budget / Committee TOR\u000BOperational
documents: Scheduled board meeting topics / \u000B List of acro...</div>
<div id="m_-861416430995037890x_m_6013628942754521316LPMetadata436128" style="font-size:14px;font-weight:400;color:rgb(166,166,166);font-family:wf_segoe-ui_normal,"Segoe UI","Segoe WP",Tahoma,Arial,sans-serif">
<a href="http://docs.google.com" target="_blank">docs.google.com</a></div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<br>
<div>
<div id="m_-861416430995037890x_m_6013628942754521316LPBorder_GTaHR0cHM6Ly91czAyd2ViLnpvb20udXMvai84MTE4ODM4OTE1Nj9wd2Q9ZWxoaVZDczBRbWxDY1VoT2VFbFJiazlaUzBOSVp6MDk." style="width:100%;margin-top:16px;margin-bottom:16px;max-width:800px;min-width:424px">
<table id="m_-861416430995037890x_m_6013628942754521316LPContainer972010" role="presentation" style="padding:12px 36px 12px 12px;width:100%;border-width:1px;border-style:solid;border-color:rgb(200,200,200);border-radius:2px">
<tbody>
<tr style="border-spacing:0px" valign="top">
<td style="width:100%">
<div id="m_-861416430995037890x_m_6013628942754521316LPTitle972010" style="font-size:21px;font-weight:300;margin-right:8px;font-family:wf_segoe-ui_light,"Segoe UI Light","Segoe WP Light","Segoe UI","Segoe WP",Tahoma,Arial,sans-serif;margin-bottom:12px">
<a id="m_-861416430995037890x_m_6013628942754521316LPUrlAnchor972010" href="https://us02web.zoom.us/j/81188389156?pwd=elhiVCs0QmlCcUhOeElRbk9ZS0NIZz09" style="text-decoration:none" target="_blank">Join our Cloud HD Video Meeting</a></div>
<div id="m_-861416430995037890x_m_6013628942754521316LPDescription972010" style="font-size:14px;max-height:100px;color:rgb(102,102,102);font-family:wf_segoe-ui_normal,"Segoe UI","Segoe WP",Tahoma,Arial,sans-serif;margin-bottom:12px;margin-right:8px;overflow:hidden">
Zoom is the leader in modern enterprise video communications, with an easy, reliable cloud platform for video and audio conferencing, chat, and webinars across mobile, desktop, and room systems. Zoom Rooms is the original software-based conference room solution
used around the world in board, conference, huddle, and training rooms, as well as executive offices and classrooms. Founded in 2011, Zoom helps businesses and organizations bring their teams together in a frictionless environment to get more done. Zoom is
a publicly traded company headquartered in San Jose, CA.</div>
<div id="m_-861416430995037890x_m_6013628942754521316LPMetadata972010" style="font-size:14px;font-weight:400;color:rgb(166,166,166);font-family:wf_segoe-ui_normal,"Segoe UI","Segoe WP",Tahoma,Arial,sans-serif">
<a href="http://us02web.zoom.us" target="_blank">us02web.zoom.us</a></div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<br>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0);background-color:rgb(255,255,255)">
<br>
</div>
</div>
_______________________________________________<br>
Finance mailing list<br>
<a href="mailto:Finance@lists.bikewinnipeg.ca" target="_blank">Finance@lists.bikewinnipeg.ca</a><br>
<a href="http://lists.bikewinnipeg.ca/listinfo.cgi/finance-bikewinnipeg.ca" rel="noreferrer" target="_blank">http://lists.bikewinnipeg.ca/listinfo.cgi/finance-bikewinnipeg.ca</a><br>
</div>
</blockquote>
</div>
</div>
</div>
_______________________________________________<br>
Finance mailing list<br>
<a href="mailto:Finance@lists.bikewinnipeg.ca" target="_blank">Finance@lists.bikewinnipeg.ca</a><br>
<a href="http://lists.bikewinnipeg.ca/listinfo.cgi/finance-bikewinnipeg.ca" rel="noreferrer" target="_blank">http://lists.bikewinnipeg.ca/listinfo.cgi/finance-bikewinnipeg.ca</a><br>
</div></blockquote></div>