Skip to main content
Daily Balance and Activity Reports together give a daily overview of the activity within accounts. The balances and transactions contained in the reports will match the monthly bank statements you receive.

​
Report Summaries

ReportDescription
Daily BalanceDetails the opening and closing balance of account(s) at the business date (posting date) level. Multiple accounts can be included on this report. This report is comma delimited.
Daily ActivityDetails each individual transaction that occurred on the account(s) within that business date (posting date). Multiple accounts can be included on this report. The report contains: transaction code, debit and credit amount, and other supplemental information for transactions when supported (such as Company ID for external ACH). The transactions for an account within this report can be aggregated to reconcile opening and closing balances supplied in the Daily Balance report. Business days with no activity will not generate a report for that day. This report is comma delimited.
ACH Cash ReconciliationBecause ACH settlements are processed in aggregated or batched form, we provide this report with transaction-level ACH details to help reconcile them with the aggregated settlements shown on your bank statement. Unlike the other two reports, Settlement Cash Reconciliation is pipe delimited.

​
Report Delivery

Because ACH settlements are processed in aggregated or batched form, we provide this report with transaction-level ACH details to help reconcile them with the aggregated settlements shown on your bank statement. Unlike the other two reports, Settlement Cash Reconciliation is pipe delimited. Lead’s platform does not perform updates or produce reports on weekends. Transactions from Saturday and Sunday are batched and processed with the next business day’s update, appearing in that day’s report with the next business day as the posted date. This means you’ll receive one file on Monday showing all weekend and Monday transactions with a Monday posted date.
Intra-day reports are not available.
Lead’s platform does not perform updates or produce reports on bank holidays. Transactions from these dates are processed with the next business day’s update and reflected in that day’s report.
If you are using ACH services, you will receive an ACH Settlement Cash Reconciliation report each calendar day for the prior day’s settled ACH transactions. Because ACH settlements occur only on business days, the report will contain no data rows (only headers) on bank holidays. This report includes ACH transactions settled between 12:00 a.m. CT and 11:59:59 p.m. CT.
Notification of Change (NOC) ACH entries will not be included in this report, as they do not have a monetary impact on the underlying account.

​
Report Naming

All reports are in csv format. They can be found in the SFTP file structure under bank-account-reports:
  • YYYY-DD-MM_[partnername]-daily-activity-report_[epoch].csv
  • YYYY-DD-MM_[partnername]-daily-balance-report_[epoch].csv
  • YYYY-MM-DD_[partnername]-ach-cash-recon-report_[UNIQUE-POSTFIX].csv