For integrations to Sage Accounting, Xero and QuickBooks Online you will also see a setting within the AutoEntry Integrate page that will allow you to broaden the range of invoice dates that duplicate-match uses for its comparison ("the threshold")


For example, with a threshold of 5 days selected, and two invoices with amounts and invoice numbers that match exactly but dates that do not, duplicate-match will extend the AutoEntry invoice date FORWARD by the 5-day threshold and suggest any resulting matches via the same 'Duplicate-check' message. By default the date threshold has been set at 10 days - this option is editable via the drop-down.

The use-case for this threshold is where...
a) an invoice is manually posted directly into the accounting software from a corresponding payment in the bank statement (rather than from the invoice itself), and then...
b) the actual invoice is subsequently published from AutoEntry into the accounting software (dated earlier than the bank payment)...
then extending the threshold will identify the manually-posted invoice (a) as a duplicate of the actual invoice (b).

Example:
a) Accounting software: Manually-posted invoice dated 15 March.
b) AutoEntry: Threshold set to 5 days.

  1. AutoEntry invoice dated 10 March: Publish identifies invoice as duplicate.
  2. AutoEntry invoice dated 9 March: Publish goes through as normal.
  3. AutoEntry invoice dated 16 March: Publish goes through as normal.

Did this answer your question?