Skip to content

Blog · Management

More sales, less cash: what the month-end close should explain

A useful monthly report explains why the result changed, separates what was invoiced from what reached the bank, shows the margin by activity with clear criteria and compares the forecast with the actual figures. It also states what information is still to be confirmed. I write it for the people who make decisions, not for those who know account names.

Which decisions does the report have to support?

The owner receives the trial balance and still does not know whether they can hire someone or buy the machine. It happens in companies whose accounts are up to date. That is why I start with the decisions on the table and only then choose what the report shows.

Handing over the trial balance is not the same as explaining the month. If the company sold more and the result got worse, the report has to say why: margins fell, an expense went up or a movement was recorded in another month. Without knowing the cause, raising prices or cutting costs is deciding in the dark.

Why is the profit not in the bank?

Because profit and cash answer different questions. A month with a positive result can end with cash tight, simply because customers have not yet paid while salaries and suppliers have already fallen due. I always separate what was invoiced from what reached the bank, and only then look at the commitments the company can take on.

I also look at amounts received for work not yet carried out. The bank balance does not say how much is free to spend, because there are future payments linked to that work. Bank, customer and supplier reconciliations show these differences. The report makes them readable, without the business owner having to rebuild the accounts.

Which activity made a margin?

The company total can hide large differences between products, services, customers or projects. I ask for a reading of the margins at the level that makes sense for the business: by product in a shop, by project in a construction company, by customer in a services company. Cost accounting only helps if the allocation criteria are understood and applied consistently.

If an expense is allocated across projects, the criterion is put in writing. If information is missing to allocate a cost, that is also stated. I prefer an acknowledged limitation to a column filled with a figure that looks precise and is not, and I say what information the company needs to start collecting.

Example

Sales up, cash tight

A restaurant is invoicing more than last year and the owner keeps putting off payments. He wants to hire, but does not know whether he can. The cost of some products has gone up and part of the sales is collected later. The total invoiced does not tell him how much he has available in the month.

I separate the reading of the margin from the reading of collections and try to find out whether the pressure comes from the business, from earlier commitments or from both. The decision to hire needs a forecast of the coming months’ payments. The conclusion may be to go ahead, to review the expense or to wait for more information.

What information is still to be confirmed?

Before using the report, I want to know whether any document is missing that could change the reading, such as an expense whose supporting document has not yet arrived or a transaction still to be identified. The report states which figures these are and marks the reading as provisional until they are clarified. Nor does it compare months prepared under different conditions without flagging it.

How should variances from budget be read?

When there is a budget, I compare the forecast with the actual figures and explain the differences that matter. A sale that moved to the following month reads differently from a lost customer. A one-off expense reads differently from a cost that will continue. Without this distinction, the comparison leads to wrong conclusions about the business.

At the end of the reading, I want to be able to say what needs to be clarified and what decision can be taken. It may be collecting a balance or reviewing a margin.

Three questions to ask at every month-end close

  • How much did I invoice and how much did I receive?
  • Which activity made a margin, and which one used it up?
  • What still needs confirming before deciding?

Frequently asked questions

What is the difference between profit and cash?

Profit compares the income and expenses of the period, even if they have not yet been received or paid: a sale counts in the month it is made, not in the month the customer pays. Cash tracks what comes in and what goes out, the money that actually comes in and goes out. A month can show a profit and little cash if customers have not yet paid.

Is the trial balance enough to make decisions?

Rarely, on its own. It shows the account balances, but does not explain why they changed or what decision they call for. That requires a written commentary.

What is cost accounting?

It is the part of accounting that allocates costs and income by activity, product, customer or project. It only helps if the allocation criteria are clear and applied consistently.

Can the report contain provisional figures?

It can, provided the monthly report identifies which figures are provisional and when they become final.

Portrait of André Romano
Written by

André Romano

Account Manager

Account Manager at Segmentos Capital.

Reviewed by Patrícia Cardona Gomes, Partner.

Meet the team

Have you read something that applies to your company?

Tell us what you are dealing with. The first conversation is for us to understand what you need, and it commits you to nothing.