Welcome to the Invoices Tabβyour centralized hub for managing issued invoices! This powerful tool allows you to view, track, and manage invoices for all enrolled children, ensuring clarity and control over your organizationβs billing processes. From filtering by status to accessing detailed invoice records, the Invoices Tab is designed to streamline your financial workflows and simplify reporting.π³π
π Availability
The Invoices Tab is accessible on both the portal and the app.
πΉ The portal will be used as the default reference throughout this guide.
πΉ Any differences between the portal and the app will be specifically illustrated where applicable.
π Table of Contents
Learn how to navigate to the Invoices Tab from both the Portal and the App for easy access to billing transactions.
How to Access on the Portal β Step-by-step guide to accessing invoices from the Parentβ’ Portal.
How to Access the Invoices Tab (App) β Instructions for finding the Invoices Tab in the Parentβ’ App.
Access to invoice transactions is based on user roles and assigned permissions, ensuring secure and controlled access to financial records.
Understand the structure of the Invoices Tab, including the key columns and data points displayed.
Read Columns in the Invoices List (On the Portal) β Breakdown of all invoice columns and their purpose.
βHow to View Invoice Details on the App β Guide to accessing invoice details on the Parentβ’ App.
Learn how the Total Statement provides a financial snapshot, summarizing all invoices within a selected date range.
Components of the Total Statement β Explanation of key financial metrics such as gross amount, due amount, and discounts.
Discover the filtering options available to help you quickly locate and manage invoices.
Search Bar β Find invoices quickly by entering a child or payerβs name.
βPredefined Filters β Use one-click filter options like "Paid," "Overdue," or "Outstanding" to narrow results.
βUsing the Filter Tool with the Purple Funnel Icon β Learn how to apply multiple filters simultaneously for precise searches.
Step-by-step instructions for downloading invoice reports in Excel or CSV format for further analysis.
How to Download the Invoice Report β Instructions for exporting reports in different formats.
Available Formats for Download β Learn the difference between CSV and Excel formats and their use cases.
Key Invoice Data Points & Their Purpose β A breakdown of all the financial data included in the invoice report.
Download Aging Report β Track overdue invoices categorized by the time they have been outstanding.
Information in the Aging Report β Details on how the report categorizes unpaid invoices (e.g., 1β30 days overdue, 31β60 days, etc.).
How to Access the Invoices Tab
π How to access on the Portal:
1οΈβ£ Go to the Menu: Open the menu on the far-left side of your screen.
2οΈβ£ Select Finance: Click on the Finance Tab from the list of menu options.
3οΈβ£ Locate Billing Transactions: In the right section under the Finance category, select Billing Transactions.
4οΈβ£ Open the Invoices Tab: Within the Billing Transactions section, click on the Invoices Tab to view, track, and manage all issued invoices.
π How to Access the Invoices Tab (App)
Follow these simple steps to navigate to the Invoices Tab on the Parentβ’ App:
1οΈβ£ Go to the App Footer: At the bottom of the screen, locate the navigation bar.
2οΈβ£ Select the Options Tab: Tap the first tab on the right to open the Options Menu.
3οΈβ£ Click on Billing Transactions: In the menu, select Billing Transactions to access financial records.
4οΈβ£ Open the Invoices Tab: The first tab in the Billing Transactions section is Invoicesβtap to view, track, and manage all issued invoices.
π Who Can Access Invoice Transactions?
Access to invoice transactions is determined by user roles and permissions, ensuring that only authorized individuals can view, manage, and download invoices.
π Owner (Full Access)
βοΈ Access Level: Full access to view and download all issued invoices across all locations.
βοΈ Permissions: Can manage billing transactions, settings, and reporting across the entire organization.
π’ Location Admin
βοΈ Access Level: Can view and download all issued invoices within their assigned locations.
βοΈ Permissions: Can manage billing only for their specific location(s) but not across multiple centers unless assigned.
π©βπΌ Authorized Staff (With Invoice Permissions)
βοΈ Access Level: Staff members who have been granted permission to either view or manage invoices.
βοΈ Permissions:
Can access and download all invoices issued at their assigned locations.
π‘ Pro Tip: Assign permissions carefully to ensure that only necessary staff members have access to financial records and invoice downloads! β ππ°
Invoices Tab Layout: A Complete Overview
The Invoices Tab is a centralized location where you can view and manage all generated invoices. It provides detailed information about each invoice, helping you track transactions, monitor payments, and ensure billing accuracy. The data is presented in a table format, with the following key columns:
π Columns in the Invoices List & Their Definitions (On the Portal)
The Invoices List contains key columns that provide essential details about each invoice. Below is a breakdown of each column, its definition, and its purpose.
π Date
π Definition: Displays the date the invoice was sent.
π― Purpose: Helps track when the invoice was issued to the payer for better financial record-keeping.
π’ Trans. Ref. (Transaction Reference)
π Definition: The unique invoice number or transaction reference assigned to the invoice.
π― Purpose: Useful for identifying and cross-referencing invoices during reviews or payer inquiries.
π§ Child
π Definition: Shows the child associated with the transaction, along with the payer responsible for that specific invoice.
π Key Insight: A child may have multiple invoices linked to different payers (e.g., separate billing for parents or guardians).
π Due Date & Service Period
π Definition: Displays the invoiceβs due date and the service period covered by the invoice.
π― Purpose: Ensures clarity about when the payment is due and what timeframe the invoice covers.
π Status
π Definition: Indicates the current state of the invoice.
π Examples:
β Paid β Payment has been successfully completed.
β³ Pending β Payment is still outstanding.
β Past due β Payment is past the due date and remains unpaid.
π― Purpose: Helps track invoice progress and follow up on overdue payments.
π° Discounts
π Definition: Shows the total amount of discounts applied to the specific invoice.
π― Purpose: Helps track fee reductions due to promotions, sibling discounts, or special offers.
ποΈ Subsidies
π Definition: Displays the amount of subsidies applied to the transaction.
π Key Insight: Indicates financial assistance provided for the childβs invoice (e.g., government funding, financial aid).
π΅ Gross
π Definition: The total amount of the invoice before any discounts or subsidies are applied.
π― Purpose: Reflects the full price of the billed services, providing clarity on the original amount.
π Total Along with Invoice Due
π Definition: Displays the final amount due after applying discounts and subsidies, along with the invoice due amount. If the invoice has been fully or partially paid, this column will reflect the remaining balance still owed.
π― Purpose:
βοΈ Provides a clear view of outstanding payments, helping payers and administrators track financial obligations.
βοΈ Ensures transparency in final charges after all adjustments (e.g., discounts, subsidies, partial payments).
βοΈ Helps monitor fully paid vs. partially paid invoices, making it easier to follow up on pending balances.
π How to View Invoice Details on the App
Follow these steps to access detailed invoice information on the Parentβ’ App:
1οΈβ£ Go to Billing Transactions: Open the app and navigate to the Billing Transactions section.
2οΈβ£ Select the Invoices Tab: Locate the invoice you want to review.
3οΈβ£ Click the Expand Arrow: Tap the expand arrow next to the invoice number and amount to reveal more details.
π Details Displayed on the App:
βοΈ Child β The name of the child linked to the invoice.
βοΈ Payer β The person responsible for the payment.
βοΈ Due Date β The deadline for payment submission.
βοΈ Invoice Period β The service period covered by the invoice.
βοΈ Status β Indicates if the invoice is Paid, Pending, or Overdue.
βοΈ Notes β Any additional comments or important information related to the invoice.
π« Not Visible on the App:
Discounts and Subsidies
Gross Amount
πΉ Important Note: The app only reports the final invoice cost after all adjustments, so discounts and subsidies are not displayed separately.
π‘ Pro Tip: Use the portal version if you need a full breakdown, including discounts, subsidies, and gross amounts! β π
π Key Takeaways
β Centralized Billing Management β The Invoices Tab offers a comprehensive view of all billing transactions in one place, streamlining financial oversight.
β Clear & Accurate Invoice Details β Each column provides essential invoice information, ensuring clarity, accuracy, and easy tracking of issued invoices.
β Efficient Financial Monitoring β With status tracking, discounts, and subsidies, the Invoices Tab is a powerful tool for managing payments, monitoring dues, and maintaining organized financial records.
π‘ Pro Tip: Use filters and sorting options to quickly find invoices, track overdue payments, and simplify financial reporting! πβ
πTotal Statement Overview in the Invoices Tab (Portal)
Above the list of invoices in the Invoices Tab, a Total Statement is displayed, summarizing key financial metrics for all invoices within the selected date range or filters.
π What the Statements Provide:
β
A comprehensive snapshot of billing performance.
β
Helps administrators track financial trends and analyze payment activity.
β
Ensures clarity on total billed amounts, outstanding balances, and payments received.
π‘ Pro Tip: Use filters to adjust the date range or invoice status for a more detailed view of financial trends and payment tracking! πβ
π Note:
πΉ Total Statements are not yet available on the app, except for the Total Invoice Net Amount, which reflects the final payable amount after adjustments.
π Components of the Total Statement
The Total Statement provides a breakdown of key financial metrics, giving administrators a clear view of invoice dues, revenues, discounts, and outstanding balances
1οΈβ£ Discount Amount
π Definition:
The total amount of discounts applied across all invoices within the selected date range or period.
π― Purpose:
βοΈ Highlights cumulative reductions offered through promotions, sibling discounts, or special fee adjustments.
βοΈ Helps administrators track financial incentives provided to payers.
π Example:
If three invoices in the selected period each have a $50 discount, the Discount Amount will display $150.
π‘ Pro Tip: Regularly reviewing discount totals helps assess the impact of promotions and financial aid on overall billing performance! β
2οΈβ£ Subsidy Amount
π Definition:
The total value of subsidies applied to invoices within the selected date range.
π― Purpose:
βοΈ Tracks financial assistance provided to payers, such as government funding, scholarships, or organizational support.
βοΈ Helps administrators monitor the impact of subsidies on overall billing.
π Example:
If subsidies of $200, $300, and $150 are applied to three invoices, the Subsidy Amount will display $650.
π‘ Pro Tip: Reviewing subsidy totals helps evaluate funding distribution and ensures accurate financial reporting! β π°
3οΈβ£ Gross Amount
π Definition:
The total value of all invoices before any discounts or subsidies are applied.
π― Purpose:
βοΈ Reflects the full chargeable amount for services provided.
βοΈ Provides a baseline view of potential income before any reductions.
π Example:
If three invoices total $1,000 each, the Gross Amount will display $3,000.
4οΈβ£ Total Amount
π Definition:
The net value of all invoices after applying discounts and subsidies.
π― Purpose:
βοΈ Represents the actual income expected from issued invoices.
βοΈ Helps administrators track adjusted revenue after financial aid and discounts.
π Example:
If the Gross Amount is $3,000, with $200 in discounts and $300 in subsidies, the Total Amount will display $2,500.
5οΈβ£ Total Due
π Definition:
The total amount still outstanding, including partially paid, unpaid, and overdue invoices.
π― Purpose:
βοΈ Tracks the total receivables owed, helping administrators identify pending and overdue payments.
βοΈ Helps ensure timely follow-ups with payers.
π Example:
If three invoices are partially or fully unpaid, with outstanding amounts of $300, $400, and $500, the Total Due will display $1,200.
π Purpose of the Total Statement
β Summarizes Financial Metrics
Provides a quick overview of financial performance for the selected date range or filters.
β Aids in Decision-Making
Helps identify trends, such as high discount usage or increasing overdue payments.
β Supports Follow-Ups
The Total Due metric highlights overdue invoices, enabling targeted communication with payers.
π Key Takeaways
βοΈ The Total Statement offers a high-level view of the financial state of your billing transactions.
βοΈ By tracking Discount Amount, Subsidy Amount, and Total Due, administrators can manage cash flow and optimize billing efficiency.
βοΈ Use this section to monitor trends and ensure timely payments for a smooth financial workflow.
π‘ Pro Tip: Regularly reviewing the Total Statement helps keep financial records organized and supports proactive payment collection! β π
Smart Filtering Tools for Efficient Invoice Management
The Invoices Tab provides powerful filtering tools to help you locate and manage specific invoices quickly. You can use the search bar or the predefined filters, which can be applied individually or in groups, to narrow down your results effectively.
1οΈβ£ Search Bar
π Definition:
The Search Bar enables you to quickly find a specific child or payer by name.
π― Purpose:
βοΈ Saves time by locating invoices instantly without scrolling through the full list.
βοΈ Helps in retrieving financial records tied to a specific payer or child.
π Example:
Searching for "Sophia Johnson" will display all invoices linked to her profile, making it easier to review her billing history.
π‘ Pro Tip: Use partial names if unsure of the full spellingβfor example, typing "Sophia J" will bring up all matches related to that name! πβ
π Note:
On the app, the search bar is integrated within the purple filter funnel icon, located at the top-right corner of the Invoices List.
π‘ Pro Tip: Tap the purple funnel icon to access both search and filter options for quickly finding specific invoices on the go! ππ²β
2οΈβ£ Predefined Filters (On both the App and Portal)
The filters appear as clickable blocks at the top of the Invoices List, allowing users to quickly sort and manage invoices based on specific categories. These filters help streamline billing oversight, payment tracking, and follow-ups.
π Filter Options & Use Cases
β
Paid
π Definition: Displays all invoices that have been fully paid
π― Use Case: Check payment completion for reconciliation or financial reporting.
β
Partially Paid
π Definition: Shows invoices where only a portion of the total amount has been paid.
π― Use Case: Identify invoices that require follow-up to collect the remaining balance.
β
Outstanding
π Definition: Lists all invoices with any balance still unpaid, but there is still time until they are due.
π― Use Case:
βοΈ Track invoices that require further action to ensure payment is completed.
βοΈ Identify unpaid balances early to follow up before they become overdue.
β
Due
π Definition: Displays invoices with amounts currently due but not yet overdue.
π― Use Case: Proactively manage payments before they become overdue.
β
Past Due
π Definition: Shows invoices that are overdue and require immediate attention.
π― Use Case: Prioritize collection efforts for overdue payments.
β
Cancelled
π Definition: Lists all invoices that have been canceled.
π― Use Case: Track canceled transactions for audit purposes or adjustments.
β
Payment in Processing
π Definition: Displays invoices where payments are currently being processed but not yet completed.
π― Use Case: Monitor payment statuses to ensure timely completion.
π How to Use Filters
β Select Filters Individually or Combine Them
Click on one or multiple filter blocks to refine the displayed invoices.
π Example: Combine Partially Paid and Outstanding to view all invoices with unpaid balances.
β Dynamic Filtering
Filters update the invoice list in real-time, allowing users to analyze data quickly without reloading the page.
π‘ Pro Tip: Use filters strategically to focus on unpaid invoices, track overdue payments, and streamline reconciliation efforts! ππβ
π Using the Filter Tool with the Purple Funnel Icon ( Portal and App)
The purple funnel icon in the Invoices Tab allows you to apply multiple filters simultaneously, ensuring that only invoices matching all selected criteria appear in the results.
π Why Use It?
β
Helps narrow down invoices based on specific conditions.
β
Ideal for advanced filtering, such as finding invoices that are both past due and partially paid.
β
Saves time by allowing precise searches instead of manually scanning through large lists.
π‘ Pro Tip: Use the purple funnel filter when you need to apply multiple conditions at once for a more refined and efficient search! πβ
π Available Fields for Filtering
The filter tool allows you to refine search results based on specific invoice details, making it easier to track, review, and manage financial records. Below are the available filtering options:
π Note:
On the app, Subsidy and Discount filters are not yet supported. To filter invoices based on subsidies or discounts, please use the portal version for full functionality.
π‘ Pro Tip: Use the portalβs advanced filtering options for a more detailed financial overview and reporting! β π
πΆ Children Status
π Options:
Current β Invoices for children actively enrolled.
Withdrawn β Invoices for children who have been withdrawn from the center.
Upcoming β Invoices for children scheduled to start in the future.
π Invoice Date
π Definition: Allows you to filter invoices by the exact date they were generated.
π― Purpose: Helps track and retrieve invoices based on when they were issued for financial review.
π Invoice Period
π Definition: Specifies the service period covered by the invoices (e.g., January 1β15, 2023).
π― Purpose: Useful for reviewing invoices tied to a particular billing cycle or program period.
π« Room
π Definition: Filters invoices based on the room or classroom associated with the child.
π― Purpose: Enables tracking invoices specific to a certain classroom, helping with budgeting or group-based financial analysis.
ποΈ Subsidy Name
π Definition: Allows filtering invoices by the specific subsidy program applied.
π― Purpose:
βοΈ Easily track and manage invoices tied to financial aid or support programs (e.g., government subsidies, grants).
βοΈ Helps administrators monitor funding usage across different subsidy programs.
π Example: Select "Government Childcare Subsidy" to view all invoices where this subsidy was applied.
π° Discount Type
π Definition: Enables filtering invoices by the specific discount applied.
π― Purpose:
βοΈ Helps identify invoices benefiting from specific discounts (e.g., sibling discount, promotional offers).
βοΈ Useful for analyzing the impact of discounts on revenue.
π Example: Select "Sibling Discount" to see all invoices where this discount was used.
π² QR Reference
π Definition: The QR Reference for invoices allows users to quickly locate specific invoices using the unique QR reference code generated for each invoice transaction. This feature is particularly useful in Switzerland and Europe, where invoices often include structured QR payment references for automated processing.
π― Purpose:
βοΈ Allows quick retrieval of invoices using the unique QR reference code.
βοΈ Helps in verifying and tracking invoices associated with QR-based transactions.
π Example: Enter the QR reference code to find the corresponding invoice instantly.
β οΈ Note: This option is only visible to users residing in Switzerland or Europe.
π Example: Applying All Filters Together
π Example: Applying All Filters Together
π Scenario
You want to find invoices for:
βοΈ Current children actively enrolled.
βοΈ Invoices generated on February 10, 2023.
βοΈ Covering the service period of February 1β15, 2023.
βοΈ For children assigned to the Sunshine Room.
π Steps to Apply Filters
1οΈβ£ Access the Purple Funnel Tool:
Click on the purple funnel icon at the top of the Invoices Tab.
2οΈβ£ Select Filters:
Children Status β Choose Current.
Invoice Date β Enter February 10, 2023.
Invoice Period β Select February 1β15, 2023.
Room β Choose Sunshine Room.
3οΈβ£ View Results:
The system retrieves only those invoices that meet all selected criteria simultaneously.
π Result
The list will display only invoices that match all the conditions, meaning:
βοΈ They belong to current children.
βοΈ They were generated on February 10, 2023.
βοΈ They cover the service period of February 1β15, 2023.
βοΈ They are for children in the Sunshine Room.
π Example 2: Applying Multiple Filters Together
π Example 2: Applying Multiple Filters Together
π Scenario
You want to find invoices for:
βοΈ Current children actively enrolled.
βοΈ Invoices generated on March 5, 2023.
βοΈ Covering the service period of March 1β15, 2023.
βοΈ Assigned to the Rainbow Room.
βοΈ With the Sibling Discount applied.
βοΈ Including the Government Childcare Subsidy.
π Steps to Apply Filters
1οΈβ£ Access the Purple Funnel Tool:
Click on the purple funnel icon at the top of the Invoices Tab.
2οΈβ£ Select Filters:
Children Status β Choose Current.
Invoice Date β Enter March 5, 2023.
Invoice Period β Select March 1β15, 2023.
Room β Choose Rainbow Room.
Discount Name β Select Sibling Discount.
Subsidy Name β Choose Government Childcare Subsidy.
3οΈβ£ View Results:
The system retrieves only invoices that meet all selected criteria simultaneously.
π Result
The list will display invoices that meet all the conditions, meaning:
βοΈ They belong to current children.
βοΈ They were generated on March 5, 2023.
βοΈ They cover the service period of March 1β15, 2023.
βοΈ They are assigned to the Rainbow Room.
βοΈ They have the Sibling Discount applied.
βοΈ They include the Government Childcare Subsidy.
π₯ Downloading and Reading the Invoice Report (App and Portal)
The Invoice Report can be downloaded in two formats: CSV and Excel. Each format is useful depending on how you plan to view, analyze, or work with the data.
π How to Download the Invoice Report
1οΈβ£ Navigate to the Invoices Tab
Go to the Invoices Tab within the Billing Transactions section.
2οΈβ£ Click the Download Button
π On the Portal:
Click the Orange Download Button located at the top-right corner of the Invoices Tab.
π On the App:
Tap the Purple Down Arrow π© to initiate the download.
3οΈβ£ Select a Format and Report Type
Choose your preferred format:
β CSV β Best for raw data exports and compatibility with various systems.
β Excel β Ideal for structured data analysis with built-in formatting and formulas.
π Note: The report can also be downloaded directly from the Report Center. A link to access the Report Center is provided at the end of this article for convenience. β π
π Available Formats for Download
When downloading the Invoice Report, you can choose between CSV (Comma-Separated Values) and Excel (XLSX), each offering unique advantages depending on how you intend to use the data.
π CSV (Comma-Separated Values)
π Definition:
A plain text file where data is separated by commas for easy readability and system compatibility.
π― Advantages:
βοΈ Simplicity β Easily opened with text editors, spreadsheet software, and database tools.
βοΈ Compatibility β Works across multiple platforms, including third-party financial systems.
βοΈ Lightweight β Smaller file size makes it ideal for sharing or importing into other applications.
π Use Case:
Best for integrating data into other platforms or performing basic analysis with tools like Google Sheets or system imports.
π Excel (XLSX)
π Definition:
A file format used by Microsoft Excel and other spreadsheet software, supporting advanced data manipulation, formatting, and visualization.
π― Advantages:
βοΈ Advanced Analysis β Use built-in functions, pivot tables, and visualization tools for in-depth insights.
βοΈ Formatting Options β Customize data with color codes, conditional formatting, and formulas.
βοΈ User-Friendly β Easier for those familiar with spreadsheet tools to navigate and analyze data.
π Use Case:
Best for in-depth analysis, data visualization, and financial reporting, especially when preparing reports for presentation or internal reviews.
π‘ Pro Tip:
Choose CSV for system integrations and quick data exports.
Use Excel when you need to analyze, format, or visualize invoice data effectively! β π
π Important Note
The data included in your downloaded report reflects only the invoices specified by your applied filters, not all invoices by default.
β
Before Downloading:
βοΈ Review and adjust filters to ensure the report includes the desired invoices.
βοΈ If no filters are applied, the report may contain only a limited selection rather than the full invoice list.
π‘ Pro Tip: Always double-check your filter settings before downloading to avoid missing important financial data! ππβ
π Key Invoice Data Points & Their Purpose
Each invoice contains essential details that help track billing, payments, and financial records efficiently. Below is a breakdown of key invoice data points and their importance in the report.
π General Invoice Information
1οΈβ£ Location Name
π Definition: The name of the center or branch where the child is enrolled.
π― Purpose: Identifies which location issued the invoice, making it easier to track and report transactions.
2οΈβ£ Invoice Date
π Definition: The date the invoice was generated.
π― Purpose: Helps determine when the invoice was issued to the payer for accurate payment tracking.
3οΈβ£ Invoice Number
π Definition: A unique identifier assigned to each invoice.
π― Purpose: Essential for tracking, referencing, and resolving payment inquiries.
4οΈβ£ Payer Email/Mobile
π Definition: The contact details of the payer.
π― Purpose: Ensures billing communications reach the correct recipient for follow-ups or reminders.
π Child & Enrollment Information
5οΈβ£ Child Name
π Definition: The name of the child associated with the invoice.
π― Purpose: Links the invoice to the child's services, ensuring billing accuracy.
6οΈβ£ Child Birthday
π Definition: The child's date of birth.
π― Purpose: Provides age context, which may influence fee structures, eligibility, or subsidy qualifications.
7οΈβ£ Child Start Date
π Definition: The enrollment start date of the child.
π― Purpose: Ensures the invoice aligns with the childβs service period and enrollment history.
8οΈβ£ Room
π Definition: The classroom or group the child is assigned to.
π― Purpose: Links billing details to a specific room, helping track service allocation.
9οΈβ£ Payer Name
π Definition: The name of the individual responsible for payment.
π― Purpose: Identifies who is financially accountable for the invoice.
π Invoice Timeline & Payment Tracking
π Invoice Due Date
π Definition: The deadline for invoice payment.
π― Purpose: Helps manage timely payments and avoid overdue balances.
1οΈβ£1οΈβ£ Invoice Start Date
π Definition: The first day of the billing period covered by the invoice.
π― Purpose: Ensures clarity on when the invoiced services began.
1οΈβ£2οΈβ£ Invoice End Date
π Definition: The last day of the billing period covered by the invoice.
π― Purpose: Specifies the total duration of services billed.
1οΈβ£3οΈβ£ Invoice Status
π Definition: Indicates the current payment status of the invoice.
π Examples:
βοΈ Paid β Invoice has been fully settled.
β³ Pending β Payment has not yet been made.
β Overdue β Payment is past the due date.
π― Purpose: Helps administrators track unpaid balances and completed payments for financial planning.
π Financial Summary & Charges
1οΈβ£4οΈβ£ Gross Amount
π Definition: The total invoice amount before any adjustments (discounts, subsidies, or taxes).
π― Purpose: Shows the full cost of services before any reductions.
1οΈβ£5οΈβ£ Due Amount
π Definition: The remaining balance after applying payments, discounts, and subsidies.
π― Purpose: Tracks what is still owed on the invoice.
1οΈβ£6οΈβ£ Charged Products and Services
π Definition: The specific services or products billed in the invoice (e.g., tuition, activities, meal plans).
π― Purpose: Provides transparency into what the payer is being charged for.
1οΈβ£7οΈβ£ Subsidy Contribution
π Definition: The subsidy applied to the invoice and its source (e.g., government funding, grants).
π― Purpose: Helps track financial assistance provided to the payer.
π Adjustments & Final Amount
1οΈβ£8οΈβ£ Discounts, Taxes, and Parent Amount
π Definition:
βοΈ Discounts β Any reductions applied to the invoice.
βοΈ Taxes β Any applicable tax amounts added to the invoice.
βοΈ Parent Amount β The final amount the parent is responsible for paying.
π― Purpose: Summarizes financial adjustments to provide a clear picture of the final cost.
1οΈβ£9οΈβ£ Net Amount
π Definition:
The Gross Amount minus discounts and subsidies, with taxes included in the final calculation.
π― Purpose: Represents the final adjusted invoice total after all deductions and adjustments.
π₯ Aging Report Download Option
The Aging Report is a financial tracking tool that provides a detailed breakdown of outstanding invoices, categorized by how long they have been due. This report helps you monitor overdue payments, prioritize collections, and maintain financial stability.
π Definition
The Aging Report tracks unpaid invoices by aging periods (e.g., 0β30 days, 31β60 days, etc.), helping you identify overdue payments and take appropriate action.
π Format
β Excel (XLSX):
The Aging Report is always downloaded in Excel format.
Allows for advanced sorting, filtering, and data analysis to streamline collections.
π― Purpose
π Track Outstanding Payments
βοΈ Identify unpaid invoices and categorize them by aging periods (0β30 days, 31β60 days, 61+ days, etc.).
π Focus Collection Efforts
βοΈ Highlight invoices that need immediate follow-up to ensure timely payments.
π Monitor Financial Health
βοΈ Assess the status of receivables to maintain a steady cash flow and prevent excessive overdue balances.
π Information in the Aging Report
The Aging Report provides a detailed breakdown of outstanding invoices, categorizing them based on how long they have been unpaid. This helps administrators track overdue payments, prioritize collections, and maintain financial stability.
π Key Data Points in the Aging Report
π General Invoice Details
1οΈβ£ Child Name
π Definition: Displays the name of the child associated with the invoice.
π― Purpose: Links the outstanding invoice to the child receiving the services.
2οΈβ£ Invoice Number
π Definition: A unique identifier assigned to each invoice.
π― Purpose: Helps with tracking and referencing specific invoices.
3οΈβ£ Invoice Date
π Definition: The date the invoice was generated.
π― Purpose: Indicates when the invoice was issued to the payer.
4οΈβ£ Room Name
π Definition: The classroom or group the child is assigned to.
π― Purpose: Identifies which room or program the billed services belong to.
5οΈβ£ Payer Name
π Definition: The name of the individual responsible for payment.
π― Purpose: Links the invoice to the payer for follow-ups and collections.
6οΈβ£ Payer Current Balance
π Definition: Displays the total outstanding balance for the payer, including all invoices linked to their account.
π― Purpose: Provides a snapshot of the total amount owed by the payer.
π Payment Status & Aging Details
7οΈβ£ Invoice Due Date
π Definition: The payment deadline for the invoice.
π― Purpose: Indicates when the invoice should be paid to avoid it becoming overdue.
8οΈβ£ Invoice Status
π Definition: Displays the current state of the invoice, such as Paid, Overdue, or Processing.
π― Purpose: Helps track payment progress and identify overdue invoices.
9οΈβ£ Invoice Amount
π Definition: The total amount billed on the invoice before it is categorized as overdue.
π― Purpose: Reflects the gross amount owed for accurate financial tracking.
π Aging Categories
These columns categorize overdue invoices based on how long they have remained unpaid:
πΉ 1β30 Days Overdue
π Definition: Invoices that have been unpaid for 1β30 days beyond the due date.
π― Purpose: Highlights recent overdue payments for immediate follow-up.
πΉ 31β60 Days Overdue
π Definition: Invoices overdue between 31β60 days.
π― Purpose: Identifies moderately overdue invoices requiring prioritized collection efforts.
πΉ 61β90 Days Overdue
π Definition: Invoices that have been outstanding for 61β90 days.
π― Purpose: Signals invoices that may need escalated attention to prevent long-term non-payment.
πΉ Over 90 Days Overdue
π Definition: Invoices overdue by more than 90 days.
π― Purpose: Highlights critical overdue invoices that may require formal collection processes or intervention.
π Key Takeaways
βοΈ Categorizing overdue invoices makes it easier to track, prioritize, and take action on outstanding payments.
βοΈ Using payer current balance and aging categories helps focus collection efforts on the most overdue amounts.
βοΈ Reviewing all key fields, such as invoice status and room name, ensures accurate follow-ups and financial record-keeping.
π‘ Pro Tip: Regularly monitoring the Aging Report helps maintain healthy cash flow and prevents long-term overdue balances! β π
π Want to Unlock Powerful Insights?
π Make data-driven decisions with ease! The Report Center: Your Data Hub for Smarter Decision-Making! is your one-stop destination for tracking attendance, billing, staff management, and more.
π Explore key features like:
β
Customizable reports for attendance, scheduling, and financial tracking.
β
Staff and child management insights to streamline operations.
β
Easy exporting of reports for analysis and record-keeping.
π Take control of your centerβs data today! ππ₯β