Skip to main content

Reconcile Dockwa Payouts to Your Bank Deposits

Match each Dockwa deposit to its bank transfer, see what it contains, and reconcile cash, checks and External Transactions.

To reconcile, match each Dockwa deposit in your bank statement to a bank transfer in the Cash Revenue report, then export that transfer to see exactly which payments, refunds and fees make up the amount.

Cash and check you collected are reconciled separately, using manual payments and the Z-Out report for POS.

  • Who can do this: Finance, Admin

  • Where: Reports → Cash Revenue, Z-Out, Transactions

  • Before you start: Your bank statement for the period, and access to the Reports menu

Scenario: the $4,812.37 deposit

Dana, the bookkeeper at a 120-slip marina, sees a $4,812.37 deposit from Dockwa on Wednesday. She needs to book it against the right revenue, see what was refunded, and confirm cash from the fuel dock was deposited separately. Here is how she works through it.

Step 1: How do I find the transfer that matches my deposit?

  1. Go to Reports, open the Cash Revenue report and set Export Type to By bank transfer.

  2. Pick the year and month, then find the transfer with the same amount and Deposited date as the bank deposit.

  3. Export that transfer and open the Revenue Summary tab to see totals by category for that deposit, and the Payment Method Summary tab for totals by payment method.

If amounts don't match, check whether an earlier payout failed. Failed payouts roll into the next successful one, so one deposit can cover more than one period.

Step 2: How do I see every payment in that deposit?

  1. Open the Cash Revenue report.

  2. Set Export Type to By bank transfer and export the deposit, as in Step 1.

  3. Download the report. It lists each payment and refund with its payment method and reservation ID, plus totals by category and by payment method.

Use this file to post revenue by category and record card and ACH processing fees, which are taken out before the payout. Processing fees appear as their own row on the Revenue Summary tab and in the Processing Fee column of the Transaction Detail tab.

Step 3: How do I reconcile cash and checks?

Cash, check and manual ACH payments never appear in a Dockwa payout. Pull the Cash Revenue report with Export Type set to By date, which includes all offline transactions (cash, check, etc) by date processed, and match it to your own deposit slips.

For the POS register, run the Z-Out report for each day. It shows POS payments, refunds and tips by payment type, but excludes reservation and contract revenue.

Step 4: What about External Transactions?

External Transactions clear invoices without recording a payment. They show in the Transactions report and as an External Transactions line in the Accrual Accounting Report summary, never in Cash Revenue or a payout. Review them separately so write-offs and payments taken in other systems are booked correctly.

Step 5: How do I handle a deposit that is lower than expected or negative?

  • Large refunds in the period reduce the payout. Check the refund lines on the Transaction Detail tab.

  • If refunds exceed payments, Dockwa withdraws the shortfall from your bank. That withdrawal appears as a debit, not a deposit.

  • Disputed card payments can reduce your balance. The Cash Revenue and Transactions reports don't list disputes as separate lines; a disputed payment still shows as a payment, so compare a short deposit against your dispute notices.

Which report should I use for which question?

Question

Report

What made up this bank deposit?

Cash Revenue, by bank transfer

What did we collect, by category and method, on a cash basis?

Cash Revenue

Does the POS register balance today?

Z-Out

Every charge, failed charge and refund, including External Transactions

Transactions

Accrual revenue by service date

Accrual Accounting Report (plan dependent)

Related articles

Did this answer your question?