Invoices¶
File: invoices_data.csv · Where: Admin Tasks → End-of-Year Reports → year →
Invoices
Every payment recorded against fees — cash, check, PayPal and card. One row per payment.
This is the file to reconcile a closed year against your bank or booster ledger.
What's in it¶
| Column | What it holds |
|---|---|
id |
The payment's ID. Fee Assignments points here with invoice_id |
payer_name, payer_id |
Who paid — usually the parent or student |
receiver_name, receiver_id |
The director or staff member who recorded it |
amount |
The amount received |
payment_method, method_id |
Cash, check, PayPal, card, and so on |
confirmation |
The check number or processor confirmation code |
date |
When the payment was recorded |
notes |
Anything typed into the payment's notes |
amount_fee_percentage, amount_fee_fixed |
The processing fee passed on to the payer, if your school passes fees on |
Reading it¶
Invoice numbers on statements have a 900 in front. A statement showing invoice 9001427
is row 1427 here.
payer_name can be blank. Names are recorded at the time of payment against the account
that made it; if that account was later deleted, the payment record survives but the name is
empty. Use payer_id against Account Data, which was exported before anyone
was removed.
Which fees a payment covered isn't in this file. One payment can settle several fees. Match
on Fee Assignments — every row whose invoice_id is this payment's id.
Processing fees are separate from amount. Where your school passes fees on to the payer,
amount is what was applied to the student's balance and the two fee columns are what the payer
paid on top.
Payments carried over from earlier years appear here too. The export copies every payment
record in myblueboard, not only those made during the closing year. Filter on date if you want
one year.