VauPrime Docs
Finance InsightsCurrent app behaviorDart-source backed

Cash Book

Detailed documentation of VauPrime CashbookScreen: select a Cash-in-hand ledger and date range, review debit-side receipts and credit-side payments, understand financial-year opening balances and calculate the resulting closing balance.

Main tabs

2

Receipts and Payments

Balances

4 figures

Opening, Receipts, Payments and Closing

Account scope

Cash-in-hand

Selected organization's cash ledgers

Default period

Today

Custom start and end date picker

What is Cash Book?

Purpose and current behavior of this feature.

The VauPrime Cash Book is a cash-ledger report for a selected Cash-in-hand account. It shows accounting entries that affect that account, separates receipt and payment movements, and calculates the opening and closing cash balance for the chosen reporting period.

When the screen opens it defaults to the current day and selects an available Cash-in-hand account from the current organization. You can change both the account and the From/To dates. Records come from transaction_entries joined to transactions, not from manually entered physical note counts.

Cash Book is not the Reconciliation Cashbook: it reports ledger movements. To count physical currency and compare it with the ledger, use the separate Reconciliation Cashbook feature. The Cash Book screen also does not implement an export despite displaying a download icon.

Android UI structure

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

Cash Book headerA teal gradient header labels the screen Cash Book and contains the voucher-number display toggle and a download-style icon with no action implemented.
Date rangeThe first filter chip opens two date pickers. Select a From date, then an End date; changing the range reloads the selected cash ledger.
Cash account selectorThe second filter chip opens a generic bottom-sheet selector listing account names grouped under Cash-in-hand.
Opening KPIShows cash opening at the beginning of the selected reporting period, using the financial-year snapshot and earlier ledger movements.
Receipts KPISum of the selected account's debit_amount values from its loaded transaction rows.
Payments KPISum of credit_amount values from loaded transaction rows.
Receipts tabShows transaction rows for which debit_amount is positive. Displays the related contra-account context and optional voucher number.
Payments tabShows rows for which credit_amount is positive. Displays counterparty and date in the same shared card layout.
Closing BalanceBottom card calculates Opening + Receipts − Payments and uses teal for nonnegative closing, red for negative closing.
RefreshPull down to refresh the Cash Book; a shimmer skeleton is shown during initial and active loading.
No activityThe Receipts and Payments tabs show an empty-state message when no entries exist for the selected period.

Windows UI structure

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

Shared CashbookScreenThe Windows implementation uses the same Flutter CashbookScreen rather than a separate dedicated desktop table.
Back navigationA dedicated back button is shown in the header when the current platform is Windows.
Date and account filtersThe same From/To date picker and Cash-in-hand account bottom sheet are available on desktop.
Receipts / Payments tabsTwo tabs display side-specific transaction lists, with counts in the labels and optional voucher numbers.
Account closingOpening, receipts, payments and closing are computed from the selected cash account and date range, using the shared calculation.
LimitationsThe screen is a read-only ledger report. The download icon has an empty callback; no export action is provided by this widget.

Cash Book fields, data sources and calculations

The current Flutter cashbook.dart implementation, including how transactions and opening snapshots are combined.

Selected OrganizationThe signed-in user's current organization (fvs_id), used to scope the Cash-in-hand accounts and selected account's entries.
Cash AccountAccounts are queried from accounts where group_account = Cash-in-hand. Account names and IDs are mapped for efficient entry matching.
Default Cash AccountThe first available Cash-in-hand account is selected when necessary. When no accounts exist the UI falls back to the label Cash, which is not proof that a real Cash master exists.
Date RangeInitially starts at 00:00 today and ends at 23:59:59 today. Custom picker begins no earlier than 2020, ends no later than today and requires End date on or after Start date.
Entry RetrievalSelects transaction_entries joined with transactions by current user, organization, account_id and transaction date. A separate account-name query supports older rows.
De-duplicationCombines account-ID and account-name matches keyed by row ID when present, otherwise by a composite of transaction, account and amounts.
Contra AccountQueries the other entries belonging to each transaction and shows the counterparty account; a missing counterparty is labelled Unknown.
Split CounterpartiesWhen a transaction has multiple contra-account rows, the display expands corresponding rows and may mark follow-on rows with show_blank rather than treating every display line as an independent voucher.
Financial-year ContextLooks up financial_years to find the year covering the From date, falling back to the current financial year record when needed.
Opening SnapshotReads account_opening_balances for the chosen financial_year_id and account_id when available.
Opening BalanceOpening snapshot plus the sum of debit_amount minus credit_amount for that cash account's earlier movements between the financial-year start and the selected From date.
Receipts TotalSum of debit_amount across loaded display rows. The Receipts tab filters to positive debit_amount rows.
Payments TotalSum of credit_amount across loaded display rows. The Payments tab filters to positive credit_amount rows.
Closing BalanceOpening + Receipts − Payments. Displayed in teal when nonnegative, red when negative.
Voucher Number ToggleHeader icon controls _showVoucherNo and changes whether voucher numbers are shown in the transaction tiles.
Receipt/Payment Tab CountsThe two tab labels show the number of displayed receipt and payment rows, not necessarily the count of distinct voucher headers when contra splits exist.
Download ActionThe icon is visible but its onTap callback is empty in the current source. No download file is generated.

How to use Cash Book — step by step

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

01

Select your organization

Sign in and choose the correct business before opening Finance Insights.

02

Open Cash Book

The screen loads today's transactions and an available cash ledger. Check the displayed account name.

03

Change cash account if needed

Open the account picker and choose a specific Cash-in-hand ledger, for example Cash or Petty Cash.

04

Select dates

Open the date chip, choose From date then To date. The report reloads the transactions for the new period.

05

Review the opening balance

The opening includes the selected financial-year opening snapshot and earlier cash ledger movements before the chosen start date.

06

Inspect Receipts

Select the Receipts tab for positive debit cash movements, counterparty context, amounts and optional voucher references.

07

Inspect Payments

Open Payments to review credit cash movements using the same account and date filters.

08

Toggle voucher numbers

Use the receipt icon at the top to reveal or hide available voucher numbers in the rows.

09

Verify closing

Compare Opening + Receipts − Payments with the Closing Balance card.

10

Refresh when needed

Pull down to refresh after transactions change. Use Reconciliation Cashbook separately if physical cash counting is required.

Validation and common checks

Checks and restrictions applied by the current screen.

Authentication and selected organization are needed to read cash accounts, transaction entries and financial-year information.
The Cash Account list is limited to group_account = Cash-in-hand. If none exist, the fallback Cash label may have no actual ledger backing it.
The date picker permits From and To dates between 2020 and today; To cannot be earlier than From.
Entry matching prioritizes account_id but also fetches account-name matches for historical rows. Results are merged to avoid double inclusion of the same row ID.
Receipt and payment tabs classify rows by the sign of debit_amount or credit_amount, not solely by voucher_type. This means the report is not restricted to Receipt and Payment voucher header types.
Opening calculation relies on financial-year and opening-balance records when available. Missing opening data can change the starting cash figure.
The display can expand a transaction with several counterparty accounts into multiple lines. Tab row count is not necessarily distinct voucher count.
The icon for downloading is not implemented; do not expect a file when tapping it.

Important behavior and notes

Details worth knowing before using the feature in daily work.

Source: App_P0_VauPackage/lib/screens/FinanceInsights/CashBookAndDayBook/cashbook.dart (CashbookScreen and _CashbookScreenState).
Worked example: opening ₹18,000 + cash receipts ₹7,500 − cash payments ₹5,000 = closing ₹20,500. These numbers are illustrations, not a live account.
The opening query chooses a financial year covering the period start when possible; it obtains a snapshot from account_opening_balances and adds transactions earlier than the period From date.
Technical nuance: the view expands multi-counterparty vouchers into several rows and _calcBalances sums the displayed _transactions rows. If a complex voucher yields surprising totals, inspect the account-ledger entries and contra breakdown rather than assuming there is only one row per voucher.
The transaction query uses transaction_entries joined to transactions with account ID and legacy name fallback. The displayed counterparty name comes from other entries in the same transaction.
The report is not the Reconciliation Cashbook and cannot count ₹500, ₹200 or other physical denominations. Physical reconciliation and difference adjustments belong to a separate screen.
Cash Book currently does not export or edit transactions directly, and it does not present a separate running balance after every individual voucher row.
The feature overview at www.vauprime.com/cash-book is informational; the actual data is accessible after signing into the native VauPrime app.