DAF & DAR

The DAF (Daily Accounting File) is emailed each morning (business days only). The DAR (Daily Accounting Report) is essentially the same report but it is not emailed out each day - instead, it’s a dynamic report that can be found under the “Accounting” tab in Analytics.

Both reports provide transaction-level detail for the activity that will be either credited or debited to your designated bank account or cash account. The information supports reconciliation for payment activity. The DAF is a Microsoft Excel (XLS) document containing five worksheets (tabs) each with a specific type of financial activity that results in a debit or credit to the designated bank account.

Accounting Summary

The high-level summary of money movement. Details for which are provided in the remaining tabs:

Daily Margin

List of all Sale Transactions that were closed for the prior day and the funding amount**.
  • Sale Transactions close when the number of purchases requested (virtual cards issued) equals the Expected Payments value entered during the sale. Sale transactions can also be manually closed.
  • The Daily Margin Funding amount equals the difference between the sale amount and the sum of the virtual cards requested.

Residual Margin

📘

Funds from Daily, Residual and Purchase Returns are aggregated into a single credit ACH entry

List of all expired virtual cards with funds (balance) remaining. For example, if a virtual card was requested for $400 but only $390 was used, the remaining $10 is released as residual funds.

Sales Returns

📘

Funds from Sales Returns & Voids are individual ACH credit or debit entries

List of Sale Transactions that were either Voided or fully or partially Returned. ConnexPay assumes one or more virtual cards are requested for individual Sale Transactions; therefore, funds are pulled from the designated bank account 14 days after the void or return.

Purch Returns

List of Purchase Transactions (Virtual Cards) that receive money in the form of a return from the supplier. Funds returned to a virtual card are released to the Operating Account when received.

Adjustments

List of Purchase Transactions that have an activity that warrants an out-of-scope adjustment to collect funds immediately. Examples are:

  • When the settled amount on the Virtual Card is greater than the issued amount
  • When there is a settled transaction on a Virtual Card after Residual Margin has already been paid

Purch Chargebacks

📘

Purchase Chargebacks are funded based on the contractual agreement

The total amount of Virtual Card chargebacks won is included in the Accounting Summary report in Analytics. Next up will be to provide that same information in the Daily report emailed to you and to provide a detailed tab that will list any Virtual Card chargebacks won.

ConnexPay employees can find more details here.


Did this page help you?