Matching in Farm Focus is a feature that will streamline your office process and make the process of matching invoices and bank transactions more efficient. The Matching tab allows you to select from both the invoice and transaction sides of the screen to directly match each item, rather than clicking into the details of each invoice or bank bank transaction.
Access the Matching screen
You can access the Matching screen from the Dashboard and your Needs Action screen.
Matching screen access from the Dashboard:
If you have fully coded invoices that are available to be matched, you will see a blue banner appear on your Dashboard.
This banner will alert that you have items ready to match. Click anywhere on the blue banner and you will be taken through to the Matching screen.
Matching screen access from the Needs Action screen:
The Matching tab is found on both the main navigation bar and has its own tab on the Needs Action banner.
The Matching Screen
Invoices sit on the left hand side and Bank Transactions on the right hand side. Only the fully coded invoices will appear in the list as you cannot match an invoice which isn't coded.
This screen mimics the Needs Action screen with default date sorting, and the same icons for attached invoices. The underlying detail is not accessible from this screen. You can change the sorting by using the dropdown arrows located next to each of the heading categories.
Matching can happen from either side. If you select an Invoice first, then the Bank Transactions will automatically sort in order for most applicable match. If you select a Bank Transaction first, then the invoices will sort in order of most relevant match.
Unselecting the first item will unselect ALL items.
Multiple transactions can be matched to one invoice, or multiple invoices to one transaction, but not multiple to multiple.
Matching process:
The first item selected becomes the main item you are matching to. It will be highlighted blue.
After you have selected your first item, the opposite side will change out and show the suggested matches first. Then the rest of the available matches will sort in order of relevance.
The Match button will highlight when the selected items are ready to match. Clicking on Match moves the selected items to the Completed screen. The screen will display the default date sorting view.
Navigate the Matching screen:
Shows the number of bank transactions (or invoices) selected.
Shows the dollar amount of transactions/invoices selected.
The search button allows you to search for specific bank transactions or invoices. The search function in bank transactions and invoices are independent of each other and are not activated until you press enter.
Allows you to select all transactions. This is useful if you have used the batch payments function and there is only one bank transaction with multiple associated invoices. In this case search using the batch number.
This is the matching assist button. It will highlight if there is an error and provides hints as to why you may not be able to match invoices to transactions or transactions to invoices eg. invoice date is after payment date.
Clicking on the three dots allows you the option to:
'View details' - this shows the details of the invoice/transaction or
'Go to Invoice' / 'Go to Transaction' - this allows you to view the original invoice/transaction.
Other functions:
Partially paid - If you have partially paid an invoice you can still use the matching function. Your bank transaction will move to the completed screen but the invoice will remain in the Needs Action screen until it has been completely paid and matched.
Made a mistake? - you have the ability to unmatch. There are several options available:
Go to Completed screen and unmatch the transaction or
If invoice is partially paid - go to three dots - 'View invoice' and then click on matched transaction and click on unmatch and save.
Link and match - Scenario:
An item was paid for in-store (eg $100 gumboots) and it appears on your invoice.
The bank transaction amount is $100 less than the invoice amount.
You matched the bank transaction and invoice but the invoice remains in the Needs Action screen as a Partially Paid invoice.
In the Needs Action page you record a Money in invoice for the same amount, mimicking what was in the original invoice including coding.
in Matching screen select both invoices and the Link and Match button will appear. Click the Link and Match button to move the invoice into the Completed screen.