The Payout Detail Report reconciles the amounts paid to Online Mooring by applicants, and the amounts payed out by Online Mooring to Providers.

Report Options

Start Date - If you enter a date in this field, you will only see payments (and refunds) that occurred on or after that date.

End Date - If you enter a date in this field, you will only see payments (and refunds) that occurred on or before that date.

Detail Categories to Include -  This allows you to control which types of payments you want to include in the report.  A drop-down list of options provides the following options:

• All Categories- All payments will show in the report, regardless of what the payments are for.  This should be most useful for Providers that are configured for net invoicing from OM (payout = Provider Fees collected by OM - Fees charged by OM), or that pay all fees to OM in a single annual lump-sum amount.
• Provider Categories- Payments for fees (and potientially taxes) charged by the Provider (i.e., harbor/town/etc.), and excluding any payments for Online Mooring fees.  This should be most useful for Providers where Online Mooring fees are separated into their own invoice, and Provider Fees are separated into a credit memo -- this option will more easily allow you to cross-reference with the credit memo.
• Online Mooring Categories - Payments for fees charged by Online Mooring (application fees, advertising fees, online payment fees, etc.), and excluding any payments for fees charged by the Provider.  This should be most useful for Providers where Online Mooring fees are separated into their own invoice, and Provider Fees are separated into a credit memo -- this option will more easily allow you to cross-reference with the invoice.

Balances to Include -  

• All Balances - use this option to show all payments, regardless of how much money remains to be paid out to the Provider
• Non-zero balances only - use this option to filter out all payments that have been paid out in full.  This option allows you to get a list of money that still needs to be paid out to the Provider.

Report Layout

Report Rows

A single payment from (or refund to) an applicant will result in 1 or more rows in this report, depending on how many charges the payment is allocated to.  For example, if a single payment pays for two applications (covering both the Provider's application fee, and the Online Mooring application fee), the payment is allocated to 4 different charges, so you would see 4 rows in this report for that payment. 

If you ever change what the payment is for, even if it is long after the original payment, you'll see additional rows in this report showing the changes.  So, if you changed the payment allocation from a payment six months ago to pay for application Y instead of application X, you'd see 2 rows with a Payment Date showing as the date you made the change:  one indicating a "refund" of the payment against application X, and one indicating a payment against application Y.  Even though the net amount of those transactions is $0, we show them because the GL codes associated with the new payment allocation may be different.

Report Columns

• Payment Date - This is the date when the applicant made a payment using Online Mooring, or when a refund was made to the applicant using Online Mooring.
• Payment Amount - For payments from applicants, the amount will be positive.  For refunds to applicants, the amount will be negative.
• Payment By - The name of the person currently listed as the applicant on the associated application.  This could be blank if the application has been deleted since the payment was made, or if there is no applicant information currently on the application .
• Payout Date -  This is the date (or dates) when this money was paid out to the Provider.  If the money has not yet been paid out, this field will be blank.  When money has been paid out already, a single date will usually appear here, but in some unlikely situations we may show a range of dates which indicates that the payout occurred in multiple partial payouts.
• Payout Amount -  If no payout has occurred, this column will be blank.  When Online Mooring pays out a payment from an applicant, the amount is positive.  When Online Mooring sends a refund to an applicant, the payout amount is negative.
• Payout Type - If the money has not yet been paid out, this will be blank.  The possible values in this column are:
  • EFT - The money was sent electronically
  • Check - The money was sent via check
  • Invoice - The money was used to reduce the amount invoiced to you.  Normally, this should only happen for clients that are configured for net billing (a single invoice/credit including fees collected by us and fees charged by us).  For example, if during during a single billing period we received a $10 payment from an applicant, and charged $15 in fees to the provider, we would send an invoice for the difference ($5).
  • Various -  The money was sent in multiple installments using different methods.  This is a situation that would normally not happen unless we had a problem.
• Balance Amount -  This shows how much money needs to be paid out.  When this is not $0, the cell is highlighted.
• Detail Category -  This indicates what kind of charge the payment was for.  This could be a payment for a Provider Fee, for tax on the Provider Fee (optional), for Online Mooring's application fee, for Online Mooring's advertising fee, or for Online Mooring's online payment fee, etc.
• Comments - This provides additional information about what the payment was for.

If you click the Export button instead of the View button, you'll get a spreadsheet that includes the information above, plus additional information:

• Reference Number - the reference number of the application associated with this payment

Security

Users that have the ability to view reports at the "Filtered" or "All" level can run this report.

|<< Back |