{"product_id":"church-budget-tithe-tracker","title":"Church Budget and Tithe Tracker Spreadsheet","description":"\u003cp\u003eThis church budget spreadsheet is built for the treasurer who has to keep designated money where the giver meant it to go. It tracks tithes and offerings across five funds, keeps the restricted ones separate, and gives you the full church budget underneath.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eFive funds, kept apart\u003c\/h2\u003e\u003cp\u003eMost giving logs only record what came in. A church treasurer also has to know how much of it is already promised. Here the building fund, missions, benevolence and designated giving each carry their own income and pay only for their own costs. A gift to the roof stays with the roof.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eFive funds, four of them restricted\u003c\/li\u003e\n\u003cli\u003eSpend more from a restricted fund than was given to it and the balance turns red\u003c\/li\u003e\n\u003cli\u003eEach fund shows its own money in and money out\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eGiving statements and pledges\u003c\/h2\u003e\u003cp\u003eThe tithe tracker side of the workbook works by envelope number, so you can answer a member's question or prepare the year-end letter without searching through the ledger.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eA statement for every envelope number: each gift, the total given, the amount pledged and what is still to come\u003c\/li\u003e\n\u003cli\u003eA receipt number on each statement for the year-end letter\u003c\/li\u003e\n\u003cli\u003eA pledge tracker comparing what each giver promised with what has actually arrived\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eThe budget and the books\u003c\/h2\u003e\u003cp\u003eEverything recalculates from two registers, money in and money out. Nothing is entered twice and there are no pivot tables to refresh.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e1,000 ledger rows, with two years of demo data already entered in the filled copy\u003c\/li\u003e\n\u003cli\u003eProfit and loss by category, with monthly and quarterly views\u003c\/li\u003e\n\u003cli\u003eA custom date range and a year-on-year comparison\u003c\/li\u003e\n\u003cli\u003eEvery total, margin and percentage calculated for you\u003c\/li\u003e\n\u003cli\u003eCharts that redraw from your own numbers, not static pictures\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eThirteen connected tabs\u003c\/h2\u003e\u003cp\u003eA Start Here tab walks you through setup in a few minutes. From there the workbook covers setup, the giving tracker, income, expenses, monthly and quarterly views, profit and loss, a custom range, the year-on-year comparison, fund balances and a dashboard.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or later, on Windows or Mac\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eBuilt with no dynamic arrays, no macros and no add-ins, so it behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice. No Microsoft 365 subscription is required.\u003c\/li\u003e\n\u003cli\u003eNo subscription and no bank connection\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel files: one filled with two full years of example data so you can click through it working, and a blank one ready for your own numbers\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. You get two Excel files for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan I keep building fund and missions money separate from general giving?\u003c\/h3\u003e\u003cp\u003eYes. There are five funds, four of them restricted, and each one has its own income and its own spending. If a restricted fund is overspent, its balance turns red.\u003c\/p\u003e\u003ch3\u003eCan I give members a statement of their giving?\u003c\/h3\u003e\u003cp\u003eYes. Each envelope number gets a statement with its gifts, total given, amount pledged, what is still to come and a receipt number for the year-end letter.\u003c\/p\u003e\u003ch3\u003eCan I track pledges?\u003c\/h3\u003e\u003cp\u003eYes. Pledges are compared with what has actually arrived, giver by giver.\u003c\/p\u003e\u003ch3\u003eIs there an example to learn from?\u003c\/h3\u003e\u003cp\u003eYes. One copy comes filled with two years of demo data across 1,000 ledger rows, and a blank copy is ready for your own records.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597864304734,"sku":"OPX-076","price":27.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/church-budget-tithe-tracker-01.jpg?v=1790832362","url":"https:\/\/opxviashop.com\/products\/church-budget-tithe-tracker","provider":"OPXVIA","version":"1.0","type":"link"}