43.3 Bank reconciliation

43.3.1 Importing bank transactions - OFX

@@@ TODO - Quick capture of chat info, needs to be revised and maybe moved to customization chapter.

43.3.2 Importing bank transactions - CAMT.053

@@@ TODO - Quick capture of chat info, needs to be revised and maybe moved to customization chapter.

43.3.3 Importing bank transactions - CSV

Cash & Banking Reconciliation

@@@ TODO - This subsection needs to be revised and maybe moved to customization chapter as it is no longer accurate.

Custom formats can be handled by creating an import file.

The file should reside in LedgerSMB/Reconciliation/CSV/Formats/

A perl sub must exist which is named:

parse_<name-of-your-company-database>_<id-of-account-to-reconcile>

With a company database name of testdb and an account id of 255 the parse code might look like the following:

sub parse_testdb_255 {
    parse_n(@_);
}

default 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,

scn = Source Coding Number