The Payout Detail Report is intended to assist with the reconciliation between the amounts received from applicants, and the amounts payed out 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.

Charge Types 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 charges - All payments will show in the report, regardless of what the payments are for.
• Charges from Provider - Payments for fees (and potientially taxes) charged by the Provider (i.e., harbor/town/etc.), and excluding any payments for Online Mooring fees.
• Charges from Online Mooring - 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.

Balances to Include -  

• All, regardless of balance - use this option to show all payments
• Non-zero balances only - use this option to filter out all payments that have been paid out in full.  You can essentially use this option to get a list of money that needs to be paid out to the Provider.

Report Layout

A single payment from (or refund to) an applicant may be represented by 1 or more rows in this report.  For example, if a single payment covers the application fees for two separate applications, as well as the Online Mooring application fees, then that payment would result in 4 rows in the spreadsheet because the payment covers 4 separate things.

For each row in the report, you'll see the following 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 the applicant information on the application was cleared out after the payment.
• 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, usually a single date will appear here, but in some unlikely situations we may show a range of dates which indicates that the payout for this item was paid out to the Provider in multiple chunks.
• 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 amount is negative.
• Payout Type - If the money has not yet been paid out, this will be blank.  You'll see that the money was paid out via "EFT" or "Check" (or "EFT/Check" in the rare situation that the money was paid out in multiple chunks, part of which was sent via EFT and part sent by Check)
• Balance Amount -  This shows how much money needs to be paid out.  When this is not $0, the cell will be highlighted in pink.
• 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.
• 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 |