Blackcart Reports

Blackcart provides four different types of reports in the Merchant Portal. More details on each report can be found below along with instructions for how to access them and tips for how to reconcile order payments for your accounting. 

In this article:

• Types of Reports
• How to access Reports 
• Tips for reconciling order payments and payouts
• Metrics Dictionary 

Types of Reports

• Orders 
• Payments
• Payout Reconciliation
• Payout Summary

Orders Report

The order level report provides a detailed breakdown of each Blackcart order. This report will be updated in real time as the order progresses through the order cycle, allowing you to keep track of order status and any transaction events.

Payments Report

The payments report should be extracted for financial reconciliation purposes. There are several transaction events throughout the Try Before You Buy order cycle and timing for charge and refund transactions will depend on a number of factors. As each order may contain multiple transaction events, the payment level data will include all of them. 

Payout Reconciliation Report

The payout reconciliation report shows all of the payments and associated payout IDs from Stripe. The report allows merchants to reconcile bank deposits and see the underlying payment transaction that comprise each payout. The report generated will be emailed to the logged in user. Note that the date range selected filters on the date when the funds are available.

Payout Summary Report

The payout summary report shows a summary of all Stripe payout transfers to your bank account. Note that the date range selected filters on the date when the funds are available.

How to access Reports in the Merchant Portal

1. Go to the Reports section in the Merchant Portal
   
   
   
   
2. Select the type of report you want to extract from the drop-down menu
   
   
   
   
3. Select the date range for your export (this can be one or multiple calendar months)
   
   
4. Click Submit. For the Orders and Payments reports, you will have the option to export the report in a CSV format using the Export Data button. For the Payout Reconciliation and Payout Summary reports, use the Export Data button to email yourself a copy of the report. 

Tips for reconciling order payments and payouts

There are a few different ways you can approach reconciling Blackcart orders. We've included two recommended workflows below but the workflow you choose can of course change depending on your preference. 

Workflow A

The following reconciliation flow starts with orders, and allows you to validate that all payouts that were expected in your bank account have been received.

Step 1: Start with the Orders report. Define a time period

Step 2: Join the Payments report. When exporting the payments report, extend the range of payments to accommodate the shipping + trial period time between order date and customer payment date. 

Step 3: Per order, compare the following:

1. Orders report: total sales 
2. Payments Report: total net payments (payments less refunds)

Step 4: Join the Payout Reconciliation Report for the same time period as the Payments report to get the Stripe Transfer ID. 

Step 5: Join the Payout Summary report and validate that all payments were included in a payout. 

Workflow B

Starting from Payouts, validate all payments and associated orders that were included in a payout are correct. 

Step 1: Start with the Payout Summary report, define a time period

Step 2: Join the Payout Reconciliation report. Extend the beginning range to accommodate the 3-5 day lag between a payment in Stripe and a payout deposit. 

Step 3: Join the Payments report to get the Shopify Order Number (this is needed because it is not always added to the Stripe Payments report)

Step 4: Join the Orders report to get order details 

Tips when reconciling: The Try Before You Buy order and payment cycle is different than a standard order. A few things to remember when reconciling: 

• Orders in Shopify always show as fully paid when the order is initially placed. This means that Shopify payment information is not always correct. You should not expect this to be accurate until the order is in a Completed state. The Orders report will tell you what status each order is in. Orders will also have a Blackcart-Complete tag on them in Shopify once completed. 
  
  
• Shopify can sometimes contain test orders placed through Blackcart's preview mode. Note that these orders are never fulfilled and you should not expect payment for them. All test orders will be tagged "Blackcart Test" to help you identify them. 
  
  
• Blackcart reports exported from Stripe sometimes have a lag in reporting payouts from the last 3-5 days. 

Reports Metrics Dictionary