Basic Financial Reports: Accessing and Understanding the Bank Transfers Report

Follow

The Bank Transfers report is used to understand the amount and source of money deposited to or withdrawn from your business's bank account. Dockwa transactions are settled in your Dockwa account. The proceeds are then transferred, in batch, to your bank account based on the schedule you choose during setup.

A new Bank Transfers report is created each time money is transferred from your Dockwa account to your business's bank account.

Each report details what individual transactions are included in the lump-sum transfer from your Dockwa account to your bank account.

The lump-sum transfer can be associated with multiple reservations and multiple line items.

  

How to export the Bank Transfers report

  1. Go to "Reports" > "Transfers" 
  2. Each line item shown represents a transfer of funds from Dockwa to your business's bank account. To export the details of a particular transfer event, click into its line item.
  3. Click "Export"
  4. Your report will be emailed to you.

 bank_transfers.png

 

How the Bank Transfers report relates to the other reports

  • Transactions report
    • The "Reservation Payments" tab of the Bank Transfers report is essentially a Transactions report, focused on the transactions contributing to the lump sum transfer of funds in consideration
  • Invoices report
    • Use the Invoices report to understand the amount of funds you have billed your customers v. the amount of funds you have collected from customers in this transfer
    • Transactions accounted for in a Bank Transfer report may settle part or all of one outstanding invoice. 
  • Reservations report
    • Use this report to identify the details of the reservation with which a Transaction included in this transfer is associated.

 

How to read the Bank Transfers report

  1. Transfer summary: A categorized summary of all funds deposited to your business's bank account in the transfer
  2. Reservation payments: A Reservation Payment Report for the reservation-linked transactions included in the transfer.

 

In the Transfer Summary sheet:

  • The Columns show categories of summed payments included in the transfer
  • The Charges row shows the total charges associated with each column/category of payment
  • The Refunds row shows the total refunds associated with each column/category of payment
  • The Fee Refunds row shows the total amount of processing fees refunded back to the marina from associated refunds back to boater
  • The Total row shows the total funds in the transfer associated with each column/category of payment

 

The following columns are included in the Transfer Summary sheet (listed in order of appearance):

Value
Definition
Count Number of transactions included in the transfer.
Dockage Estimated dollar* value of dockage transactions included in the transfer.
Moorage Estimated dollar* value of moorage transactions included in the transfer.
Storage Estimated dollar* value of storage transactions included in the transfer.
Electric Estimated dollar* value of electric transactions included in the transfer.
Discount Estimated dollar* value of discount transactions included in the transfer.
Adjustment Estimated dollar* value of adjustment transactions included in the transfer.
Metered Electric Estimated dollar* value of metered electric transactions included in the transfer.
Fuel Estimated dollar* value of fuel transactions included in the transfer.
Services Estimated dollar* value of services transactions included in the transfer.
Supplies Estimated dollar* value of supplies transactions included in the transfer.
Deposit Estimated dollar* value of deposit transactions included in the transfer.
Environmental Fees Estimated dollar* value of environmental fee transactions included in the transfer.
Facility Fees Estimated dollar* value of facility fee transactions included in the transfer.
Resort Fees Estimated dollar* value of resort fee transactions included in the transfer.
Misc Fees Estimated dollar* value of misc fee transactions included in the transfer.
Boat Charge Misc Estimated dollar* value of misc boat charge transactions included in the transfer.
Sales Tax Dollar value of tax associated with transactions included in the transfer.
Gross Sum of transaction types and Sales Tax.
Processing Fee Dollar value of credit card processing fee tacked included in the transfer.
Net Dollar value of funds deposited into your bank account. Equals the Gross minus the Processing Fee value. 

 

*Why are the transaction categories estimates?

Category breakdowns are a proportional allocation of the funds you receive, based on the categories associated with transactions included in the transfer.   

 

In the Reservation Payments sheet:

  • The Rows show each transaction included in the transfer that is associated with a reservation
  • The Columns show categorical and numerical details of each transaction included in the transfer that is associated with a reservation

*Did you issue a refund and are looking for a deposit of a credit card processing fee back into your account? Look for the new "Fee Refund" transaction type in the report.  

Value
Definition

Sale Type

Indicates whether the transaction was from made on a "Reservation" or the "Standalone" POS tool on iOS app

Reservation ID

The unique string of letters and numbers that identifies the Dockwa reservation with which the transaction is associated

Invoice ID

The unique string of letters and numbers that identifies each Dockwa invoice (customer bill) with which the transaction is associated

Transaction ID

The unique string of letters and numbers that identifies each Dockwa transaction (charge or refund) at your business
Type Indicates whether the transaction was a "Charge", "Refund", or a "Fee Refund"
Transaction Date The date on which the transaction took place
Available On The date on which the funds are transferred to your bank account
Payment Method Type of payment involved with transaction. Takes value of Credit or Dockwa Dollars.
Card Type If payment method is "Credit," the type of customer credit card used (ex. Visa)
Last 4 If payment method is "Credit," the last four numbers of the credit card number
Check number Will not be populated - check and cash transactions are not included in transfer reports.
Customer name Name of customer associated with transaction
Base Amount
Dollar value of transaction

Sales Tax Dollar value of tax associated with transaction
Gross Sum of transactions included in the transfer.
Processing Fee Sum of Base Amount and Sales Tax.
Net Dollar value of transaction deposited into your bank account. Equals the Gross minus the Processing Fee value.
1 out of 1 found this helpful

Comments

0 comments

Please sign in to leave a comment.