Expense Sheet Multiple Companies Template: Templates and Setup

Use one stable company ID on every entry. Select that ID and a reporting period before reading a total. Keep a single reporting currency in the core file, with conversion evidence retained separately when needed. Check a sample from each company before exporting. This is a shared register with entity filters; it does not eliminate intercompany items or create consolidated financial statements.

Preview the expense sheet multiple companies template

The core Transactions tab has separate company and project columns. A project can belong to a company, but its ID is not a substitute for the company field. Keeping both explicit makes the selected scope visible when you review or export a report.

In this fictional January sample, A has 180 and B has 70. Adding them gives 250 recorded costs, but that combined number is only a sum of entered rows. It does not automatically have the meaning or adjustments required for a consolidated report.

Set company IDs before entering records

Choose a short, unambiguous code for each business. Keep a private list that maps code to entity. Avoid names that differ only by punctuation or spacing. “A”, “A ” and an informal trading name can split one company across different criteria if entered inconsistently.

Put the company ID on each cost row, even when a group of rows all belongs to the same entity. A blank cell that visually inherits the label from the row above will not necessarily meet the formula criteria. Sorting makes that visual assumption especially fragile.

Record costs for the correct entity

Use the source document to identify which company incurred the cost. The card or account used may help, but it does not settle every shared-cost question. If a purchase relates to several entities, keep the allocation decision and its evidence outside a guessed label.

Do not enter the full cost under each company unless that accurately describes separate events. A shared payment can otherwise become two costs in the combined register. Keep a link between any split rows and the original source so a later reviewer can see how the amounts fit together.

Filter and total each company

The monthly summary combines an inclusive start, exclusive end and selected company criterion. All ranges cover the same rows. The fictional 999 company A cost on 1 February does not belong in January. Company B's January 70 does not belong in A's total.

Check a known item from each entity. One correct company total does not prove that the others are complete. Look for blank IDs, spelling variants and rows beyond the formula range. Review exceptions before exporting an entity's records.

Keep currency and access separate from filters

The core file uses one reporting currency. A company column does not make amounts in different currencies comparable. Preserve the original amount and conversion source when converting records into the reporting currency. Do not add 100 USD and 100 EUR as if the numeric sum described a single amount.

Filters do not secure company data. Anyone with access to the workbook may be able to view other rows. If different reviewers must not see other entities, use separate controlled files or a system with the required access model. Do not rely on a hidden tab or filter selection as a confidentiality boundary.

Export separate company records

State the company and period in the export filename or cover record. Inspect the export rather than assuming the current screen filter controls every export route. Compare row count, source IDs and total against the selected company's reviewed records.

Keep the original workbook and a period copy. A CSV does not retain formula checks or the rest of the company context. If the receiving system uses a different company code, record the mapping and reconcile the imported amount. An export is a transfer step, not proof that the receiving records are correct.

Understand the consolidation limit

This file does not eliminate intercompany sales, balances or shared-cost entries. It does not translate different reporting currencies automatically. The combined sum of rows may be useful for a management question, but its label should state exactly what it includes.

Keep ownership and entity records distinct from the shared workbook. If the task is formal consolidation or an intercompany reconciliation, use the appropriate process. The spreadsheet can supply source rows, provided their company IDs and evidence are sound.

Check the company scope before every handoff

Read the selected ID aloud or put it in the report heading. Compare a known source from that company with the exported rows. Then check that a known row from another company is absent. This small boundary check helps catch a report that was left on the last selection used.

Keep the company code mapping with the private file. If the receiving tool uses a different code, record the change in the handoff. Do not change live company IDs merely to match an export label without checking all related formulas and rows.

Keep shared costs visible as a separate question

When a cost spans entities, keep its source and the supported split together. Check that the parts add to the intended amount and that the original full cost is not counted again. If the split is not yet known, record that question and owner.

The register can hold the resolved rows after review. It does not create a cost-sharing agreement, decide legal responsibility or perform intercompany elimination. Keep the label close to the actual work completed so a combined total does not imply more than the file supplies.

FAQ: multiple-company records

Can each company use its own currency?

The core workbook uses one reporting currency. Keep original foreign amounts and conversion evidence separately, then enter checked reporting amounts. Separate company IDs do not convert currencies. If each entity needs a different reporting currency, consider separate files and a deliberate review process before combining any figures for a group view.

Does a company filter keep data private?

No. A filter changes the view, not the underlying access rights. Someone who can open the workbook may be able to see or copy all rows. Use separate files or suitable access controls when company records must remain separate. Check sharing at the storage folder as well as the file.

What if one receipt covers two companies?

Keep the original receipt and record the supported allocation decision. Link any split rows to that source. Check that the split adds to the intended amount and does not duplicate the full cost under both entities. The template does not decide which company should bear a shared cost or create an allocation policy.

Is the combined total consolidated expense?

It is a sum of entered rows under the selected scope. Formal consolidation may need eliminations, currency work and other adjustments that this file does not perform. Label the combined result as recorded costs rather than implying a complete group financial statement. Keep the individual company exports available for review.

Sources and checks

Checked 15 October 2026. The examples are fictional and the arithmetic is original.

• IRS records: Business recordkeeping and supporting documents.
• Excel SUMIFS: Official multiple-criteria sum syntax.
• Sheets SUMIFS: Official Sheets multiple-criteria sum syntax.
• IRS books: Publication 583, December 2024 edition, Recordkeeping System section.

Related records and guides

• business expense spreadsheet
• expense tracker google sheets
• business expense tracker

Verdict on the expense sheet multiple companies template

Use the expense sheet multiple companies template when stable entity IDs and separate exports answer the task. Check each company's boundary and keep the access and consolidation limits clear.