VauPrime Docs
VauPrime DocsFinance InsightsReconciliation Cashbook
Finance InsightsCurrent app behaviorDart-source backed

Reconciliation Cashbook

A step-by-step guide to VauPrime physical cash reconciliation: select a date and Cash-in-hand ledger, inspect vouchers and closing balance, count notes and coins with narrated lots, explain variances, and save or edit reconciliation history.

Cash basis

Cash-in-hand ledger

Choose a cash account and a selected date

Voucher categories

4 types

Payment, Journal, Contra, Receipt

Cash values

10 denominations

₹2,000 down to ₹1, including coins

Results

MATCHED / EXCESS / SHORT

Calculated from the final cash difference

What is Reconciliation Cashbook?

Purpose and current behavior of this feature.

Reconciliation Cashbook is a physical cash-verification workspace. It compares the selected Cash-in-hand account's accounting closing balance against manually counted notes and coins for a selected date. It is not bank-statement import or automatic bank reconciliation.

The screen reads the account ledger for the relevant financial year, computes the selected day's opening balance from the financial-year opening and prior movements, then summarizes same-day Payment, Journal, Contra and Receipt ledger entries. It presents the totals and lets the operator count cash by denominations and optional narrated lots.

Users can record an optional positive or negative difference adjustment with an explanation. This does not create a payment, receipt or journal voucher. The result, counts, notes and reconciled timestamp are saved, and previous reconciliations can be reviewed, edited or deleted.

Android UI structure

Screen-by-screen structure, tabs, lists, taps and action behavior on Android.

Global HeaderReconciliation Cashbook is shown beneath the app's mobile header in a vertically scrolling screen with cards and date/account controls.
Cash Reconciliation heroTeal header with the selected Cash-in-hand account, selected date, two selectors and tabs for reconciliation and history.
Date selectionDate picker allows dates from 2020 through today. Changing date loads relevant financial-year and day ledger movements.
Cash Account selectorOnly accounts whose group_account is Cash-in-hand appear. The first eligible account is used initially if one has not been selected.
Summary sectionCards show opening balance, receipts, payments and closing balance, with contextual reconciliation counts/status.
Voucher summaryPayment, Journal, Contra and Receipt categories show summarized debit and credit movement for the selected day.
Cash-counting panelResponsive denomination tiles display note quantity, number of lots and corresponding amount. Tap a tile to edit its cash lots and narration.
Difference sectionCounted total, ledger closing balance, raw difference, signed adjustment and final difference show whether cash is matched, excess or short.
Adjustment sectionOptional Positive/Negative type, adjustment amount and required reason when amount is non-zero. These notes explain accepted differences, not accounting postings.
Save actionsClear Count resets the denomination input; Save Reconciliation stores a result. In edit mode, Update Reconciliation replaces the saved record.
History tabPrevious reconciliations display in a table/list with date, cash account, closing balance, counted cash, final difference, status and saved time.

Windows UI structure

Desktop layout, wide-screen controls, tables and row actions on Windows.

Desktop shellWindow Global Sidebar and Global Header surround the Reconciliation Cashbook workspace.
Responsive heroThe teal summary puts title and date/account selectors side by side on wide layouts, stacking when space is limited.
Ledger overviewSummary cards and voucher movement breakdown use the available width; the ledger can be opened for investigation.
Count panelAt widths of at least 940 px, the denomination grid and reconciliation summary are side by side. Denominations display 2–4 columns depending on available width.
History tableSortable table with row numbers, hover details and Edit/Delete actions. Clicking a history row also opens it for editing.
EditingSelecting a history entry loads its account, date, saved note, denomination counts, positive/negative adjustment and narrated cash lots into edit mode.
History scopeHistory is limited to the authenticated user's 100 most recent records sorted by reconciliation and creation timestamps.

Fields, formulas, and saved values

The current app's source-level reconciliation calculation and persistence model.

Selected DateThe day being reconciled, rather than a selectable date range. Date controls disallow future dates.
Cash AccountAn account whose group_account exactly equals Cash-in-hand. The displayed selection is by account_name.
Financial-year openingWhen a selected financial year ID is available, the opening is obtained using AccountLedgerService.getOpeningBalanceFromSnapshotTable for the chosen account.
Opening BalanceFinancial-year opening plus the account's debit minus credit movements between financial-year start and the day before the selected date.
Receipts and PaymentsFor same-day entries the screen aggregates debit into receipts and credit into payments for Payment, Journal, Contra and Receipt voucher categories.
Closing BalanceOpening Balance + Total Receipts - Total Payments.
Entry countNumber of ledger entries on the selected date. The reconciliation count widget is an indicator, not an item-by-item voucher matching audit.
DenominationsSupported rupee values: 2000, 500, 200, 100, 50, 20, 10, 5, 2 and 1.
Cash lotsA denomination can contain one or more cash lots with quantity/narration. The total number of lot lines is capped at 1000 during save.
Counted CashSum of denomination value multiplied by count for each denomination.
Raw DifferenceCounted Cash - Closing Balance. Positive means physically excess cash; negative means short cash.
Adjustment TypePOSITIVE adds adjustment amount to raw difference. NEGATIVE subtracts it. No type contributes zero.
Final DifferenceRaw Difference + signed Adjustment. A difference with absolute value less than ₹0.01 is treated as matched.
StatusMATCHED when |final difference| is under 0.01; EXCESS when it is positive; SHORT when it is negative. Before saving a new reconciliation, display status starts at PENDING.
Optional NoteFreeform reconciliation note saved alongside the result.
Saved date rangeA record includes reconcile_date and selected-day start_date/end_date (end set to 23:59:59).
Saved voucher summaryPer-type receipt and payment totals for the four cash voucher categories.
DatabaseThe cash_reconciliations table stores the snapshot, denominations, adjustments, final difference, status and related timestamps. Child cash lots are saved together through an RPC.

Reconcile a cash balance — complete workflow

Follow the current in-app flow from start to completion.

01

Open the feature

Sign in, select the desired organization, and choose Finance Insights → Reconciliation Cashbook.

02

Choose a cash account

Select a Cash-in-hand account from the account selector. No eligible cash accounts means the reconciliation form has no cash ledger to work with.

03

Pick the reconciliation date

Use the date picker for today or an earlier supported date. The screen resolves the date's financial-year context and fetches the account ledger.

04

Review balances

Check opening, receipt, payment and closing figures. Expand the Payment, Journal, Contra and Receipt day-summary sections if needed.

05

Count cash physically

Tap each denomination tile; enter counted quantities and, where necessary, separate narrated lots. Verify the combined Counted Cash total.

06

Compare counted and ledger totals

Read the raw difference: a positive result indicates excess counted cash, a negative result indicates shortage, and zero indicates a match.

07

Add an optional explanation adjustment

If accounting policy permits a variance explanation, select Positive or Negative, enter a nonzero amount and give a reason. It changes the reconciliation comparison only.

08

Add a note and save

Enter any optional reconciliation note and select Save Reconciliation. Results can be MATCHED, EXCESS or SHORT, subject to validation.

09

Review history

Open History to see the latest saved reconciliations, their dates, cash accounts, counted cash, final difference and status.

10

Edit or delete

Select a history record to load it for editing, change cash counts or adjustments and save again. Delete requests confirmation and removes the reconciliation record, not ledger transactions.

Validation and common checks

Checks and restrictions applied by the current screen.

Authentication is required, and a cash account and reconciliation date must be selected.
The Cash Account list includes only accounts grouped under Cash-in-hand.
Negative ledger closing balances are restricted from reconciliation. The screen directs you to open and correct the Account Ledger first.
An already MATCHED record cannot be saved again from ordinary create mode; use History → Edit to update an existing saved entry.
When Adjustment Amount is positive, select Positive or Negative. A reason is mandatory for a nonzero adjustment.
The final matched threshold is absolute difference below 0.01, not arbitrary rounding to a whole rupee.
The cash-lot payload cannot exceed 1000 lines.
Delete removes only the reconciliation record, not payment, receipt, journal or other ledger entries.
An old reconciliation can be edited only if its stored account still exists among available Cash-in-hand accounts and its saved ID and date are present.

Important behavior and notes

Details worth knowing before using the feature in daily work.

Worked example: opening ₹18,000 + receipts ₹7,500 - payments ₹5,000 = closing ₹20,500. If counted cash is ₹20,500, raw and final differences are ₹0 and the result is MATCHED.
Worked shortage example: closing ₹20,500, counted cash ₹20,400, raw difference -₹100. Without an adjustment the saved status is SHORT. A justified POSITIVE adjustment of ₹100 changes final difference to zero and status to MATCHED but does not post ₹100 to the accounting ledger.
Worked excess example: closing ₹20,500 and counted cash ₹20,600. The raw difference is +₹100 and the status is EXCESS unless the final difference is changed by an adjustment.
The app uses AccountLedgerService.getAccountLedger and the financial-year opening snapshot to compute account movement. It does not import paper cash counts or bank statements automatically.
Reconciliation history is retrieved from cash_reconciliations for the signed-in user with a 100-record limit. Source queries match saved status by user, account name and date.
The write operation invokes Supabase RPC save_cash_reconciliation_with_denominations with p_payload, p_lines and optional p_edit_id to save the reconciliation and its narrated cash lots atomically.
This is physical-cash reconciliation. It should not be confused with the separate bank reconciliation feature.
The website feature overview at www.vauprime.com/reconciliation-cashbook is informational; the source-backed workflow lives in VauPrime's native app.