Why do I have discrepancies between the totals on screen and the Excel report?

When you export a list from either the purchase invoices or the sales invoices section, you might notice a variance between the displayed totals on your screen and the figures presented in the Excel report. This discrepancy arises due to the selection of specific columns, where a single invoice could span multiple lines – an example being the inclusion of the payment field.

In practice, this means that if a particular field contains more than one value, the export process generates an equivalent number of lines. For instance, if an invoice has been subject to two separate payments, the export will generate two distinct lines for that same invoice.

It's important to comprehend that this behavior is intentionally designed in this manner. The rationale behind this approach is rooted in the recognition that we lack the insight into the precise data you seek. Consequently, the export process aims to provide flexibility by accommodating various potential scenarios, ensuring that your exported data remains comprehensive and adaptable to your specific needs.