Skip to main content
All CollectionsBilling and Invoicing
Billing Transactions: Exploring Invoices Transactions
Billing Transactions: Exploring Invoices Transactions

Learn how to manage, review, and track all issued invoices efficiently using the Invoices Tab in the Billing Transactions section.

M
Written by Michael
Updated over a month ago

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.

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.

Download Aging Report – Track overdue invoices categorized by the time they have been outstanding.


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

πŸ“ 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

πŸ“ 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! πŸ“ŠπŸ“₯βœ…

Did this answer your question?