What MySplitPay reads from your reports
MySplitPay reads four pieces of information from every report line. Those four fields decide how MIDs are created, how commissions are calculated, and where everything lands in your views.
The four pieces of information
Section titled “The four pieces of information”Whether a file is recognized automatically or through a custom mapping, each line is read for the same four things:
| Field | What it is | What it drives |
|---|---|---|
| MID | The processing account number | Which MID the line belongs to — created automatically if it’s new |
| DBA name | The merchant’s business/location label | How the MID is labeled everywhere in the app |
| Commission | The residual/commission amount for the line | The amount that’s split between you and the assigned rep |
| Period | The month the line belongs to | Where the line lands in ledgers, filters, and statements |
The file itself is recognized by the way its columns are arranged. That’s how MySplitPay knows which processor a file came from without you telling it each time.
How report data is organized
Section titled “How report data is organized”Everything is organized by MID and month: one MID’s activity in one month makes one commission line. That single rule has a few practical consequences:
- Duplicates are counted once. If the same MID shows up for the same month in more than one uploaded file, the most recent upload wins. That’s why re-uploading a corrected file is safe.
- New MIDs are created automatically. A MID that’s never been seen before is added to your book, carrying the DBA name from the file. It arrives unassigned; link a rep to it and set the assignment’s start period — including a past month, if their split should cover reports already uploaded.
- Commissions follow the period. A line’s period decides which month it counts toward in every view, so a rep’s ledger, the Commissions view, and period filters all agree.
When a line can’t be used
Section titled “When a line can’t be used”Lines that can’t be read cleanly raise warnings on the report. The count appears in the Reports list, and the details on the report’s page, alongside the original lines exactly as they came in. Warnings don’t block the rest of the file; they flag the lines worth a second look.
Next steps
Section titled “Next steps”Uploading reports covers getting files in and what deleting a report does. Custom report formats is where these four fields get mapped for a new file layout.