AWRA OpsHub Search
Tie & agree

Four things
that have to
agree.

Reconciliation is not a monthly ritual here. Four pairs are computed from live records every time you open the screen, both sides shown, and the difference between them printed rather than buried.

What reconciles
  • 01 Stock against the ledger
  • 02 Purchase orders against payables
  • 03 Debits against credits
  • 04 Payments register against the ledger
The worksheet

Both sides, and the gap.

A reconciliation that shows you only the answer is asking to be trusted. Each of these shows what was compared, what each side said, and what is left over.

01

Stock against the ledger

Agrees
Stock on hand, valued
4,182,600
Inventory ledger account
4,182,600

Both sides are valued at weighted average, because that is what POS cost of goods posts at. Value the stock side at buying price instead and you report a variance that is only a difference of basis — a number that looks like a problem and is not.

02

Purchase orders against payables

Variance named
Open purchase orders
1,246,900
Accounts payable ledger
1,198,400
Left over 48,500

Every purchase order that is neither paid nor cancelled, against what the payables account says you owe. A gap here is usually a receipt posted without its invoice, or an invoice entered against no order.

03

Debits against credits

Agrees
Total debits
18,904,250
Total credits
18,904,250

The internal-consistency test for double entry, run across every journal entry rather than a sample. Both halves are written on every posting, so the totals must match exactly; an imbalance means a journal was written incomplete.

04

Payments register against the ledger

Agrees
Settled payments out
2,640,100
Bank and cash ledger
2,640,100

Money actually leaving on the payment rails, against what the bank and cash accounts say left. Settled, pending and failed are counted separately, and the settled figure is split by what it was for and by how it was paid.

The leak check

Money that moved
without a posting.

A total that agrees can still hide a gap, because two errors can cancel. So there is a second, narrower test on the one rail whose posting contract we own: a settled project payout is expected to carry its own settlement journal — debit payable, credit bank — keyed by the payment reference.

Any settled payout with no matching journal is listed by name. Money that left without reaching the ledger is the failure that costs most and shows least, because nothing on any screen looks wrong until someone goes looking.

Settled payouts · journal match
PYT-2026-00841 182,400 ✓ posted
PYT-2026-00844 96,750 ✓ posted
PYT-2026-00849 240,000 ▲ no journal
PYT-2026-00852 58,200 ✓ posted
Scope

This reconciles your records to your ledger.

That is the half that catches posting errors, unposted settlements and stock that drifted from its account — the errors made inside the system, which are the ones a system can reasonably be asked to find. The other half, your ledger against the bank’s own statement, is bank reconciliation, and it runs on its own screen.

On this page

Your records against your ledger

Four ties between figures that are all inside AWRA, computed live every time the screen opens. Nothing is saved and nothing is locked; it is a view of the position now.

Its own screen

Your ledger against the bank

Bank reconciliation imports the statement — CSV, OFX or MT940, uploaded, emailed or fed in from M-Pesa — matches each line to the ledger, and completes and locks a statement date only when the two agree to the cent.

More we can add to your workspace

Card settlement as a feed

Settlement reports from the card acquirer read into bank reconciliation net of fees, so card collections clear against the ledger the way M-Pesa and bank statement lines already do. It is a well-defined build on rails that already exist, and we will scope it with a written specification, a timeline and a price.

Talk to us about it
Questions

Asked at month end.

What does the reconciliation screen actually compare?
Four pairs. Stock on hand against the inventory ledger account, open purchase orders against accounts payable, total debits against total credits, and settled payments in the register against the bank and cash ledger accounts. Each pair shows both sides and the difference between them.
Does it import my bank statement?
Yes, on its own screen. Bank reconciliation imports CSV, OFX and MT940 statements, or receives them by email and from the M-Pesa feed, matches each line to the ledger entries on that bank account, and locks a statement once it is completed with no difference. The four ties on this page are the other half: your own records against your own ledger, which catches posting errors and unposted settlements that a bank statement cannot see.
What is the difference between these ties and bank reconciliation?
The ties compare two sets of figures that are both inside AWRA, live, every time you open the screen. Bank reconciliation compares your ledger with a document from outside it — the bank’s statement — line by line, and is completed to a statement date and locked. You want both: the ties catch errors in how AWRA was used, and the bank catches what only the bank knows about, such as charges, interest and cheques that never cleared.
Why value stock at weighted average rather than buying price?
Because the ledger side does. POS cost of goods posts at weighted average, so valuing the stock side at buying price would report a variance that is only a difference of basis — a number that looks like a problem and is not. Both sides use the same basis so a difference means something.
What is the debits-equals-credits check for?
It is the internal-consistency test for double entry. Every posting writes both halves, so the totals must match exactly; any imbalance means a journal was written incomplete. It runs across every journal entry rather than a sample.
How do I know a payment actually reached the ledger?
A settled project payout is expected to carry its own settlement journal — debit payable, credit bank — keyed by the payment reference. The screen lists any settled payout with no matching journal, so money that moved without a posting is named rather than quietly absent.
How often does it run?
Every time you open it. The figures are computed from live records rather than a nightly snapshot, so what you see is the position now.

Help Center

Need a quick answer while you read?

Run inventory, procurement, assets, sales, and field work with approved AWRA guidance for setup, migration, integrations, security, pricing, and support.

Search all approved AWRA public help articles.

Open Help Center