Manually matching unmatched transactions

AR Management - This article will describe the process for manually matching transactions that were not auto-matched within the bank statement

Required packages and permissions

Available with:  Lumary 22.82 and later

Permission: Lumary AR - AR Management & Lumary AR - EFT Matching

Lumary AR Management features do not necessarily come as standard. If these features are not available to your users, please contact your Account Manager.

This feature currently does not handle transactions from credit card payment gateways or refund transactions. These transactions should be ignored in the matching process and handled manually.

There will be times where we are unable to directly match a transaction to the related invoice, this could be when:

• the transaction is from plan managers who pay in bulk for multiple invoices and a remittance is needed to match that transaction to its related invoices, or
• when you have already recorded a payment for the transaction received, such as an EFTPOS payment.

In these cases, you will need to manually match a transaction either an invoice/s or existing payment/s. In some cases you’ll first need to match the transaction to the debtor, and then the invoice/s and/or payment/s related to them.

1. Navigate to the Bank Statement
2. Click the Requires Matching tab, this is where you are presented with all the transactions that require manual matching

Matching a Debtor to a transaction

If there is No Debtor matched:

1. When no debtor could be automatically determined, you will need to link the appropriate debtor to the transaction.
2. Use the provided lookup fields to either find a Debtor Account (a third party business being billed, NDIA, Plan Managers, Insurers etc.) or Debtor Contact (an individual Client, Parent etc) to assign to the transaction. Only one of these field should be populated per transaction.
3. Click Update Debtor to confirm your selection.

Matching a Payment or Invoice to a transaction

If there is No Invoice or Payment matched:

1. Any Unpaid Invoices and any Payments not linked to existing transactions to select from will be listed.
2. To select Invoices or Payments to assign to the transaction - use the checkbox to the left of the invoice or payment.
3. On selecting the Invoices or Payments, an Allocated amount field will become available on the right of the row, this field will indicate how much of the transaction to allocate to the invoice or payment, this will default to the value of the invoice or payment.
4. Save Matches - Once you are ready to save the matches, click the Save Matches button.

Modify Matches on a transaction

To modify a match or remove a match:

1. Use the Pencil button to put the Match back into an editable state where the allocated figure can be modified.
2. Use the Bin button to delete the match and return the Invoice or payment to a state that can be matched to another transaction.
3. Once you are ready to save the matches, click the Save Matches button.

Set Transaction to Matched

1. Click the Set Transaction to Matched button to close off the transaction and update its status to Matched, meaning it will be ready for approval.

Manual Matching Notes

1. Any remaining amounts not matched on the transaction will be assigned to the debtor as credit to be assigned to future invoices manually.
2. The transaction should now disappear from the list of transactions requiring matching.
3. Once all Items are matched, you can now validate and verify those matches and auto-matches and approve them.