Basic Financial Reports: Accessing and Understanding the Transactions Report

Follow

The Transactions report provides a summary of all charges and refunds processed in Dockwa, including credit card and manual payment methods such as cash and check.

When a transaction (charge or refund) is recorded in Dockwa, a unique Transaction ID is created to identify the transaction.

 

How to access the Transactions Report

  1. Go to "Reports" > "Transactions" 
  2. Specify the date range you'd like to include in your Transactions Report
  3. Click "Export"
  4. Your report will be emailed to you.

 

transactions_report.png 

How the Transactions Report relates to other reports

  • Invoice report
    • Use the invoice report to see the Invoice/customer bill that a transaction partially settles
    • Every transaction and its corresponding Transaction ID are associated with one invoice and corresponding Invoice ID.
    • The invoice/Invoice ID represent the bill issued to a boater for goods and/or services provided by your marina, while the associated Transaction ID(s) represent the boater charges or refunds that settle the bill. 
    • A Transaction ID never represents the settling of multiple invoices.
  • Reservations report
    • Use the Reservation report to identify the details of the reservation with which a Transaction is associated.
    • Every transaction and corresponding Transaction ID are associated with one reservation and corresponding Reservation ID. A Transaction ID never represents the settling of invoices associated with multiple reservations/Reservation IDs.
    • A Transaction ID may be associated with multiple line items and their corresponding Line Item IDs. 
  • Line Items Ledger report
    • You can have one or more transactions made against an invoice, so transactions can pay for partial, one, or several line items. Therefore, the Transactions report and the Line Items Ledger report are not typically used with one another
    • A line item/Line Item ID represents the individual good or service provided by your marina, while the associated Transaction ID represents the charge or refund that covers the cost.
  • Bank Transfer
    • Connecting the Bank Transfers to the Transactions reports lets you see the bulk transfers in which your boater transactions reach your bank account.
    • Connect the Bank Transfers report to the Transactions report via the Transaction ID in the Bank Transfers report or via the Available On date in the Transaction report

 

How to read the Transactions Report

  • The Rows show each charge or refund processed through Dockwa over a specified period of time 
  • The Columns show categorical and numerical details of each charge or refund over a specified period of time

*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. 

 

The Transactions report includes the following categorical and numerical information (listed in order of appearance):

 

Value
Definition

Transaction ID

The unique string of letters and numbers that identifies each Dockwa transaction (charge or refund) at your business
Invoice ID The unique string of letters and numbers that identifies each Dockwa invoice (customer bill) with which the transaction is associated.
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.
Customer Name The name of the customer associated with the transaction.
Processed At The date on which the transaction was processed (in the case of cc transactions) or recorded (in the case of cash/check transactions) in Dockwa.
Status Indicates whether the transaction "succeeded" or "failed."
Method Type of payment involved with transaction. Takes value of Cash, Check, or Credit.
Type Indicates whether the transaction was a "charge" or a "refund."
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 If payment method is "Check," the unique check number.
Transfer ID The unique string of letters and numbers that identifies the Dockwa transfer with which the transaction is associated.
Available On The date on which the transaction value is transferred from Dockwa to your bank account.
 Gross The dollar amount the customer pays in the transaction. If a positive amount, the transaction is a charge. If a negative about, the transaction is a refund. 
 Processing fee The dollar amount of the Gross value that is attributed to the credit card processing fee. This value is subtracted from the Total value, as it is collected by Dockwa in the case of a charge and returned to you in the case of a refund.
 Total The net dollar amount the your marina receives from the boater in the transaction. If a positive amount, the transaction is a charge. If a negative about, the transaction is a refund. 
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.