Payment & Refund Report

See your Payments & Refunds broken down in detail

Running the Report

• Select your required Date Range
• Select which Payment/Refund Types you want to report on
• Select whether you want to report on Payments or Refunds
• Select whether you want the results to show on screen in the browser, or export straight to Excel
• Click Generate Report

The Results - Payment Report

Here's what the report shows you:

• Franscape Transaction ID
• Franscape Payment ID
• Payment Type
• Date of Payment
• Time of Payment
• Stripe Transaction ID
• Amount Paid
• Refunded
• Refunded Amount
• Refunded %
• Refunded Date

The Customer

• Customer ID
• Customer Name
• Franchisee Name

The Deductions

• Levies
  
  • If your Franchisor is taking levies (aka Franchise Fees) at the source of payment, a breakdown of how much has been taken will show in the columns after "Franchisee Name"
  • These are broken down into % and £, then totalled

• Total Levies Applied %
• Total to Franchisor £
• Franscape Fees %
  • The % of each payment taken by Franscape to cover processing
• Franscape Fees £
  • The Fixed £ amount of each payment taken by Franscape to cover processing

• Franscape Fees Taken From Payment £
  
  • Total of (Franscape Fees % + Franscape Fees £)

What the Franchisee Receives

• Total to Franchisee 
  
  • This is the total the Franchisee receives after all deductions

Extra Details

• Monthly Plan Payment?
  
  • Is this transaction a Monthly Plan Payment?
• Monthly Initial Payment?
  • Is this transaction a Monthly Initial Payment?

• Note
  • Notes attached to the payment, usually explaining what it's for

The Results - Refund Report

The Transaction

• Franscape Transaction ID
• Franscape Payment ID
• Payment Type
• Date of Refund
• Time of Refund
• Original Stripe Transaction ID
• Original Amount Paid
• Refunded Amount
• Refunded %

The Customer

• Customer ID
• Customer Name
• Franchisee Name

The Returns

• Levies Returned
  • If your Franchisor is taking levies (aka Franchise Fees) at the source of payment, a breakdown of how much has been returned will show in the columns after "Franchisee Name"
  • These are broken down into % and £, then totalled

• Notes