UAE · ENBook a demo
RetailFinanceAssistant

Bookkeeping Agent

Records and categorizes transactions.

Bookkeeping AgentAccounting Operations
Industry
Retail
Department
Finance
Team
Accounting Operations
Kind
Assistant
Approver
Finance Controller
Code
FIN-01

It records and codes the day's transactions from store tills, online orders, marketplace sales, returns, gift card sales and redemptions and loyalty points, posting them to the right store, channel and category cost centres. It flags anything it cannot code, such as an unknown store number or a gift card liability that does not balance, rather than guessing.

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 chart of accounts, store and category cost centres, tax codes and the day's sales summaries from the point-of-sale and order systems..

  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 posts the coded journals and holds the rest in suspense. and records what was done.

What it works with

Your knowledge, your systems, your people.

Knows

The chart of accounts and coding rules: accounts by revenue stream (store, online, marketplace), store and category cost centres, the treatment of gift cards and loyalty points as deferred revenue, sales tax by jurisdiction, and the returns provision.

Reads from

the ERP's general ledger: the chart of accounts, store and category cost centres, tax codes and the day's sales summaries from the point-of-sale and order systems.

Acts in

the ERP's general ledger: it posts the coded journals and holds the rest in suspense.

Hands back

A list with one entry per transaction, each with date, account, cost_centre, category, debit, credit, tax_code, confidence and status (posted or held) with reason.

Asks a person when

An item is held in 1999 Unallocated, a day's till sales do not match the bank and card totals, or a journal exceeds the posting limit.

ApproverFinance Controller

Settings

Your limits, set by your managers.

SettingDefaultWhat it controls
Post without review above confidence0.9Transactions coded with lower confidence wait for review.
Suspense account1999 UnallocatedWhere uncodable items are held.
Book gift card sales as a liabilityOnWhen on, gift card sales are deferred revenue until redeemed.
Revenue deferred for points issued (%)1The share of sale value deferred for loyalty points issued, from the points valuation.

Limits are settings, not code: a manager changes them without a developer.

Rules it always follows

  • Code each transaction to the account, store or channel cost centre and category from the coding rules; never invent a code.
  • When on is true, gift card sales are deferred revenue and only redemptions are revenue.
  • Defer 1 percent of qualifying sales for loyalty points issued, and release it when points are redeemed or expire.
  • Post sales tax to the jurisdiction of the store, or of the delivery address for online orders.
  • Post only above 0.9 confidence; hold the rest in 1999 Unallocated with the reason.
  • Returns reverse the original sale's coding, not today's.

See the Bookkeeping Agent agent on your own work.

We’ll run it on a sample of your work and show you what your approver would see.

Bookkeeping Agent · Retail | Basinwright Industries