Skip to main content

6.5.  Outgoing invoice payment - automated data import from Bank

Important! OZOLS TMS provides bothtwo options - manual and automated outgoing invoice payment, or linking of incoming payments to invoices.payment.
Only one solutionof foroptions connecting incoming payments maycan be used in one reporting period - manual or import fromfor the internetaccounting bank.period!

1. 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
    2) Bank revenue
    3) Functions
    4) Import payments from bankimage-1647520866947.png

3. Import bank payments
     1) 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 > choose which documents to include. 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.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 been paid and highlight them (if there are several invoices, then holding down the Ctrl key) -> Press the "Blue arrow up" (1) or double-click on invoice to relate it.
6) With green arrows (1) switch between incoming payment documents
7) With the filter (4), it is possible to quickly find the required invoice by number, amount, etc.

image-1647524906334.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.

Back to top