43 Accounting

43.3 Bank reconciliation

The reconciliation report at Cash & Banking → Reconciliation is used to reconcile bank statements.

@@@TODO

@@@TODO need screenshot

43.3.1 Reconciliation import

The available formats for importing bank statements are:

  1. 1.

    OFX Bank statement

  2. 2.

    ISO 20022 - CAMT.053 (Customer statement)

  3. 3.

    PayPal (CSV / Column names),

  4. 4.

    PayPal (CSV / Column numbers - no headings).

Importing bank transactions - OFX

An example of this format can be found on Github at ofx_bank_statement.xml

Importing bank transactions - CAMT.053

An example of this format can be found on Github at campt053-sample.xml

Importing bank transactions - CSV

The default CSV with header format is:

Ψcleared_date,amount,scn,type
Ψ2021-09-01,25.25,224435,CHECK
Ψ2021-09-01,-30.31,44351,CHECK
Ψ2021-09-02,100,,
Ψ2021-09-02,-425,3321435,

Where the scn column represents the Source Coding Number.

Custom import formats

It is also possible to create custom import formats. Please check with the developers for assistance.