A tax amount on a provider's fee invoice belongs to the transaction described on that invoice: the provider's service to the merchant. A tax amount on a customer order belongs to the sale described by that order. Identify the issuer, recipient, underlying transaction, currency, period and account or order before comparing either amount with a balance report. The shared label 'tax' does not make the amounts interchangeable, and a provider fee export does not establish the store's buyer-tax total or anyone's tax liability.
For: An owner or operations lead of a research-only merchant reconciling processing documents with store order records for a bookkeeper or adviser.
Identify the two transactions before adding amounts
Read the processing invoice from its heading down to the line item. Identify the company issuing it, the merchant entity receiving the service, the service description, the stated period and the field labeled tax. Preserve the amount, sign and currency exactly as the document presents them. You are establishing what the document covers, not deciding whether its tax treatment is correct.
Read the store record separately: the merchant is the seller, the order identifies the goods sold, and its tax field describes that customer transaction. Distinguish an amount calculated on an order from an amount evidenced in a completed payment or later refund. An order export can establish what the store recorded; the field label alone does not establish collection, remittance or liability.
Keep these transaction groups separate even when the invoice and order fall in the same month or show the same currency. A provider-fee tax total is not a missing part of the customer-order tax total merely because both were paid through the same business account.
Use a fee export within its documented scope
Stripe's Fees report separates amount, tax and currency, with product and feature fields helping identify the fee. It covers most fees paid from the balance, but excludes Terminal devices, Capital, Atlas and fees invoiced after use. A genuine provider invoice can therefore cover charges that are absent from that report. Do not assume a missing export row proves the invoice is wrong.
The report's CSV data is not a PDF tax invoice. Use the invoice to identify the billed transaction and preserve the export as a separate reconciliation record. When matching fee rows to the transaction that incurred them, Stripe documents the incurred_by field, and one transaction can have multiple fee rows. Such a reference connects a fee to its origin; it does not turn tax on that fee into tax charged to the buyer.
Identify whether the export covers one account or multiple accounts. Stripe supports organization exports with differing account arrangements, and account_id appears in specified formats. If the available export does not let you establish which account a row belongs to, record the account scope as unresolved before comparing it with an invoice for one entity.
Keep the balance comparison on a consistent basis
Stripe's balance summary describes account movements for a selected period in settlement currency and separates gross, fee and net amounts. It does not associate payouts with individual payments. Use it to examine the recorded balance movements, keeping the provider invoice and store order documents available to explain the underlying transactions.
Align the account, currency, date range and date basis before comparing fee-export totals with balance totals. Stripe distinguishes the date a fee was incurred from the date it affected the balance, and fee data can take up to 96 hours after the balance effect to appear. Its documentation also notes that revenue-share treatment can differ. A difference after a first comparison is therefore a question to trace, not a tax amount to invent.
Avoid counting the same documented charge twice merely because it appears in an invoice and in an export used to explain how it was collected. Keep both document references beside the matched item. If you cannot establish that two entries describe the same charge, leave the link unresolved instead of forcing a match or subtracting one tax total from the other.
Turn each unmatched figure into a specific question
A useful reconciliation handoff separates provider-service tax, customer-order tax and movements whose document scope is still unknown. Within each group, retain the amount and currency, the exact field label and the record that defines it. Give your bookkeeper the originals through the business's authorized channel, with a list of unclear associations rather than a combined tax figure.
Ask the provider about its invoice issuer, service period, missing document or report-field definition. Ask a qualified tax adviser about liability, collection duties, deductions, recovery or filing. This worksheet supplies neither a tax calculation nor a tax treatment; it preserves enough context for those questions to refer to the right transaction.
For a Prism processing consultation, describe which provider document and store total you cannot distinguish and what review help you need. Confirm scope, responsibilities, fees and terms before work. Keep invoices containing private details, full account identifiers, bank records and customer-order exports out of the public inquiry.
Tax-amount document scope map
Repeat this map separately for each provider invoice and customer-order report being compared. Enter document references and field meanings, retaining private originals in your accounting system. Compare amounts only after the transaction, account, currency and time basis are identified; this sheet does not determine tax treatment.
Worksheet entries are not submitted by Prism’s worksheet and are not saved by the site. Use record types, availability, anonymized observations, or match/mismatch results. Do not enter government identifiers, customer names or addresses, customer messages, receipt-access links, card or bank details, passwords, or keys. Send sensitive documents only through the provider’s verified secure channel.
Tax-amount document scope map. The last column is for temporary notes.
Scope detail
Evidence to record
Interpretation check
Your document finding
Document issuer and recipient
Evidence to recordThe legal names and roles shown on the invoice or report; use internal labels when sharing the worksheet.
Interpretation checkIdentify whether this documents the provider's service to the merchant or the merchant's sale to a buyer.
Underlying transaction
Evidence to recordThe billed service or customer-order line and its document reference.
Interpretation checkKeep provider-service charges separate from the goods sold on customer orders.
Tax field and amount record
Evidence to recordExact field name, amount, sign and currency as recorded, with the source column or line.
Interpretation checkDo not infer that similarly named fields describe the same transaction or tax duty.
Covered account or order
Evidence to recordNon-sensitive account label or internal order reference and whether the report aggregates accounts.
Interpretation checkAn organization total must not be assumed to describe one invoice recipient or store.
Period and date basis
Evidence to recordInvoice period, order-report date definition and fee-export incurred or balance date basis.
Interpretation checkA matching month label is insufficient when the reports use different dates.
Document type and coverage
Evidence to recordInvoice, fee CSV, order export or balance report, including documented exclusions.
Interpretation checkStripe fee CSV data is not the tax invoice and does not include every invoiced fee.
Linked balance movement
Evidence to recordExisting evidence connecting the billed charge to a balance entry; retain separate references.
Interpretation checkAvoid counting the same charge twice without treating an unexplained similarity as a confirmed match.
Question for bookkeeper or provider
Evidence to recordThe precise missing field definition, document association or amount explanation.
Interpretation checkRoute report and invoice questions to the provider; reserve liability and tax-treatment questions for a qualified adviser.
These are temporary notes. Leaving or reloading this page may clear them. Worksheet entries are not sent automatically. If you copy notes into the consultation message and submit the form, Prism receives them as part of your request.
Limits
This comparison identifies records. It does not calculate tax or advise on deductions, filing, collection duties, recovery or tax liability.
Stripe report fields, exclusions and timing apply to Stripe. Another provider's invoice and export require that provider's definitions.
Do not combine currencies, accounts or underlying transactions to create a balancing amount. Keep sensitive financial and customer records out of public forms.
Stripe Fees report — checked 2026-09-29. The report separates amount, tax and currency, has stated coverage exclusions and account-export formats, and distinguishes incurred and balance dates. Data can take up to 96 hours after balance effect; multiple rows can refer to one incurred_by transaction. CSV data is not a tax invoice and does not establish tax liability.
Stripe balance summary report — checked 2026-09-21. The balance report summarizes a selected period in settlement currency with gross, fee and net components; it does not associate payouts with individual payment transactions.
Discuss my processing options
Want to talk through your own processing situation?