Need automated reconciliation act generator built for our accounting

We keep running accounts with dozens of counterparties, and every month someone on our team manually pulls payment records and delivery documents to put together a reconciliation act for each partner. It takes hours, small mistakes slip through, and disagreements about balances drag on for weeks because nobody fully trusts the numbers until they are double-checked by hand.

We want to hand this off to a working tool instead of a person. The system should read payments and shipments straight out of our accounting software for a chosen period and counterparty, match them against what the other side reports, and produce a ready document that clearly highlights any discrepancies so both sides can agree on the final balance quickly. The finished act needs to be laid out the way our accountants expect, broken down by date and supporting document, and easy to export into the format our bookkeeping team uses for filing.

We are open to different technical approaches, but the result has to fit into our existing accounting setup rather than change how we record transactions day to day. Please describe how you would approach pulling and matching the data, and share examples of similar tools you have built.

What matters most to us:
— correct matching even when dates or amounts differ slightly
— a document layout accountants can use without extra editing
— export suitable for our bookkeeping software
— willingness to fix issues after handover