Your bank statment must be in the following format:

• Date in column A
• Payment Ref in column E
• Transaction Type in column K
• Amount in column W

Your file must be saved as a .csv file.

Select the File Format BarclayExcel.

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.

Note: 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.

Any Unmatched items can be linked to a lease by Searching for the lease, selecting the lease and clicking Link Item to Lease.

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.