Overview: This guide will walk you through the
steps to import payments into SchoolBanks, especially useful if you use
external payment providers.
Why Import Payments? Some schools prefer to use
their own payment providers instead of the integrated options like Stripe.
Importing payments allows you to maintain a single view of all student
transactions within SchoolBanks.
Steps to Import Payments:
Navigate
to Payment Options:
Go
to Admin > Settings > Payment
Options.
Here,
you can see the available payment options, including Stripe.
Prepare
Your Payment File:
Export
the payment data from your external payment provider.
Ensure
the file includes at least the student number and payment amount.
Import
Payments:
Go
to Admin > Data Sync > Payments
Import.
Select
your payment file.
Match
the columns in your file to the corresponding fields in SchoolBanks. For
example, map the student number and payment amount.
Start
the Import:
Click
the Import button.
The
system will begin importing the payments, checking for duplicates based
on receipt numbers and transaction IDs.
Review
Import Results:
Once
the import is complete, a downloadable report will be available.
This
report will show which payments were successfully imported and which ones
failed.
Use
this report for reconciliation if needed.
Verify
Imported Payments:
Go
to the Student View page.
Select
a student to see the imported payments on their ledger.
The
payment date and a SchoolBanks receipt ID will be added for each imported
payment.
Student
Access:
Students
can log in to their accounts to view their payment history.
If
Stripe payments are enabled, students can also make payments directly
through their accounts.
Importing payments into SchoolBanks
helps streamline your financial management by consolidating all transactions in
one place. Follow these steps to ensure a smooth import process and maintain
accurate student ledgers.
Avoid Duplicate Payments:
SchoolBanks has a protection mechanism to prevent duplicate payments. If a receipt number or transaction ID already exists, the system will skip that payment.
How to enable online payments: 1. Login 2. Navigate to Admin / Settings 3. Click the Online Payment button 4. Then the page will navigate to Online Payment Processing view 5. Click the Connect with Stripe button 6. The Stripe connect page will open. ...
How to import teachers from a CSV file: 1. Login 2. Navigate to Admin / Data Sync 3. Click the Teachers (Import / Update) button 4. The file selector page will open 5. Select the file you wish to importNote: You can download the Teacher.csv sample ...
How to import assets from a CSV file: 1. Login 2. Navigate to Admin / Data Sync 3. Click the Assets (Import / Update) button 4. The file selector page will open 5. Select the file you wish to importNote: You can download the Assets.csv sample file ...
How to import sections from a CSV file: 1. Login 2. Navigate to Admin / Data Sync 3. Click the Sections (Import / Update) button 4. The file selector page will open 5. Select the file you wish to importNote: You can download the Section.csv sample ...
How to import fees from a CSV file: 1. Login 2. Navigate to Admin / Data Sync 3. Click the Fees (Import / Update) button 4. The file selector page will open 5. Select the file you wish to import Note: You can download the Fees.csv sample file ...