Petty Cash Log Essentials-Vorlage
Track small cash transactions with date, description, and amount. Maintain a running balance and reconcile the petty cash fund.
Was enthalten ist
- 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
Vorschau
Sehen Sie, was in dieser Vorlage enthalten ist
So verwenden Sie diese Petty Cash Log-Vorlage
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.
Erstellt von Claude AI. Verfeinert von uns.
Wir verwenden Claude AI, um jede Vorlage nach gründlicher Recherche zu entwerfen. Dann greift unser Team ein. Wir verfeinern das Layout, testen jede Formel auf Herz und Nieren, beheben Grenzfälle und polieren das Design, bis es sich anfühlt wie etwas, das wir selbst verwenden würden. Die KI bringt uns 80 % ans Ziel. Die letzten 20 % sind rein menschliches Urteilsvermögen.
Häufig gestellte Fragen
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.
Wie öffne ich diese Vorlage in Google Sheets?
Laden Sie die .xlsx-Datei auf Google Drive hoch und öffnen Sie sie mit Google Sheets. Alle Formeln und Formatierungen bleiben erhalten.
Weitere Essentials-Vorlagen: Business Finance
Auf der Suche nach Premium-Tabellenvorlagen?
Unsere kostenpflichtigen Vorlagen umfassen erweiterte mehrseitige Dashboards, native Excel-Diagramme und laufende Aktualisierungen.