Transaction Reconciliation

Overview

Use Newline APIs and CSV reports to reconcile transaction activity with Fifth Third bank statements and daily closing balances.

Reconciliation in Newline is a lifecycle‑driven process. Settlement, statement posting, and closing balance calculation occur at different points in time, so you need to combine the correct APIs and CSV reports instead of relying on a single transaction view.

In this guide, you will:

Distinguish settlement from statement posting.
Identify when statement posting fields and balances become available.
Choose which APIs and CSVs to use for reconciliation.
Use the Prior Day Posted Transactions CSV in your workflow.

Understanding the Transaction Lifecycle

Reconciliation requires understanding three distinct phases in a transaction’s lifecycle.

1. Transaction Settlement

Indicates that funds movement has completed.
Reflected in transaction status (for example, settled).
Captured in the Settled Transactions CSV.

Settlement does not imply:

The transaction has posted to the bank statement.
Closing balances have been calculated.
Reconciliation‑ready data is available.

2. Transaction Posting (Statement Alignment)

Occurs when the transaction is posted on the Fifth Third bank statement.
Represented by the statement_posted_at field.
Posting may occur after settlement, often on a later business day.

Settlement and posting are separate lifecycle events.

3. Daily Closing Balance Calculation

Closing balances are calculated once per business day.
Provided for both synthetic and custodial accounts.
Exposed via API and CSV reporting.
May populate after settlement and posting events.

Closing balances provide the authoritative end‑of‑day figures used for reconciliation.

Key Reconciliation Capabilities

Statement Posting Date Identification

The statement_posted_at field enables direct alignment between Newline transactions and Fifth Third bank statement activity.
This field may not be populated at settlement and is updated later in the transaction lifecycle.

Daily Account Closing Balances via API

Dedicated endpoints provide access to daily closing balances for:

Synthetic accounts
Custodial accounts

These balances represent the official end‑of‑day figures used for reconciliation and auditing.

CSV Reporting for Reconciliation

Newline provides CSV reports that support reconciliation workflows, including:

The Prior Day Posted Transactions CSV
Enhancements to existing transaction CSVs
Daily closing balance exports

API Endpoints

Synthetic Accounts

Endpoint	Use it to
`GET /synthetic-account-closing-balances`	Retrieve a paginated list of synthetic account closing balances. Filter the results by account identifier and date range when you need balances for a specific account or reconciliation period.
`GET /synthetic-account-closing-balances/{uid}`	Retrieve the closing balance for one synthetic account balance record by its unique identifier. Use this when you need the details for a specific closing balance entry.

Custodial Accounts

Endpoint	Use it to
`GET /custodial-account-closing-balances`	Retrieve a paginated list of custodial account closing balances. Use this endpoint to review custodial account end-of-day balances for reconciliation.
`GET /custodial-account-closing-balances/{uid}`	Retrieve one custodial account closing balance record by its unique identifier. Use this when you need the details for a specific closing balance entry.

Reporting Enhancements for Reconciliation

Note
When receiving an initial settled event or querying a transaction with a settled status, the following fields may not yet be populated:

statement_posted_at

net_usd_closing_balance

These fields are updated later in the transaction lifecycle. Clients should use polling or CSV ingestion to retrieve them once available.

Prior Day Posted Transactions CSV

The Prior Day Posted Transactions CSV is the primary CSV used for reconciliation.

It includes:

Transactions that posted to the bank statement on the prior business day.
statement_posted_at timestamps.
Transaction identifiers needed for traceability.

This report provides a posted‑date‑driven view, making it reconciliation‑ready.

Daily Closing Balance Availability

Daily closing balances are usually available by 8:00 AM Eastern Time following a business banking day.

On a standard five‑business‑day banking week:

Day available	Represents closing balance for
Tuesday	Monday
Wednesday	Tuesday
Thursday	Wednesday
Friday	Thursday
Saturday	Friday

Align your data ingestion and polling strategy to this schedule.

How Reconciliation Fits Together

Follow this workflow to reconcile posted transactions to statement balances:

Use the Prior Day Posted Transactions CSV to identify transactions posted to the bank statement.
Use statement_posted_at to align transactions with statement dates.
Retrieve daily closing balances via API or CSV.
Match posted transactions to closing balances for statement reconciliation.

Relationship to Other CSV Reports

Report	Role in reconciliation
Settled Transactions CSV	Confirms settlement completion.
Updated Transactions CSV	Supports lifecycle monitoring.
Prior Day Posted Transactions CSV	Provides the primary reconciliation input.
Daily Closing Balance APIs / CSVs	Supports balance validation and tie‑out.

Important Usage Notes

Settlement and statement posting occur as separate lifecycle events.
Posting may occur after settlement, often on a later business day.
Closing balances update on a daily cadence.
Reconciliation requires combining posted transactions and closing balances.

Summary

Reconciliation in Newline is lifecycle‑based, not settlement‑based.

Settlement confirms funds movement completion.
Posting aligns activity to bank statements.
Closing balances provide the reconciliation anchor.

By combining posted transaction data with daily closing balance reporting, you can reconcile Newline activity with Fifth Third bank statements.