The Export to CSV feature allows Practice Users to download transaction-level data for Payments, Refunds, and Deposits. This functionality is invaluable for internal accounting, financial reporting, and reconciling financial data with external systems like Practice Management Software (PMS) or bank statements. All exports are in CSV format, which is compatible with Excel, Google Sheets, and most accounting tools.
Why It’s Beneficial
Streamlines Reconciliation: By exporting detailed transaction data, practices can easily match internal records with bank statements or PMS, ensuring that payments, refunds, and deposits are accurately accounted for.
Supports Financial Reporting: The ability to export this data enables practices to generate reports, monitor cash flow, and gain insights into their financial health without manually extracting data from various systems.
Saves Time and Reduces Errors: Automating the process of data extraction reduces the chances of manual errors during data entry and speeds up the reconciliation process.
Improves Compliance: Having accurate and readily available records for payments, refunds, and deposits is essential for meeting financial reporting standards and ensuring compliance with audits or tax regulations.
Enhances Decision-Making: Access to accurate transaction data allows practice managers to make informed financial decisions, helping to manage costs, optimize revenue cycles, and identify trends.
Where to Access the Export Feature
Log in to your PbN account.
Go to Payments →
You'll see three options in the left menu:Payments
Deposits
Refunds
Each of these tabs provides its own data grid and export option.
1. Exporting Payments to CSV
Step 1: Go to the Payments Tab
From the PbN Platform, navigate to:
Payments Tab → Payments from the left menu navigation.
Step 2: Apply Filters (Optional)
Use filters to narrow down records:
Date Range (e.g., Last 7 days, Custom Range)
Payment Method (e.g., Credit Card, ACH, BNPL)
Patient Name
Status (Completed, Failed)
Transaction ID
Step 3: Click "Export CSV"
Click the “Export” button at the top-right corner of the Payments grid. A CSV file containing all matching records will be generated and downloaded.
2. Exporting Deposits to CSV
Step 1: Go to the Deposits Tab
Navigate to:
Payments Tab → Deposits
This section lists all deposits made to the practice’s bank account.
Step 2: Apply Filters (Optional)
You can refine the deposit history using:
Deposit Date Range
Step 3: Click "Export CSV"
Click the “Export CSV” button in the Deposits tab header. A deposit summary file will be downloaded along with payment records.
3. Exporting Refunds to CSV
Step 1: Go to the Refunds Tab
Navigate to:
Payments Tab → Refunds
This tab displays all refund activity, including manual refunds, chargebacks, or automatic returns.
Step 2: Apply Filters (Optional)
Refine the refund report using:
Refund Reference Id
Date Range
Payment Reference Id
Refund Type
Status
Step 3: Click "Export CSV"
Click the “Export CSV” button at the top-right corner of the Refunds grid. The file will contain all filtered refund records and will download instantly.
How to Open the Exported CSV in Google Sheets
If you don’t have Excel, you can open the CSV file in Google Sheets. Here’s how:
Log into Google Sheets
Open a New Spreadsheet: Go to Google Sheets and click on “Blank” to create a new spreadsheet.
Import the CSV File:
Click on File → Import → Upload.
Drag and drop the CSV file or click Select a file from your device.
After uploading, choose Import data and select Insert new sheet(s).
The CSV data will now appear in your new sheet, ready for further analysis.
By using the Export to CSV feature, practices can efficiently manage their financial data for Payments, Refunds, and Deposits. This tool not only simplifies the reconciliation process but also supports better financial oversight, improved compliance, and smarter decision-making. Whether you’re preparing for audits, tracking cash flow, or integrating data with external systems, exporting transaction data in CSV format is a key practice management tool.