BimpBlog

Manufacturing Management Reporting: Profit, Cash and Debt in One Monday Meeting

A fictional household chemicals maker: P&L, cash flow and chain debt in Bimp instead of three Excel files. Figures, steps and reports for a Monday meeting.

DO
Dmytro ObukhovCo-Founder & CEO
Table of contents
In short
  • Every Monday a manufacturing owner asks three things: profit for the month, cash in the accounts and what customers owe. In Bimp the P&L, Cash flow and Customer settlements reports answer them, and all three read the same documents.
  • In the fictional example, net profit for October is €8,950, net cash for the month is +€7,000 and customer debt grew by €15,000 to €62,500. The gap between profit and cash is explained by the retail chains' debt.
  • Three Excel files with different numbers are no longer needed: the meeting starts from one report template, and the argument about whose number is right turns into a conversation about causes.

The company is fictional. Every action in Bimp is a real product feature. The figures in the example are invented, and the arithmetic can be checked on a calculator.

Manufacturing management reporting answers three questions: how much the company earned, how much cash is in the accounts and who owes money. In Bimp three reports answer them: “Income and Expenses (P&L)”, “Cash flow” and “Customer settlements”. In the fictional example net profit for October is €8,950, cash grew by €7,000 over the month and customer debt grew by €15,000.

The owner of CleanHome holds a meeting every Monday at nine. The finance manager arrives with three Excel files: profit in one, cash from bank statements in the second, customer debts in the third. The numbers differ, because the files were put together on different days from different sources. For the first twenty minutes the owner and the finance manager decide which file is right.

Why do people argue about numbers at the meeting?

CleanHome (a fictional company) makes household chemicals: gels, dish soaps and washing powders. It has 85 employees. Products go through two channels: its own wholesale through sales managers and deliveries to three retail chains. The owner manages week by week and wants three answers in one place.

The files disagree for objective reasons. Profit in the first is counted by shipments, cash in the second by payments, and debts in the third are updated by hand once a week. Confusion is added by the fact that bank fees and exchange rate differences sit inside the cost price in one file and on a separate line in another.

When the data lives in one system, the argument disappears. Shipments, payments and expenses are entered as documents, and the reports only group them in different ways.

How do you build manufacturing management reporting in eight steps?

Each step has a help page, linked next to it.

Step 1. Lines of business and items. In the directory you create the lines “Own wholesale” and “Retail chains”, plus income and expense items with groups: production overheads, administrative, selling and non-operating. This decides which line of the report every euro lands in (Projects and lines of business, Income and expense items).

Step 2. The “Income and Expenses (P&L)” report. It shows sales revenue, cost price, gross profit, expense groups, earnings before interest, taxes and depreciation, non-operating items and net profit. The columns come from grouping by months, quarters or years, and the “Lines of business” filter separates wholesale from the chains (Income and Expenses (P&L) report).

Step 3. The “Expenses” and “Non-operating income/expenses” reports. The first quickly shows the groups of operating expenses. The second collects taxes, exchange rate differences and commissions that do not belong in the cost price (Expenses, Non-operating income/expenses).

Step 4. Cash. “Cash flow” gives the opening balance, receipts, expenses and the closing balance by accounts and cash desks. “Net cash flow” adds breakdowns by counterparty and line of business, and “Cash flow by activity type” splits the flow by type of activity, for example into an operating and a financial part (Cash flow, Cash flow by activity type).

Step 5. Customer debt. The “Customer settlements” report shows, for each customer and contract, the opening balance, shipped, paid and closing balance. A positive closing balance means the customer owes money. Overdue debt by days of delay comes from a separate report, provided the contract states the deferral days (Customer settlements).

Step 6. The Trial Balance. When a number looks odd, the report shows turnovers and balances by account, and the “Show as last level: Documents” switch takes you down to the documents (Trial Balance).

Step 7. Templates and export. Filters and grouping are saved with the Save as new template button, and a finished report can be downloaded to your device. The meeting opens the same templates every time (Reports in Bimp).

Step 8. The dashboard. On the start page the owner sees the tiles “Cash balance”, “Gross profit”, “Profitability”, “Revenue” and “Customer payments”. For custom dashboards there is BigQuery with Looker Studio: Bimp support sets up the connection at the request of the company owner (Bimp overview, BigQuery and Looker Studio).

What does the owner see on Monday: profit, cash, debt

Below are CleanHome’s October figures. All amounts are fictional.

Profit on an accrual basis. The P&L for the month, filtered by line of business:

IndicatorOwn wholesale, €Retail chains, €Total, €
Sales revenue60,00090,000150,000
Cost price39,00072,000111,000
Gross profit21,00018,00039,000
Margin on revenue35.0%20.0%26.0%

The chains bring 60% of revenue but only 46% of gross profit (18,000 / 39,000 = 46.2%). That is the first question for the meeting.

Below gross profit, the report shows expenses by group:

RowAmount, €
Gross profit39,000
Production overheads10,500
Administrative expenses7,750
Selling expenses7,000
Total operating expenses25,250
Earnings before interest, taxes and depreciation13,750
Depreciation1,500
Earnings before interest and taxes12,250
Non-operating expenses (commissions 600, exchange rate difference 450, tax on profit 2,250)3,300
Net profit8,950

Check: 10,500 + 7,750 + 7,000 = 25,250. Then 39,000 - 25,250 = 13,750, 13,750 - 1,500 = 12,250, 12,250 - 3,300 = 8,950. Net profit margin is 8,950 / 150,000 = 6.0%. How to read each line of such a report is covered in a separate article, Manufacturing P&L Example: How to Read It.

Cash on actual payments. The “Cash flow” report for October across all accounts and cash desks:

IndicatorAmount, €
Opening balance28,750
Receipts (customer payments)135,000
Expenses: suppliers 77,500, salaries 29,500, other operating 14,000, taxes and fees 7,000128,000
Net cash flow7,000
Closing balance35,750

Check: 135,000 - 128,000 = 7,000, and 28,750 + 7,000 = 35,750.

Where did the debt go, if profit is €8,950 and cash grew by only €7,000?

Revenue for the month is €150,000, but payments came to €135,000. The €15,000 difference went into receivables. The “Customer settlements” report shows where.

IndicatorAmount, €
Opening customer debt47,500
Shipped in October150,000
Paid135,000
Closing balance62,500

Check: 47,500 + 150,000 - 135,000 = 62,500, and the growth is 62,500 - 47,500 = 15,000.

Expanding by customer shows that all the debt sits with the chains: the first chain owes €28,750, the second €20,500, the third €13,250. Total 28,750 + 20,500 + 13,250 = 62,500. Wholesale buyers pay on the day of shipment, so they carry no debt. The overdue debt report adds that €18,500 of this amount is already past its due date: €13,250 for the third chain and €5,250 for the second.

Challenge

The owner builds the meeting from three Excel files. Profit, cash and debt differ between them, and the first twenty minutes go on arguing about which file is right.

Solution with Bimp

Lines and items are set up once. The meeting opens saved templates of the P&L, Cash flow and Customer settlements reports, which read the same documents.

Result in numbers

Net profit is €8,950 (6.0% of revenue), net cash flow is +€7,000, and customer debt is €62,500 (up €15,000), of which €18,500 is overdue at two chains.

How does the meeting change when the reports agree?

The talk about numbers is replaced by a talk about decisions. The owner sees that the chains bring only 46% of gross profit, and that all of the debt growth sits with them. Now it is possible to discuss terms: shorten the deferral, introduce prepayment for the third chain or review its prices.

The finance manager gets back the time spent collecting files. Notionally, one and a half days a week of reconciliation turn into two hours of meeting preparation. When the owner doubts a number, they open the Trial Balance, expand the account down to documents and see what stands behind it. No call to the accountant is needed.

How management accounting is built across a manufacturer is covered in Management Accounting for Manufacturers: Where to Start. Bimp is a Ukrainian cloud ERP for manufacturers, and all of these reports work in one system, so the numbers do not diverge by source.

What Bimp does and what stays with you

Reports are built from posted documents, so an unposted payment or invoice will not reach them. If a document has no item or line of business, the amount ends up in the wrong report line, and the Trial Balance helps to find it. Opening balances on accounts are entered before the first report, otherwise the starting balance is zero.

Profit and cash always diverge, and that is the normal state for a manufacturer that grants deferrals. Bimp shows the reason for the gap, while the decision on deferrals is the owner’s. The BigQuery connection is made by support and does not switch on by itself. Some help articles that the steps rely on are still under verification, so check the button names against your version.

CleanHome’s financial picture for October fit into three report templates: profit of €8,950, cash of +€7,000 and debt of €62,500 with a clear address. To set up such reports on your own lines and items, see the Finance and reporting in Bimp page.

FAQ

Why does the profit in the P&L differ from the money in the account?

The P&L counts profit on an accrual basis: a shipment lands in revenue on the day of the sale. The Cash flow report shows actual payments. The difference comes from customer debt, advances to suppliers and payments that fall in another month.

Can you see profit for each line of business separately?

Yes. In the "Income and Expenses (P&L)" report the "Lines of business" and "Project" filters build a separate report for your own wholesale and for the retail chains. Lines and projects are created in the directory before the first documents.

Why does an owner need the Trial Balance?

It helps to verify numbers that look odd. It shows turnovers and balances for every accounting account, and the "Show as last level: Documents" switch expands a balance down to the documents it was built from.

Can you build your own dashboards on top of Bimp data?

Yes, through BigQuery and Looker Studio. The export is enabled by Bimp support at the request of the company owner: send the company ID and a Google email. It cannot be switched on in the interface by yourself.

See the owner's Monday on your own data

In a Bimp ERP demo a specialist builds the P&L, cash flow and customer debt in the breakdowns your meeting needs.

Book a demo
DODmytro ObukhovCo-Founder & CEO