Petty Cash Log

Record every petty cash voucher and top-up with approvals and receipts, and see each cash box’s live balance and top-up alert.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Finance

Tables

Cash Boxes, Transactions

Fields

23

Views

grid, kanban, form, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Cash Boxes

8 fields · 2 sample rows

  • Balances (Grid)
Cash BoxTextCustodianTextFloat LimitCurrencyTransactionsLink to another tableCash InRollupCash OutRollupBalanceFormulaTop-up NeededFormula
Front officeLata Iyer₹10,000Opening float, Printer paper & toner, Tea, coffee & biscuits, Courier to Chennai client, Auto fare to bank, Change returned from supplies₹10,150₹4,910₹5,240OK
WarehouseMohammed Rafi₹5,000Opening float, Forklift tyre puncture repair₹5,000₹4,300₹700Top up ₹4300
Field details
Cash Box · Text
Custodian · Text
Float Limit · Currency
INR
Transactions · Link to another table
Links to Transactions
Cash In · Rollup
sum of In via Transactions
Cash Out · Rollup
sum of Out via Transactions
Balance · Formula
{Cash In} - {Cash Out}
Top-up Needed · Formula
IF({Balance} < {Float Limit} * 0.2, 'Top up ₹' & ({Float Limit} - {Balance}), 'OK')

Transactions

15 fields · 8 sample rows

  • Ledger (Grid)
  • Approvals (Kanban)
  • Request petty cash (Form)
  • Where cash goes (Dashboard)
DescriptionTextVoucher #AutonumberDateDateCash BoxLink to another tableTypeSingle selectCategorySingle selectAmountCurrencyInFormulaOutFormulaPaid ToTextRequested ByTextApprovalSingle selectApproved ByTextReceiptAttachmentNotesLong text
Opening floatPC-00015 Nov 2026Front officeTop-up₹10,000₹10,000₹0ApprovedKiran (Finance)
Printer paper & tonerPC-00027 Nov 2026Front officeExpenseOffice supplies₹2,850₹0₹2,850Sri StationersLata IyerApprovedKiran (Finance)
Tea, coffee & biscuitsPC-000310 Nov 2026Front officeExpenseTea & snacks₹1,420₹0₹1,420Chai PointLata IyerApprovedKiran (Finance)
Courier to Chennai clientPC-000413 Nov 2026Front officeExpenseCourier & postage₹480₹0₹480Blue DartAnilApprovedKiran (Finance)
Auto fare to bankPC-000516 Nov 2026Front officeExpenseLocal travel₹160₹0₹160Auto driverAnilPendingNo receipt – self-declared.
Change returned from suppliesPC-000617 Nov 2026Front officeRefund to box₹150₹150₹0Approved
Opening floatPC-00075 Nov 2026WarehouseTop-up₹5,000₹5,000₹0ApprovedKiran (Finance)
Forklift tyre puncture repairPC-000818 Nov 2026WarehouseExpenseRepairs₹4,300₹0₹4,300Ganesh Tyre WorksMohammed RafiPending
Field details
Description · Text
Voucher # · Autonumber
Date · Date
Cash Box · Link to another table
Links to Cash Boxes
Type · Single select
Expense, Top-up, Refund to box
Category · Single select
Office supplies, Tea & snacks, Courier & postage, Local travel, Repairs, Cleaning, Other
Amount · Currency
INR
In · Formula
IF({Type} = 'Expense', 0, {Amount})
Out · Formula
IF({Type} = 'Expense', {Amount}, 0)
Paid To · Text
Requested By · Text
Approval · Single select
Pending, Approved, Rejected
Approved By · Text
Receipt · Attachment
Notes · Long text

Form view “Petty cash voucher” asks for: Description, Date, Cash Box, Category, Amount, Paid To, Requested By, Receipt, Notes.

Petty Cash Log: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates