E-Documents

Reconciliation letters go out one by one by email, replies are tracked in Excel

The e-Reconciliation module sends customer/supplier account and tax-total reconciliations in bulk from the system, collects the other party's reply in the same list and shows differences line by line. A reminder is ready for those who do not reply; the decision to send stays with accounting.

e-Reconciliation
In short

e-Reconciliation is the Panda ERP module that sends customer/supplier account and period purchase/sales total reconciliation letters in bulk by email from the system, collects the other party's approval, rejection or difference reply in the same list, and compares the two statements line by line. The reconciliation is prepared from balances and movements on the customer/supplier card; there is no second data entry. The difference list and a reminder draft for firms that do not reply reach accounting.

How is this work done today?

  • Letters are prepared and sent one by one

    For each customer and supplier a statement PDF is taken and attached to an email; who sent what on which date is searched for in the sent folder.

    1 accountant × 2 days / period
  • Replies are tracked in Excel

    Firms that approve, object or do not reply are marked by hand in an Excel list; who gets the second reminder is checked from that list.

    1 person × 3 hours / week
  • Differences are searched line by line by hand

    The other party's statement and your own are opened side by side and the missing invoice or payment is found one by one; the period does not close until the difference is found.

    2 people × 1 hour / firm

How does e-Reconciliation work?

  1. 1

    Period and scope are selected

    The reconciliation type (account, period purchase totals, period sales totals), the period and the list of accounts to send to are selected. Email address and contact person come from the customer/supplier card; the list of missing addresses comes back to you first.

  2. 2

    Bulk sending

    For each account the statement and reconciliation letter are prepared in the system and sent in bulk by email. The other party sees the statement from the link and gives approval, rejection or a difference notice from the same page.

  3. 3

    Reply and difference list

    Replies are collected in one list; the statement of a firm that reports a difference is compared line by line, and the missing invoice and payment are marked. A reminder draft is ready for firms that do not reply.

  4. 4

    Closing and report

    Approved reconciliations are closed by period, and the PDF and reply record are stored on the customer/supplier card. The period report comes out not as an approval rate but as a list of open differences and firms with no reply.

See how e-Reconciliation would work in your business

Tell us briefly about your process and we will walk through the screens with your own example.

  • Reply the same business day
  • 15+ years of experience
  • 90 client businesses

e-Reconciliation features

e-Reconciliation: Account reconciliation
  • Account reconciliation

    Customer and supplier balance and movement detail are prepared from the customer/supplier card; the letter template is your own text, and sending is done in bulk.

  • Period total reconciliation

    Period purchase and sales totals are listed by account and compared with the other party line by line; a line with a difference is flagged.

  • Bulk email sending

    The letter and statement for the selected accounts go in one go; sending, delivery and open status appear in the list.

e-Reconciliation: Reply page
  • Reply page

    The other party sees the statement from the link in the email, approves it or writes the difference; the reply drops into the list without any user opening it.

  • Line-level difference report

    Two statements are compared by amount, date and document number; missing invoices, duplicate entries and payment differences are listed under separate headings.

  • Reminder template

    A ready email template for firms that do not reply; the date and count of sending are on record, and the text and timing are your decision.

  • Approval, rejection and change flow

    Approval, rejection and correction requests are managed from one screen; a corrected statement is sent again, and earlier replies are not deleted.

  • Archive and activity log

    The letter sent, the statement PDF and the reply are stored by period on the customer/supplier card; for an audit a period is chosen and exported.

What does Panda AI add to e-Reconciliation?

The Finance and Accounting Agent is the Panda AI agent that takes on due-date tracking, bank-to-ERP matching and draft account reconciliations.

  1. Today Bank transactions are matched to the ERP by hand With the agent Unmatched transactions are listed every morning
  2. Today Due-date lists are kept separately in Excel With the agent A cash flow forecast is ready on current data
  3. Today Account reconciliation e-mails are written one by one With the agent Reconciliation e-mails arrive as drafts; approval is yours

Jobs it takes on

  • Due-date and collections tracking
  • Bank-to-ERP matching check
  • Cash flow and budget variance report
  • Draft account reconciliations
  • Invoice and expense inconsistency alerts
  • Month-end closing checklist

The agent prepares, a person approves. Anything that posts a record or sends something outside the company goes through your approval.

Explore Panda AI agents

Frequently asked questions about e-Reconciliation

How does the reconciliation letter reach the other party?

A letter and a statement link are sent to the email address on the customer/supplier card; the other party sees the statement from the link and gives approval or a difference notice from the same page. They do not need to install a program or sign up. Delivery and open status appear in the sending list.

How is period purchase and sales total reconciliation done?

The period's purchase and sales totals are listed by account from the system and sent to the other party with the supporting details. The amount the other party reports is compared with yours; an account with a difference is flagged, and the missing or extra invoice is found as a line. Which periods you reconcile is your decision, in line with the rules that apply to you.

What happens when a difference is found?

The statement of the firm that reports a difference is uploaded to the system or written on the reply page; the two statements are compared by amount, date and document number. Missing invoices, duplicate entries and payment differences are listed under separate headings. Accounting makes the correction, and the updated statement is sent again.

What is done about firms that do not reply?

After the set time, the list of firms with no reply reaches accounting; a second sending is made with the ready reminder template. How many times and when a reminder was sent is kept on record. A list of firms to call by phone can be taken as Excel; the decision to send stays with accounting at every step.

What if the other party does not use Panda ERP?

That is not a problem. The letter and statement go by email; the reply is given on a page that opens in the browser, and no installation is needed. If the other party sends its own statement as PDF or Excel, the file is uploaded and the line-level comparison is done on the same screen.

How are reconciliation records stored?

The letter sent, statement PDF, reply and reminder record sit on the customer/supplier card by period; nothing is deleted, and corrections are made with a new record. In an audit or dispute a period is chosen and the documents are exported with their replies. The activity log keeps who sent what and when.

Does it work together with e-Bank and e-Invoice?

Yes. Because the statement, e-invoice and bank movement are on the same customer/supplier card, the reconciliation letter is prepared with the current balance. A missing invoice the other party reports is searched for in the e-invoice inbox, and a payment difference is compared with the bank movement. Together, the three modules shorten period closing.

What does the agent do in e-Reconciliation?

Customer/supplier statements are compared line by line with the other party's statement; a difference list and a reminder draft for firms that do not reply arrive ready. Accounting approves sending and corrections; the agent does not change customer/supplier records and does not send a letter on its own. Scenario: daily reconciliation.

See e-Reconciliation with your own data

Describe your process in a few sentences and we will show you the modules that fit.

  • 15+ years of enterprise software experience
  • In the cloud or on your own server
  • Processes compliant with KVKK (Turkey's data protection law)

Last reviewed: · Panda Yazılım product team