Faq: How can I receive a daily or recurring emailed report of my Mosaic payouts / deposits?

For Mosaic Worldpay users, the portal allows you to schedule certain reports for recurring email delivery. The Disbursement Txn Details report can be scheduled as a recurring report and sent to your accounting or internal teammates you designate.

What information is included in this report?

The Disbursement Txn Details report provides a breakdown of the sales and refunds included in a processed disbursement. It can include information such as:

  1. Cardholder name
  2. Last four digits of the card
  3. Transaction type and status
  4. Transaction ID
  5. Approved and requested amounts
  6. Fees
  7. Net transaction amount

How do I schedule the report?

  1. Log in to the Mosaic Worldpay portal.
  2. Select Reports under the Admin section of the left navigation menu.
  3. Open the Scheduled Reports tab.
  4. Select Disbursement Txn Details as the Quick Report you want to schedule.
  5. Set the recurring frequency to Daily.
  6. Select the time of day when the report should be generated. Scheduled report times are based on Eastern Time.
  7. Enter the email address or addresses that should receive the report, such as your accounting department’s email address.
  8. Apply any available merchant, division, or other reporting filters needed for your account.
  9. Save the scheduled report.

The report will be generated automatically according to the selected schedule and emailed to the listed recipients.

What if I only need to generate the report manually?

You can also create and download the report at any time.

  1. Go to Admin, then Reports.
  2. Open the Standard Reports tab.
  3. Select Disbursement Txn Details from the report menu.
  4. Choose the applicable report date or date range.
  5. Optionally select a saved report template.
  6. Optionally apply additional filters.
  7. Select Generate Report.
  8. Download the completed report in CSV or XLS format from the upper right corner of the report.

Why might I not see the scheduling option?

The reports and scheduling options visible in the portal can depend on your user role and access permissions. If you do not see the Scheduled Reports tab or the Disbursement Txn Details report, contact Mosaic Merchant Support for assistance reviewing your portal access.

Reports larger than 24 MB cannot be attached to an email. When this occurs, the completed report will be available from the portal’s Report History page instead.

Additional reconciliation guidance

The Disbursement Txn Details report focuses on the sales and refunds included in the disbursement. For a broader review of a payout, including fees, disputes, and other adjustments, you may also want to use the Disbursement Summary and Balance Details reports.

Related resources