Your bank statment must be in the following format:

• Date in column A
• Account Number - Sort Code in column B
• Bank Account Name in column C
• Transaction Type in column D
• Amount in column E
• Payment Ref in column G

Your file must be saved as a .csv file.

Select the File Format LloydsCommercialBanking.

Click Import Statements > Browse..., select the file you wish to import > Import. The Statement Items screen displays the relevant statement details.

Note: If there are outstanding invoices and Auto-Allocate imported payments is ticked, the imported payments will be allocated to those invoices. The payments are allocated to the most outstanding invoice first.

Note: If you untick Auto-Allocate imported payments, the payments will be unallocated and can be allocated manually.

The first time a Payment Reference is imported, select the payment, and from the Lease Search section, if the lease does not display in the list, click Search to select the lease.

Select the lease and click Link Item to Lease.

The next time a statement is imported, the payment Status will be Auto-Linked.

All line items with leases will automatically link. Click Display Lease to view the details of a selected line item.

Any Unmatched items can be Marked Irrelevant. The status updates from Auto-Linked to Do Not Process.

Any Auto-Linked items can be marked Do Not Process. The status updates from Auto-Linked to Do Not Process.

Note: You can Unlink From Lease if you wish to sever the link of a Manually linked item.

Click Process All Linked Items to link the transactions to the Payments In. The status updates to Processed.

Once items are processed, you can Display Payment.

Introduce in version 2018.5.16.4984 released on 28/5/2018.