Accessing the Historical Debtors Report

   

You can access the Historical Debtors Report by navigating to the "Reports" or "Financials" section of the system and selecting "Historical Debtors Report".

   

Understanding the Filters

   

At the top of the Historical Debtors Report, you'll find filters to customize the data displayed:

   
           
  • All Companies: If your system handles multiple companies, this dropdown lets you select a specific company or view data for all companies.
  •        
  • Start: Use the calendar icon to specify the beginning date for the period you want to view.
  •        
  • End: Use the calendar icon to specify the ending date for the period you want to view.
  •    

   

Report Overview

   

The report provides a summary of invoice activity within the specified date range. Key information displayed includes:

   
           
  • Invoiced: The total amount invoiced to customers during the period.
  •        
  • Paid: The total amount paid by customers during the period.
  •        
  • Balance: The remaining balance owed by customers for invoices issued during the period.
  •    

   

Understanding the Columns

   

The Historical Debtors Report table displays the following information for each invoice:

   
           
  • ID: A unique identification number.
  •        
  • #: Likely indicates the status of the invoice (e.g., Open).
  •        
  • Number: The invoice number.
  •        
  • Date: The date the invoice was issued.
  •        
  • Invoiced Amount: The total amount of the invoice.
  •        
  • Paid Amount: The amount paid by the customer towards the invoice.
  •        
  • Balance: The remaining balance owed on the invoice.
  •        
  • First: The customer's first name.
  •        
  • Last: The customer's last name.
  •        
  • Company: The company associated with the invoice.
  • SMS/Email: Indicates if SMS or Email reminders can be sent to the customer.
  •    

   

Navigating and Using the Historical Debtors Report

   
           
  • Filtering: Use the "All Companies," "Start," and "End" fields to narrow down the data and focus on a specific time period or company.
  •        
  • Sorting: Click on the column headers (e.g., "Date," "Number," "Balance") to sort the report.
  •        
  • Pagination: If there are many invoices, use the pagination controls (e.g., "Start Previous," page numbers, "Next End") to navigate through the report.
  •        
  • Export: Click the "Export" button to download the report data. The exported file is likely in CSV format, which can be opened in spreadsheet software.
  •    

   

Using the Report to Manage Debt

   

The Historical Debtors Report is a valuable tool for:

   
           
  • Tracking Accounts Receivable: Monitor how much money is owed to your business over time.
  •        
  • Analyzing Payment Trends: Identify patterns in customer payments, such as late payments or changes in payment behavior.
  •        
  • Evaluating Collection Effectiveness: Assess how well your collection efforts are working by comparing invoiced amounts to paid amounts.
  •        
  • Financial Forecasting: Use historical data to help forecast future cash flow.
  •    

Updated: 23 November 2021

Support telephone: 02 9521 4052