Offering count sheet · Otherworld Labs
Enter the count once. The sheet foots three ways: against the funds you allocated, against the deposit slip, and against the cheque tape, and it prints each variance it can to the cent.
This sheet sums the figures you enter and prints whether the three legs foot. It is not an audit and it does not say whether a count is right. It keeps nothing of your count: no cookie, no account, and it does not hold last week's count, which is the workbook's job; the one thing it does remember is whether you left the walkthrough open. No figure you type is sent anywhere. It records; it does not control. Questions about tax, restricted-fund obligations or your denomination's requirements go to your denomination's finance office.
The figures on this sheet are the worked example it ships with, so the sheet shows a real result before you touch it. They are nobody's count. Type your own figures over them, or press Clear the sheet, which blanks every figure and leaves the two counts of lines to show where they are.
The walkthrough is on. Each part says what its figures are and who at the table holds them. Turn it off at the top once you know your way around.
Two unrelated counters sort the cash into piles and read the piece counts off the sorted piles in front of them. Enter the number of pieces, not the amount: the sheet multiplies by face value, foots the notes and the coin separately, and adds them.
A denomination you have none of can be left blank. A blank line in a grid that has figures in it is read as none of that denomination; a grid with nothing in it at all is read as a grid nobody has filled in, and the lines print as not entered instead of as zero.
Kept only this week's totals? Type the cash total and the designated total, leave the denomination grid and the fund amounts blank, and the sheet still foots the funds leg and the deposit leg; the cheque leg prints not entered, because one tape total cannot be checked against itself.
One line per cheque, the amount and nothing else. There is no field for a giver's name here and there is none in the workbook either: this sheet records what was counted, not who gave it.
The counter who listed the cheques ran them through an adding machine first. Enter how many the tape says and what the tape totalled: the sheet closes your listed lines to that tape, which is the only check a cheque list has on itself.
A line you take off the sheet keeps whatever you typed in it, and this sheet reads only the lines it shows. An amount left on a line it does not read is counted, summed and named in the entry notes, it is in none of the figures, and the sheet prints no all-clear while it stands. Press Clear the sheet to empty every line at once.
No cheques at all this week? Type 0 as the tape total and leave the lines blank, and the sheet foots the cash on its own.
The counter reading the envelope lines and the cheque memos allocates the money to funds. Four funds are fixed; two more are yours to name, for a restricted fund your church has decided on. Fund names only here: a giver's name belongs in neither this sheet nor the workbook.
What remains after the envelopes and memos are allocated is loose cash, and the funds leg is exactly how much of it there is.
A fund that got nothing this week can be left blank. A fund is a fixed category, so a blank line among lines that have figures in them is read as none of that fund, the way a blank line in the denomination grid is; a block with nothing in it at all prints not entered. A cheque line is different: it is an item, not a category, and a blank cheque line is no cheque, which is how the sheet can tell the tape's count of cheques from the lines you have written down.
A restricted fund line you take off the sheet keeps whatever you typed in it, just as a cheque line does. An amount left on a line this sheet does not read is counted, summed and named in the entry notes, it is in neither the designated total nor any variance, and the sheet prints no all-clear while it stands.
Leave every fund amount blank and this one figure stands in for them. Put a figure in any fund line and the lines become the record; the typed total is then set aside, not compared.
Whoever writes the slip writes one figure: cash and cheques together, the amount the sealed bag is supposed to contain. Leave it blank until the slip is written, and the deposit leg prints not entered instead of a figure built from a blank.
Every denomination, cheque and designation you enter is summed in front of you, and the sheet shows whether the designations foot to the deposit total, and by how much if they do not. On this sheet the deposit total in that sentence is the counted total for the bag, the cash and the cheques this sheet has: the total written on the slip is a leg of its own, and the funds leg closes the designations to the count. The lines here are the arithmetic, worked from the figures as printed.
| Denomination | Pieces | Value |
|---|---|---|
| $100 notes | 2 | $200.00 |
| $50 notes | 3 | $150.00 |
| $20 notes | 14 | $280.00 |
| $10 notes | 9 | $90.00 |
| $5 notes | 21 | $105.00 |
| $2 notes | 1 | $2.00 |
| $1 notes | 37 | $37.00 |
| $1.00 coins | 4 | $4.00 |
| $0.50 coins | 6 | $3.00 |
| $0.25 coins | 28 | $7.00 |
| $0.10 coins | 41 | $4.10 |
| $0.05 coins | 33 | $1.65 |
| $0.01 coins | 86 | $0.86 |
| Notes | $864.00 | |
| Coin | $20.61 | |
| Cash counted | $884.61 |
The funds, as the envelopes and the memos allocated them. Designation totals only; no row here or in the workbook carries a giver's name.
| Fund | Amount designated |
|---|---|
| General | $1,269.61 |
| Building | $500.00 |
| Missions | $125.00 |
| Memorial | $40.00 |
| Designated total | $1,934.61 |
One counted total, closed three ways, each against a figure from a different source: the envelopes and memos, the bank's slip, and the adding-machine tape. Each leg prints its own signed variance, and the sheet names which leg is out instead of saying only that the sheet is out. A leg whose second figure you have not entered prints not entered; it does not print a figure.
The designations and the count do not agree: the funds come to $1,934.61 and the count comes to $1,974.61, a difference of $40.00. That much of the count is designated to no fund at all, which is usually loose cash.
The designations against the slip, the one subtraction the three legs do not print: the designations come to $1,934.61 and the slip is written for $1,974.61, a difference of $40.00 with the designations under the slip. The gap between them, direction and all, is the funds leg's variance less the deposit leg's variance, and not a fourth closure: each of those two figures is already closed to the count, on a leg of its own.
| Leg | The leg's figure | Closed to | Variance |
|---|---|---|---|
| Designations allocated | $1,934.61 | $1,974.61 | -$40.00 |
| Deposit slip written | $1,974.61 | $1,974.61 | $0.00 |
| Cheque tape total | $1,090.00 | $1,090.00 | $0.00 |
This sheet foots one Sunday and forgets it when you close the tab. What it cannot tell you is what the building fund stands at in March, because that answer is a year of Sundays and one page holds none of them.
The kit is two files, for one price, yours to keep:
One payment, no subscription, no account on this site. A spreadsheet and a PDF; files, not software. Nothing on this page needs it, and this page stays free and complete without it.