交易

从银行对账单中导入交易,可以追踪银行账户交易,并与会计记录进行核对。

银行同步 自动执行该过程。但是,如果您不想使用它,或者您的银行还不支持它,还有其他选择:

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

備註

  • 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.

備註

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.

导入交易

Odoo 支持多种导入交易的文件格式:

  • SEPA推荐的现金管理格式(CAMT.053)

  • 逗号分隔值(CSV)

  • Excel (XLSX)

  • 开放式金融交易所(OFX)

  • 快速交换格式 (QIF)

  • 比利时:会计报告编码格式(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.

小訣竅

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.

手动注册银行交易

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.

對帳單

**银行对账单**是由银行或金融机构提供的文件,其中列出了特定银行账户在特定时期内发生的交易。

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.

重要

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.

小訣竅

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.

A "Statement" button is visible when hovering on a transaction.

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.

小訣竅

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.

账单查看、编辑和打印

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.

備註

  • 手动更新 起始余额 会根据 起始余额 的新值和报表的交易值自动更新 期末余额

  • 如果 起始余额 不等于前一个报表的 期末余额,或如果 期末余额 不等于运行余额(起始余额 加上报表的交易),则会出现一个警告来解释这个问题。为保持灵活性,仍可在未解决该问题的情况下进行保存。

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

備註

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.