Developed and maintained by ProWorkstack · Development and review process
Compare payment activity with accounting entries after separating fees, refunds, tax and timing adjustments.
Your results
Enter your inputs and select Calculate.
How this calculator works
Adjusted payment amount = captured payments − refunds − fees − excluded tax − documented timing amount. Signed difference = adjusted payment amount − comparable accounting entries. Positive or negative differences both require transaction-level review.Worked example
Captured payments of 20,000 less 1,000 refunds, 600 fees, 1,200 excluded tax and 500 timing adjustments give 16,700. Against 16,500 accounting entries, the signed difference is 200.Assumptions
Defaults are illustrative. Replace them with your own measured quantities and documented assumptions. Use matching periods and a consistent currency wherever monetary amounts are entered.Interpreting your results
This does not connect to Stripe, QuickBooks or another provider. A difference is not tax exposure or evidence of lost revenue. Enter zero for any deduction already excluded from the captured starting amount to avoid double counting.Calculation formulas
- expected
gross-refunds-fees-tax-timing- Unexplained payment and accounting difference
expected-booked- Payment amount after adjustments
expected- Size of the difference to review
ABS(expected-booked)
Frequently asked questions
What should I check before using the result?
A gross sales ledger should not be compared directly with net payouts. State whether fees and tax belong in the accounting amount you are checking, then subtract only the adjustments needed to reach that basis.
Does this tool connect to my records?
No. This is a local calculation from the figures you enter. It does not scan accounts, import private records or verify legal, regulatory or exam requirements.
Maintained by ProWorkstack · Last reviewed: 2026-10-04 · Development and review process