Modules
Industries
Areas we serve
Resources
Company

Video ยท 1:45 min

Bank Reconciliation and Bill-wise Adjustment in ERP

Match advances against bills with reference adjustment, and books against the bank statement with bank reconciliation.

In this video

  • 0:00Advance pending. Bill pending. Party total correct?
  • 0:12Reference Adjustment
  • 0:25Pending debit references matched against credit references
  • 0:39Why do books and bank never match?
  • 0:59Books balance, uncleared deposits and payments, clearing dates
  • 1:11Saved and matched with the bank statement balance
  • 1:31Book a free demo

Transcript

A payment was booked on account. The bill is still pending, and so is the advance. The party total looks right, but the ageing is completely wrong.

Reference adjustment fixes it. Pick a party, press Auto Adjust to match oldest first, or tick bills yourself, and save once debit equals credit.

Bills appear on top, credits and advances below. Fully adjusted bills disappear from the pending list, and history keeps every adjustment, with delete if needed.

Now the second monthly job. Why do the books and the bank statement never show the same balance?

Because a voucher is made in the ERP today, but the bank clears it days later. Bank reconciliation explains exactly that difference.

Choose the bank and the as-on date, and enter the statement balance. Tick entries, set the clearing date from the statement, and watch the difference fall to zero.

Save, and the cleared entries move to the cleared tab. The BRS is ready, and can be exported to Excel.

Clearing dates cannot be before the voucher date, user rights control save and delete, and each plant is reconciled on its own.

Book a free demo of Tejaxo ERP. WhatsApp us on +91 96717 27474, or visit tejaxo.com.

Related videos and guides

Screens shown are real Tejaxo ERP screens with all data hidden; diagrams are illustrations.

See it on your own data

Book a free demo and we will walk through the modules that matter to your plant, on-site or online.

Stay connected

ERP insights, product updates and automation tips for manufacturers.

You have been successfully subscribed! Oops! Something went wrong, please try again.
© 2017–2026 Tejaxo Technologies Pvt. Ltd. All rights reserved. Privacy policy · Sitemap · Contact