Skip to main content

6.5.  Outgoing invoice payment - automated data import from Bank

Important! OZOLS TMS provides two options - manual and automated outgoing invoice payment.
Only one of options can be used for the accounting period!

1. Export Account report from your Bank

Open your company's internet bank > prepare the Bank Account report for the desired period > export it in FidaVista or ISO format. Save this document to your computer.

2. Open OZOLS TMS
 

 
1) Finance
 > Documents
   Bank incomings 2) Bank revenue
    3) Functions
    4) Import payments from a bank

image-1647520866947.pngimage-1662628603969.png

 

3. Import bank payments
 

 
 1)Choose choose Import from file
     2) Specify the location of the document to be imported on the computer.
     3) Press Import
     4) Close
image-1647521443054.png

4. Linking incoming bank payments with outgoing invoices
 

 
 1) OZOLS Finances > Documents > Bank incomings
     2) Filter Filtrs> choose which documents to include. include Set the desired filter. For example, Show only uncovered payments
     3) set the desired filter
     4) Select the first payment and press the image-1647522540789.png "Relate" button (Ctrl+D)

image-1647524019114.pngimage-1662629357125.png

Settlement - Incoming payment window consists of 3 areas:
            A) Incoming bank payment
            B) Covered invoices
            C) Uncovered invoices

5) In the lower list (C) we find the invoices that have beenunpaid paidinvoices. andTo highlightrelate thempayment (ifwith there are several invoices, then holding down the Ctrl key) -> invoice Press the "Blue arrow up" (1) or double-click on invoice to relate it. If there are several invoices, select them by holding the Ctrl key 
6) With green arrows (1) switch between incoming payment documents
7) With the filter (4)3), ityou is possible tocan quickly find the required invoice by number, amount, etc.

image-1647524906334.pngimage-1662630566554.png

When the Incoming Payment is linked to the corresponding invoice, the amount in the "Uncovered" column in the Bank incomings list will be zero.