Match transactional data
The images and steps in this topic are based on our new design (which you can currently switch on and off). If you haven't switched the new design on, the images may look different.
Once you’ve loaded your transactions from your bank, you’re ready to begin using the transactional data to create new invoices, purchases & bank transactions and allocating them to existing ones; this is called Matching in IRIS KashFlow.
When you match transactional data you can:
-
Create a new item such as an sales or purchase invoice based on the transactional data that has been collected from your bank.
-
Assign a imported transaction to an existing invoice or purchase, or replace an existing bank transaction with the transactional data that has been collected from your bank.
Ignore a transaction to prevent it being imported.
You must have loaded transactions into IRIS KashFlow before you can perform matching.
Creating an Invoice, Purchase, or Bank Transaction (Example 1)
Example 1; a customer has deposited £100 in your bank account for something they have bought, however, you have not created an invoice for them in IRIS KashFlow already. You need to create an invoice for them and then apply the payment.
Bank feeds can now do this automatically for you with just a few clicks.
To create an invoice from the imported transaction;
- Import your bank transaction data.
- From the Action column select Match.
- In the Match transaction window, go to the Create tab.
- Select which item you want to create.
For money in transactions, Sales invoice will be pre-selected, and for money out transactions, Purchase invoice will be pre-selected.
- Enter the required details and select Create.
The invoice has now been created, however, the payment won’t be imported until you select Import.
Assigning imported transactions to Invoices, Purchases, & Bank Transactions (Example 2)
Example 2; the bank has charged you £10 for going into an unauthorised overdraft, however, you’ve not recorded this in IRIS KashFlow. You need to record this payment to make your IRIS KashFlow bank account match your real-life bank account balance.
To assign an imported transaction to an existing sales invoice, purchase invoice, or bank transaction;
-
From the Action column select Match.
-
In the Match transaction window, go to the Assign tab.
-
Type is pre-selected depending on the imported transaction you are matching. Change this if needed.
You can also filter the list by Status and Time period, or search by invoice number, purchase number, customer, supplier, purchase order, reference, or amount.
-
Select the existing sales invoice, purchase invoice, or bank transaction you want to assign, and select Assign.
If you select multiple items, the total must balance with the imported transaction amount.
When you assign an existing bank transaction to an imported transaction, the existing details will be updated with the imported details. For example, if you had an existing bank transaction of £20 with the description “bank charge”, and you assigned it to an imported transaction of £20.10 with the description of “overdraft fee”, the latter would replace the existing transaction details.
The transactions are now matched, however, the payment won’t be assigned until you select Import.