I will create a daily cash closing spreadsheet that finds the difference for you

At the end of the day the money in the drawer never matches what the system says, and nobody knows where it went. This sheet tells you.

You enter what was sold by payment method, the change fund, the withdrawals and what is physically in the drawer. It calculates what SHOULD be there and shows the gap: OK, SHORT or OVER, in colour, with the exact amount.

What you get:

- A day sheet ready to print and sign

- A month dashboard showing which days had losses

- A full log of every entry

- An instructions tab in plain language

Works in Excel and in Google Sheets.

Em português: no fim do dia o dinheiro da gaveta não bate com o sistema. Essa planilha aponta a diferença sozinha: OK, FALTA ou SOBRA, com o valor. Vem com a folha do dia pronta para imprimir e um painel do mês.