What are balance types?

By accumulating pre-defined balances you can easily track different types of balances. Each balance type contains the total balance of a selected group of technical accounts for a card account.

The data represents a snapshot that is taken during the end of day process that is run at midnight 24:00 UTC. The Account_Balance_Type files contain the AVAILABLE balance for all accounts every day. The other balances are only available incrementally, i.e. when they have changed. For example:

Day 1

  • AVAILABLE : 1000€
  • Cardholder makes a purchase for 100€ (settled the same day)

Day 2

  • AVAILABLE: 900€
  • TOTAL_BALANCE: 100€
  • Cardholder pays off the 100€ balance

Day 3

  • AVAILABLE: 1000€

  • TOTAL_BALANCE: 0€

    • Balance types with zero amount are included in the case they have changed to zero since the previous day.
  • The following balance types are available in the Account_Balance_Type file:

Balance type codeDescriptionAvailable for following products
AVAILABLEThis is the available amount on the card account. The available amount considers both financial transactions as well as pending authorisations. The amount is the available amount at the point of end of day process. Unlike other balance types, the available balance is provided for all accounts every day even though it wouldn’t have changed since the previous day.Prepaid, Debit, Credit
TOTAL_BALANCEThis amount is the total balance of the card account at the point of end of day process. For credit products this balance includes both invoiced and uninvoiced balances.Prepaid, Debit, Credit
STMT_BALANCEThis is the total amount of your customer’s invoice. This includes both the minimum to pay balance as well as any potential balance on grace and billed technical accounts. For detailed technical account mapping, see this guide.Credit
DUEThis is the due amount your customer is expected to pay. It should be noted that this does not include any potential overdue amounts. The DUE amount is updated when payments are posted to the card account.Credit
OVD_01This is the amount of overdue balance that has passed one due date, i.e. 1-30 days past due date.Credit
OVD_02This is the amount of overdue balance that has passed two due dates, i.e. 31-60 days past due date.Credit
OVD_03This is the amount of overdue balance that has passed three due dates, i.e. 61-90 days past due date.Credit
OVD_04This is the amount of overdue balance that has passed four due dates, i.e. 91-120 days past due date.Credit
OVD_05This is the amount of overdue balance that has passed five due dates, i.e. 121-150 days past due date.Credit
OVD_06This is the amount of overdue balance that has passed six or more due dates, i.e. > 150 days past due date.Credit
PAST_DUEThis is the sum of all overdue balances, i.e. the sum of the OVD_ technical accounts.Credit
TOTAL_DUEThis is the sum of DUE and PAST_DUE. It is the total amount of due balance of the card account.Credit
OPENING_BALANCEThis is the total balance of the card account at cycle start. This balance type is only available in statement files.Credit