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 item | Input | What to settle today | Owner | Decision | Due |
|---|---|---|---|---|---|
| Bank and source reconciliation | Bank statement and payment gateway or cash records | Which accounts are reconciled, which have open differences? | Bookkeeper | ||
| Bills or entries not posted | Ledger and bill folder | Which bills received this month are not yet in the books? | Accountant | ||
| Accruals and closing stock | Journal approval and stock count | Which journals are drafted, supported and approved? | Owner | ||
| Trial balance and reports | Trial balance and management reports | Which balances look unusual against last month? | Bookkeeper | ||
| Soft close | Month-close status | Can 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 item | Input | What to settle today | Owner | Decision | Due |
|---|---|---|---|---|---|
| Bills or entries not posted | Bill folder, October | 7 bills worth ₹1,12,400 received but not posted | Accountant | Post all seven today; confirm none belongs to November before posting | 2 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.