There are many reports associated with A/R activity. Most A/R reports include selection criteria to provide different views of the data so that you only print what is needed. For most A/R reports you can select date ranges, accounting periods, transaction types, specific guardians, etc.
Probably the most widely used SchoolLeader Report, the Guardian Account statement prints all A/R activity (charges, payments, credits) for the selected guardian or group of guardians for a selected accounting period range. The Guardian Account Statement is typically printed directly from the Student Folder or Guardian Folder Payment Account Tab. If you need to print more than one statement at a time, the following options are available from the Central Report Manager. You can print statements for:
ALL guardians. Statements will print for All Active Primary Guardians.
a SPECIFIC Guardian. If you need to print a statement for a guardian that is no longer ACTIVE, click on the SHOW ALL button, then select the guardian for whom you need a statement.
With Balance. ALL Active Primary Guardians who have an outstanding debit balance (they owe you money) as of today's date.
You can also select the accounting period range to further increase the detail displayed in the report.
The Bank Register Report displays activity for one bank account or ALL bank accounts for the selected date range
The Batch Deposit Ticket documents and itemizes all the check payments included in a specific Deposit Batch. The report is useful for reconciling your payments received prior to bringing them to the bank. Also, this report can be used as a replacement for your bank's itemized deposit ticket. This will save a significant amount of time from writing out the ticket by hand.
By design, this report only itemizes check detail. Some schools choose not to deposit all of their Cash receipts. This report allows you to 'write in' the cash amount, but the cash amount is not calculated for you.
The Batch Deposit Statement lists ALL items in a deposit batch, including cash and checks. A separate page is displayed for cash details, check details, and totals of all deposits.
The Batch Deposit Summary displays all of your bank deposits for a selected date range. This report prints one line per deposit batch and is typically used for reconciling your deposits against a monthly bank statement.
The A/R Period Summary Report displays the charges, credit and payments for each active primary guardian for the selected accounting period. One line is printed per guardian, so the report gives a quick overview of your accounting period.
The Outstanding A/R Payment Accounts Report is also known as the A/R Aging Report. When you run this report, you will receive a list of guardians who still have an outstanding balance, as well as how old that balance is. You can run this report for:
active families
inactive families
The aging portion of the report shows balances by the following breakdown:
less than 7 days
8 - 15 days
16 - 30 days
31 - 60 days
greater than 60 days
This report is often used to determine which accounts are considered delinquent and may be turned over to collections.
The Balance Summary By Period Report displays a one line summary for each selected period that includes the:
opening balance
payments
charges and credits
ending balance
The Balance Summary by Subaccount Report displays a summary by each A/R subaccount for each selected period that includes the:
opening balance
payments
charges and credits
ending balance
The Balance Summary By Group & Guardian has 2 further views:
by date range
by period
Based on which report you choose to run, the results will be displayed by either the selected date range or period. This report takes advantage of the 'Family Groups' that you defined while setting up your Family related functions. By assigning primary guardians into Family Groups, you can determine how much revenue is being produced by each group.
This powerful report allows you to review A/R transaction detail for each subaccount. There are many combinations for this report and different results will be displayed based on your selection criteria:
select ALL subaccounts or a specific subaccount
include ALL primary guardians, or those with a debit balance (they owe you money), a credit balance (you owe them money), or a specific guardian
include Accounting Periods (can be one accounting period or multiple accounting periods)
include Activity Types ALL, or Transactions, or Payments. When you select Transactions, you are further prompted to select ALL transaction types, or charges, credits, and/or system transfers. For accrual based accounting, you would need to check off Activity Type of Transactions, then also check off Charges and Credits.
This report allows you to review A/R transaction detail by Activity Date. There are many combinations for this report and different results will be displayed based on your selection criteria:
select ALL subaccounts or a specific subaccount
include ALL primary guardians, or those with a debit balance (they owe you money), a credit balance (you owe them money), or a specific guardian
include Accounting Periods (can be one accounting period or multiple accounting periods)
include Activity Types ALL, or Transactions, or Payments. When you select Transactions, you are further prompted to select ALL transaction types, or charges, credits, and/or system transfers. For accrual based accounting, you would need to check off Activity Type of Transactions, then also check off Charges and Credits.
This report allows you to review A/R transaction detail by Primary Guardian. There are many combinations for this report and different results will be displayed based on your selection criteria:
select ALL subaccounts or a specific subaccount
include ALL primary guardians, or those with a debit balance (they owe you money), a credit balance (you owe them money), or a specific guardian
include Accounting Periods (can be one accounting period or multiple accounting periods)
include Activity Types ALL, or Transactions, or Payments. When you select Transactions, you are further prompted to select ALL transaction types, or charges, credits, and/or system transfers. For accrual based accounting, you would need to check off Activity Type of Transactions, then also check off Charges and Credits.
This powerful report allows you to review A/R transactions summarized for each subaccount. The results display debits, credits and balances for each A/R subaccount. There are many combinations for this report and different results will be displayed based on your selection criteria:
select ALL subaccounts or a specific subaccount
include ALL primary guardians, or those with a debit balance (they owe you money), a credit balance (you owe them money), or a specific guardian
include Accounting Periods (can be one accounting period or multiple accounting periods)
include Activity Types ALL, or Transactions, or Payments. When you select Transactions, you are further prompted to select ALL transaction types, or charges, credits, and/or system transfers. For accrual based accounting, you would need to check off Activity Type of Transactions, then also check off Charges and Credits.
This powerful report allows you to review A/R transactions summarized for each Primary Guardian. The results display debits, credits and balances for each Primary Guardian. There are many combinations for this report and different results will be displayed based on your selection criteria:
select ALL subaccounts or a specific subaccount
include ALL primary guardians, or those with a debit balance (they owe you money), a credit balance (you owe them money), or a specific guardian
include Accounting Periods (can be one accounting period or multiple accounting periods)
include Activity Types ALL, or Transactions, or Payments. When you select Transactions, you are further prompted to select ALL transaction types, or charges, credits, and/or system transfers. For accrual based accounting, you would need to check off Activity Type of Transactions, then also check off Charges and Credits.
The Payment Journal by Transaction ID Report will display a chronological list of payments for the selected date range. SchoolLeader assigns a transaction id to every payment, and this report will display the payments in transaction order.
The Payment Journal by Transaction ID Report will display a chronological list of payments by guardian for the selected date range.
This Guardian Payment History Statement is typically given to parents for IRS tax purpose at the end of the year. SchoolLeader is tracking all payments, and at the end of the year, you can print out each Guardians' Payment History Statement. The Statement displays a line item showing the total number of payments made, including the dollar amount paid. Your federal tax ID number is also printed on the statement.
This Guardian Payment History Details is typically given to parents for IRS tax purpose at the end of the year. SchoolLeader is tracking all payments, and at the end of the year, you can print out each Guardians' Payment History Statement. The report displays the payment history by guardian for the selected date range. Your federal tax ID number is also printed on the statement.
This Payment Allocations Details Report by Accounting Period/Subaccount allows you to view how each payment was allocated to each subaccount for the selected accounting periods. This report is particularly useful for those schools who need to pay royalties on certain types of income, such as Tuition.
This Payment Allocations Details Report by Deposit Batch/Subaccount allows you to view how your deposit batch was allocated for each A/R subaccount for the selected accounting periods.
This Payment Allocations Summary Report by Accounting Period/Subaccount allows you to view on a summarized level how the payments were allocated to each subaccount for the selected accounting periods. This report is particularly useful for those schools who need to pay royalties on certain types of income, such as Tuition.
This Payment Allocations Summary Report by Deposit Batch/Subaccount allows you to view on a summarized level how your deposit batch was allocated for each A/R subaccount for the selected accounting periods
The Recurring Fee Schedule Billing Details Report is also referred to as the Revenue Potential Report. This report simulates the Posting of Recurring Fees, without actually committing the charges to your database. This report serves three purposes:
to determine the recurring charges that will be posted to all primary guardian accounts when you run the Recurring Fee Schedule Charges process.
to determine the recurring charges that were posted to all primary guardian accounts when you ran the Recurring Fee Schedule Charges process. Once the Recurring Fee Process has completed, you will be prompted to print this report.
to perform 'what if' analysis with your recurring fee schedule table. By changing fees in the fee table, SchoolLeader will automatically update all students/guardians associated with those fees. The Recurring Fee Schedule Billing Details Report simulates posting of recurring charges (without actually committing the charges to your database) so that you can understand the revenue impact to a change in recurring fees.
The report is presented in different views based on you particular needs. Regardless of which report you select, you will be prompted for the billing cycle number for which you want to simulate charges. The Reports will display recurring charges/discounts based on your selection criteria.
The charges and credits displayed in these reports are a result of the recurring fees and discounts that are in your A/R Recurring Fee Schedule table.
This report view displays your recurring charges for each A/R subaccount.
This report view displays your recurring charges for each classroom. This is particularly useful if you need to determine how much revenue is being brought in by each classroom.
This report view displays your recurring charges for each Primary Guardian. This report is typically created once you have completed your initial data entry into SchoolLeader. By running this report, you can see the exact charges and credits that will be posted to each guardian's account should you choose to run the Recurring Charge Process.
This report view displays a summarized total of your recurring charges for each A/R subaccount.
This report view displays a summarized total of your recurring charges for each classroom. This is particularly useful if you need to determine how much revenue is being brought in by each classroom.
This report view displays a summarized total of your recurring charges for each Primary Guardian. This report is typically created once you have completed your initial data entry into SchoolLeader. By running this report, you can see the exact charges and credits that will be posted to each guardian's account should you choose to run the Recurring Charge Process. Some schools also choose to run this report with details instead of summarized.
This report displays all write offs of outstanding balances you performed for the selected accounting periods. The report is sorted by Primary Guardian.
This report displays all write offs of outstanding balances you performed for the selected accounting periods. The report is sorted by Accounting Period.
This report lists all primary guardians who have Security Deposits or Escrow Balances.