Tills

tills records a cash drawer from the float a shift starts with to the bank deposit that cash becomes. The count at the end of the day books its difference in accounting, and a deposit is matched to the bank transaction that shows it.

better-supabase add tills

import { createTills } from "better-supabase/blocks/tills";

The module requires memberships, permissions and subjects. With accounting a till with a cash account books count variances and deposits. With banking a deposit can be reconciled to a bank transaction. outbox records the events and audit audits every change. The pos preset installs the block.

TablesCopy Anchor Link

A shiftCopy Anchor Link

createTill takes a name, a currency that never changes and, for bookkeeping, the accountId of the accounting account that holds the till's cash. A till has one open session at a time. The expected cash is the float plus sales and cash in minus refunds and cash out, and a refund or cash out cannot take more than the drawer holds.

const tills = createTills({ transport, tenant: organizationId });

const till = await tills
  .createTill({
    name: "Front counter",
    currency: "EUR",
    accountId: cashAccount,
  })
  .orThrow();

const session = await tills
  .openSession(till.id, { openingFloat: money(10_000n, "EUR") })
  .orThrow();

await tills
  .recordMovement(session.id, "cash_sale", money(25_000n, "EUR"))
  .orThrow();

Closing and the countCopy Anchor Link

closeSession counts the drawer from denominations, a map of a note or coin value in minor units to how many there are, or from a total amount. It stores the expected cash, the counted cash and the variance, and closes the session. A non-zero variance is booked in accounting: an overage debits the till account and a shortage credits it, against the suspense account role. A till without a cash account keeps the count and books nothing.

const closed = await tills
  .closeSession(session.id, { denominations: { "5000": 6, "1000": 2 } })
  .orThrow();

closed.count?.variance; // money(-1000n, "EUR")

Deposits and reconciliationCopy Anchor Link

deposit takes counted cash to the bank from a closed session. The deposits of a session never add up to more than its count. With accounting the deposit books the bank account role against the till account. reconcileDeposit passes a bank transaction to banking's matching with the deposit's accounting entry, then marks the deposit reconciled. The transaction's amount must equal the deposit's.

const deposit = await tills
  .deposit(session.id, { amount: money(32_000n, "EUR"), reference: "Bag 1" })
  .orThrow();

await tills.reconcileDeposit(deposit.id, bankTransactionId).orThrow();

ErrorsCopy Anchor Link

EventsCopy Anchor Link

The hooks are before_till_session_open, after_till_session_open, before_till_session_close, after_till_session_close, before_till_deposit and after_till_deposit.

Without the clientCopy Anchor Link

create_till, update_till, list_tills, open_till_session, get_till_session, list_till_sessions, record_till_movement, close_till_session, deposit_till_cash and reconcile_till_deposit are plain SQL functions. In custom mode you implement them over your own tables.