Detail Ledger Report
Detail Ledger Report User Guide Version 1.0 Date: June 28, 2017
3111 North University Drive, Suite 705, Coral Springs, FL 33065 | P 800.996.0398 | F 954.346.3791
Table of Contents VERSION TRACKING
3
INTRODUCTION
4
RUN A REPORT
4
CUSTOMIZE REPORT RESULTS
6
GROUPED DATA ITEMS PER PAGE SAVED REPORTS EXPORT REPORTS TO A FILE
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 2 of 11
6 9 9 10
Version Tracking Version Number 1.00
Modification Date 06-28-2017
Modified By
Changes Completed
Product Development
Initial Documentation Completed.
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 3 of 11
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 Active Members report: 1. 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 the Saved Reports menu 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. 2. Select the specific merchant account(s) you want to see in the report.
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 4 of 11
3. Click the date-selector box and choose the time period you want to report on. Select Today, Yesterday, Last Week (the last completed Sunday-Saturday period), Last Month (the previous calendar month), This Month (the current calendar month), Last 7 Days, Last 30 Days or pick a Custom Range and select starting and ending dates:
4. To choose the specific detail you want included in the report, click Advanced Options:
A menu will show all of the optional data you can include for each transaction in the report, as in the following image:
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 5 of 11
5. 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 the Currency column to display one currency at a time, and see true totals for amount (see next section for help with filtering).
Customize Report Results Grouped Data
To sort the list view alphabetically or numerically according to any specific column in the report, click the column header (click it again to return to the original sorting).
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 6 of 11
You can filter the data in most columns by clicking the inverted triangle icon next to the column header (see image below). Choose an option, such as “is equal to” and type the value you want to filter for. For example, “is equal to” EUR will only show rows where the value in the column you filtered is EUR.
You can group data according to any column in the report, as well. Just click on the column header(s), and drag/drop it onto the blue bar. For example you can group the report by Transaction Type, as in the following image, to see transactions by type:
You can drag and drop multiple column headers – for example to group the report by Transaction Type, and then by Transaction Source, as in the following image:
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 7 of 11
Staying with the example above, you can reverse the grouping by clicking the URL label in the blue bar, then dragging and dropping it to the left of Membership Type.
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 8 of 11
Items per Page
By default, the report will display 100 results per page, maximum. Click the Items per Page menu below the report to increase the results per page to 100, 500, 1000 or “All” (to see all results on one page).
Saved Reports
You can save any report you run, so you don’t have to re-create it the next time. After running the report, click Save this Report in the top-right area of the report. You’ll see the following window:
Click Add Report, give your saved report a name and click Save. Now, any time you click Save this Report, you’ll see your existing reports listed, with the ability to delete each saved report, or edit its name.
Note that your saved report will include the settings you selected in steps 1-6 above; if you sorted or grouped the report by any specific column(s), the saved report will not include those customizations.
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 9 of 11
Once you’ve saved a report, you can retrieve it at any time by visiting the Invoice Report page, clicking Saved Reports and selecting the report you want to see:
If you want to make changes to a saved report, just open the report, make your changes and click Save this Report. Then click Overwrite to update the report with your changes.
Export Reports to a File
You can export your reports to CSV, PDF or Excel files. Just click Download in the topright area of the report. Then enter a file name, select a file type (CSV, PDF or XLSX) and click Save.
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 10 of 11
The report will be saved to the Downloads folder on your computer. Please feel free to let us know any thoughts or suggestions you have about this report or anything else, by emailing [email protected].
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 11 of 11
3111 North University Drive, Suite 705, Coral Springs, FL 33065 | P 800.996.0398 | F 954.346.3791
Table of Contents VERSION TRACKING
3
INTRODUCTION
4
RUN A REPORT
4
CUSTOMIZE REPORT RESULTS
6
GROUPED DATA ITEMS PER PAGE SAVED REPORTS EXPORT REPORTS TO A FILE
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 2 of 11
6 9 9 10
Version Tracking Version Number 1.00
Modification Date 06-28-2017
Modified By
Changes Completed
Product Development
Initial Documentation Completed.
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 3 of 11
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 Active Members report: 1. 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 the Saved Reports menu 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. 2. Select the specific merchant account(s) you want to see in the report.
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 4 of 11
3. Click the date-selector box and choose the time period you want to report on. Select Today, Yesterday, Last Week (the last completed Sunday-Saturday period), Last Month (the previous calendar month), This Month (the current calendar month), Last 7 Days, Last 30 Days or pick a Custom Range and select starting and ending dates:
4. To choose the specific detail you want included in the report, click Advanced Options:
A menu will show all of the optional data you can include for each transaction in the report, as in the following image:
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 5 of 11
5. 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 the Currency column to display one currency at a time, and see true totals for amount (see next section for help with filtering).
Customize Report Results Grouped Data
To sort the list view alphabetically or numerically according to any specific column in the report, click the column header (click it again to return to the original sorting).
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 6 of 11
You can filter the data in most columns by clicking the inverted triangle icon next to the column header (see image below). Choose an option, such as “is equal to” and type the value you want to filter for. For example, “is equal to” EUR will only show rows where the value in the column you filtered is EUR.
You can group data according to any column in the report, as well. Just click on the column header(s), and drag/drop it onto the blue bar. For example you can group the report by Transaction Type, as in the following image, to see transactions by type:
You can drag and drop multiple column headers – for example to group the report by Transaction Type, and then by Transaction Source, as in the following image:
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 7 of 11
Staying with the example above, you can reverse the grouping by clicking the URL label in the blue bar, then dragging and dropping it to the left of Membership Type.
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 8 of 11
Items per Page
By default, the report will display 100 results per page, maximum. Click the Items per Page menu below the report to increase the results per page to 100, 500, 1000 or “All” (to see all results on one page).
Saved Reports
You can save any report you run, so you don’t have to re-create it the next time. After running the report, click Save this Report in the top-right area of the report. You’ll see the following window:
Click Add Report, give your saved report a name and click Save. Now, any time you click Save this Report, you’ll see your existing reports listed, with the ability to delete each saved report, or edit its name.
Note that your saved report will include the settings you selected in steps 1-6 above; if you sorted or grouped the report by any specific column(s), the saved report will not include those customizations.
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 9 of 11
Once you’ve saved a report, you can retrieve it at any time by visiting the Invoice Report page, clicking Saved Reports and selecting the report you want to see:
If you want to make changes to a saved report, just open the report, make your changes and click Save this Report. Then click Overwrite to update the report with your changes.
Export Reports to a File
You can export your reports to CSV, PDF or Excel files. Just click Download in the topright area of the report. Then enter a file name, select a file type (CSV, PDF or XLSX) and click Save.
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 10 of 11
The report will be saved to the Downloads folder on your computer. Please feel free to let us know any thoughts or suggestions you have about this report or anything else, by emailing [email protected].
Confidential & Proprietary © 2017 SegPay May not be reproduced or released without the written consent of SegPay Last Revision Date: 01/04/2017 Page 11 of 11
