How do I match sales received in payment gateways such as Stripe with invoices and payouts?
This FAQ aims to clarify the process of matching bank transactions with invoices in the following scenario:
You utilize a payment gateway, such as Stripe, to handle the sales revenue from your customers. This is where you receive your sales.
Your company maintains a corporate bank account, for instance, with Wise.
Periodically, the payment gateway initiates a payout to your corporate bank account. This payout encompasses all sales from a specific period, minus any associated fees and commissions.
Attempting to match invoices with the payouts from the payment gateway received in your corporate bank account may pose challenges for several reasons:
Payment gateways typically aggregate revenue over a period and issue a single payout to your corporate bank account. Consequently, the amount deposited into your bank account encompasses revenue from multiple sales, making it difficult or even impossible to trace back to individual transactions.
Payment gateways commonly apply fees, resulting in the final payout amount not aligning with the sum of the individual sales for that period.
These factors render matching the payouts received in your bank account nearly impossible. The correct approach involves tracing both the sales recorded in the payment gateway and the corresponding payouts deposited into your corporate bank account.** To facilitate this process, ensure that both your payment gateway and corporate bank accounts (where the payouts are sent) are connected in Companio**. For detailed instructions, please refer to this guide.
When a customer makes a purchase, the corresponding amount is received in the company's payment gateway, such as Stripe. For example, if a customer makes three purchases totaling €250 (€100 for sale 1, €100 for sale 2, and €50 for sale 3), these transactions are matched with the respective sales invoices, as the amounts usually match exactly the total specified in the sales invoice.
Subsequently, the payment gateway (e.g., Stripe) accumulates the total amount received (€250), deducts applicable fees (e.g., -€3.45), and initiates a payout to the corporate account of the business, resulting in a transfer of €246.55.
This payout is then deposited into the corporate bank account of the business, such as Wise, which is the designated bank account of the customer's company.
An incoming transaction appears in Wise, corresponding precisely to the outgoing transaction (the payout) from Stripe.
To reconcile these transactions, one of them should be categorized as an "internal transaction between accounts." The system will prompt you to select the corresponding transaction. For instance, if you designate the outgoing transaction from Stripe (-€246.55) as an "Internal movement between accounts," you should then choose the incoming transaction of €246.55 received in Wise as the matching transaction.
Typically, payouts do not incur fees. However, if fees are applied, they will be accurately recorded in your accounting records automatically.
You utilize a payment gateway, such as Stripe, to handle the sales revenue from your customers. This is where you receive your sales.
Your company maintains a corporate bank account, for instance, with Wise.
Periodically, the payment gateway initiates a payout to your corporate bank account. This payout encompasses all sales from a specific period, minus any associated fees and commissions.
Attempting to match invoices with the payouts from the payment gateway received in your corporate bank account may pose challenges for several reasons:
Payment gateways typically aggregate revenue over a period and issue a single payout to your corporate bank account. Consequently, the amount deposited into your bank account encompasses revenue from multiple sales, making it difficult or even impossible to trace back to individual transactions.
Payment gateways commonly apply fees, resulting in the final payout amount not aligning with the sum of the individual sales for that period.
These factors render matching the payouts received in your bank account nearly impossible. The correct approach involves tracing both the sales recorded in the payment gateway and the corresponding payouts deposited into your corporate bank account.** To facilitate this process, ensure that both your payment gateway and corporate bank accounts (where the payouts are sent) are connected in Companio**. For detailed instructions, please refer to this guide.
When a customer makes a purchase, the corresponding amount is received in the company's payment gateway, such as Stripe. For example, if a customer makes three purchases totaling €250 (€100 for sale 1, €100 for sale 2, and €50 for sale 3), these transactions are matched with the respective sales invoices, as the amounts usually match exactly the total specified in the sales invoice.
Subsequently, the payment gateway (e.g., Stripe) accumulates the total amount received (€250), deducts applicable fees (e.g., -€3.45), and initiates a payout to the corporate account of the business, resulting in a transfer of €246.55.
This payout is then deposited into the corporate bank account of the business, such as Wise, which is the designated bank account of the customer's company.
An incoming transaction appears in Wise, corresponding precisely to the outgoing transaction (the payout) from Stripe.
To reconcile these transactions, one of them should be categorized as an "internal transaction between accounts." The system will prompt you to select the corresponding transaction. For instance, if you designate the outgoing transaction from Stripe (-€246.55) as an "Internal movement between accounts," you should then choose the incoming transaction of €246.55 received in Wise as the matching transaction.
Typically, payouts do not incur fees. However, if fees are applied, they will be accurately recorded in your accounting records automatically.
Updated on: 02/04/2024
Thank you!