Funding Dashboard


Funding Dashboard reconciles daily Net Sales down to Net Settlement, showing the bridge through Processor Fees, Network Fees, Interchange Fees, Disputes, and Adjustments, broken out by funded date, settlement date, and acquirer.

The question it answers is the one finance asks every morning: the deposit that landed in our account is smaller than the sales we booked — where did the difference go, and is it right? Work the page top to bottom. The chart shows you the shape of the bridge for a single day. The table shows you the same bridge broken down far enough to tie a line back to a specific batch.

Acquirer Data Availability

What appears on this dashboard depends on which acquirers send Optimized Payments the underlying data. If an acquirer is not listed below, its activity will not appear here — that is a gap in source data coverage, not a true zero. Within your own account, coverage also depends on which of these acquirers you process with.

Acquirers with funding data currently available:

  • Chase

  • Fiserv

  • AmEx

  • WorldpayVAP

  • PayPal

  • Adyen

Coverage varies by column as well as by acquirer. Some acquirers do not report every fee component, so a $0 in one column for one acquirer while others carry values is usually a reporting gap rather than a genuine zero. Check the acquirer against the column before treating a zero as a finding.

Chart Section

Net Funding

A waterfall running left to right from Net Sales to Net Settlement, with each fee and adjustment category stepping the balance up or down in between.

  • Y-Axis: Dollar amount ($)

  • X-Axis: Net Sales, Processor Fees, Network Fees, Interchange Fees, Disputes, Net Settlement

  • Bars: Net Sales and Net Settlement are Total bars anchoring each end. The categories in between are Increase or Decrease bars depending on which way that category moved on the day

The legend shows three bar types — Increase, Decrease, and Total — and the middle categories genuinely use both. A fee category normally reduces the balance, but credits, rebates, and dispute reversals land in the same category and push it the other way, so a Disputes bar pointing up means you recovered more than you lost that day rather than that something is broken.

Date Period for Chart defaults to Yesterday and is set independently of the Data section below.

Data Section

Below the chart, a configurable table breaks the same bridge down to the funded date, settlement date, and acquirer level. This is where a reconciliation actually gets resolved, because it is the only view that puts every component on one row.

  • Measure: multi-select, with all seven selected by default — Net Sales, Processor Fees, Network Fees, Interchange Fees, Disputes, Adjustments, and Net Settlement. Leaving all seven on is usually right here, since the point of the table is to see the full bridge on a single row. Clear a few only when you are tracking one component over time and the width is getting in the way

  • Groups: sets how many levels the table drills through, each chosen independently

  • Group 1 / Group 2 / Group 3: defaults to Funding : Funded Date, then Funding : Settlement Date, then MID : Acquirer. That sequence is deliberate — reading it left to right tells you when the money moved, when the underlying activity settled, and who sent it

  • Date Period: defaults to the last 7 days including today, set independently from the chart's Date Period

  • Date Granularity: defaults to Daily, switchable to Yearly, Quarterly, Monthly, or Weekly

Keep Daily granularity while reconciling. Rolling up to Weekly or Monthly nets offsetting adjustments against each other and hides the individual day that is out.

Filters

The FILTERS button at the top right opens a panel with four tabs. Two of them are generic; the other two are what make this dashboard usable for reconciliation rather than just reporting.

Funding

The tab to use when you are working backwards from something concrete — a deposit on a bank statement, a remittance advice, a figure your acquirer gave you.

Filter

When to use it

Batch ID

Pin the page to one settlement batch. This is the fastest route from "this deposit looks wrong" to the rows behind it

Payment Number

Isolate a single payment where the acquirer's reference is what you have to hand

Bank Account Number

Separate funding by receiving account when you settle into more than one

Funded Date / Settlement Date

Filter on either leg independently. Useful when a batch crossed a date boundary and you need to know which side it fell on

Channel / Platform

Narrow to a specific funding channel or platform when more than one feeds the same account

Currency

Presentment, Reporting, and Settlement are three separate filters because they are three different currencies. If a settlement amount does not match what you presented, a currency mismatch is a likelier explanation than a fee, and this tab is how you confirm it before chasing the fee columns.

MID

Narrows the page to part of your estate — by Acquirer, Merchant ID, Merchant Account, Division, Region, Chain, Legal Name, DBA Name, MCC, Reporting Group, the two Rollup levels, and the rest of the standard merchant hierarchy. Use it to scope a reconciliation to one entity before drilling, rather than filtering after the fact.

Card

MOP Name, MOP Network Name, MOP Type, and OP MOP Category. Funding timing differs by payment method, so isolating a method here is how you tell a slow-settling MOP from a genuinely missing batch.

Apply & Close commits your selections; Clear Filters resets every tab at once, not just the one you are looking at.

Filtering Tips

  • Two independent date controls. Date Period for Chart defaults to Yesterday and drives only the Net Funding chart. Date Period in the Data section defaults to the last 7 days including today and drives only the table. Changing one does not change the other, so a chart and a table that appear to disagree are usually just showing different days

  • Date Granularity defaults to Daily on the Data section, switchable to Yearly, Quarterly, Monthly, or Weekly. Leave it on Daily while reconciling

  • Groups defaults to 3 levels — Funded Date, Settlement Date, and Acquirer. Swap Group 3 to Merchant ID when the acquirer is not the thing in question

  • Filters apply to the chart and the table together, unlike the date controls. Narrowing to one acquirer or one batch reframes the whole page at once

Use Case Examples

"We want to confirm yesterday's net settlement matches what we expect after fees and disputes."

  • Review the Net Funding chart to see the bridge from Net Sales to Net Settlement for the selected day

  • Use the Data section to break that same bridge down by Funded Date and Settlement Date to confirm the batch settled on the expected day

  • Drill into Acquirer to see whether a specific acquirer's fees or disputes are driving an unexpected deduction

  • Check the Adjustments column before concluding the difference is fee-driven, since it does not appear on the chart

"A deposit hit our account and it does not match any figure we were expecting."

  • Open FILTERS → Funding and enter the Batch ID or Payment Number from the bank statement or remittance advice

  • Read the resulting row across all seven measures to see the full bridge for that batch alone

  • If Net Sales is right but Net Settlement is not, the answer is in one of the fee or Adjustments columns. If Net Sales itself is wrong, the batch is not the one you thought it was — widen Funded Date and check whether it settled a day either side

  • If everything reconciles in your reporting currency but not against the bank, check FILTERS → Currency for a presentment-to-settlement mismatch