MosoFin skill · vendor-statement-reconciliation · learning guide

From one invoice number to a payment that went somewhere else

This page shows how the skill checks a supplier's statement against your books, one level at a time. It starts with one invoice number written two ways. It ends with a payment that never reached the supplier. The page quotes every rule from the skill itself. It also works every number in front of you.

The rules are the skill's ownThe page quotes each rule word for word, with the file and section it comes from.
Outside sources back the factsThey are US audit standards, an international accounting standard, a UK tax guide, QuickBooks help, a fraud study and the FBI. Each one has a number and a link.
The page shows the mathOpen "Check it yourself" on any level. Follow every line on a calculator.
Your numbers, your checkAt the end, enter your own statement. The page builds the same bridge.
Rule: quoted from the skill Fact: from a cited authority, numbered like 1 Example: made-up figures, calculated in full
How it thinks

Thirteen rules the whole skill runs on

Every level below applies one or more of these rules. The examples use one company, Northbrook Trading, and one supplier, Harbor Office Supply, account NB-2210. Harbor dated its statement 25 September, and it lists every open item. Your books are at 30 September.

Learning path

Six levels, from simple to complex

Check it yourself

Put in your own statement

Enter the totals for one supplier and one statement, or load an example. The page builds the bridge from your books to the statement, line by line. It shows any credit notes as money owed to you, on their own. The page sends nothing anywhere.

From the supplier's statement
From your books

The page uses expected statement = B − L + T + M − C, and unexplained = S − expected. The page calls it a tie when the unexplained amount is under half a cent. The skill itself matches item by item, in its four tiers. This bridge only adds up the totals of what that matching finds. The "Harbor, September" preset puts Levels 2, 3 and 4 on one statement: $18,640.00 + $2,480.00 − $410.00 = $20,710.00.

Using it

What it asks, needs and gives back

Asks firstDo you want to use MosoFin, or upload the data yourself? Which supplier, or which suppliers? The skill asks for the statement, as a PDF or CSV. It asks which company the statement is for, and the account reference. It asks for your period end, the statement's date and what the statement covers. It also asks about a dispute log and who owns the exceptions.
NeedsThe skill needs the supplier's statement, which only you can supply. It needs your AP ageing or vendor ledger for that supplier, connected or exported. It needs your cutoff date. A payment register and a dispute log make the result better.
Gives backThe skill gives back six sheets. They are a summary, the matched items with their tier, the exceptions with owner and age, and the proposed entries. The last two are the vendor ranking and a coverage sheet. Every entry carries the label PROPOSED — NOT POSTED. The skill asks before it makes an Excel file.
NeverThe skill never posts an entry and never contacts a supplier. It never books a liability from a statement line. It never forces an uncertain match. It reads nothing before you answer its questions and say yes.
Sources

Where every fact on this page comes from

The rules are the skill's own. The facts below come from seven outside sources. They include a US audit standard-setter, an international accounting standard-setter and the UK tax authority. The others are QuickBooks help, a fraud examiners' association and the FBI. MosoFin checked each one on 24 October 2026 official source pages and reviewed the linked sources on 27 October 2026. Follow each link for the latest wording.

    Not backed by an outside authority. The four match tiers, the six difference types and the Step 0 ranking signals are the skill's own rules. So are the "three near-substitutes" and the six output sheets. The page marks them as the skill's where they appear.