# Finance reconciliation and control worksheet

Ops Automators | Updated September 7, 2026

Synthetic USD example. Record payment IDs and allocations separately from invoice status. Replace approval rules with your organization's policy.

Guide: https://www.opsautomators.com/guides/finance-billing-automation

## Worked example

| Event ID | Invoice ID | Currency | Invoice amount | Payment allocation | Remaining balance | State / action | Owner | Evidence |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Issue | I-104 | USD | 1000 | 0 | 1000 | Open | Finance |  |
| P-88 | I-104 | USD | 1000 | 600 | 400 | Partially paid | Finance |  |
| P-88 replay | I-104 | USD | 1000 | 0 | 400 | Duplicate ignored | Finance |  |
| P-89 | I-104 | USD | 1000 | 400 | 0 | Verify then settle | Finance |  |
| P-90 |  | USD |  |  |  | Unmatched; review | Finance |  |

## Blank brief

### Event ID

[Complete this field.]

### Invoice ID

[Complete this field.]

### Currency

[Complete this field.]

### Invoice amount

[Complete this field.]

### Payment allocation

[Complete this field.]

### Remaining balance

[Complete this field.]

### State / action

[Complete this field.]

### Owner

[Complete this field.]

### Evidence

[Complete this field.]


## Acceptance

- Owner:
- Date:
- Evidence:
- Open decisions: