Page Comparison

...

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 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 : 

...

2. Interactive payment accounting report 

   Now if you'd like to do the exercise of adding all transactions in a certain period and see if they fit the total payout you can download the full transaction report list  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 "gross credit" *of the "Settled" type transaction to get the sales amount. 
      Note      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