44 Accounting

44.3 Bank reconciliation

44.3.1 Importing bank transactions - OFX

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

44.3.2 Importing bank transactions - CAMT.053

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

44.3.3 Importing bank transactions - CSV

Cash Reconciliation

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

Custom formats can be handled by creating an import file like https://github.com/ledgersmb/LedgerSMB/blob/master/doc/reconciliation/recon_csv.pl

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