https://wiki.godlovesbrookline.com/mw/index.php?action=history&feed=atom&title=Category%3A5%25Category:5% - Revision history2026-09-29T18:13:53ZRevision history for this page on the wikiMediaWiki 1.43.9https://wiki.godlovesbrookline.com/mw/index.php?title=Category:5%25&diff=249&oldid=prevSerenity152102: new2022-03-24T12:53:06Z<p>new</p>
<p><b>New page</b></p><div>Open [https://docs.google.com/spreadsheets/d/1tDV6HZqjGL_NZ2LQCdvbKEufYxwgMut-IdaH0qZdR-k/edit#gid=214472204 Deductions and Deposits tab]<br />
<br />
Go to the 5% tab<br />
<br />
Open the [https://banking.fnb-onlinebankingcenter.com/FNBPA/login.aspx/ Bank Account]<br />
<br />
Go to Bill Pay on the top of the page<br />
<br />
Scroll down to:<br />
<br />
Open Bible Churches<br />
<br />
5%<br />
<br />
Click on Activity to view the payments made.<br />
<br />
In the Google sheet, look in Column D "Amount Paid" for the last payment made<br />
<br />
Add any additional payments that have been made per the bank activity<br />
<br />
Next, look for the last row that has both a start and end date listed.<br />
<br />
Example:<br />
<br />
Start Date End Date<br />
<br />
1/20/2022 2/17/2022<br />
<br />
On a new row, list the date after the end date you just found and the day before the current date<br />
<br />
Example (assuming the date is 3/23/2022):<br />
<br />
Start Date End Date<br />
<br />
2/18/2022 3/23/2022<br />
<br />
Go to [https://giving.planningcenteronline.com/ Giving]<br />
<br />
Click on Donations on the top of the page<br />
<br />
Click on Donations List on the left side of the screen<br />
<br />
Date Range: [Enter the dates you wrote in the Google Sheet]<br />
<br />
Filter: Fund --> General<br />
<br />
Submit<br />
<br />
On the right side of the screen it will say "donated | -fees | =net<br />
<br />
Copy the "Donated" amount and paste it the Deductions and Deposits sheet under "Enter total general giving in date range"<br />
<br />
This automatically calculates the 5% amount in the cell under "5%"<br />
<br />
Enter that amount in Column C "5% owed for this range" of the row where you entered your date range.<br />
<br />
Column G calculates the running balance.<br />
<br />
If there is a negative number in that column, we do not need to do anything.<br />
<br />
If the amount is 0, do not do anything.<br />
<br />
If the amount is a positive number, go to the bank account and pay the amount from Column G. In the memo line, write 5% Tree of Life OBC.<br />
<br />
On the Deductions and Deposits sheet, on a new row, enter today's date in Column A "Start Date", in column "D "Amount Paid" - enter the amount you just paid through the bank. In Column F "Payment made via" write "FNB Bill Pay". Coumn G should now say $0.00.</div>Serenity152102