Enquiries

There are usually 2 Main enquiries categories : 

1. Sales to payout. Typical questions : 
   1. How to make sure all my sales were payed out ? 
   2. How to know what sales where paid out in <time period> 
2. Sales to invoices. Typical questions :  
   1. Why am I paying this amount this month? 
   2. How to find which transactions led to the invoices in < month> ? 
3. Net revenues in a month 

Here is how to answer them : 

Sales to payout 

1. Head to Finance > Sales to payout > Payouts 

From here you can download 2 types of reports: 

1. 1. Complete payouts report
      
      
      Here you can export the report containing all payouts within a certain date range.
      The top part, will give you a combined data of sales, refunds, costs, adjustments and payouts during the period
      The second part will give you the detail for each payout.
      
      Here you can see how much sales you made in this time period and how the converted to the payouts you received 
      
      Note: if you are settling in several currencies you will need to download this report for each currency you settle in ( you will see an additional dropdown to pick the currency next to the export button ) 
      
      
      
      
   2. Payout report detail 

While the first report will help you with general reporting, you may wonder how was those numbers calculated and what is behind them. For instance you may wonder what are those adjustments you see in your payout report. To drill more on each payout you can extract the detail of what element constitute it. 

This report will tell you which settled transactions, refunds, adjustments where included. The fees for the payout are the combination of the acquiring fees for each settled & refund transaction included + the transaction fees for the date mention ( in this example 03-01-2023 )  

2. Interactive payment accounting report 

   To do this at larger scale you can download the  Interactive payment accounting report to get all transactions over a certain period ( select all events )

From this report you may 

1. 1. Calculate the sales  :
           Sum the "Captured" amount of the "Settled" type transaction 

      =SUMIFS(Sheet2!N:N;Sheet2!J:J;"Settled")

   2. Calculate the processing fees 
      Sum the "Processing Fee" amount of the "Authorised" and "SentForRefund" type transaction 

      =SUMIFS(Sheet2!V:V;Sheet2!J:J;"Authorised")+SUMIFS(Sheet2!V:V;Sheet2!J:J;"SentForRefund")

   3. Calculate the Acquiring fees
      Sum the "Commission", "Markup" and "Scheme Fees" amount of the "Settled" type transaction 

      =SUMIFS(Sheet2!Q:Q;Sheet2!J:J;"Settled")+SUMIFS(Sheet2!R:R;Sheet2!J:J;"Settled")+SUMIFS(Sheet2!S:S;Sheet2!J:J;"Settled")

   4. Calculate the refunds