Features/Importing/Party Ledger Reconciliation

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.

To the paisaamounts must agree exactly
14 daysthe most two dates may differ
PDF, Excel, photoor a CSV of their ledger
Prime Polymers their ledger of us Apr – Aug 2026
DateParticularsAmountin our books
01/06Sale Bill 06/131,31,549.00 Dragrees ✓
19/06Payment received88,000.00 Cragrees ✓
13/07Payment received48,900.00 Crwe paid 49,000
04/08Sale Bill 08/3010,712.00 Dragrees ✓
04/08Freight, Bill 08/301,180.00 Drnot in ours
22/08Sale Bill 08/315,428.00 Drnot in ours
Six of their sixteen lines. Their debit is a credit in your books, so their bills pair with your purchases.
A/c Statement in Vertex ERP for Prime Polymers, with their ledger PDF read below it: 16 rows read, 13 agree, 3 only on theirs and 1 only in ours, listed under 'On their sheet, not in our books' and 'In our books, not on their sheet'.
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.

  1. Their debit is your creditA sale in their books is a purchase in yours, and a payment they received is a payment you made.
  2. The amount must agree to the paisa48,900 against 49,000 is not a match. It is the thing you were looking for.
  3. The same date first, then the nearestA cheque they banked three days after you wrote it still pairs, within fourteen days.
  4. Each line pairs onceTwo bills for the same amount are not both answered by one entry.
  5. 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
Free for 30 days

Match this year's confirmations against your own books.

The complete software, every module. On day thirty-one it asks for a licence key, and everything you entered stays exactly where it is.

Vertex ERP for Windows and MacFrom vertexerp.co.in
Windows
1.1.12 · 183 MB
Mac
Apple silicon
Trial
30 days, every module
Card
Not needed
Download