I am working on a simple spreadsheet and would like to know if the answers are correct (the formula that I am most concerned with is the formula in the "difference" column). Log 1 and Log 2 are two petty cash accounts and when the bookkeeper pays a vendor from petty cash, it is entered into the finc'l records. So looking at the spreadsheet below, it appears that $155 was taken from petty cash and only $50 was paid towards coffee. This would mean that $105 is missing. On the other hand, it looks like two vendors were overpaid for Gardening service and Co Mtg. I want to make sure this spreadsheet is correct. Does this look accurate??
Thank you in advance.
<tbody>
</tbody>
Thank you in advance.
Log 1 | Log 2 | TTL of L1 & L2 | Finc'l Records | Difference | |||
$150 | Coffee | $5 | Coffee | $155 | $50 | Coffee | -$105 |
$253 | Gardner | $10 | Gardner | $263 | $323 | Gardener | $60 |
$328 | Co Mtg | $28 | Co Mtg | $356 | $596 | Co Mtg | $240 |
<tbody>
</tbody>