Financial Reports

Two Companies, Two Ledgers, and a Quarter That Won’t Close

Two Companies, Two Ledgers, and a Quarter That Won’t Close
Key Takeaways
  • Intercompany reconciliation is what holds the close open: When one person keeps the books for more than one company, matching up what each company paid on the other's behalf is usually the slowest step of the month.
  • The workbook that ties it together is a single point of failure: Exports, copy-and-paste and a hand-built consolidation sheet leave plenty of room for lost data and errors nobody spots until later.
  • Late numbers cost more than people can put a figure on: Owners and small teams know that running weeks behind affects their decisions, even when they can't say by how much.
  • You can keep Excel and still automate the plumbing: Connecting each company's ledger and refreshing consolidated reports in Excel removes the manual steps, and everyone keeps the spreadsheet they built.

I asked an owner how long his month-end takes. He told me he does all of it himself, that it takes way too long, and that he still hadn’t closed the previous quarter. Then he apologized, as if it were a personal failing.

It isn’t. I hear a version of that answer almost every week, usually from someone good at the job who’s carrying more than one company’s books in a spreadsheet built for just one.

This piece is based on three conversations I had in the fall of 2026, with any identifying details changed.

Why does intercompany reconciliation slow down the month-end close process?

Intercompany reconciliation is the month-end check that two related companies recorded the same transactions the same way: what one booked as owed, the other booked as owing. Until the two sides match, the eliminations can’t be posted and the group’s books can’t close.

PwC finds that even at much larger companies, the process is often manual, and many organizations can’t complete it on time.

The owner I just mentioned runs two companies that pay each other’s expenses. That’s common, and it’s sensible: one company covers a bill because it’s convenient, and the other settles up later. Those intercompany transactions pile up all month, and at month-end someone has to work out who owes whom.

He told me most of his month-end close process isn’t hard. The slow part is the intercompany reconciliation, done by hand. After that he exports both sets of books into a spreadsheet he designed himself to combine them, and builds his reports from there. He was blunt about what that costs: plenty of room for lost data, and plenty of room for human error.

What struck me was how much he likes Excel. He had no interest in leaving it. He wanted the reports in his Excel to stay current on their own, so he could stop downloading a fresh one every time and checking he had the latest.

I asked him what being a quarter behind costs the business. He said he couldn’t put a number on it, but he wasn’t naive enough to think the answer was nothing. That’s the most honest answer I get to that question, and it’s the one I hear most.

What happens when companies in the same group close their books on different days?

A few days earlier I’d spoken with a small finance team running the books for a group of several companies. Same problem, bigger.

They do their intercompany accounting in Excel, calculating intercompany charges and allocations there before entering them into their accounting system. To see the group as a whole, they export everything back out into Excel and consolidate it there. Some of the companies close their books on different days, so the team moves dates back by hand to make the periods line up. Even then, they told me, they never get fully consolidated financial reporting. The Hackett Group lists timing issues between the two sides of an intercompany transaction among the top intercompany pain points.

Then there’s cash. Every week, someone spends most of a working day rebuilding bank balances and payment terms, without a clear view of the checks still outstanding. One of them summed up the whole setup as Excel hell.

Then we got to the allocation they recalculate every month, the one that spreads corporate costs across the companies. When I showed them it could run on its own, you could see the relief.

What does it cost to move numbers from the accounting system into Excel by hand?

The third conversation was with a single company, but the shape was the same.

The person keeping the books had inherited them years behind and rebuilt them herself. To get numbers out of the accounting system and into Excel, she prints the report, emails it to herself and converts the file. She called the process a nightmare, with feeling.

The cost shows up in odd places. Without up-to-date numbers, things get missed, and the business ends up paying more to rush a part overnight than the part cost in the first place.

When I described her reports refreshing without the print-and-email routine, and being able to check them from her phone, she said: “Oh my gosh, that would be so nice.”

What do these three small finance teams have in common?

All three are good at what they do and comfortable in Excel, and two of them love it. The trouble sits upstream of their spreadsheets, in the journey the data takes to reach them: the exports, the copying and pasting, the hand-built consolidation and the reconciliations nobody else knows how to do.

So that’s what I talk about on these calls. Datarails FP&A, built on FinanceOS, connects directly to each company’s accounting system and handles the multi-entity consolidation, applying intercompany eliminations and allocations the same way every month. We set it up around how your companies already book intercompany charges, and because it runs on FinanceOS, every consolidated number traces back to the source ledger. The reports then refresh in Excel, and on dashboards you can open on your phone. At month-end, or halfway through the month if you want a look, you refresh and open your P&L, balance sheet and cash flow. The workbook stays the one you built, and the trips to get data into it stop.

Can one person automate financial reporting for several companies?

Every one of these conversations reaches that question eventually. My answer is a controller at a medical device incubator.

She covers the holding company and three spinouts on her own, which is the owner’s situation above with two more companies added. She found us through an ad about stressed-out CFOs who need a report for the CEO in 30 minutes, and told us it felt a little too real. Her multi-entity reports used to take hours or days of exporting and reformatting. Now they take about an hour.

The people I talk to care about that comparison most, because they’re usually one person covering several sets of books and trying to get their Friday afternoon back.

Where should you start if you keep the books for more than one company?

If you’re the one keeping more than one company’s books, time the intercompany reconciliation at your next month-end. In most of my conversations, that’s the step holding the close open, and it’s the first one worth taking off your plate.

A final word

If you’ve ever apologized for how long your close takes, like the owner I started with, please don’t. You built something that worked when there was one company and a lot less going on. It just has more to carry now than any one person should be carrying by hand.

If any of these three conversations sounded familiar, I’d love for you to see what your month-end looks like when the numbers arrive on their own. Book a demo, tell us how your companies are set up, and we’ll walk you through it using your own reports. Bring your spreadsheet. You’ll be keeping it.

Related Articles

Become a Partner

Drive Business Performance With Datarails

Drive Business Performance With Datarails

Drive Business Performance With Datarails

Drive Business Performance With Datarails

Drive Business Performance With Datarails

Drive Business Performance With Datarails