Pay by Bank Reporting and Settlement

Pay by Bank: Reporting & Settlement

How to find Pay by Bank transactions, reconcile deposits, and understand settlement timing

Pay by Bank reporting lives in Dutchie POS Backoffice under Reports. This article covers where to find Pay by Bank data, how to reconcile your deposits to your closing report, and how settlement timing works. For a video walkthrough of reconciliation, see the StoreOps Reporting section.


When Will My Deposit Arrive?

Pay by Bank batches are processed daily covering the full transaction date — midnight to 11:59 PM local time. Deposits arrive on the next business day after the transaction date.

  • Deposits are net of processing fees — fees are deducted before disbursement. Learn more about Pay by Bank fees.
  • On bank holidays, deposits are made the following business day.
  • If you use one bank account across multiple locations, each location's deposit is transferred separately.

The deposit line item in your bank account will look similar to this:

Example Pay by Bank deposit line item as it appears in a bank account.

Need to update the bank account on file for deposits? Learn how to update your bank account here.


Pay by Bank on the Closing Report

The Closing Report is your starting point for daily reconciliation. Pay by Bank totals appear in two places:

  • Pre-Payments (under Payment Summary) — the total amount customers paid via Pay by Bank for the day. This includes tips and processing fees have not been deducted.
  • Income Summary > Total Tips — all tips across all payment methods including Pay by Bank.
  • Income Summary > Pay by Bank Tips — Pay by Bank tips specifically.
  • Income Summary > Non-Revenue Donations > Pay by Bank Fee — optional surcharge fees, if your store has surcharging enabled.

Closing report showing Pay by Bank Pre-Payments and Income Summary sections.


Your closing report Pre-Payments total is the gross amount customers paid. Your bank deposit will be lower because processing fees are deducted before disbursement. The two reports below let you reconcile from gross to net.

Total Income (closing report Pre-Payments)$8,061.72
− Processing Fees$261.30
= Bank Deposit (Disbursement)$7,800.42
Sales Report
Best for daily reconciliation
  • Auto-totaled — no export needed
  • Shows total income, fees, and disbursement in one view
  • Fastest way to confirm your deposit matches the closing report
  • Note: voided transactions at the register won't appear here
Settlement Report
Best for transaction-level detail
  • Full transaction-level breakdown
  • Use when discrepancies exist or voided transactions need investigating
  • Requires export to get column totals
  • Transactions won't populate until the batch closes for the day

Using the Sales Report to Reconcile

The Sales Report is the fastest way to reconcile your Pay by Bank deposits day-to-day.

  1. Go to Reports > Sales Report
  2. Set it to your location and select the transaction date
  3. Run the report and scroll to the bottom to find the payment method breakdown
  4. Change the dropdown from Gross Sales to Total Income
  5. The Pay by Bank line will match your closing report Pre-Payments total
  6. Click into the Pay by Bank line and scroll right to see the Disbursement Amount — this is what hits your bank account

Note: If a Pay by Bank transaction was voided or canceled at the register, it will not appear on the Sales Report and may cause a discrepancy. Use the Settlement Report in those cases.

Using the Settlement Report to Reconcile

The Dutchie Pay Settlement Report gives you a full transaction-level breakdown and is the best tool when you need to investigate discrepancies or review individual orders. Find it in Backoffice under Reports by searching for "Dutchie Pay Settlement Report".

  • Run it for the specific transaction date you're reconciling
  • Scroll right to find the key columns: Transaction Amount, Transaction Fees, and Disbursement Batch Total
  • The report does not auto-total — export to Excel or Google Sheets to sum columns
  • Transactions will not populate until the batch closes for that day

Dutchie Pay Settlement Report showing transaction columns.

Settlement Report: Column Definitions

Column Definition
Batch File The Batch ID — use this to group transactions with a specific deposit
LL Transaction ID The Dutchie POS order number
Transaction Amount Cart total + optional surcharge + tip. Totaled across all rows, this matches your closing report Pre-Payments.
Transaction Fees The Pay by Bank fee charged to the merchant. Deducted from the transaction at the time of deposit.
Disbursement Amount Transaction Amount minus Transaction Fees — the net amount per transaction
Disbursement Batch Total The total deposit amount for the batch — what hits your bank account
Transaction Tip Amount The tip amount for that individual transaction

Tip: To see how a Pay by Bank transaction was completed (E-Commerce, Kiosk, or in-store), run the Payments report. Use the Order Source and Order Type columns to identify the channel.


Pay by Bank Tip Reporting

For a breakdown of tips by budtender for a given date range, go to Reports > Employee and select either Tip Summary by Employee or Tip Summary by Terminal.

Note: Tips are paid out as part of the order total in your deposits. How tips are distributed to budtenders is determined by your store's process and applicable state regulations.

Was this article helpful?