Reconciliation Overview

Welcome to the PowerBoard Dashboard tutorials. Today we’ll show you how to create and download a CSV report for the purposes of obtaining a daily reconciliation. To access the PowerBoard portal, you’ll need to log in using your credentials. To create a reconciliation CSV report, you’ll first need to create a new template. Navigate to the Charges tab…here you’ll see a list of previous transactions. Head to the yellow tab titled Charges View Mode. Using the drop-down, select Transactions View Mode. Then click Settings in the upper right corner of this screen. The Field Settings window will appear. You’ll notice the first tab selected is the Transactions View Mode. To create the template, you’ll need to select the fields you’d like to include by checking the boxes in the Display in the ‘Transactions’ page and Display in the CSV export columns. There are six mandatory fields. Once you’ve selected these, you can select any other additional fields you want displayed in your CSV report. For this example, we’ll use the 6 mandatory fields only.

Navigate to the Charge View Mode in the Fields Settings window. There are two mandatory fields, authorization and customer payment source card scheme. The rest are optional. Navigate to the Template Name field and add a name. We’ll call this template Reconciliation Test Report. Then click on Save as a new template. From here you’ll need to filter the transactions. Click on Apply New Filter and in the date dropdown field select Processed At. Then in the Date From field select the start of the date range, normally the day before the current settlement time. You can select any date range, and download reconciliation reports on a daily, weekly or monthly basis.

For this example, we’ll download a daily report for the 16th of January. Ensure you select the time according to your geographical location. The PowerBoard Portal Settlement time is aligned with Australian Eastern Standard Time or Australian Eastern Daylight Time. If you want the report to reflect settlements made on a specific date, enter the previous day and settlement cut off time of 5:30 PM AEST or AEDT and the next date settlement cut off time of 5:30 PM AEST or AEDT. Then navigate to the Status field and from the drop-down, select the Completed and Refunded options. Head down to the Charge Type field and select the Financial option from the drop-down box. In the Transaction Type field, select the Sale, Refund and Capture options. In the Gateway Type field select the payment service you want in the report.

Selecting the Mastercard option ensures all transactions made from Mastercard, AMEX, Visa or from digital wallets such as Google Pay and Apple Pay, will be included in the report, because they are all processed through the Mastercard gateway. AMEX transactions may take between 3-5 business days to settle and so may need to be filtered in or out when reviewing the CSV file. Alternate Payment Methods transactions, like PayPal and After Pay, can also be included, however the transactions from these APMs don’t have the same day 5:30PM AEST or AEDT settlement time as the traditional cards and digital wallet payments … so these settlement figures may not be accurately referenced in the report. In this example, we’ll proceed with transactions made from the Mastercard gateway only. Next, head down and click on the yellow Apply Filter button. In the Active Filters section, you’ll notice all the options that have been selected. The filtered items will also include the transactions processed on that settlement date and immediately refunded on the same day. The filtered items will exclude all the failed transactions.

Navigate to Download Report and click on the arrow. Select All Filtered Items from the dropdown to download your report. The report will be visible as a CSV file. View the next video in this series ‘Calculating the Settlement Amount from the Reconciliation CSV report’. Discover more new features on the PowerBoard Developer Hub.