Petty Cash Log Modelo Essentials
Track small cash transactions with date, description, and amount. Maintain a running balance and reconcile the petty cash fund.
O Que Está Incluído
- Dashboard with petty cash fund summary showing starting balance, total disbursed, and remaining fund amount
- Cash log with date, payee, description, and amount columns plus an automatic running balance after each entry
- Category tracking for each disbursement so petty cash spending can be grouped by office supplies, travel, meals
- Fund reconciliation support with replenishment entries to reset the cash balance to the original fund amount
- Color-coded input cells (yellow) and auto-calculated running balance (blue) for accurate cash tracking
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required
Pré-visualização
Veja o que tem dentro desta planilha
Como Usar Esta Planilha de Petty Cash Log
Set the fund amount
Enter the starting petty cash fund balance at the top. This is the amount initially placed in the cash box.
Log each disbursement
Record every cash payment with date, payee, description, amount, and category in the cash log.
Monitor the balance
The running balance updates after each entry. Check it against the actual cash in the box to verify accuracy.
Replenish the fund
When the balance gets low, add a replenishment entry to bring the fund back to the original amount.
Criadas com Claude AI. Aperfeiçoadas por nós.
Usamos Claude AI para criar cada planilha, após uma pesquisa aprofundada. Depois, nossa equipe entra em ação. Refinamos o layout, testamos exaustivamente cada fórmula, corrigimos casos extremos e polimos o design até que pareça algo que nós mesmos usaríamos. A IA nos leva 80% do caminho. Os últimos 20% são puro julgamento humano.
Perguntas Frequentes
How do I reconcile the fund?
Count the physical cash, add up outstanding receipts, and compare to the expected balance in the log. Any difference is a variance to investigate.
What categories should I use?
Common categories include office supplies, postage, meals, parking, and miscellaneous. Use whatever matches your typical small cash expenses.
How often should I replenish?
Replenish when the fund balance gets low - typically when 50% to 75% has been disbursed. The log entry restores the balance to the original amount.
Can I track multiple petty cash funds?
This template covers one fund. Duplicate the file if you maintain separate petty cash funds at different locations or departments.
Como abrir no Google Sheets?
Envie o arquivo .xlsx para o Google Drive e abra com o Google Sheets. Todas as fórmulas e formatações serão preservadas.
Mais modelos Essentials de Business Finance
Procurando planilhas premium?
Nossas planilhas pagas incluem painéis avançados com várias abas, gráficos nativos do Excel e atualizações contínuas.