Preparing a Profit Summary and Planning Cash Needs
Use your records to compare trading performance with the money available for upcoming payments.
Use your records to compare trading performance with the money available for upcoming payments.
Part 8 of 10 | Bookkeeping for Small Businesses
Learning goals
You will prepare a simplified management profit summary, distinguish gross profit from the result after operating expenses and build a short cash forecast. You will explain why loan principal, owner withdrawals and stock purchases affect cash differently from profit.
Before you begin
Allow an hour with a calculator. Use the stated assumptions only. These examples exclude VAT, income tax, depreciation, interest, prepaid expenses, accrued expenses and other adjustments unless specifically included. The resulting management surplus is not a final statutory profit or taxable-income figure.
Define the period and records
Choose the month or week being reviewed and use transactions belonging to that period. Assemble completed sales, returns, stock figures and operating expenses. Include credit sales under the course's stated management convention, even when money has not arrived. Include the relevant expenses whether paid or still owed, where they belong to that period.
Do not mix this approach with a cash-only list halfway through the report. Write the basis and any simplifying assumptions at the top. Items such as long-use equipment, advance rent and customer deposits can need different treatment. Keep them identified for review rather than forcing them into ordinary sales or expenses.
Calculate a simplified result
In an independent fictional month, sales are GMD 8,000. Opening stock is GMD 2,000, purchases are GMD 4,000 and closing stock is GMD 1,500. With no losses or other stock adjustments assumed, cost of sales is 2,000 plus 4,000 minus 1,500, or GMD 4,500.
Gross profit is GMD 8,000 minus GMD 4,500, giving GMD 3,500. Suppose operating expenses belonging to the month are rent GMD 1,000, delivery GMD 300 and account charges GMD 50. Total operating expenses are GMD 1,350. The simplified surplus before excluded items is GMD 2,150.
Interpret the result carefully
The surplus indicates how trading performed under the example's assumptions. It is not a statement that GMD 2,150 can safely be withdrawn. Customers may still owe money, bills may be due, replacement stock may be needed and tax or financing obligations may exist. Ask both whether the business earned a surplus and whether it can meet its next payments.
An owner's contribution can improve available cash without improving sales. Loan principal received or repaid changes financing and the amount owed; it is not sales or ordinary operating expense. Interest and charges are separate items needing their proper treatment. A long-use asset purchase also consumes cash while its effect on profit can be spread or adjusted under the applicable accounting policy.
Prepare a simple cash forecast
Start with actual available money and estimate collections and payments for a stated future period. Separate confirmed receipts from uncertain ones. Forecast when customers are likely to pay, not merely when invoices were issued. Include stock payments, supplier settlements, rent, fees, loan payments and planned owner withdrawals as relevant cash movements.
In a separate fictional week, opening available money is GMD 1,500. Expected customer collections are GMD 2,000. Planned stock payments are GMD 1,800 and other payments total GMD 900. Expected closing money is 1,500 plus 2,000 minus 1,800 minus 900, or GMD 800. The calculation is about timing and cash, not that week's profit.
Test uncertainty before committing
Suppose only GMD 800 of the expected collections arrives on time. Closing money becomes 1,500 plus 800 minus 1,800 minus 900, or negative GMD 400. This signals a shortfall under the assumptions. It is not a real negative pile of notes; it means the planned payments exceed the funds expected to be available.
List practical responses to investigate, such as collecting verified overdue invoices, negotiating payment timing before the due date or postponing a nonessential purchase. Do not assume a lender will approve finance or that a supplier will accept delay. Update the forecast when agreements are confirmed and keep a contingency for uncertainty appropriate to the business.
Turn figures into a review habit
Compare the current result with prior periods using the same basis. Ask whether sales volume, selling prices, stock costs or operating expenses explain the change. A higher cash balance following a loan should not be celebrated as improved trading performance. Likewise, lower cash after a planned stock purchase is not by itself proof of a loss.
Write one action with an owner and review date. A report that produces a specific follow-up is more useful than an unexplained total. Keep the evidence and assumptions so someone else can understand how you reached the decision.
Guided exercise
1. Prepare the month summary from sales of GMD 8,000 and the stated stock amounts. Show cost of sales and gross profit.
2. Deduct the three operating expenses and label the GMD 2,150 result with its exclusions.
3. Build the independent weekly forecast using expected collections of GMD 2,000. Calculate the closing money.
4. Repeat with only GMD 800 collected. Identify the shortfall and propose two actions requiring verification.
5. Explain why neither a loan receipt nor an owner withdrawal belongs in ordinary sales or operating expenses in this sole-owner example.
Knowledge check
1. What is the month's gross profit?
2. What is the base-case forecast closing money?
3. Is the simplified surplus automatically taxable income?
Answer guide
1. GMD 3,500 before the GMD 1,350 operating expenses.
2. GMD 800; the delayed-collection case instead shows a GMD 400 shortfall.
3. No. Applicable tax rules and further accounting adjustments must be considered.
Completion standard
Calculate both reports correctly, label their assumptions and explain the difference between profit and cash. Your proposed response to the shortfall must identify what needs confirmation before action.
Sources and verification notes
Original bookkeeping explanations and fictional worked examples. Simplified management records do not establish statutory accounts or tax treatment.
Bookkeeping for Small Businesses
Continue through the course in order. New published parts appear here automatically.
- 1Understanding Bookkeeping and Separating Business Money
- 2Organising Receipts Invoices and Source Records
- 3Building a Daily Cashbook for Cash Bank and Wallet
- 4Recording Sales Credit Customers and Customer Advances
- 5Recording Purchases Expenses and Supplier Balances
- 6Tracking Stock and Calculating the Cost of Sales
- 7Reconciling Accounts and Correcting Bookkeeping Errors
- 8Preparing a Profit Summary and Planning Cash Needs
- 9Preparing Records for Tax and Professional Review
- 10Completing a Monthly Bookkeeping Cycle