Saturday, January 30, 2010

, ,

Incomplete Records Calculations: Profit, Sales & Purchases

Last reviewed: July 2026.

This guide explains the main incomplete-records calculations used to reconstruct profit, credit sales, credit purchases, cash movements, gross profit and inventory. Each method uses an accounting equation or control-account relationship; a balancing figure should be accepted only after the other movements have been checked.

Quick answer: calculate profit from the change in net assets, use receivables and payables control accounts for missing credit sales and purchases, use the trading relationship for inventory and gross profit, and use a cash account for missing receipts, payments or drawings.

For the evidence, workflow, professional-judgement and control process, read the main incomplete records accounting methods and workflow guide.

Incomplete-records formula summary

Calculation Relationship
ProfitClosing net assets − Opening net assets + Drawings − Additional capital
Credit salesReceipts + Returns + Discounts + Write-offs + Closing receivables − Opening receivables
Credit purchasesPayments + Returns + Discounts + Closing payables − Opening payables
Cost of salesOpening inventory + Purchases − Closing inventory
PurchasesCost of sales + Closing inventory − Opening inventory
Missing cash itemOpening cash/bank + Receipts − Known payments − Closing cash/bank

Method 1: calculate profit from net assets

When a reliable income statement is unavailable, compare opening and closing net assets and adjust for owner transactions:

Profit = Closing net assets − Opening net assets + Drawings − Additional capital

Example:

Closing net assets108,000 CU
Less: opening net assets(80,000 CU)
Add: drawings18,000 CU
Less: additional capital(10,000 CU)
Profit36,000 CU

The result is only as reliable as the opening and closing assets and liabilities. Verify inventory, receivables, payables, accruals and owner transactions before accepting the profit.

Method 2: reconstruct credit sales

A receivables control account derives the credit sales needed to explain opening receivables, customer collections, returns, discounts, write-offs and closing receivables.

Assume:

  • opening receivables: 25,000 CU;
  • cash received from customers: 160,000 CU;
  • sales returns: 4,000 CU;
  • irrecoverable debts: 2,000 CU;
  • closing receivables: 31,000 CU.

Credit sales = 160,000 + 4,000 + 2,000 + 31,000 − 25,000 = 172,000 CU

Add settlement discounts, refunds and contra entries when relevant. Do not include cash sales in the receivables control account.

Method 3: reconstruct credit purchases

The payables relationship is similar:

Opening payables + Credit purchases − Payments − Purchase returns − Discounts = Closing payables

Assume opening payables are 18,000 CU, supplier payments are 110,000 CU, purchase returns are 3,000 CU, discounts received are 2,000 CU and closing payables are 24,000 CU.

Credit purchases = 110,000 + 3,000 + 2,000 + 24,000 − 18,000 = 121,000 CU

Compare the result with supplier statements, unpaid invoices and bank payments. Investigate credit notes and invoices recorded in the wrong supplier account.

Method 4: use gross margin and mark-up

Gross margin is gross profit divided by sales. Mark-up is gross profit divided by cost. They are not interchangeable.

Information Meaning
25% gross margin on salesGross profit = 25% of sales; cost of sales = 75% of sales
25% mark-up on costGross profit = 25% of cost; sales = 125% of cost

If cost of sales is 75,000 CU and gross margin is 25% of sales:

Sales = 75,000 × 100 ÷ 75 = 100,000 CU

Once cost of sales is known:

Purchases = Cost of sales + Closing inventory − Opening inventory

Use historical margins cautiously where product mix, prices, discounts, wastage, theft or damaged inventory changed during the period.

Method 5: build a cash and bank summary

A cash account can derive a missing drawing, cash sale, expense or receipt. First update the ledger for direct debits, charges, interest and electronic receipts found on the bank statement.

Example: opening bank balance is 8,000 CU, total receipts are 220,000 CU, known payments are 205,000 CU and closing bank balance is 11,000 CU.

Missing drawings = 8,000 + 220,000 − 205,000 − 11,000 = 12,000 CU

Separate transfers, loans, capital introduced and asset-sale proceeds from trading receipts. A balancing figure is not necessarily sales or drawings until the other movements have been classified.

Integrated worked example

A trader has opening receivables of 20,000 CU, closing receivables of 27,000 CU, customer receipts of 145,000 CU and sales returns of 3,000 CU.

Credit sales:

145,000 + 3,000 + 27,000 − 20,000 = 155,000 CU

If cash sales are 35,000 CU:

Total sales = 155,000 + 35,000 = 190,000 CU

If gross margin is 30% of sales:

  • gross profit = 190,000 × 30% = 57,000 CU;
  • cost of sales = 190,000 − 57,000 = 133,000 CU.

With opening inventory of 18,000 CU and closing inventory of 22,000 CU:

Purchases = 133,000 + 22,000 − 18,000 = 137,000 CU

Cross-check the purchases against supplier statements, bank payments and the payables control account. Then add operating expenses and year-end adjustments to prepare the detailed profit calculation.

Cross-checks and common errors

  • agree opening balances to the prior financial statements;
  • reconcile customer and supplier balances to supporting evidence;
  • keep cash sales separate from credit sales;
  • include returns, discounts, write-offs, refunds and contra entries;
  • distinguish gross margin from mark-up;
  • verify inventory quantity, valuation and cut-off;
  • include drawings and additional capital in the net-assets formula;
  • do not force unexplained differences into profit or suspense;
  • compare the detailed profit with the movement in net assets;
  • document estimates and limitations.

Frequently asked questions

Why are closing receivables added when calculating credit sales?

They represent sales not yet collected at the end of the period. The control account must include them to explain the closing balance.

Are cash sales included in credit sales?

No. Cash sales do not pass through trade receivables and must be added separately when calculating total sales.

How do I convert a margin to sales?

If gross margin is 25% of sales, cost of sales is 75%. Divide cost of sales by 75% or multiply it by 100/75.

Can profit be calculated only from net assets?

It can be estimated from net assets, drawings and capital introduced, but the underlying assets and liabilities must be complete and reliable. A detailed reconstruction should be used as a cross-check.

Authoritative references and related guides

Key takeaway: derive missing figures from linked accounting relationships, check the other movements first and reconcile each answer to independent evidence and the overall financial position.

This article is for educational purposes. Actual reconstructions may require professional accounting, tax, audit or legal advice.

Advertisement