Reports

Reconcile Sales by Payment Method

The Types tab is the payment-method control total. Run it for the same branch and time window as the till close, then compare each method with the drawer, terminal, bank or wallet evidence.

Menu path
Reports -> Money -> Payment -> Types
Verified from
Posnic demo and current POS source reviewed on 2026-09-08
Technical source evidence

frontend/modules/paymentReport.html, frontend/static/script/js/modules/js/report_payment.js, api/src/controllers/sales.controller.js paymentSaleTypeReport, api/src/repositories/sale.repository.js getPaymentSaleTypeReport

Payment method totalsLive demo captured 2026-09-11. Cash and card appear as separate control totals with partial, outstanding, refund and transaction columns.

Run the Payment Method Summary

  1. Open Reports -> Money -> Payment.
  2. Keep Types selected.
  3. Open Filter and choose the exact date range and branches used for close.
  4. Apply the filter.
  5. Read one row per payment method.
  6. Compare each row with its independent settlement evidence before approving the close.

Read Every Column

ColumnMeaningControl use
Payment TypeConfigured tender label stored on the sale or split-payment entry.Match the label to the drawer, terminal, bank or wallet.
Total AmountRecorded sale amount for the method; split tenders contribute their individual method amount.Primary method control total.
Partially CollectedThe sale partial balance apportioned by each split tender's share when multi-payment is present.Flag bills that were not fully collected.
Outstanding AmountPayment pending amount, apportioned across split methods when applicable.Reconcile with Pending Payment Reports.
RefundsRecorded returned amount, apportioned across split methods when applicable.Compare with return transactions and provider refunds.
Total TransactionNumber of sale records contributing to the method; a split sale can increment more than one method.Do not treat this as a customer or invoice count.

How Split Payments Affect Totals

  • For a sale with a populated multi_payment object, Posnic sums each positive method amount separately.
  • Partial, outstanding and refund values are divided among those methods in proportion to each method's share.
  • A split sale increments the transaction count once for every positive method entry.
  • When no usable split-payment data exists, the full sale is assigned to payment_mode.
  • Blank and N/A method rows are excluded from the displayed summary.

Close-Day Reconciliation

  1. Use the same date boundaries and branch everywhere.
  2. Compare cash with counted cash after opening float and authorized cash movements.
  3. Compare card, UPI, bank and wallet rows with provider batch totals.
  4. Open Sale Payment Transactions for the bills behind an unexpected method total.
  5. Open Return Sale Payment Transactions for refund evidence.
  6. Record unresolved differences before closing the register.

Troubleshooting

ProblemCheckAction
Method is missingPayment label, branch and date scopeCorrect the scope and confirm the sale stored that method.
Split total looks unexpectedmulti_payment values and each method's shareTrace the original bill and tender breakdown.
Cash differs from drawerOpening float, cash in/out, refunds and wrong tender labelsReconcile register activity before changing records.
Card differs from providerSettlement cutoff, failed or duplicated paymentMatch individual sale transactions to provider references.
Report is unavailableReport Read permission and plan accessCorrect role or subscription access.

Related Manual Pages

Reports Sale Payment Transactions This tab is the bill-level trail for completed and partially returned sales. Use it when a payment-method total does not match the till or external provider. Reports Return Payment Transactions The return-payment tab is the refund trail for partial and full returns. An empty result means no matching return records in the selected scope, not that returns are disabled. Reports Day-End Summary Day-End Summary is the owner and cashier close report for the selected date range and branch. It ties sold items, tender totals, discounts, tax and shop identity into one review. Registers Daily Close A sale is not fully controlled until the register and payment totals are closed and explained. Settings Payments Payment settings decide which labels cashiers can choose at checkout and whether one bill can be split across methods.