Accounting reports directory

What different types of reports mean

Aging Report

The Aging Report shows all families with unpaid invoices by date range (30, 60, 90, 90+ days).

You can specify a date (to show all unpaid invoices as of the specified date) and select whether

you want the report based on the paid date (when the parent paid the invoice) or transfer

date (when the payment settled in the school's bank account). If you have selected by transfer

date invoices will be considered in this report if they are paid, but have not settled in your bank

account. Use this report to see the total unpaid for each family, by the days past due.

Billed Report

The Billed Report shows all line items (both charges and credits) billed within a specified date

range grouped by accounting category. You can specify the date range of the report, which will

filter the included invoices by the invoice date. Use this report to see how much you billed for a

date range, and how much you billed for each account category (such as Tuition and Late Fees).

Deposit History Report

The Deposit History Report shows all deposits (payments) made within a specified date range,

grouped by payment type (cash, check, credit card, bank transfer, etc). You can specify a date

range for this report to see all that was paid between the two dates. Use this report to see all

payments by payment type, or to match your cash/check payments to the bank deposit. (To

match credit card and bank transfer payments to your bank statement, use the Settlement

Report).

Detailed Billing Report

The Detailed Billing Report shows what was billed by the accounting category and what was

paid by payment method within a specified date range. This report calculates a beginning and

ending balance (A/R) for the specified date range. The beginning balance is calculated

considering the unpaid invoices as of the "From" date minus unapplied credits as of the "From"

date (what is still owed to the school, or A/R, at the beginning of the month). The ending

balance is calculated as the beginning balance plus what was billed minus what was paid (what

is still owed to the school, or A/R, at the end of the month). You can specify a date range, as well

as if you want the payments displayed based on paid date or transfer date.

Use this report to see want to see the A/R at the beginning and end of the month.

*New: The Paid section of the Detailed Billing Report is now grouped by payment method rather

than family. Use the Paid Report by Family to see how much was paid by each family.

Monthly Invoice Audit

The Monthly Invoice Audit shows you all currently enrolled students, their current enrollment, and

the recurring invoice(s) they received for the specified month. This report allows you to audit the

invoices to ensure that all enrolled students received an invoice for the correct amount. Please

note that this report only shows recurring invoices (if you created an ad hoc invoice for the

student, it would not appear in this report), and the student's current enrollment.

Paid Report (Summary)

The Paid Report (Summary) shows the total paid to each chart of account category within a

selected date range. This report does not include details of individual invoices. You can select a

date range for the report, as well as whether the report is based on paid date or transfer date.

Use this report to see the total paid to each account category (i.e. tuition, extended care, etc).

Paid Report by Line Item

The Paid Report by Line Item shows all paid invoices within the selected date range by line

item grouped by the chart of account categories. This report shows the detail of the Paid Report

(Summary). You can select a date range for the report, as well as whether the report is based

on paid date or transfer date. Use this report to see the detail of what was paid to each account

category (i.e. tuition, extended care, etc).

Paid Report by Family

The Paid Report by Family shows all paid invoices within the selected date range grouped by

family. You can select the date range for this report. Use this report to see how much was paid by

each family. *Formerly the "Paid" section of the Detailed Billing report.

Proofing Report

The Proofing Report shows all line items on queued and saved temporarily invoices. Use this

report to audit all queued and saved temporarily invoices and see what will be sent on the

invoice send date.

QuickBooks Reconciler

The QuickBooks Reconciler provides a month’s summary of billed items (by accounting category)

and settled payments (by payment method, based on transfer date). You can select the date

range for this report. Use this report to see a month’s summary of what was billed and paid so

you can transfer the information to QuickBooks or other accounting software.

Raw Accounting Report

The Raw Accounting Report shows detail of all line items for all invoices (including canceled and

queued invoices) within a specified date range. This report includes line items from canceled

invoices. You can select the date range to filter the line items by the invoice date. Use this report

if you want to see all invoice detail for a specific date range.

Settlement Report

The Settlement Report shows online payments (credit card, bank transfer) within specified date

range by transfer date. This report displays the invoices included in each batch deposit. This

report is filtered by date range. Use this report to reconcile the deposits on your bank statement

to what Curacubby reports were received.

Unapplied Credits Report

The Unapplied Credits Report shows all families with unapplied credits as of a specified date.

Use this report to see a list of parents with unapplied credits.

Unpaid Report by Invoice

The Unpaid Report by Invoice shows all unpaid invoices as of a specified date. You can specify

a date (to show all unpaid invoices as of the specified date) and select whether you want the

report based on the paid date (when the parent paid the invoice) or transfer date (when the

payment settled in the school's bank account). If you have selected by transfer date invoices will

be considered in this report if they are paid, but have not settled in your bank account. Use this

report to see all unpaid invoices