Legalsense can track the payment status of invoices you've sent, so finance staff and other users, such as the timekeepers involved, can see whether debtors have paid. In the invoice overview, Legalsense highlights overdue, unpaid invoices in red and partially paid overdue invoices in yellow. Reports show which debtors are overdue with payments.
In this article
Automatic synchronization with your accounting system
Legalsense integrates with several accounting systems, including Twinfield, Exact Online, Exact Financials, AFAS, Visma, and Fortnox. If your firm uses one of these integrations, Legalsense can retrieve payment status automatically. Legalsense synchronizes with your accounting system roughly every 12 minutes. For more information on how to setup an accounting software integration see the article ↪ Managing the integration with accounting software.
How Legalsense recognizes a payment depends on which accounting system you use, because each integration reads payment data from that system in its own way. The behavior below applies generally, but some details apply only to the Twinfield integration, which does the most extensive reconciliation of the supported systems. These details are marked where relevant.
For Twinfield, Legalsense tracks payment status through debit entries in the accounting system, and considers an invoice paid once three conditions are met:
- The booking entry is finalized in the accounting system.
- The booking is debited to a payment account, which as a rule is the bank.
- The entry the invoice was set against is also finalized.
Other supported systems import payment records directly from that system's own API, without this three-step check.
How Legalsense creates a payment
When Legalsense recognizes a payment from your accounting system, it creates a payment record with:
- The same date as the corresponding entry in the accounting system.
- A description noting that the payment was created automatically from your accounting system. The exact wording depends on which system you use, and may include the accounting system's own transaction description where available.
For Twinfield specifically, if Legalsense finds a manually entered payment for the same invoice with the same amount as the incoming payment, it links the manual payment to it instead of creating a duplicate. This amount-matching safeguard isn't currently available for the other supported accounting systems. With those systems, a manual payment entered around the same time as a synchronized one is more likely to result in two separate payments. See Manual adjustments below for how to handle this.
Corrections based on outstanding amount
Legalsense can't always derive all the correct data from your accounting system, for example when entries have been written off but not finalized, or were made in a different journal than the bank. In these cases, Legalsense still tries to reflect the most current status:
- Legalsense reconciles against the outstanding amount value on the accounting system's entry line.
- Because Legalsense can't derive an exact payment date this way, it uses the date it detected the difference as an approximate date instead.
- Legalsense marks the payment as an automatically created correction, with your accounting system noted as the source.
- Legalsense never applies this correction to invoices marked Ignore Payment Status.
- Legalsense keeps only one correction payment of this kind per invoice. If the outstanding amount changes again, Legalsense replaces the earlier correction.
- Legalsense can sometimes recognize this correction before all corresponding entries, including the bank entry itself, are finalized.
Note: In a limited number of cases, a firm can have this correction method turned off in consultation with Legalsense.
Manual adjustments
Sometimes it's useful to adjust the payment status in Legalsense manually. For example, an error may have been finalized in your accounting system and then corrected in a way Legalsense can't recognize automatically, such as through a memo entry.
Before you make a manual adjustment, keep the following in mind:
- You can normally edit payments manually whether or not an automatic integration is active. If your firm wants to restrict manual editing while synchronization is running, contact Legalsense.
- Only adjust a payment status manually if the payment won't later be entered into your accounting system. Otherwise Legalsense may record the same payment twice: once from your manual entry and once from the synchronization. For Twinfield, Legalsense tries to detect this by matching on amount, as described above. This safeguard doesn't currently apply to the other supported accounting systems, so take extra care there.
- You can delete outstanding amount correction payments, but this has no lasting effect if the underlying discrepancy in your accounting system remains. Legalsense recreates the correction on the next synchronization.
- You can't delete payments that Legalsense recognized directly from your accounting system (as opposed to corrections), because they're tied to the accounting system's record. If one of these payments is wrong, enter a separate manual payment to correct the balance, with the reverse sign if needed. Legalsense never deletes a payment you enter this way.
Comments
0 comments
Please sign in to leave a comment.