Coming in an updateIn testing now, and arriving in a software update.
Their statement against your ledger, line by line.
A supplier or a customer sends you their ledger of your account as a PDF. Open the party in A/c Statement and give it their file: it reads their sheet, pairs every line with yours, and lists exactly the entries the two books disagree about.
Six of their sixteen lines. Their debit is a credit in your books, so their bills pair with your purchases.
Prime Polymers' sheet against the demo books: 16 rows read, 13 agree, 3 only on theirs, 1 only in ours.
On menu 3A
What agrees, and what does not.
The control sits beside the dates on A/c Statement, labelled Their statement. Choose the party, choose their file, and the answer appears under the ledger.
On their sheet, not in our booksA bill you never entered, a freight charge you did not know about, or a payment they recorded at a different figure.
In our books, not on their sheetA payment they have not credited yet, or an entry one side made in error.
Everything else agreesCounted, not listed, so the page shows only what needs a decision. When every line pairs, it says so in a sentence.
The rules
How their lines are paired with yours.
Their ledger is written from their side of the counter. The pairing turns it round first, and then it is strict, because a reconciliation that forgives a wrong amount is not a reconciliation.
Their debit is your creditA sale in their books is a purchase in yours, and a payment they received is a payment you made.
The amount must agree to the paisa48,900 against 49,000 is not a match. It is the thing you were looking for.
The same date first, then the nearestA cheque they banked three days after you wrote it still pairs, within fourteen days.
Each line pairs onceTwo bills for the same amount are not both answered by one entry.
Nothing is ticked for youReading their sheet changes nothing in your books.
The missing entries
Post what is missing, without keying it.
For a line that is only on their sheet, choose the account the other side should go to. Post, and each one becomes a journal on their date, with their narration, against the party.
You choose the accountFreight to freight inward, a missing bill to purchases. Nothing is proposed for you on this screen.
Only what you choseA line with no account chosen is left exactly as it was.
Marked as importedThe journal says where it came from, so it can be found again.
A reason for any that failEach line that cannot be posted says why, and the rest still go through.
On menu 3S
Or tick it off by hand.
A/c Matching is the same job the way it was always done: type the balance they state, tick the entries you both agree on, and the unticked lines are what explain the difference.
Ticks are saved as you make themA telephone call in the middle does not lose the half you had done.
Their sheet here tooLabelled The sheet they sent, beside the balance they state.
Where it lives
The statements it works beside.
Each one opens from its menu number and its letter. Every plan includes them.
StatementsReports menu 3
3AA/c StatementOne account, with the balance brought forward — the statement you send
3JSundry Debtors & CreditorsWho owes us and who we owe, party by party, as at the year end
3BCash In HandEvery cash drawer as one progressive balance
3TCash & Bank BalancesHow much is in each bank and in the till, one line each
3CCheque RegisterCheques issued and received, and which have cleared
3DSummary BalanceBalances gathered under their groups, with a total for each
3ECross A/c ReportOne account, split by the accounts it faced
3FMonth Wise BalanceAn account month by month, each opening where the last closed
3GClub A/c LedgerSeveral accounts merged into one ledger, under a single running balance
Reports, in partReports menu 3
3SA/c MatchingMatch a party’s ledger against the statement they sent
3RMulti A/c ViewSeveral accounts side by side, on one screen
General, in partGeneral menu 4
4APayment Receivable / PayableWho owes you, who you owe, and for how long