---
title: Daily balance file
slug: concepts/cards/reporting-and-compliance/card-issuing-reports/daily-balance-file
description: Daily card balance file for reconciliation and compliance, including card status, balances, lifecycle dates, transaction activity, and charge-offs.
createdAt: 2026-06-08T14:23:41.023Z
---

## Card balance file

This file provides the ending balance and status for each issued card at the end of each business day. This file supports account reconciliation, negative balance monitoring, and charge-off reporting. It also supports other Cross River operational and compliance oversight functions.

:::hint{type="info"}
Daily balance files are only required for Cross River held funds and external ledger
:::

## File delivery and format

Refer here for [file delivery](docId\:i4b_iqAVcQFp9m1611twC) and [file format](docId\:i4b_iqAVcQFp9m1611twC) details.

## Sample card balance file

The following file contains sample data.  If you have any questions, please be in touch with your onboarding team.

::File{src="https://api.archbee.com/api/presign/4hvUOg5mU1sCngl0n0Has/TgeIOM09YMTSUjm3mSRtZ-20260616-065427.csv" label="Card_Balance_Report_Template.csv"}

## Explanation of fields

| Field                   | Data Type                             | Description                                                                                                                                                                                                                 | Required/Conditional                                                                                     |
| ----------------------- | ------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------- |
| unique\_program\_id     | varchar(12)                           | Identifier provided by the processor to distinguish programs for settlement and reconcilliation.                                                                                                                            | Required                                                                                                 |
| product\_id             | varchar(12                            | If a partner has more &#xD; than one type of card program, the &#xD; processor should include a &#xD; product identifier, e.g., 1001 = &#xD; Credit Card, 1002 = &#xD; Commercial Prepaid, 1003 = &#xD; Platinum, etc.&#xD; | Required                                                                                                 |
| user\_id                | varchar(50)                           | Identifier given to each unique &#xD;customer or cardholder by the processor or partner (not generated by Cross river). &#xD;                                                                                               | Required                                                                                                 |
| card\_id                | varchar(50)                           | Identifier given to each unique card issued to an account.&#xD;                                                                                                                                                             | Required                                                                                                 |
| card\_status            | varchar(20)                           | Card status at the prior day’s&#xD; cut-off time, in US Eastern Time.                                                                                                                                                       | Required                                                                                                 |
| status\_change\_date    |  DATETIME (YYYY-MM-DD HH\:MM\:SS.sss) | Date and time of the most recent status change of the &#xD;<br />card, in US Eastern Time.&#xD;                                                                                                                             | Required                                                                                                 |
| current\_balance        | decimal(18,4)                         | Card balance, excluding &#xD;<br />pending authorizations, at the prior day’s cut-off time (Midnight, US Eastern Time).                                                                                                     | Required                                                                                                 |
| available\_balance      | decimal(18,4)                         | Card balance, including &#xD;<br />pending authorizations, at the &#xD;prior day’s cut-off time (Midnight, US Eastern Time).                                                                                                | Required                                                                                                 |
| created\_date           |  DATETIME (YYYY-MM-DD HH\:MM\:SS.sss) | Date and time when the card &#xD; was first created, US Eastern Time.                                                                                                                                                       | Required                                                                                                 |
| activation\_date        |  DATETIME (YYYY-MM-DD HH\:MM\:SS.sss) | Date and time when the card &#xD; was first activated, US Eastern Time.&#xD;                                                                                                                                                | Conditional- blank if card is still in 'Issued' status. Required once card transitions to 'Active'       |
| last\_transaction\_date |  DATETIME (YYYY-MM-DD HH\:MM\:SS.sss) | Date and time when the card last had a balance-affecting &#xD;transaction, US Eastern Time.                                                                                                                                 | Conditional- blank if the card has not had a transaction                                                 |
| negative\_balance\_date |  DATETIME (YYYY-MM-DD HH\:MM\:SS.sss) | Date and time of the most recent time the card had a negative balance, US Eastern Time.                                                                                                                                     | Conditional - blank if the card has not had a negative balance                                           |
| closed\_date            |  DATETIME (YYYY-MM-DD HH\:MM\:SS.sss) | Date and time when the card was permanently closed, US Eastern Time.                                                                                                                                                        | Conditional - blank unless card is 'closed'                                                              |
| charge\_off\_amount     | decimal(18,4)                         | Balance of the card at the time &#xD; of closing following a charge-off                                                                                                                                                     | Conditional - blank if account not charged off. Populated only when delinquency\_bucket = 'Charged-Off'. |
|                         |                                       |                                                                                                                                                                                                                             |                                                                                                          |

### Expected values for card status

| Status        | Explanation                                                 |
| ------------- | ----------------------------------------------------------- |
| Issued        | Card was issued but it yet to be activated                  |
| Active        | Card has been activated and is open to transact             |
| Suspended     | Card temporarily suspended by cardholder or program manager |
| Fraud Blocked | Card blocked by program manager due to fraud                |
| Closed        | Card permanently closed (end state)                         |







