- Industry
- Retail
- Department
- Finance
- Team
- Accounting Operations
- Kind
- Assistant
- Approver
- Finance Controller
- Code
- FIN-08
It runs the month-end close checklist for the retailer: sales cut-off across stores and online, stock valuation and shrink provision, markdown and returns provisions, gift card and loyalty deferrals, vendor rebate accruals and intercompany. It tracks each task to its owner and deadline and reports what is late or blocking.
How it works
6 steps, and a person signs off before step 6.
- 01Looks it up
Finds the record the request is about in the ERP's general ledger: the close checklist status, stock and count results from the inventory system, sales and returns by channel, and rebate agreements..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Works it through
Prepares the draft, match, recommendation or reply, with its sources.
- 05Asks a person
Hands the work to Finance Controller with its reasoning before anything goes out.
- 06Acts
Once approved, it acts in the ERP's general ledger: it updates the close checklist and posts the provision journals as drafts. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The close calendar and checklist: the tasks, owners and deadlines by working day, the stock count and shrink provision method, the returns and markdown provisions, the gift card breakage policy and the rebate accrual method.
Reads from
the ERP's general ledger: the close checklist status, stock and count results from the inventory system, sales and returns by channel, and rebate agreements.
Acts in
the ERP's general ledger: it updates the close checklist and posts the provision journals as drafts.
Hands back
An object with tasks (a list of task, owner, due_day, status and note), provisions (a list of provision, amount and basis), blockers (a list) and on_track (true or false).
Asks a person when
A provision rate changes from the policy, or the close will miss day 5.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Close by working day | 5 | The close finishes on this working day. |
| Shrink provision for uncounted stores (% of sales) | 1.5 | Stores not counted this period are provided for at this share of sales. |
| Returns provision (% of last month's online sales) | 8 | The expected returns provided for at month-end. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Cut off sales at the last trading day: online orders count when shipped or collected, not when placed.
- Provide for shrink at 1.5 percent of sales for stores not counted this period, and true up counted stores to the count.
- Provide for returns at 8 percent of last month's online sales unless the returns data supports another rate.
- Accrue vendor rebates earned to date from the agreements and purchases, never on hope of a deal.
- Report every task late against its working day and anything that puts day 5 at risk.
See the Month-End Close Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.