Reconcile Stripe CSV records with explicit source references.
The free CSV tool explains balance movements and compares invoice payment evidence locally in your browser. The separate paid account imports Stripe data, creates localized accounting copies and posts balanced journals after configuration. Stripe remains the invoice issuer.
Start with the balance-transaction template
Required headings are id, type, currency, amount, fee and net. Optional headings are source, status, livemode and account. The id must identify one balance transaction. Status means available or pending funds, not charge success. Choose decimal amounts or integer minor units explicitly.
Download synthetic balance transactions. Other Stripe report layouts require column mapping before import. Maximum 5 MB and 10,000 rows per file.
Compare invoices with successful charges
Invoices template: id, currency, amount_paid, amount_remaining, status. Charges template: id, invoice_id, currency, amount, amount_refunded, status. Aggregate refunds once per charge. IDs must be explicit; the tool does not infer matches from customer names or equal amounts.
Successful charges with the same invoice ID and currency are summed and compared with invoice amount paid. Failed and pending charges are excluded. If the totals differ, review export coverage, customer credits, out-of-band payments and multiple payments before treating it as an error.
Why a paid invoice can still have a refund
The invoice amount paid is compared with gross successful charges, while refunds and retained receipts are shown separately. A full refund can leave processing fees behind. Retained receipts before fees are not profit or recognized revenue; credit notes and tax adjustments need separate review.
Why failed bank recovery is not another loss
A transfer and its reversal can offset each other. The negative balance that caused the recovery attempt may remain outstanding, but each failed attempt is not another fee. Inspect the original payout for its failure reason.
Partial exports, modes and currencies
Each import is scoped to one declared account and mode. Present account/livemode columns must match those selections. If absent, origin cannot be verified. Currencies are never added together. Missing linked records are flagged as outside the file's scope; they are not automatically missing financial records.
Does this generate VAT invoices or an accounting ledger?
The free CSV tool exports comparison summaries and exceptions, not accounting journals. The paid account supports English, German, French and Spanish PDF accounting copies, invoice and credit-note lifecycle changes, accountant-selected mappings, and balanced payment and reversal journals. US checks cover domestic record fields; UK checks cover domestic GBP, tax-exclusive, undiscounted taxable lines with explicit positive VAT rates. Neither product determines tax obligations, files taxes, or supplies mandated structured e-invoices. Retain the original issued Stripe documents.
Data handling
The free CSV tool processes CSV contents locally and makes no network calls for analysis. Closing the page discards imported values; downloaded reports remain on your device. Source strings are displayed as text, and text exports neutralize spreadsheet formulas. No API keys are requested by the free tool. Paid imports use an encrypted restricted Stripe key on our server. Optional automation stores encrypted document snapshots and journals for 90 days; source IDs remain reserved against duplicate posting until explicit deletion. Download and retain records for your required retention period.
Paid automation: setup before your first event
The paid account costs $19 USD/month plus applicable tax for one Stripe account and up to 1,000 balance transactions per selected calendar month. Verify a restricted read-only key before checkout. You or your Stripe administrator must be able to configure API permissions and webhooks.
- For balance imports, allow Account and Balance reads. For invoice comparison, add Invoices and Charges. For document automation, also allow Credit Notes, Tax Rates and Refunds reads.
- Choose the PDF language and document-check scope. Supply the issuer's legal name, postal address, country and applicable tax ID. Have your accountant select distinct receivables, revenue, tax payable, Stripe balance, fees, suspense, bank clearing and disputed-funds accounts.
- After subscription activation, save document settings without a signing secret to obtain the endpoint. In your connected Stripe account, register that endpoint with event version 2025-02-24.acacia.
- Select invoice.finalized, invoice.paid, invoice.updated, invoice.voided, credit_note.created, credit_note.updated, credit_note.voided, charge.succeeded, charge.refunded, refund.created, refund.updated, refund.failed, charge.dispute.created, charge.dispute.updated, charge.dispute.closed, charge.dispute.funds_withdrawn, charge.dispute.funds_reinstated, payout.paid, payout.failed, payout.canceled and balance.available.
- Save the endpoint's signing secret in Ledger Check. Review processing status and Stripe delivery results. Signing secrets and API keys belong only in the secure account form, never in support messages.
Open the paid account and setup controls. Creating or changing invoices, credit notes, charges and refunds happens in Stripe. Ledger Check imports those records.
Recover an interrupted request or payment
If your connection drops or a request times out, its server-side work may still complete. Reconnect and refresh account status and documents before repeating the operation. Requests are not automatically resubmitted. Checkout reuses your existing open checkout and protects against duplicate subscription attempts; do not start another payment while the first result is uncertain. Use Manage subscription or support if access does not recover.
Understand processing status
Waiting for processing means the worker will process the event automatically; failed attempts retry at five-minute intervals. Needs your review means automatic retries have stopped: correct the displayed cause and select Retry reviewed events. Completed means processing finished, but you still need to review exports and any accounting exceptions. Stopped means automation was disabled; retained evidence protects against duplicate postings.
Export, stop and cancel
Export records regularly within the 90-day detail-retention window. Repeated complete journal exports contain stable journal_key values: deduplicate by that key, and do not import both individual-document and complete journals for the same invoice. Mapping changes affect new postings; reversals use the original accounts. Standalone payments and FX settlements require suspense classification, and bank-clearing entries require statement matching.
Stop automation or disconnecting Stripe does not cancel billing. Cancel renewal in Manage subscription; access continues through the paid period. Explicit deletion removes documents, journals and reserved source IDs, so reconnecting and importing afterwards starts a new ledger.
Sources
Stripe balance-transaction object · Stripe invoice object · Stripe Tax reports.