lamp.
ResourcesPricingAbout
3 min readBy

Record-to-report: daily operating review pack

This is the daily sheet used by the bookkeeper, the accountant and the owner while the month's books are being closed. It shows which reconciliations are done, which bills are not yet posted, which journals await approval and what stands between the books and a clean trial balance. The close then moves day by day instead of waiting on one person's memory.

When to use it

Use it every working day from the last two days of the month until the month is soft closed, normally a few working days into the next month. Outside that window, a weekly look at the same list is enough.

The template

A bookkeeper in a small firm may also be the accountant. When that happens, ask the owner to read the unposted bills and the journals, because the second pair of eyes is the point of the sheet.

Review itemInputWhat to settle todayOwnerDecisionDue
Bank and source reconciliationBank statement and payment gateway or cash recordsWhich accounts are reconciled, which have open differences?Bookkeeper
Bills or entries not postedLedger and bill folderWhich bills received this month are not yet in the books?Accountant
Accruals and closing stockJournal approval and stock countWhich journals are drafted, supported and approved?Owner
Trial balance and reportsTrial balance and management reportsWhich balances look unusual against last month?Bookkeeper
Soft closeMonth-close statusCan the month be closed, and who approves later changes?Accountant

How to fill it

  • Review item: keep the five lines in order. The first four feed the last; do not close before they are settled.
  • Input: name the file or statement used and its date, such as "HDFC statement to 31 Oct".
  • What to settle today: answer in numbers wherever possible, such as "3 of 4 accounts reconciled, difference ₹2,310 on the fourth".
  • Owner: a person's name. Journals need an owner who did not post them.
  • Decision: a short action, such as "post five bills today" or "hold close until the stock count is in".
  • Due: a date. If an entry touches tax or a statutory record, Check the current rule on the official portal or with your CA before acting.

Example row

Review itemInputWhat to settle todayOwnerDecisionDue
Bills or entries not postedBill folder, October7 bills worth ₹1,12,400 received but not postedAccountantPost all seven today; confirm none belongs to November before posting2 Nov

Review and sign-off

  • The bookkeeper updates the sheet each morning and the accountant reads it before approving any journal.
  • The owner reviews the sheet on the day before soft close and again when it is done, and signs off the close.
  • Escalate to the owner when a reconciliation difference is still unexplained on the day before close, when stock count is late, or when someone asks to post into a closed month without approval.

Keeping it up to date

  • Keep each day's sheet. If a decision changes, add a new line with the date and reason, not an overwrite.
  • At the end of each close, write down the three items that took the most time and fix their cause before the next month.
  • Keep the sheets with the month's reports for the period your CA or the law requires.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →