Skip to content

Finance & accounts: AR ageing, rebate claims and the month-end close

The finance agent reads your AR and AP ageing, claim register, vouchers and close checklist, and invoices in Odoo where you run it. Totals are calculated from the rows you upload, and nothing is sent unless an admin approves it.

Works from: Invoice, Voucher, GL trial balance, Tax return

Where a mill’s finance desk loses cash and days

Finance sees these problems first in its own files: the claim register, the AR ageing, the reconciliation workbook, the AP inbox. They show up later as working capital held by others, a late trial balance, or a vendor kept waiting.

  • Sales tax refunds, rebates and drawback held by the government

    You pay sales tax, GST or VAT on yarn, dyes and power, then wait for the refund. Customs rebates, duty drawback and export cash incentives each run their own claim cycle, with their own forms, windows and checks. The claims sit in a register one tax accountant keeps. The playbook puts it plainly: customs rebates expire, so a claim nobody tracks can lapse before it is filed.

    About Rs 250 billion

    Pakistan’s textile and apparel sector liquidity stuck in deferred sales tax refunds held by the FBR, by APTMA’s 2024 estimate, with Rs 35 billion more in provincial tax refunds.

    Source: All Pakistan Textile Mills Association (APTMA), Bring Back Zero-Rating (opens in a new tab), 2024.

  • Buyers who pay late, and a 90+ list that waits for a decision

    Export invoices go out on shipment under the buyer’s terms. Then a buyer asks for more days, pays part and disputes the rest, or pays after the realisation deadline (120 days in Bangladesh). The AR accountant builds the 0–30, 31–60, 61–90 and 90+ buckets from invoices, bank credits and remittance advices. The 90+ list then waits for Sales to make the call, and Treasury’s cash plan waits with it.

    Over 57%

    Share of suppliers asked in 2020, during COVID-19, to extend buyer payment beyond the standard 45 days, in Better Buying data cited by the ILO. About 39% were asked for 60 days or more.

    Source: International Labour Organization (ILO), The supply chain ripple effect: How COVID-19 is affecting garment workers and factories in Asia and the Pacific (opens in a new tab), 2020.

  • A month-end close that runs on reconciliation workbooks

    Bank, AR, AP and WHT reconciliations live in Excel, open items roll from month to month, and the close checklist sits in an email thread. The playbook warns that reconciliation differences build up quietly. The trial balance slips, the management report slips with it, and the CFO, the owner and the bank wait. A group with separate spinning, weaving and garment companies then consolidates by hand.

    5 days

    Median time top performers take from the trial balance to final monthly consolidated statements; the cross-industry median is 6 and the slowest take 10. APQC 2022 data from 10,201 organisations, all industries.

    Source: APQC, Cycle Time in Days to Complete the Monthly Consolidated Financial Statements (opens in a new tab), 2025.

  • Vendor invoices that arrive before the GRN does

    Invoices for yarn, dyes, chemicals, trims, freight and job work come by email or on paper. The playbook wants each one booked within three working days, matched to its PO and GRN before payment, and paid with WHT deducted by vendor type and filer status. A missing GRN, a duplicate or a rate that differs from the PO stops the invoice, pulls Stores and Sourcing into queries, and keeps the vendor waiting.

    12 in 100

    Supplier payments late or otherwise incorrect at the bottom quarter of organisations in APQC cross-industry data, against 5 in 100 at the median. Causes include duplicate invoices and pricing errors. Not a textile figure.

    Source: CFO.com (APQC data), Percentage of error-free disbursements: Metric of the Month (opens in a new tab), 2025.

Claims, invoices, ledgers and statements, worked from your files

It answers from the ageing, registers, vouchers and returns Finance keeps, and shows its sources; totals from an uploaded table come from its rows. Any email, message or sheet row it drafts waits for an admin to approve or decline, and runs only if approved.

  • Claims by scheme and status, totalled from your register

    Answers with sources

    Upload the rebate, drawback and refund register as an Excel or CSV file. Ask which claims are filed, received or still pending, and the agent counts and sums them from the rows by scheme or status, or by month where the register has a month column, and shows the rows it used. It quotes a tax rate or a rebate entitlement only from a document on record, never from memory, and says so when none is there.

    Ask“How many rebate and drawback claims are still pending, and what is the pending total for each scheme?”

  • A vendor invoice set beside its PO and GRN, from the files

    Reads your documents

    Upload vendor invoices with the PO and GRN exports. Ask about one invoice and the agent quotes its quantities and rates beside the PO’s and the quantity received on the GRN, citing each file. If no GRN for it is in the files, it says so; the playbook’s rule is to block payment and ask Stores within 48 hours. It quotes a WHT rate only from the rate schedule you uploaded. It books no invoice and releases no payment.

    Ask“Invoice 7781 from our yarn supplier: set its quantities and rates beside PO 4510 and the GRN for that delivery.”

  • A variance summary built from your ledger export

    Creates files

    Upload a GL export that covers this month and the last, with a period column. The agent sums each cost head by account and period from the rows, builds the variance summary as a spreadsheet, and explains a movement only where the records show its cause. As the playbook asks, FX revaluation gains and losses sit on their own line: they come from currency, not operations. Ask for a change and it edits that part.

    Ask“Build a variance summary for dyes and chemicals against last month from the GL export, by account.”

  • A statement of account for a buyer past 90 days

    Acts in your tools

    From the AR ageing you uploaded, the agent lists a buyer’s 90+ invoices with amounts and any dispute note. It writes a statement-of-account email for Gmail or Outlook, asking the buyer’s accounts team to agree the open invoices. The playbook has Sales call first, so it drafts a WhatsApp Business message asking the salesperson on the row to call. An admin approves or declines each; nothing is sent unless approved.

    Ask“List this buyer’s invoices in the 90+ bucket and draft a statement-of-account email to their accounts team.”

  • An invoice’s status in Odoo, read when you ask

    Reads your ERP

    If your factory runs Odoo, the agent reads a customer invoice there: its number, customer, total, status and date, with the time it was fetched. Set it beside the AR ageing you uploaded to see whether an invoice in the ageing is posted. It only reads: the finance agent cannot alter, pay or cancel an invoice or any other ERP record. With other ERPs, Finance works from the exports and sheets you connect.

    Ask“Is invoice INV/2026/00412 posted in Odoo, and what total and date does it show?”

From the weekly ageing review to day four of the close

  • The weekly ageing review with Sales and Treasury

    Finance manager

    Monday, an hour before the weekly AR review with the Sales head and Treasury.

    1. Asks

      “From this week’s AR ageing, what share of total AR is in the 90+ bucket, and which buyers make it up?”

    2. The agent

      Reads the AR ageing uploaded as an Excel file. Sums the 90+ bucket and total AR from the rows, works out the share, and splits the 90+ total by buyer, citing the rows it used. Sets the result against the playbook: under 2% of total AR is the target, and above 5% goes to the CFO and Sales head with a collection plan within a week. Shows any part-payment or dispute note recorded on a row.

    3. Result

      One answer for the review, with the rows behind every total, and the buyers the playbook says to escalate.

  • Pending drawback claims, and a follow-up to the customs agent

    Tax and rebate accountant

    The CFO asks how much duty drawback is still pending, and the customs agent has not replied for weeks.

    1. Asks

      “Which duty drawback claims are still pending? Put them in a sheet and draft a follow-up email to our customs agent.”

    2. The agent

      Reads the claim register uploaded as an Excel file, filters its rows by scheme and status, and counts and sums the pending drawback claims. Builds the list as a spreadsheet with claim number, shipping bill, amount and filed date, as recorded, and the claim window where the register has one. Prepares the email to the customs agent, to send from Gmail, quoting the claim numbers and amounts from the register.

    3. Approval

      The drafted email waits for the finance manager, as department admin, to approve or decline it. It goes to the customs agent only if approved, and the decision is kept with the name of who made it.

    4. Result

      The pending drawback total with the rows behind it, a sheet for the CFO, and a follow-up that is sent to the customs agent only if approved.

  • Day four of the close, and the CFO asks what is open

    GL accountant

    Day 4 of a close run on the playbook’s calendar: GL adjustments and tax posting are under way, and the trial balance is due tomorrow.

    1. Asks

      “What is still open on this month’s pre-close checklist, and how many unmatched items are left in the bank reconciliation?”

    2. The agent

      Reads the pre-close checklist in the connected Google Sheet and lists each open item with its owner, citing the cells. From the bank reconciliation workbook uploaded as Excel, with the unmatched items on its first sheet, it counts and sums them by bank account from the rows and, where the workbook has a days-outstanding column, gives the oldest item’s age. Writes the close-status note for the CFO as a document. It does not do the reconciliation itself.

    3. Result

      A close-status note with every open item, its owner and the unmatched bank items, each tied to the sheet or rows it came from.

The cash and days at stake, from published sources

These are published figures on export incentives, overdue proceeds and close times, each cited at the source. None of them is a Mavick result. A pilot is judged on your own numbers: record the KPIs below first, then read them again at the end.

  • Every pending rebate and drawback claim counted and chased

    About 18 months

    How long after shipping Bangladeshi exporters generally receive export cash incentives, by the BKMEA president’s account in October 2026. About a year of it is bank, audit-firm and central-bank paperwork.

    How the agent helps

    When asked, the agent counts and sums claims by scheme and status from the register you upload, and lists the rows. It drafts the follow-up to the bank, the customs agent or the audit firm verifying a claim; an admin approves or declines it, and it is sent only if approved. It does not file claims or read a government portal.

    Track: Value of rebate, drawback and incentive claims pending, by scheme

    Source: The Business Standard (Bangladesh), Tk1,958cr export incentives stuck in payment delays (opens in a new tab), 2026.

  • Fewer export receivables past 90 days

    Over $1.42 billion

    Bangladesh export proceeds, all sectors, unrepatriated in December 2022 after the 120-day limit, built up since 2012 against about $376 billion exported. Missing the limit can cost EDF finance, cash incentives and LC margin facility.

    How the agent helps

    When asked, the agent sums the 90+ bucket and total AR from the ageing you upload, splits it by buyer and shows the rows. It drafts the statement of account, or the note asking Sales to make the call, for an admin to approve or decline; nothing goes out unless approved. It does not chase buyers by itself.

    Track: AR over 90 days as % of total AR

    Source: The Business Standard (Bangladesh), $1.42b export proceeds overdue amid cry for dollar (opens in a new tab), 2023.

  • A year-end close where the auditor’s samples come from the file

    35 days

    Annual close at slower performers, against a median of 18 days and 10 or less at top performers. By size, the median is 10 days under $100 million in revenue and 23 at $1–5 billion. APQC research, all industries.

    How the agent helps

    The playbook starts statutory audit prep 60 days before year-end and tests readiness with “pull this invoice”. Ask for a sampled invoice or voucher and the agent quotes it from the uploaded files and names the supporting documents it lists. It builds the PBC list as a spreadsheet and lists open findings from your tracker.

    Track: Days from year-end to a completed annual close

    Source: APQC, How to Streamline the Annual Closing Process and Speed Up Year-End Close (opens in a new tab), 2026.

What to baseline before a pilot

Measure each one before the pilot starts, then again at its end.

Finance & Accounts: the KPIs to baseline before a pilot, and why each matters
KPI to baselineWhy it matters
Monthly close on time %The playbook’s target is a close by Day 5 after month-end, with variances against budget reviewed by Day 7. APQC’s monthly figure above starts at the trial balance, so it runs on a different clock.
AR over 90 days, as % of total ARThe playbook’s target is under 2%. Above 5%, it goes to the CFO and the Sales head with a formal collection plan within a week.
DSO against the buyer’s termsA rising DSO points to a collection issue. The playbook reads DSO more than 10 days above terms as a collection problem, not a buyer-side one.
DPO against negotiated termsShows whether vendors are paid to terms. The playbook says never pay early without a negotiated discount, and to weigh any discount vendor by vendor.
Reconciliation accuracy on bank, AR and APUnmatched items that roll from month to month sit in the trial balance as unexplained differences. The playbook’s target is 99.5% or better on all three.

What the agent works from

Records it reads

  • Invoice
  • Voucher
  • GL trial balance
  • Tax return
  • AR and AP ageing
  • Rebate and drawback claim register
  • Bank reconciliation
  • Pre-close checklist

In your ERP

From the factory’s ERP connection, Finance reads invoices in Odoo: number, customer, total, status and date, each with the time fetched. No connection reads the general ledger, trial balance, vouchers or bank; those come from your files and sheets. The finance agent has no write access to any ERP. The other ERPs Mavick connects give Finance no records today.

One ERP connection serves the whole factory: SAP Business One, SAP S/4HANA, Odoo, Oracle NetSuite, Microsoft Dynamics 365, WFX Cloud ERP or Datatex NOW. This agent reads only the records named above; we check yours on the call.

In your tools

Searches and reads Gmail when you ask. Reads recent Outlook mail. Reads the close checklist or claims sheet in Google Sheets. Drafts statement-of-account emails, follow-ups to your customs agent or bank, a row in the claims sheet, or a Slack or WhatsApp Business message to an item’s owner. An admin approves or declines each write; it runs only if approved.

Tools named today: Gmail, Outlook, Google Sheets, Slack and WhatsApp Business.

Never made up

  • Amounts, balances or account codes
  • Invoice numbers, voucher numbers or booking dates
  • Tax rates, rebate entitlements or drawback claims
  • Audit findings or their status

If it is not in your connected data, the agent says so.

Belongs to another department

What the Finance & Accounts playbook covers

  • SOP: the month-end close, day by day

    Transactions cut off on Day 1. Day 2 is AP cut-off and the accrual review, Day 3 AR cut-off and revenue recognition, Day 4 GL adjustments and tax posting, Day 5 the trial balance and management report. Variances against budget are reviewed by Day 7.

  • Decision rule: a vendor invoice with no GRN

    Block the payment and investigate with Stores within 48 hours. Most cases are a GRN posted late, and the fix is the posting. Rarely, the vendor has billed without delivering; that goes to Sourcing and Legal.

  • KPI: reconciliation accuracy, 99.5% or better

    The target on bank, AR and AP reconciliations. A gap on the bank statement goes to the CFO and Treasury within four hours to trace the transactions. The playbook also asks for a weekly bank rec, because it catches what a monthly one misses.

  • Edge case: sailed on 31 December, documents dated 2 January

    Revenue follows the incoterm, not the document date. Under EXW it is when goods are placed at the buyer’s disposal at the factory; under FOB, CFR or CIF when they are on board, shown by the on-board BL date; under DDP on delivery at destination.

Written as general textile practice and reviewed by four independent AI models. Not yet signed off by a human subject-matter expert. Upload your own SOPs and standards, and every answer shows which source it used.

Ten questions it ships with

The template’s starter questions. Your team can edit them, or ask in its own words.

  • What a voucher records

    What does this voucher record, against which accounts, and what supporting documents are attached?

  • Open reconciliation items

    Where does this reconciliation stand, and which items are still unmatched? Show amount and age for each.

  • Month-end close outstanding

    What is still open on the month-end close checklist, and who is each item with?

  • Receivables ageing past terms

    Which receivables are ageing past their agreed terms? Show buyer, amount, and days overdue, oldest first.

  • Payables due this week

    Which payables fall due this week, to which vendors, and what is the total?

  • Variance against last period

    Prepare a variance summary for this cost head against the prior period from the ledger, and explain the movements the records support.

  • What a tax return contains

    What does the filed return for this period contain, and when was it submitted?

  • Rebate and drawback claims

    Which rebate or drawback claims are filed, which are received, and which are still pending?

  • Expenses booked to a cost centre

    Show expenses booked to this cost centre for the period, grouped by account, with the largest items listed.

  • Audit findings still open

    Which audit findings are still open, what does each require, and what is the status of the response?

Finance & Accounts: questions before a demo

Can the agent post a journal entry or book an invoice in our ERP?

No. The finance agent drafts no change in any ERP: no journal entries, vouchers, invoices, credit notes, payments or notes. Its ERP access is reading, and today that means invoices in Odoo. The books stay with your accountants. When something needs to move, it drafts an email, a Google Sheets row or a Slack or WhatsApp Business message instead; an admin approves or declines it, and it runs only if approved.

Can it read our general ledger from SAP or Odoo?

No. No ERP connection reads the general ledger or the trial balance. In Odoo the agent reads invoices; the other named ERPs give the finance agent no records today. Upload the GL or TB export to Finance as Excel or CSV instead. A table holds up to 5,000 rows and anything beyond is left out, so split a larger export by month or account range. Totals by account, cost centre or period are then calculated from the rows. It does not consolidate group companies or net off intercompany balances; with each company’s TB export uploaded, it sums each one by account.

Will it do our bank reconciliation?

No. It does not match statement lines to ledger lines across two files, and it has no bank feed. It works from the reconciliation your team prepares: upload the workbook with the unmatched items on its first sheet, or those items as their own Excel or CSV file, and it counts and sums them by bank or account from the rows, gives the oldest item’s age where the workbook has a days-outstanding column, and cites the rows. Asked for the cash position itself, it says Treasury & Banking owns it.

Our vouchers and tax acknowledgements are scanned. Can it read them?

Only files with text in them. A scanned voucher, a photographed GRN or an acknowledgement saved as an image has no text to read, and Mavick does not read text from images. Upload the voucher export from your accounting software, or the return and acknowledgement as downloaded PDFs, and the agent quotes them and names the file it used. Paper vouchers stay outside what it can see until they exist as text, in an export or a typed sheet.

Will the HR or stores agent see our ledgers?

No. Files uploaded to Finance stay inside it, and other departments’ agents cannot read them; that boundary is built into how Mavick stores and retrieves everything. A file reaches other departments only if someone shares it factory-wide. Salary, bank-account and tax-ID fields are removed from ERP records before the agent reads them, so payroll figures reach Finance only through a file or sheet connected to Finance. Asked about payroll inputs or attendance, the agent says Human Resources owns them.

Will it remind us before a rebate window or a filing date passes?

No. Nothing runs between questions: the agent does not reread the register on a timer, and it sends no reminders. If your claim register records each claim’s window month, ask which pending claims fall in a given month and it lists them from the rows. The playbook’s warning is that customs rebates expire, so put that question on the agenda of your weekly review.

Bring Finance & Accounts. We’ll build it on the call.

Book a 30-minute demo (opens in a new tab)
Email
support@mavick.si