Non-Resident US LLC Tax Tracker | Form 5472 Bookkeeping (Google Sheets, Excel)

FREQUENTLY ASKED QUESTIONS

Q: Do I get both the Google Sheets* and Excel* versions?
A: Yes. You get the Google Sheets* version (a one-click copy link inside your download PDF), a separate Excel* (.xlsx) file, and an Instructions PDF.

Q: Do I need paid software or spreadsheet skills?
A: No. Google Sheets* is free in any web browser, or you can open the .xlsx file in Microsoft* Excel* 2016 or newer. It is built for beginners: type in the green cells and everything else calculates for you.

Q: Does it file my taxes or give tax advice?
A: No. It is a record-keeping tool that organizes your numbers the way Form 5472 asks for them, so you or your tax preparer can fill in the forms faster. It does not file anything and is not tax or legal advice.

Q: Can I accidentally break the formulas?
A: Nothing is locked, so you stay in full control. Formula cells are grey and show a warning before you change them, and the Instructions PDF shows how to undo a mistake in seconds.

Q: Which states and currencies does it support?
A: Deadlines are calculated automatically for Wyoming, Delaware, New Mexico, Florida and Texas, and you can type your own due date for any other state. 34 currencies are preloaded (EUR, GBP, INR, PKR, AED, TRY, NGN and more) and you can add more.

---

Own a US LLC but live outside the US? Keep your books, your currencies and your deadlines in one place. This tracker converts every transaction to US dollars, tags every owner transaction for Form 5472, and counts down to every IRS and state deadline. Missing a required Form 5472 can cost $25,000 per form, so keep your records ready all year.

WHAT'S INCLUDED
- Google Sheets* version (copy link in a PDF)
- Excel* version (.xlsx)
- Instructions PDF with step-by-step setup, resizing and formula-safety tips
- Blank and ready to use: no demo data, no macros, no subscription

KEY FEATURES (12 TABS)
- Dashboard: income, expenses and net profit in USD, money the owner put in and took out, cash in all accounts, next deadline countdown, overdue items, rows that need attention, yearly compliance cost and 4 charts.
- Transactions: 1,000-row ledger in any currency. Uses your own rate, your monthly rate table or the IRS yearly average rate, and shows the rate used and the USD value on every row.
- Automatic Form 5472 tags: owner contributions, distributions, loans, services and other related-party money are tagged as you type. Mark a bill the owner paid personally and it counts as an expense AND an owner contribution.
- Form 5472 Summary: Part IV lines grouped for you (including loan start and end balances), Part V contributions and distributions, and a pro forma Form 1120 filing checklist.
- Profit & Loss: month by month in USD, 10 income and 25 expense categories, owner money kept separate.
- Compliance Calendar: Form 1120 + 5472 due date, Form 7004 extension, extended deadline, 1099-NEC, your state's annual report (WY, DE, NM, FL, TX or any state), registered agent renewal and your own deadlines, with Overdue and Due soon flags.
- Renewals & Fees: registered agent, virtual address, state fees and filing services. Next renewal rolls forward automatically and yearly cost is shown in USD.
- Accounts: balances for Mercury*, Wise*, Payoneer*, Stripe* or any account, in its own currency and in USD.
- FX Rates: monthly rates plus the IRS yearly average for 34 currencies. Keep it as the schedule of exchange rates you used.
- LLC Profile & Documents: EIN, state, formation date, registered agent and owner details, plus a checklist for your Articles, EIN letter, W-8BEN and past filings with links and expiry dates.
- Settings: rename categories and dropdown lists to fit your business.

WHO IT'S FOR
- Non-US residents and digital nomads with a Wyoming, Delaware, New Mexico or other US LLC
- Foreign-owned single-member LLCs that file a pro forma Form 1120 with Form 5472
- Freelancers, agencies, e-commerce and SaaS founders paid in more than one currency

HOW YOU RECEIVE IT
Instant digital download. You get 3 files: Google Sheets Download Link (PDF), Instructions (PDF) and the Excel* file. Open the link PDF, click the link and Google makes your own private copy in your Google Drive*.

DISCLAIMER
This template is a record-keeping and organization tool. It is not tax, legal or accounting advice and it does not file any forms. Tax rules, line numbers, deadlines and fees change. Always confirm with a qualified US tax professional.

*Google Sheets and Google Drive are trademarks of Google LLC. Microsoft and Excel are trademarks of Microsoft Corporation. Mac, Wise, Mercury, Payoneer and Stripe are trademarks of their owners. ProFormaGrid is not affiliated with them.

More templates at ProFormaGrid.com