How to Reconcile Stripe, PayPal, and Bank Deposits Without Double-Counting Revenue
Author : James Baker & Associates | Published On : 26 Oct 2026
Businesses that accept payments through Stripe, PayPal, and other online payment platforms often face a common bookkeeping challenge: the same customer transaction can appear in multiple places. A sale may appear in Stripe's transaction report, a payout may show up in the business bank account, and the processing fees may appear in a separate report. If these entries are recorded incorrectly, revenue can be overstated and financial reports can become unreliable.
The key to accurate bookkeeping is understanding the difference between revenue earned, payment processor activity, and money transferred to the bank. These are connected parts of the same transaction, but they do not represent three separate sales.
For business owners, accountants, and bookkeepers, establishing a consistent reconciliation process helps prevent duplicate income, identify missing transactions, account for processing fees, and keep financial statements accurate. This guide explains how to reconcile Stripe, PayPal, and bank deposits without counting the same revenue twice.
Why Stripe, PayPal, and Bank Deposits Can Create Duplicate Revenue
Payment processors act as intermediaries between customers and businesses. When a customer pays through Stripe or PayPal, the processor records the payment and may hold the funds temporarily before transferring them to the business's bank account.
Consider a business that receives $1,000 from customers through Stripe. Stripe deducts $30 in processing fees and transfers $970 to the business bank account.
The transaction may generate several records:
-
Stripe records $1,000 in customer payments.
-
Stripe records $30 in processing fees.
-
Stripe records a $970 payout.
-
The bank records a $970 deposit.
These records describe different stages of the same activity. They should not all be treated as revenue.
If the bookkeeper records $1,000 as sales from Stripe and then records the $970 bank deposit as additional income, the books show $1,970 in revenue even though customers paid only $1,000.
The solution is to distinguish the original customer payments from the movement of funds between accounts.
1. Understand Gross Revenue vs. Net Deposits
The first step is to understand what each amount represents.
Gross revenue generally reflects the amount earned from sales before payment processing fees, subject to applicable accounting policies and adjustments. Net deposits reflect the cash transferred to your bank after relevant deductions and adjustments.
For example, suppose your business processes the following transactions through Stripe:
|
Transaction |
Amount |
|
Customer payments |
$1,000 |
|
Stripe processing fees |
−$30 |
|
Refunds |
$0 |
|
Bank payout |
$970 |
Your accounting records should distinguish the $1,000 in customer payments, the $30 processing expense, and the $970 transfer to the bank.
The payout is not a second sale. It is the movement of funds already recorded through the payment processor.
This distinction also matters when refunds, disputes, reserves, or adjustments affect the amount transferred. Stripe's payout reconciliation report can show which transactions and fees contributed to a particular payout.
2. Use a Payment Processor Clearing Account
One of the most reliable ways to avoid duplicate revenue is to use a separate clearing account for each payment processor.
A clearing account temporarily holds funds received through a processor before they reach your business bank account. In your accounting software, it may be set up as an other current asset or a dedicated payment processor account, depending on your accounting system and workflow.
You might create accounts such as:
-
Stripe Clearing
-
PayPal Clearing
-
Business Checking
-
Payment Processing Fees
-
Sales Revenue
-
Sales Returns and Refunds
Each account has a specific purpose. Sales revenue records the income earned, clearing accounts track funds held by payment processors, and the bank account records actual deposits.
Example: Recording a Stripe Transaction
Assume a customer pays $1,000 through Stripe, and Stripe deducts a $30 processing fee before sending $970 to the business bank account.
The entries could look like this:
When the customer payment is processed
|
Account |
Debit |
Credit |
|
Stripe Clearing |
$1,000 |
— |
|
Sales Revenue |
— |
$1,000 |
When Stripe deducts its fee
|
Account |
Debit |
Credit |
|
Payment Processing Fees |
$30 |
— |
|
Stripe Clearing |
— |
$30 |
When the payout reaches the bank
|
Account |
Debit |
Credit |
|
Business Checking |
$970 |
— |
|
Stripe Clearing |
— |
$970 |
After these entries, the Stripe Clearing account has a zero balance for this example. Revenue remains $1,000, processing fees are $30, and the bank receives $970.
The important point is that the bank deposit is recorded as a transfer from Stripe Clearing—not as additional sales revenue.
3. Reconcile Stripe Payments and Payouts
Stripe may combine numerous customer payments into one payout. It can also deduct fees, refunds, disputes, and other adjustments before transferring funds to your bank.
As a result, a bank deposit will not necessarily match an individual customer's payment.
To reconcile Stripe accurately, follow a consistent process.
Step 1: Export the Relevant Stripe Reports
Download the transaction and payout information for the period you are reconciling. Stripe's Balance report helps you review activity over a selected period, while the Payout Reconciliation report helps connect automatic payouts to the transactions included in them.
Step 2: Match Each Payout to the Bank Statement
Compare each Stripe payout with the corresponding bank deposit. Use the payout amount, reference or payout ID, and expected arrival date to investigate matches.
Remember that the date a customer pays is not necessarily the date the money reaches your bank. Processing and settlement schedules can cause transactions from one period to be deposited in another.
Step 3: Verify the Payout Calculation
For each payout, check that the underlying charges, fees, refunds, disputes, and other applicable adjustments explain the amount transferred.
A simplified reconciliation might look like this:
|
Payout components |
Amount |
|
Gross customer charges |
$2,500 |
|
Processing fees |
−$75 |
|
Customer refunds |
−$100 |
|
Other adjustments |
$0 |
|
Expected payout |
$2,325 |
|
Bank deposit |
$2,325 |
|
Difference |
$0 |
This example assumes all listed activity belongs to the same payout and no other adjustments apply. In real accounts, a payout may contain additional transaction types.
Step 4: Investigate Differences
If the bank deposit does not match the expected payout, do not force the numbers to agree. Check for timing differences, missing transactions, failed payouts, currency conversions, fees, refunds, or incorrect entries.
A payout should be marked reconciled only when the supporting records explain the amount received or identify a legitimate outstanding difference.
4. Reconcile PayPal Without Counting Withdrawals as Sales
PayPal creates a similar bookkeeping challenge. Customer payments enter the PayPal balance, and the business may later withdraw or transfer that balance to its bank account.
The withdrawal is not new revenue. It is a transfer of funds between accounts.
PayPal provides reports that can help track sales, refunds, fees, disputes, withdrawals, and changes in the account balance. Its Balance Reconciliation Report is designed to support transaction-level reconciliation and help merchants understand how activity affects their PayPal balance.
A practical workflow is to:
-
Export PayPal activity for the reconciliation period.
-
Separate customer payments from refunds, fees, disputes, and withdrawals.
-
Record customer sales according to your accounting method.
-
Record applicable processing fees and refunds in their appropriate accounts.
-
Record withdrawals from PayPal as transfers to your business bank account.
-
Match the withdrawals to bank deposits and investigate discrepancies.
Example: A PayPal Withdrawal
Suppose customers pay $800 through PayPal. PayPal deducts $24 in processing fees and transfers $776 to your bank.
The accounting records could be:
Customer payments: Debit PayPal Clearing $800 and credit Sales Revenue $800.
Processing fee: Debit Payment Processing Fees $24 and credit PayPal Clearing $24.
Bank withdrawal: Debit Business Checking $776 and credit PayPal Clearing $776.
The result is $800 in revenue, $24 in processing fees, and $776 received in the bank. The withdrawal does not create another $776 in revenue.
5. Reconcile Stripe, PayPal, and Bank Deposits Together
When a business uses multiple payment processors, the same reconciliation principles apply to all of them. However, each processor should have its own records and clearing account so its balance can be checked independently.
A combined reconciliation process can be organized as follows.
First, reconcile customer sales. Compare Stripe and PayPal transaction reports with invoices, orders, or other sales records. Confirm that payments have been recorded once and assigned to the correct accounting period.
Second, reconcile processor fees and adjustments. Identify processing fees, refunds, chargebacks, disputes, and other account activity. Avoid assuming that every deduction is a processing fee; classify each item based on its actual nature.
Third, reconcile processor balances. Calculate how much money remains with Stripe and PayPal after the period's activity and payouts. Account for payments that are pending settlement or have not yet reached the bank.
Fourth, reconcile bank deposits. Match each incoming deposit to the corresponding processor payout. Do not record a matched deposit as additional sales if the underlying customer payment has already been recorded.
Finally, review the clearing accounts. Investigate unexplained balances, duplicate entries, and transactions that remain outstanding at month-end.
This process gives you a consistent view of revenue earned, money held by processors, and cash received by the business.
6. Handle Refunds, Chargebacks, and Processing Fees Correctly
Payment reconciliation involves more than matching sales to deposits. Other transaction types can change the amount available for payout and must be classified properly.
Refunds
When a customer receives a refund, the refund should be recorded according to your accounting policy, commonly in a sales returns and allowances account or as a reduction of revenue. The original sale should not simply be deleted if it was validly recorded in the prior period.
The refund also affects the processor balance and may reduce a subsequent payout.
Chargebacks and Disputes
A chargeback can remove funds from your processor balance while a dispute is being reviewed. Additional dispute fees may also apply.
Record the underlying transaction and subsequent dispute activity according to its nature and your accounting policy. If a disputed amount is later returned, reconcile that reversal to the original dispute records.
Processing Fees
Processor fees are generally recorded as an expense rather than netted against sales revenue when gross revenue presentation is appropriate. This keeps revenue and payment-processing costs visible in the financial statements.
However, the correct accounting treatment can depend on the nature of the arrangement, applicable accounting standards, and how the business earns its revenue.
Sales Tax
If a customer payment includes sales tax collected on behalf of a taxing authority, that amount generally should not be treated as sales revenue. Record the applicable tax liability separately, based on your tax obligations and accounting method.
Separating these transaction types helps explain why gross customer collections and net bank deposits may differ.
7. Common Reconciliation Mistakes to Avoid
Even businesses with good accounting software can develop reconciliation problems when payment processor activity is recorded inconsistently.
Watch for these common errors:
-
Recording bank deposits as income: This duplicates revenue when customer payments have already been recorded.
-
Recording only net payouts as sales: This may understate gross revenue and hide processing expenses or refunds.
-
Ignoring processing fees: The books may fail to reflect the actual cost of accepting online payments.
-
Mixing multiple processors in one clearing account: This makes it harder to identify the source of outstanding balances.
-
Matching by date alone: Settlement delays mean the customer payment date and bank deposit date may differ.
-
Leaving clearing balances unexplained: Old balances can indicate missing payouts, unrecorded fees, duplicate entries, or timing differences.
-
Using summary totals without transaction detail: Monthly totals may hide missing refunds, duplicate charges, or unresolved disputes.
The best safeguard is a repeatable process that ties sales records to processor activity and processor payouts to bank transactions.
8. How Often Should You Reconcile Payment Processors?
The appropriate frequency depends on transaction volume, business risk, and reporting needs.
For businesses with frequent daily sales, reviewing processor activity regularly can help catch missing payouts and duplicate entries before they accumulate. Monthly reconciliation should generally be part of the financial close process, even if transaction-level reviews happen more often.
A practical schedule may include:
-
Daily or weekly: Review high-volume activity, unusual transactions, failed payouts, and significant discrepancies.
-
Monthly: Reconcile processor clearing accounts, bank deposits, fees, refunds, and outstanding balances.
-
Quarterly: Review recurring discrepancies, processor fees, and the consistency of accounting procedures.
-
Year-end: Confirm that outstanding processor balances, refunds, disputes, and settlement timing are properly reflected in the financial statements.
Regardless of frequency, retain the processor reports, bank statements, and reconciliation notes that support the final figures.
Frequently Asked Questions
1. Why doesn't my Stripe payout match my total sales?
Stripe payouts may combine multiple transactions and deduct processing fees, refunds, disputes, and other adjustments. The payout is a net transfer, not necessarily the total value of sales processed during the same date range.
2. Should Stripe and PayPal deposits be recorded as revenue?
Not if the underlying customer payments have already been recorded as revenue. In that case, the deposits should generally be recorded as transfers from the appropriate processor clearing accounts to the business bank account.
3. What is a payment processor clearing account?
A clearing account tracks funds processed by a payment platform but not yet transferred to the business bank account. It helps connect customer payments, processor fees, refunds, and payouts without recording the same revenue twice.
4. How should payment processing fees be recorded?
Processing fees are generally recorded as an expense when gross revenue presentation is appropriate. The exact account and treatment should be consistent with the business's accounting policy.
5. What should I do if a processor clearing account has a balance at month-end?
Review outstanding payouts, unsettled payments, refunds, disputes, fees, and timing differences. A balance is not automatically an error, but it should be supported by identifiable transactions and expected settlement activity.
6. Can accounting software automate Stripe and PayPal reconciliation?
Many accounting systems and integrations can import processor activity and match bank transactions. Automation can reduce manual work, but duplicate income, incorrect fee classifications, and unmatched transfers still require review.
7. Should I reconcile Stripe and PayPal separately?
Yes. Separate clearing accounts and transaction reports make it easier to trace differences to the correct processor before consolidating the results into your financial statements.
Keep Your Revenue Accurate With a Consistent Reconciliation Process
Reconciling Stripe, PayPal, and bank deposits is ultimately about understanding the complete path of each payment. Customer transactions establish the sales activity, processor reports explain fees and other adjustments, and bank statements confirm the cash that arrived.
When each step is recorded correctly, your books can reflect revenue accurately without treating processor payouts as additional sales. Separate clearing accounts, detailed payout reports, and regular reconciliation help keep the process transparent and make month-end reporting more reliable.
If your business is struggling with duplicate revenue, unexplained processor balances, or inconsistent bank reconciliation, James Baker & Associates can help you review your bookkeeping workflow and establish a clearer process for recording payment activity.
