2950
Introduction
The Detail Ledger Report allows you to see a list of transactions over a selected date range, along with fees, reserves and other details associated with each transaction. The Detail Ledger report does not include any current day transactions as fees are not applied until the transactional day has been completed.
Run a Report
Follow these steps to run the Detail Ledger report:
Login to the Segpay Merchant Portal at: https://mp.segpay.com, then point your mouse at the Financial Details menu and select Detail Ledger Report.
Click Choose from a Saved Report if you have run the Detail Ledger report before and want to retrieve a previously-run report (see the Saved Reports section near the end of this document for more detail). Otherwise, see step 2 below to generate a new report.
Select the specific merchant account(s) you want to see in the report.
To choose the specific columns you want included in the report, click the Columns dropdown.
To choose additional columns that are not shown by default look under the Additional Fields dropdown.
Click Generate Report. By default, results are sorted reverse-chronologically by date (newest transactions first).
Note that if you are viewing transactions in multiple currencies, totals will reflect a blended total of all currencies. You can filter or group on the Currency column to display one currency at a time and see true totals for amount (see next section for help with filtering).
Choose from a Saved Report
Most reports have four small icons in the top right corner. The one shaped like a floppy lets you save your report filter choices so that you can easily retrieve them later.
Just click the icon and type in a name to use when retrieving your report filter. If you choose the same name again it will let you overwrite the old filter. You can also rename and delete your filters.
When you are ready to use your filter just click ‘Choose from a saved report’ to pull up your saved filter. This can save you time if you run the same report many times. Note saved reports save filters but do not save groupings.
Download my Report
To download your report choose the icon in the top right that looks like a down arrow.
Then give your report a name and choose the format for your download (CSV,XSLX,PDF) and click the download button.
On some reports that return thousands of rows of data you will be given some additional choices for your download. You will see an option to have your report emailed to you.
Large reports may be emailed to you in a zip archive format. Very large reports (usually in PDF format) can require the zip archive to be split into multiple emails for delivery. Save all attachments to the same folder and open the first one and it will uncompress them together into a single large file.
Report Charts
In the top right corner of your report you will see several small icons. The icon with the waving arrow will allow you to see a chart view of your report.
When viewing each chart type you can use the other dropdown filters to change the way your chart data is represented on the page. Experiment with different options to see which gives you the best view for that chart type.
Result Table Filtering in your Report
Your report data is returned in a tabular grid format. There are several useful controls built into this grid for filtering and sorting your data.
Page Controls and both Horizontal and Vertical Scroll Bars will help you to see data that is too large to fit on the screen.
Use the arrows to advance to a certain page or go all the way to the last page. You can also control how many items display on a single page. Totals are shown to the right.
Please feel free to let us know any thoughts or suggestions you have about this report or anything else, by emailing [email protected].
