Period mismatch

{

Attribute

Data type

Description

begin_date

Date

end_date

Date

begin_balance

Money

end_balance

Money

}

Period mismatch indicates gaps between the Periods captured on bank statements. For instance, if a bank statement has three periods:

[
  {
    "pk": 1001,
    ...
    "begin_date": "01/12/2019",
    "begin_balance: "500.00",
    "end_date": "01/31/2019",
    "end_balance: "750.00"
  },
  {
    "pk": 1002,
    ...
    "begin_date": "02/08/2019",
    "begin_balance: "600.00",
    "end_date": "02/28/2019",
    "end_balance: "800.00"
  },
  {
    "pk": 1003,
    ...
    "begin_date": "03/05/2019",
    "begin_balance: "800.00",
    "end_date": "03/31/2019",
    "end_balance: "500.00"
  },
]

The period mismatch list would contain one mismatch, as follows:

[
  {
    "begin_date": "01/31/2019",
    "begin_balance: "750.00",
    "end_date": "02/08/2019",
    "end_balance: "600.00"
  }
]

A period mismatch is identified when the end_date of a given period does not line up with the begin_date of the next period; and the balances for these periods will also fail to match. This is demonstrated in the mismatch displayed in the example above.

If the end_balance of the period is the same as the begin_balance of the next period, a gap in the end_date and begin_date of adjacent periods is assumed to not contain any Transactions. That's why no mismatch is shown between period 1002 and period 1003 in the example.


Did this page help you?