Skip to content

Payments & bookkeeping · 45

How to prepare a monthly shop accounts summary

Bring sales, stock, dues, expenses and money movements together for a useful month-end review.

The quick answer

A monthly summary should explain both trading activity and the closing position. Sales alone do not show unpaid customers, unsold stock, supplier dues or actual cash. Use the same period and clear supporting records.

Dukanam brings everyday billing and bookkeeping records together. Prepare the summary from reconciled entries and use your accountant for the final accounting and statutory treatment.

Before you begin

  • A defined month and complete transaction records.
  • Cash/bank evidence and stock counts where required.
  • Schedules for customer dues, supplier dues and owner movements.

See how the pieces connect

  1. Complete

    Enter missing supported transactions.

  2. Reconcile

    Match stock, money and balances.

  3. Summarise

    Prepare consistent schedules.

  4. Review

    Resolve differences and agree actions.

Work through the steps

  1. Set the cut-off

    Use the month’s opening and closing dates. Identify late supplier invoices, goods received and pending settlements. Keep corrections traceable so the accountant understands what changed.

  2. Complete sales and purchases

    Check document sequences, returns, discounts and duplicate entries. Match purchases to received goods and supplier invoices. A draft order should not appear as a completed purchase.

  3. Reconcile money

    Match drawer cash, UPI, card settlements and bank movements. Separate collections on old bills, owner transfers and loans. List pending settlements with references rather than forcing the balance.

  4. Review stock and dues

    Check opening stock plus receipts minus issues against closing quantities. Prepare customer and supplier balance schedules. Investigate large or aged differences and preserve accepted credit notes.

  5. Summarise costs and results

    Give the accountant relevant sales, supported cost, expenses and asset/owner movement details. Label gross profit separately from net profit. Use one consistent tax and valuation basis.

  6. Agree the next actions

    List overdue collections, supplier payments, stock issues and unresolved documents. Record who will resolve each item and when. Keep the final schedules and evidence accessible for the next review.

A summary needs several views

Illustrative review items, not a complete financial statement.

Schedule What it explains
Sales and returns Trading activity during the month
Customer dues Money still to collect
Supplier dues Money still to pay
Stock closing Goods remaining
Cash and bank Verified funds and pending differences

These schedules connect the month’s activity with the closing position. They cannot be replaced by one total sales number.

Common mistakes to avoid

  • Comparing schedules from different dates.
  • Ignoring unpaid bills and unsold stock.
  • Forcing cash differences into sales.
  • Sending unexplained totals without documents.

Questions you might have

Is this the same as a filed GST return?

No. It prepares records for review. Filing requires the relevant statutory workflow and reconciliations.

Should I wait until year end?

Regular month-end checks make errors easier to resolve while the evidence is still available.

A smart, low-cost choice for small-business GST billing

Dukanam brings billing, purchases, stock, customer balances, payments and reports together. It is built for Indian small businesses that want clear records without a complicated setup.

Best suited to shops that want connected everyday billing and bookkeeping, web and mobile access, and nine product languages. Choose the plan that includes the features you need.

GST-aware billing and preparation depend on your plan. Review records before filing on the GST portal; Dukanam does not directly submit GST returns, government e-invoices or e-way bills.

Current plans with GST preparation

  • Advanced Plan₹299.00 per month

Check annual prices, limits, applicable taxes and checkout terms. Paid plans do not include a free trial.

Sources and further reading

Official rules and portal screens can change. Use the linked authority for the current requirements; the figures in our worked examples are illustrative.