How do I reconcile Stripe payouts to Mercury when QuickBooks shows different totals?
I'm seeing discrepancies between Stripe's gross sales for the month, Mercury's incoming deposits, and what QuickBooks shows. Some of it is timing (payouts in transit), some of it is fees, some of it is refunds. What's the right reconciliation approach so I'm not chasing my tail every month?
Related Questions
What bookkeeping do I need to maintain for my foreign LLC's bank account?
I've been running my foreign-owned LLC for about six months and I've been pretty lax about bookkeeping. I have a Mercury account with maybe 50-60 transactions total — mostly client payments and a few ...
My Stripe 1099-K triggered a CP2000, but I already reported that income — what do I do?
I run my business through a US LLC and Stripe issued a 1099-K. The IRS sent a CP2000 treating the whole 1099-K as unreported income, but I did report those sales on my return. I think the problem is t...
If I have no US employees and no US warehouse, do I still need to file Form 1040-NR for my foreign-owned LLC?
I'm a non-US-resident running a single-member US LLC that does about $200,000/year through Stripe, selling physical goods worldwide. No US employees, no US office, no US warehouse — everything ships f...
How do I map my monthly bookkeeping to Form 5472 — which transactions go on Part IV vs Part V?
I want my bookkeeping to flow cleanly into Form 5472 instead of scrambling at filing time. For a foreign-owned disregarded LLC, which related-party transactions go in Part IV (the monetary lines) and ...
My company is formed in the UK and registered in New York. Does that still make me a BOI filer even though domestic LLCs are exempt now?
I am a UK resident and my business is a UK company that registered to do business in New York instead of forming a new U.S. LLC. After the 2025 BOI rule changes, I got confused because everyone now ta...
What is California's $800 'tax trap' if I'm doing business there but never registered?
People keep warning me about a California $800 trap. My LLC is formed out of state and I've been doing some business with California customers but I never registered with the California Secretary of S...
How do I identify the 'US customer subset' of my Stripe transactions for a defensive ECI filing?
I've decided to do a defensive ECI filing with a small voluntary amount on 1040-NR. My question is methodological — Stripe shows me a lot of customer data, but which fields actually justify treating a...
Can I keep my section 6038A records electronically, or do I need paper? Is a folder of PDFs enough?
I run everything paperless. My invoices, contracts, and bank records are all scanned into cloud folders, and my accounting is in software. Is electronic storage actually acceptable for section 6038A, ...
My LLC's books are in euros — how do I reconcile that with a US-dollar Form 5472, and what are sections 985-988 about?
My single-member LLC bills clients in euros and my accounting software is denominated in euros. Form 5472 obviously wants US dollars. Can I even keep my books in a foreign currency? How do I bridge to...
My foreign LLC's bank account was frozen — what should I do?
I woke up this morning and can't access my Mercury account. When I try to log in, it says my account is under review. I have about $12,000 in the account and two client payments are supposed to come i...
Have a similar question?
ForeignLLCTax members get expert answers with IRS citations. One CPA consultation costs $200+. Full access is $9.99/month.
Become a Member — $9.99/moDisclaimer: All content on ForeignLLCTax.com is created by a tax professional and is provided for general educational and informational purposes only. It does not constitute tax, legal, or accounting advice, and should not be relied upon as such. Every tax situation is different — for advice specific to your circumstances, please consult a licensed CPA, Enrolled Agent, or tax attorney. By using this website, purchasing a subscription, or accessing any tools or services, you acknowledge that no client-professional relationship is established between you and ForeignLLCTax.com or its operators. This website is not affiliated with the IRS.
