Transaktionen

Durch den Import von Transaktionen aus Ihren Kontoauszügen können Sie die Transaktionen auf Ihren Bankkonten nachverfolgen und mit den in Ihrer Buchhaltung erfassten Transaktionen abstimmen.

Bank-synchronisierung automatisiert den Prozess. Wenn Sie diese Funktion jedoch nicht nutzen möchten oder wenn Ihre Bank nicht unterstützt wird, gibt es andere Optionen:

• Import bank transactions delivered by your bank;

• Register bank transactions manually.

Bemerkung

Grouping transactions by statement is optional.

Transaction view

The list of transactions for the bank journal is displayed in the Bank Matching view. To access it, go to the Accounting Dashboard, then either:

• click the journal name (e.g., Bank) or its Transactions button to display all transactions, including those previously reconciled, or

• click the x to reconcile button to display only unreconciled transactions. To include previously reconciled transactions, remove the Not Matched filter from the search bar.

Unreconciled transactions display the following information while collapsed:

• The date of the transaction

• A button linked to the chatter. The icon of this button can vary:

  • The (comments) icon displays only on hover and indicates that there are no attachments or activities for the transaction.

  • The (attachments) icon indicates that there is an attachment on the journal entry.

  • The (activities) icon indicates that there is an activity scheduled on the journal entry.

• The label of the transaction

• The partner of the transaction (if one is set)

• Up to two action buttons, depending on the details of the transaction

• The balance of the transaction

Bemerkung

• When the chatter of a transaction is open, a blue tag highlights the related transaction.

• The chatter can be opened and closed by clicking the (comments) icon and the (close) icon in the top right of the view.

• Once a transaction is reconciled, its action buttons are replaced with the labels of the item(s) it was reconciled with or the account if it was reconciled with the Set Account action button.

Duplicate transactions

Duplicate transactions occur when either by human error or bank sync error, the same transaction is created multiple times. The duplicate transaction view identifies potential duplicate transactions so they can be selected and deleted. To access the duplicate transaction view, first access the Bank Matching view by going to the Accounting Dashboard and clicking the bank journal’s name, then open the Actions menu and click Find Duplicate Transactions.

Potential duplicate transactions are identified based on their amount, date, and account number, or (if the transaction is created via bank sync) the transaction ID.

Select a Starting Date to view the corresponding potential duplicate transactions, then select the transactions to delete and click Delete Selected.

Bemerkung

Any transactions created by bank sync that the bank sync provider determines to be potential duplicates are displayed in the Provider Duplicates tab. This tab is only visible if there are any potential duplicates according to the provider.

Transaktionen importieren

Odoo unterstützt mehrere Dateiformate für den Import von Transaktionen:

• SEPA empfohlenes Kontoauszugs Format (CAMT.053)

• Komma-getrennte Werte (CSV)

• Excel (XLSX)

• Open Financial Exchange (OFX)

• Quicken Interchange Format (QIF)

• Belgien: Coded Statement of Account (CODA)

To import a file, go to the Accounting Dashboard, click the (ellipsis) icon on the Bank journal, and select Import file. Next, select the file and upload it.

Tipp

Alternatively, access the transaction list by:

• clicking on the Bank journal’s name, then clicking Upload

• dragging and dropping a file on the bank journal on the Accounting Dashboard

• dragging and dropping a file on the Bank Matching view

Certain file types such as CSV and XLSX, then require setting the necessary formatting options and mapping the file columns with their related Odoo fields, after which you can run a Test and Import your bank transactions. Other file types are mapped automatically.

Siehe auch

Daten exportieren und importieren

Banktransaktionen manuell registrieren

You can also record your bank transactions manually. To do so, go to the Accounting Dashboard, click the Bank journal’s name, and then on New. The Partner field is optional to ease the reconciliation process, but the Label and Date fields are mandatory.

Kontoauszüge

Ein Kontoauszug ist ein Dokument, das von einer Bank oder einem Finanzinstitut zur Verfügung gestellt wird und in dem die Transaktionen aufgelistet sind, die in einem bestimmten Zeitraum auf einem bestimmten Bankkonto ausgeführt haben.

In Odoo Accounting, it is optional to group transactions by their related statement, but depending on your business flow, you may want to record them for record-keeping and organizational purposes.

To access a list of existing statements, go to the Accounting Dashboard, click the (dropdown menu) icon next to the bank or cash journal you want to check, then click Statements.

Wichtig

To ensure the ending balances of your bank statements in Odoo align with the ending balances of the statements that are provided by your bank, create an opening transaction to record the bank account balance as of the date you begin synchronizing or importing transactions. This is necessary to ensure the accuracy of your accounting.

Tipp

To access a statement’s transactions, click Transactions directly from the Bank Statements list view or open a statement and click the Statement lines smart button.

Statement creation

The Bank Matching view displays transactions from most recent to oldest and groups them by statement, with any recent transactions that do not belong to a statement at the top. To add transactions to a statement, hover on the most recent transaction that should be included in the statement, and click the Statement button that appears on the upper separator line. Doing so creates a statement from that transaction down to the oldest transaction that is not yet part of a statement.

In the Create Statement window, fill out the statement’s Reference, verify its Starting Balance and Ending Balance, add an attachment such as a PDF of the statement if desired, and click Save.

Tipp

Transactions can also be added to statements from the list view. Select all the transactions corresponding to the bank statement, and, in the Statement column, select an existing statement or create a new one by typing its reference, clicking on Create and edit…, filling out the statement’s details, and saving.

Ansicht, Bearbeitung und Druck von Kontoauszügen

To view an existing statement, click the statement amount in the Bank Matching view or click the statement name and then the (Internal link) icon in the Bank Matching list view. From here, you can edit the Reference, Starting Balance, Ending Balance, and Attachments.

Bemerkung

• Durch manuelles Aktualisieren des Startsaldos wird der Endsaldo automatisch auf der Grundlage des neuen Werts des Startsaldos und des Werts der Transaktionen des Kontoauszugs aktualisiert.

• Wenn der Startsaldo nicht mit dem Endsaldo des vorherigen Kontoauszugs übereinstimmt oder wenn der Endsaldo nicht mit dem laufenden Saldo (Startsaldo plus Transaktionen des Auszugs) übereinstimmt, wird eine Warnmeldung angezeigt, die das Problem erläutert. Um Flexibilität zu gewährleisten, ist es weiterhin möglich, zu speichern, ohne das Problem zuvor zu beheben.

To generate and print a PDF of the bank statement, click the (gear) icon and click Statement.

Bemerkung

When a bank statement is generated to be printed, it is automatically added to the Attachments if no file was attached when creating the statement.