THE STARTING POINT

Record what moved, why it moved and which evidence supports it. Keep the business expense separate from the owner funding or reimbursement that paid for it.

The missing transaction is often outside the LLC bank account

A new founder sends a preparer the LLC bank statement and says that it contains everything. But the formation invoice was paid with a personal card, the owner used a personal subscription for business work and a supplier refund went back to that same card. None of those movements necessarily appears in the LLC's statement.

This guide gives you a practical way to assemble the transaction trail before a bookkeeping or tax review. It is intended for founders who keep mixing the question “what did the business buy?” with the question “who actually paid?” The worksheet is a working list, not a complete accounting system or an IRS form.

Start with one entity and one review period. If you operate two LLCs, prepare separate lists. If several people funded the same entity, record the party references separately in the descriptions so the preparer can identify each relationship using a secure supporting file.

Use six columns that make a payment traceable

A practical schedule for your preparer
ColumnUseful entryWhat it helps establish
DateDate the payment or transfer occurredConnect the movement to the relevant period and statement.
Movement typeOwner paid supplier; LLC reimbursed ownerDescribe the direction without pretending to settle its tax treatment.
AmountThe positive amount of that movementAvoid hiding transfers by netting unrelated inflows and outflows.
CurrencyUSD in the interactive worksheetPrevent unlike currencies from being added together.
DescriptionOwner paid supplier invoice; later reimbursedExplain purpose and connect events.
Evidence referenceDOC-02 / DOC-03Link to documents held separately and securely.

A bank narration such as “transfer” may be accurate but incomplete. Add a description that another person can understand months later. Do not put full account numbers, passport numbers or tax identifiers into a general worksheet. A short document reference is enough to connect it to the secure file.

Work through a $300 bill before entering your own numbers

In this fictional example, the owner pays a $300 supplier invoice for an LLC on 6 January. The LLC reimburses the owner on 2 February. There is one supplier invoice and two money movements involving different accounts.

Record the personally paid invoice with the owner's payment evidence. Then record the reimbursement with the LLC bank reference, linking both rows to the same invoice. Do not describe the reimbursement as another purchase of the same service. Your accountant still needs to decide the appropriate expense, asset and owner-balance entries from the documents and accounting method.

Now add $1,500 of owner funding and a separate $500 withdrawal. The worksheet shows each movement type separately. It does not subtract the withdrawal from the funding and tell you that only $1,000 “happened.” The separate facts may matter even when the bank balance appears straightforward.

Click “Try the fictional example” below to see those four movements. The sample deliberately leaves the withdrawal's evidence reference blank. The missing-reference count helps spot unfinished documentation; it is not a compliance score.

Use the worksheet

Use positive amounts and choose the movement description that fits the evidence. Select “Other / classification unresolved” when you do not yet know. Keep amounts in USD; the tool does not convert currencies. For foreign-currency source transactions, retain the original amounts and conversion method in a separate supporting schedule.

You can add up to 50 rows, remove individual rows and download a CSV for a spreadsheet. The worksheet totals movement categories separately. It intentionally provides no overall “taxable amount,” no filing decision and no amount to copy directly onto Form 5472.

BUILD YOUR OWN WORKING SCHEDULE

Follow the money. Keep the evidence.

Enter USD movements for one entity and one period. Use document references, not names, bank numbers or tax IDs. This worksheet organises records; it does not determine tax treatment or prepare a return.

0 recorded movements

0 missing references

Add a transaction or try the fictional example.

No sign-up or upload. Your entries stay in this page and disappear when you leave or reload it. Download before closing. The file can contain sensitive business information: store and share it carefully.

What to do with the rows marked for review

Missing evidence: find the invoice, payment confirmation or written explanation and give it a stable document reference. A reference entered in the worksheet does not prove the document exists or establishes the correct treatment; check the underlying file.

Unresolved classification: explain what you know without inventing a loan or capital contribution. If the parties agreed repayment terms, supply that agreement. If a payment was reimbursed, link the original expense. If no repayment decision was made, say so and ask the preparer what further facts are needed.

Non-cash arrangements: record property, rights, services and balances that cannot be captured faithfully by this cash worksheet in a separate narrative schedule. Do not insert a nominal $1 just to make the tool accept an event. A record can be relevant even when there is no bank transfer.

Why foreign-owned LLCs need a separate reporting review

For a foreign-owned U.S. disregarded entity, owner transactions can be relevant to Form 5472 even without customer revenue. The IRS instructions cover certain formation-related transactions, contributions and distributions. Whether a particular entity must file, which transactions are reportable and how they belong on the form require a separate analysis.

Read the no-sales reporting guide for the scope and an example. The worksheet does not establish who is a related party, apply the form's exceptions, measure nonmonetary transactions or determine the owner's separate tax position. Those limits are why its categories describe movements rather than assert final tax classifications.

Finish with a useful handover, not an unexplained attachment

Send the worksheet through the secure channel agreed with your preparer, alongside the matching statements and document folder. Include a short note naming the period, any missing accounts, ownership changes and unresolved rows. Keep a copy of the version you supplied so later corrections can be followed.

Ask the preparer to identify the entries that remain provisional. A clean CSV is useful because it makes facts easier to inspect; it does not replace invoices, establish deductibility or confirm a filing is complete. Revisit the schedule when a reimbursement, repayment or correction happens instead of waiting until the next deadline.

The IRS recordkeeping guidance and Publication 583 explain the role of books and supporting evidence. The six-column layout and fictional example here are Taxure's practical organisation approach, not a mandatory IRS template.

Official sources

Check the current instructions and the version that applies to your tax year before acting.

The examples are hypothetical. This guide is general education, not a determination of your filing requirements or tax liability. How we prepare our guides.

Have a different fact pattern?

Tell Taxure what you need reviewed. Please arrange secure sharing separately for tax returns, identity documents and account details.

Ask about a consultation ↗