CORAA
Resources · Continuous Internal Audit

Continuous monitoring rules.

Continuous monitoring works when rules are specific enough to run on real ERP data and documented enough to survive internal-audit review. This repository lists practical rule logic, data fields, exception examples and cadence choices for common Indian internal audit cycles.

Download Excel/PDF rulesOpen control repository
Rule design

What every rule should capture fields

A monitoring rule is not just a query. It is a documented audit procedure with a population, source, logic, threshold, reviewer conclusion and follow-up trail.

Process cycle
Control objective
Population and source report
Required data fields
Exception logic
Threshold or parameter
Cadence
Expected false positives
Reviewer conclusion
Action owner and due date
Rule repository

Cycle-wise monitoring rule examples examples

P2P

Duplicate supplier invoice

Exception logic

Flag same supplier + invoice number + amount, and near-duplicates where invoice number differs only by spaces, prefixes or separators.

Example: Two invoices from the same vendor for Rs. 8,42,000 with invoice numbers INV-1024 and 1024, both paid.
Required fields
  • Supplier GSTIN / vendor code
  • Invoice number
  • Invoice date
  • Invoice amount
  • PO/GRN reference
  • Payment status

Cadence: Weekly for active AP teams; monthly for low-volume entities.

Related RCM ->
P2P

MSME payment ageing

Exception logic

Flag MSME invoices outstanding beyond the agreed/statutory credit period and paid invoices with delayed settlement.

Example: Micro enterprise invoice accepted on 5 April remains unpaid after the agreed 30-day term.
Required fields
  • Vendor MSME flag
  • Udyam number
  • Invoice date
  • Acceptance/deemed acceptance date
  • Payment date
  • Outstanding amount

Cadence: Weekly during close and before tax audit finalisation.

Related RCM ->
O2C

Credit limit override

Exception logic

Flag invoices or orders processed where exposure exceeds approved credit limit without documented approval.

Example: Customer exposure exceeds limit by Rs. 22 lakh and the ERP override field is blank.
Required fields
  • Customer code
  • Approved credit limit
  • Outstanding balance
  • Sales order value
  • Override user
  • Override approval

Cadence: Weekly for trading/manufacturing entities.

Related RCM ->
R2R

Manual journal posted after close

Exception logic

Flag manual journals posted after the close cut-off, large journals, blank narrations and creator-approver conflicts.

Example: Rs. 48 lakh manual provision posted two days after close by the same user who approved it.
Required fields
  • Journal ID
  • Posting date
  • Document date
  • Creator
  • Approver
  • Amount
  • Narration
  • Reversal flag

Cadence: Daily during close week; monthly otherwise.

Related RCM ->
Cash & Bank

Stale BRS items

Exception logic

Flag unreconciled receipts/payments older than the approved ageing threshold, separated by debit and credit side.

Example: Payment entry of Rs. 13.5 lakh remains unreconciled for more than 45 days.
Required fields
  • Bank account
  • Book date
  • Bank date
  • Cheque/reference number
  • Amount
  • Nature
  • Ageing bucket

Cadence: Monthly minimum; weekly where cash leakage risk is high.

Related RCM ->
H2R / Payroll

Leaver paid after exit

Exception logic

Flag salary, reimbursement or incentive paid after recorded exit date except approved full-and-final settlements.

Example: Employee exited on 12 June but appears in July salary bank file without F&F tag.
Required fields
  • Employee ID
  • Exit date
  • Payroll period
  • Gross pay
  • Bank account
  • F&F status
  • Access disabled date

Cadence: Monthly before salary release.

Related RCM ->
Inventory

Negative stock and ageing exception

Exception logic

Flag negative closing quantities, no-movement stock beyond threshold and items where NRV marker is below cost.

Example: SKU shows negative 18 units at one location and no approved stock adjustment.
Required fields
  • Item code
  • Location
  • Opening stock
  • Receipts
  • Issues
  • Closing stock
  • Last movement date
  • NRV marker

Cadence: Monthly; weekly for multi-location inventory.

Related RCM ->
Treasury

Covenant watchlist

Exception logic

Flag facilities where covenant ratios are breached or within the warning band defined by treasury policy.

Example: Debt service coverage ratio is below the lender threshold and no waiver note is attached.
Required fields
  • Facility
  • Covenant
  • Threshold
  • Current ratio/value
  • Reporting date
  • Breach flag
  • Waiver status

Cadence: Monthly and before lender reporting dates.

Related RCM ->
Statutory Compliance

Return and challan delay

Exception logic

Flag late filings, missing challans, nil returns filed despite ledger activity and interest/late fee not booked.

Example: GSTR-3B filed after due date and no late fee/interest accounting entry exists.
Required fields
  • Compliance type
  • Period
  • Due date
  • Filing date
  • Challan date
  • Amount
  • Interest/late fee

Cadence: Monthly close and quarterly audit committee reporting.

Related RCM ->
ITGC

Leaver access and privileged user activity

Exception logic

Flag active user IDs for exited employees and privileged activity without ticket or approval reference.

Example: Exited employee user ID remains active 14 days after exit and has export/download activity.
Required fields
  • User ID
  • Employee status
  • Exit date
  • Role
  • Last login
  • Privileged action
  • Access removal date

Cadence: Monthly; weekly for finance-admin roles.

Related RCM ->
Evidence discipline

How a flag becomes audit evidence evidence

1

Lock the population: save the source report, extraction date, filters and completeness check.

2

Run the rule: retain the rule logic, threshold and exception count before manual exclusions.

3

Clear false positives: document exclusions and why they do not indicate a control issue.

4

Investigate validated exceptions: obtain source documents, owner explanation and financial/compliance impact.

5

Report only concluded issues: convert validated exceptions into observations, ratings and ATR follow-up.

Open monitoring rules toolTrack exceptions in ATR
Downloadable workpapers

Turn rules into audit files Excel/PDF

Monitoring is useful only when the exception can move into a workpaper. These cycle workbooks export the RCM, testing sheet, exception register and reviewer fields auditors need for follow-up.

P2P workbookDuplicate invoices, MSME ageing, three-way match, advances, payments and vendor access.Open workbook ->O2C workbookCredit overrides, dispatch-to-invoice gaps, credit notes, collections and receivables ageing.Open workbook ->R2R workbookManual journals, reconciliations, accruals, provisions, intercompany and close controls.Open workbook ->H2R workbookLeaver payments, statutory deductions, employee master changes, exits and access removal.Open workbook ->Treasury workbookBorrowings, covenants, investments, BG/LC, forex exposure, bank mandates and payments.Open workbook ->ITGC workbookLeaver access, privileged activity, change tickets, backup failures, interface jobs and logs.Open workbook ->
FAQ

Monitoring rules FAQs questions

What are continuous monitoring rules in internal audit?

Continuous monitoring rules are repeatable exception tests applied to recurring business data. They flag transactions, balances or master-data changes that need internal-audit review, such as duplicate invoices, stale BRS items, leaver access or late statutory filings.

Can monitoring exceptions be reported directly as audit observations?

No. A rule exception is only a flag. The auditor still needs to verify the population, validate the logic, review false positives, obtain evidence, assess root cause and then decide whether an observation should be reported.

Which cycles are best suited for continuous monitoring?

P2P, O2C, R2R, cash and bank, payroll/H2R, inventory, treasury, statutory compliance and ITGC work well because they generate structured data on a recurring cadence.