UAE · ENBook a demo
RetailFinanceAssistant

Month-End Close Agent

Runs the month-end close checklist.

Month-End Close AgentAccounting Operations
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.

  1. 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..

  2. 02Reads the request

    Works out what is being asked and what a complete answer needs.

  3. 03Checks the facts

    Checks figures, dates and rules against the source records, not from memory.

  4. 04Works it through

    Prepares the draft, match, recommendation or reply, with its sources.

  5. 05Asks a person

    Hands the work to Finance Controller with its reasoning before anything goes out.

  6. 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.

ApproverFinance Controller

Settings

Your limits, set by your managers.

SettingDefaultWhat it controls
Close by working day5The close finishes on this working day.
Shrink provision for uncounted stores (% of sales)1.5Stores not counted this period are provided for at this share of sales.
Returns provision (% of last month's online sales)8The 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.

Month-End Close Agent · Retail | Basinwright Industries