![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAPMAAAAyCAYAAACJQu0uAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAABpvSURBVHhe7Z0HmBRF2sffndnZvOTMIrvksKByIiKimCOmM4EZTs6AgnyYTr3jOAycZ4BTwQQqB+bsGThRgqAYAJEsklkywubZnZn96v9O1XZ1Tc/sgCA72L/n6We7amZnunvrrTdWbVKVgFxcXBIeV5gFG3eW0scLt8pWmKtObE0ZqV7ZcnGp/bjCLJg2ewM99sEq2SJq0SCd3ryjN6Uke2SPi0vtxx2tgrXbS+RZmDZNM11Bdkk43BErWLPNLsx5TTLlmYtL4vC7F+ZdRRW0dluxbIXJdYXZJQH53QszTOzCsoBshYGZ7eKSaPzuhXmNoZWb1E11hdklIYkrml1VVkYl94+UrcQh7bohlJx/JC1au4cmfPqz7LWzZXc5FfxSJlvEga9urevKlp3Ljs+hU7s3lS0Xl9pFXMJc+f18Krl7uGwlDtlPv0je9h3puf+toWemr5G9+8+/ru1O/fKbyJbLgSa0dQuFtm2RLSJv53xKSkmRLZeaiMvMDq1fK88SB0+LHPLk5vG5Ga3eH5LEkdc0K9xwOSj433mNikfewkfJX26nqt075Ssu8RCfMG9YL88SB29uG0ryhWf1n7fa/eL9IU/40a0bZ8iWy8EgtNEaZ55WrcnTrIVsucRDXGZ20Y3XUPDnn2QrkqT0dPL1PUW2agfJRx9DKaedRRWBED301grZa2fjrlL2pxUo3zy1m7NPDEG+7pRc2XI54PjLqXDwAGFmh8tqU04+nTL+MprPDySh3bsouG4N+Xr0lD1RCAYpsGo5eZo2J0+DhrKzdlOjMFft+YUfclXhXtnjTOqFl1LqgGvEjTeSPbWf8f9dTS/PXCdbRMd1aEBP3tBDtlx+S4I/raCim6+XLaK0a26gtKsHydavp/yFCVQ5dxYFhfb3HdeHMv/xL/mKncDyJeSf8gIFlvzAgd/sSa+SV1gJiUCNZnZw+9ZIQfZGLkDwv/sGlT3+MD+AWoOYXTmooh9iZlas2Fwoz8K0cX3iQ0ZogzWpAm/rA2cFVe3dQ/6P32dBBp7ctvzTicrZn1Plt1/zOE4SGtnTsLF8pfZTszCvspuoSVlZlDlqLJvWJpVfz+XAhS4whwoIbvFdt1Hh1RfbjvKJ4/j1ymAVFey2Tzxu5dehI2gIM3zmAwU+GwKt8LY6Qp5FElxvXQc0clJG4sRJvKME8tyRyukfUXDlMtkSvmjnfEofdCMldztKmC0ziSoq5CthQtu3UWD+XPIdfyIlZR4a4fC/9yaVjr6HQps2yh6LlAsuoeQOnTkoNvlz+wC69uRcalY/Tbai8+P6vbRpVxlt+aWcUn0e4Wsnc39RWYBmLt1Os5bsoMLSSqqXmUJpKc7LKKN9xswl22nG4u38+9EmF8QB5q3cSd/9/AvNXb6TFq3bQzsL/dyfKT7HJxeJoI2YAL4DB9q4Jif068GBlWMmwVAVfb1qN80R3/nVql20bnsJxxmifeb34vrU5zWqk0peTxJfw0ffb6FZy3ZwWz1v/3tvVAfAkIlIv+ZP4sRZ10AwK7+cSZVfzaHAj4sotGsnJdWtJxSMXfAwoSPWE1jwLb9PkdzzOCKheavTYCmpFBRmNdr+N6dWj2lPyxzyNGnK/Tg8zZpzvwl8cFxPYP488X2rqKq4mLx4r8P143Xcp/rupKxs/lkprrFy1gwKbd5E3nYduE8R2rGdAou+o8p5symw8Dv+PgpUimtrJt8RpkafufiOoeKDvpct4ctceiWlDRnK55VCaMunvUTBZT9yWye5a3f2oX29+siegw+us+Kj96jii//JHguvEODU8y6klLPP5/ani7bRvVOt626QnUJvjOxNdTN8sic6p42aRXtKKvn8gSvz6Zi29ekvU5fw4NVpKD5z7NXd6ai8erLH4pwxX9L2veV8Pv5PR1PHFlk08qXFLFRg6NntIgJuKG6ZPGMdTf9hK5X6g7I3kqtOak3Dzm0vPt9Plz/6FU8yoE+nRjRu8FF8rgOBH/HiDzyBgLOObkZjBubzueKDbwvoyY9Xcy27yRlHNaP7LunMgq3A88FzUrx/Tx++nr++srS6SKc6by+GYNHgAdVmsK/3CZQ5+hE+14HpW/bko1Qx4xMhFfb7h8WYNuRWSpV/XwC3zy/GQyzSbx5O3jbtOR0WC2/7TpT99GTZCgOhKn14lGNw2Nu2PaWPuIcVhw6+J/DDAj5PH/p/lHLGuVT64P1s1YLU8y6i9GF38jkmrfJpL1LFh+9QlaE0gf5eENPMxgxjpqU8R1gDDIIKLe37Qy/ZYxFYupjKJz9DlTM/kz0Hj6rSUjGjTqPSJ8Y6CnLKuRdSxvC7qgUZmGWcWCkVjyBjkCpBBqlCC/554oIIQQYY+Le9sFD89MueMNBwSpBBhtDe+AwlyKBLqzryLAwKXy595Ct695vNMQUZNK8X1nYoTW3XzIoDIHrvxGyhJZUgQ1ue2t0qjNkt7gGBwn+8scxRkMH0RVtZ0HX2lNjfW1we4GehV9upe4S/rAQZOJnY0EilD9xPFdP/GyHIAGO1/Jl/hwVdon9mNLzCf2ZNVwPevDbyLAyURomw/qJledBf/sx4Cq6xPxdYCwpPo8bslipBBp4Onfhn1Y5tVDb+EfK//ZqjIIPko/4gz8LEFObg+rXC/7Un7nVhBslH9qC0QX8mX5+TZI8Fbqhs0gQOPhwsAosXCiF+mMrEHzK02W5Ww1yBEGeI2QuVYDprjUKSeOuxYVrqjHlzOfe1FUIz5Iw2fEAjKyB4L31hH1Smr/7eNwURn9s5xxJmbJzwrBBmmKiAU2jdm9LdF3eip27owZpRRy9HbdfcEmaY0QXC5NVZv6OUZi3dIVvC6jiyKZ2sVbmNem0pR/zF/MOlrri/yUN70uPXH2n7ntfnbrRNctDCinqZPvrnuyttkxD6mtQNTzqmv+w1xhhM0xIhyLAEAXxZaKTsiS+x9lNVYlUlxTblkXxsb0qDua4BCw196vAKCxJmPZ8Lbaqjvw8aVOEXmrJUaP3Qxg3cTjnxFMoc9TBlPTWJtaUisHiRzbzngKwy7QWV84SbIMx7nWQpzP7336aK2Z/zOcD3Z44dT1n/eoqvx9fnRPKd0E++GiamMIc22Cu/PA0biQcdOWviAUFDp5x6luyxCG0pIP+kiTzDHEhgcvnffIXKhCBXOmjj1LP7iz+40MZCK1MS6rfsmMIc7xpmswAFAxiCNWXYsTTkdCHM4vi3MJt1PhM+sM5GIVQ6H3xXwD9hVk+7vRd998hplJ0e9qE/FP7lK3PCgwYcnVefHryyGz18VTf643E5dGz7BlRHvhfg9+CfKnTNHBISuWmnXTtDkCHQwCO08mla7TlM63krw8FMTCAv3tqT7w9C3LdLY3YFdPRno2/4gGcEUx5af9h57XkXl89GWZO/Gck2NXPZk49VB7B8wt/NemoyC423bQc2q339TufXQHCtpWXTrhBunqFkkL9Ou3pw9YGJAJ+Jc09jaxLzCMHW3welBeC/lk94gs8BXM6M+x/g74FJDdMZJr9CL4QJFmySZ2HYyhDgHrLGP0f1PvmS7wnAh1ZgkskQkxZy46w8xfUgCG1mlWJrZvMhixlTOewmeC0NAg3hMQjt+YXKXhAaeqrwOUJh7fJrwGxXNm6s0MbCjJGzo8KT15YfKAQ5uVMX2WsH5Z3m7iKo8IqHzYZmgx868oIOtp1JOrTIpq6amby3tMJmam8xNDMYcX4HFg78rgKaeNIMa0JtXj+dHroqn79TZ7FmnkPbNdaFWdPMANpZAdMaJrYCgnxyfjgVg+/WTWdYAfq1gdXGxJau+cxqglDg+Tw9pAddLfx5M7Cnj7OkBg2FwgiX4QK4TUp7oXgj466/RWRSdDM54jVT6+fazWVFVWUFW6KKaO8rF5amMnuhHRFD0oGw6+lZXV50E1uRevHlYd+6c75NOEMbreuuqcZDUaOZrWOaPyaI/EGg0y4ZKHs0KvxU9uKzLNRVxUWycx/xl1P5W6+yiVMx41PZaZFyxjmUOfxuSr3gkohZS8c0aeuk++LOMZsbGVwvtKkuPIpmQvAU/sqQGMzW9egCBRAEGtg3Ml0ydfZ63mxQge9qmG3/LkwS2/ZYE0y3I+wrvqCZm2sRev3zZi3bWV0BJ5SmEGZLM02Zub7aR4ZJfKY05fF9iA+M+/Aneux9a9+0Vo0yqKMm7KYFcHW/1vSHtvVly05AFyJWGNbfAsUeCl+/0zhqDXMV/jCKQIpvv5GCq5bLd4j3CJNXR9f6SZlZ5GltTRQ6iA3BilR4W0cKMyaNis8snzxVjnOMZ1SL+d9+lYqGDuLrU/j6WqZwyNDMbNEOuVW27CgNDTBBFCPlK37GIqowV5WXRZo/NQgz8NSpGxboq8RNORWXvP4fDozVdGEm0Malj4/lPLFuugCv+ANl3Hw7a2NvF3sU1glz4UVukwybnxuLgt2W4ED7do+yXHKHFuBqL7SjMpvBygL7ZDaiv91XU7z4hfX8ERG/qFdL2bLYuLNMaH7LVzV9/8y0ZKGdNSHTJpLZuq8stPIp3Sxh/mGdlZeFmdzrrhl0zB2f0Zmj59CfJ35PU2at50AewLP722Vd2IxWLNtkFeTg3rHbqROhrQVUFSX4hTGi+5hw1fac3pv2nHUCFQ26gkpG3W3zOWEuKwFT6ArJ0zrXZkrrRBStyEU6OioKrcBEguvZe9EZVHzLICqbMM7KZ4uxnzb4JrtQGsGydGSFoigdLN/VX0N6rWjIlTyBRSOqMIcfpH37WW8UszUCn4/Srr0hfLEO+N9/i0of/GtcUUTMeuVTXqCSe0fYIpUK+BCZYx6llIsui3u5nBnJbqP5lbHAoNb9wk45ddjPNMEgX7HZEtiWDa38J17bqpnqSGs55XSXC2HQA0Z9OztXIn253B6gdHIXcrUFIso0hrB9scSaUP/YO0eehdGFMRoQ3uM7NuR4gZ5+w/PVg2H9uja2TWY6ECI9Wqtbf9EixSaclhKDHyWappmtC6mTtlXo1gHGr9N7Q3GMV4AAXeaDj7PPrqP7zJi0zKCsDsZ11tjx7FooELHHBIb0nBNRhTm41ljML2YJhPH3hdSLr+DggNPsgxkVCzjKJjzBJoruZ7DZsnwJlQuznKu2Xn7e9jrAHw2+MaJ70ZL50Vi33W4CxhvJNgf4se2czUYURajIM2jbzPp8mKkbNBM0P4pmNyPeeU2dK5E+1wQSwAowOTLX+g6Y2ZhQEEFXwPzVTWAIoi6M8HEhtP2PacEHAnXIjX8xuh//VFFpxWbDjejZvoE8iyQiLqNp5uA6+xjEAEfkGJFdHOk3DeOIdt13/kdpV14fMc6gJXWF4aRtFaGfLZfB07gpeVpEWkEBrRoSEwhfj7wWBOQyRt5Hdaa9x/XcEQs54BqIMa1IbteBkjJijzsW6AkvUbLxWSiK0iPdiuiaeYVV9QV4SeF+LBTnsL3DjMmIG4TpBBNl7/mnUOHAC6jw8vPCZsttN1D51Mk8G5ngJrOfnRr2jfcRDGZTM8dbxvmTYR43lflcHRRofLLIsmhggkL7KhatswczOjgIH/hpi/0aW2g+uGLG4m02HxiYPjUwc9bLNhbSxwss8xURah0zL3668KUhtH+7vAsfCNRBuPUiER3z2vWIuonNpxVjJFmvyQ7Y92ZLv2k4K4eMO+7jA8pCN2NNAoZm97SK7ibqVoC3pd1KUejj33NEHisSdS1IlaWceW5UMz6w7Ee7BSJTUDUBzQwNjUCZTuCrOfLMIqowB7SZCsR6aDUBXwZmBwcvYsCmfYy6bsyG+6uNFUhJBYJW0Vt6incfNLMlzIjO5hvBJvDWV5to/qrdskWcturZztJM6yL8defvLq2wF0aYKTGY4E99YtdcpoZUoF9/DQUoyoQ3tTJAzlyPzq8xLJmaWKdFsnOEixFrUwddM0MrJzXS0kMtW8mzMPsaZzEDTtEEDeifnVTfecmj/vuh1SvlWXxERNW1iH08pF5kF2Y9yKZwFmYxI1aZ/nIbe05xX8FeXFnwbU8/W/bED6ebrh1C2eOe2y9trAOfEsEadYwSmqaZg4Z1Qo+Cw89VASAFgkJ6Ogd+4uBT7dpAtwoQAY4WRc8x/GhEnhUQxGGTFrJW1gN3iDpH4+g8a+JRuWP4vNjXzAl9kkG9OCYpE9z/nGU7qstFFfpzymuSQT5vZFwBVImJ2x7Jtg9wr/i768Alc6rq4lptrYpKYY7h4Eor6q1jpozMAKvCo/m40LKl/7g3wv0DMO3N67QF2FJSowaTVWTcxAy+OcWvkpxqszFLweTVyXp8IgvkgQBLzFB+iQhdLLAwHKZLKoJbUfLbvxUQoBPv+0K2wkAY+3ZuxFoUg1ovd4QJisnC3ADw8ke/rtayJ3ZtTI9d5/xM8Z4rn5hvmzCgMVsJTffN6l18PfhugIUPAAUkqAhzYvLna+mpj+2a/JwezWn0gK6yZQcCf9vzC2UrTJecOtU+Piq8fly/h+/55WHH8muq/5JH5lVr/mv65dJt5zorAtTSo/ZfkT7oJq7n1ykd+3dbOohNceFmIX4DKw7RbsRfEHTKfm6qfFcYBIrgX+ogHcRFIogWS6DBC6+9VLbCQAujMgyVXWrsQXCLBl9h0+J4H67HIyyK0M7tFFy9ioUZPrz+HSX3DKfK7+bzuVOdtwLVkmWPPcTXmZwfrk4LrljKUWw1ccBChZtpWhqOmlnP2yl+jZltwlU8wg+o+8503k1CL5vjihrRV2fK21TnP29ztcuBFGTMcPoR73LNJRsiE/fQjNPmbKB352+2CTLM1jED8iMEef0Oe7FKrKozCK4ZYYaAY1UWBAWa895LOtvM8WhmNujY0u43QytfdVL0pYDwiZ0i3CjbxAFtre5Z99vXiXtUggyiBe6AmQ7yOFQXpt0wlCd1BQY0tHD5qy9zBRVrLGFymiY18HaKnKgwts06B94vzhAMCCwmCX3scdD1lhE23xnvw2TD1yN+qoCbfj24Zt3MjlWvgVWKANeJeBIvLBGfW20BeL2Ucf+DEdcLnIVZzC46cNYdA1i/Ejwos7wOFTXo21+fOBahTRuo+M5bqzeNwxFculi+GhuzYgzCZgJtDAHASiloXZO120q5pFJRUwnpiP4d6MJj7VFVCCFqsSfd0pODXXoNdKMYufKiMis6DS7s1TKiosvknos7iXvp5hh8A0hHoXKtV3vLxzQzBbHuMdKPjBzkCABB48K9chqD6MP2UE5bDKGfK7SMKLdTpBqVZRBqHWhbE5RtZk18mbWxE1znLbRy6sDrZE940sLSYEWseo2Us/qHq8EMMIEgal7HKVIucTSzS4QvgB0XFPBzM+78q2wlLjBVkKfTyX5+Ghed1AQWVEADK2aPOZlXPsE/9AdCbHIjaqsHjg4U+B5oRQgyqqxiaWAnoNGvf/Lbao0J3/qdu/pEzf06Ab8Y94qUG1ZjIZJ/MO61JuDfciGJGNwQNicNZcIpKviwQoM7aWEF/GBoVLwfwVpYBLGUmO39wvTF9dQU5I0XaGKY7bAicB3x7EPmKMyFfxpo214XlSxmAjwRKX/lZa6tVUATZL/wimzFBlVPapkjothYdJAIoFzz3x+trq7oapCVQsP7t2d/2eXwImJq5V0Q4jB/EpFIHy2++yoUJqq+ygoR2kRgVUERWxR6aSZqpF1BPjyJEGauZdWVNSq/4jBDE4GIhSNx3hdyw7uLrQBXvEUmhwqY1di1ZODj821pIggxVi25/HaY1XSKaP2o/FOpPryuVxLi3KwM1HEWZg1oZTN5n4igznx/NfP+Lpc8VCCthGizDlZmYRmjy28D1oJjayhsnYQDqUvwzU+76aKx86r7kf5TQo2f5z80l5e9XjPum+r3wMLCKrV+98/k1/XVajqRZvZ+DvjaDiapKr99LXK87oMuzD6vp8Yo9KFGX0uNYNWt57TjPb2ilV+6HFggbH9/fRm1a5bJ2QDsE9erQ0Muv71VCC9W6T1/8zGcUcDEC0EFqv7gtbkb6awezeiyPq04aHnzsws4AIrsAv6G2DrKiZo182FiYkdMUs1bxj1RXXdyHm9Ih+OtO3tz5Lo206NNfd4NBFv8IFCHXUfTfBF/apeDAIQOwti3SyOuZ0etgVoLPu7D1ZyReGBgN07r3XlhRxZOFVhVK9r692zB69sHnBC2iPE72L0G/Ugn6nl8HdtfOFiwOa7cXyJi3hcKFOJdOIJUDso31ZEIYJ8uLKDY1zSWy68D2zChas9cvw1TGZsZYpcYZSFtFv6vJympugxX7c6iSmxVDQE0uEoDolDHqcYB2ISZtVel3Sk/XMxsUzMfLpOUS+1i+56wAOpbKAGlTfVdXyDg2LU0R1p6G3aUcDxGCatacquWsGJHGWx60amlc7FPkp5n9r8+lcqee1K2xIDPOYKLKpzWIycSKOjn/5ellfFljLyXUs48T7aig904sKe0iwtAqe4zN1pb3CK6fPeUH+mkro1p8Gl5vIvqs9PXcOYA1XGl/gD/kwNsHYXAFzIhTw85mrX3zc8u5N/HBoewoC7+5zwuPHrs+nC9/mjhd38m/OzXR/bmxUBYjXfLcwto6DnthOsXqYzsZrbhLyfVq5/wggwq5s+11+OKe0ru2Vs2YqMv53NxMdOS2BEGGvT7NWG/d8AJR7Bm/WjBFo5EI/o8b8Uuds+wqQOCXP0fnMsHtDV8YbyGun0Idk5Dy43D9lYItqpVfSrNmNvYOQBr08ylj4yp3v6TEYMeGwtgYUSigkJ8bFGkL6jAhgm8A0ocYGN6PVfr8vumozBx9Zp2tQwUAUe1MYS+NLRt8ywWPuUnw7ReubmIBRh7o6t+vBevwQxXcRkExlByq74Pwo5/9YPvciqltQkz1os67W/NdaHyH5cnFJUVkauixASFzQ0O1HJOF5fagk2YocVKRt0lTFL7rhaHE2mDbqI0Y82si8vhgE1XY1mX7/jIfzNzuIDFIq4guxyu2DSzAgutsTOm0z5DiQgmKWx6YP5HPheXwwlHYQbwNfGP1nm7UyP3nBBg7+PctpTcuesBW2Pq4lKbiSrMLi4uiQTR/wNSVFD8qvRgswAAAABJRU5ErkJggg==)
PrayerLetters.com can take the burden of printing and mailing Year End Statements off your plate. They specialize in printing and mailing newsletters for missionaries, but their experience applies equally well for organizational mailings.
You can contact them to get started with the process of setting up how your Year End Statements will appear. From DonorWise, all you need to do is run a query and export it to Excel. Securely upload that Excel file to PrayerLetters.com, and they can take it from there.
<< call to action >>
How to Export Donations For The Year to Excel
In DonorWise, under the "Tools" menu, click on "Run Reports". If you don't see "Run Reports" make sure you're a member of the "Report Writer" role, and also make sure you're on a recent version.
Run this query (when prompted for "Parm1", enter the year you're reporting on):
SELECT GiftView.DonorID, GiftView.DonorName, ContactView.MainEmail AS DonorEmail, ContactView.Greeting AS DonorGreeting, ContactView.MainAddressBlock AS DonorAddress, GiftView.ReceivedDate, GiftView.GiftAmount, GiftView.PaymentTypeCode, DesigView.DesigID, DesigView.ShortName AS DesigName, GiftView.DonationMemo
FROM GiftDonationActualView AS GiftView INNER JOIN DesigView ON GiftView.DesigID = DesigView.DesigID INNER JOIN ContactView ON GiftView.DonorID = ContactView.ContactID
WHERE (YEAR(GiftView.ReceivedDate) = ?) AND (GiftView.DesigID <> 3) AND (GiftView.PaymentTypeCode <> N'FLOW-THRU') AND (GiftView.PaymentTypeCode <> N'TRANSFER')
ORDER BY GiftView.DonorID, GiftView.DesigID, GiftView.ReceivedDate
|
Then click "Export" to save a CSV/Excel file.