{"id":128,"date":"2020-10-05T16:33:34","date_gmt":"2020-10-05T23:33:34","guid":{"rendered":"http:\/\/www.omtiblog.com\/reporterbase101\/?p=128"},"modified":"2025-08-25T18:15:39","modified_gmt":"2025-08-26T01:15:39","slug":"aged-a-r","status":"publish","type":"post","link":"https:\/\/www.omtiblog.com\/reporterbase101\/modules\/receivables\/aged-a-r\/","title":{"rendered":"Find overdue invoices &#038; act on them easily"},"content":{"rendered":"<h6>Lesson #55<\/h6>\n<h5>Receivables \u2013 Aged A\/R function<\/h5>\n<p>The first step in collecting a debt is finding out who owes you what and for how long. Aged A\/R (Accounts Receivable) reports tell you which clients have unpaid invoices, how much they are in arrears, and for how long \u2014 but RB\u2019s version is much more than that.<\/p>\n<h2>Multi-tasking tool<\/h2>\n<p><strong>RB\u2019s Aged A\/R reports are interactive so after you compile a report you can click a firm name in the report to get all of their contact info \u2014 plus see the record of which collections actions you have already pursued with them.<\/strong> You don\u2019t have to go to a separate function to do collections tasks. You can also click a monthly total to see which invoices are included and view their details.<\/p>\n<p>In addition to viewing firm and invoice details, you can view relevant information directly from the Aged A\/R report that you would otherwise go into separate functions to look up. Having this information at your fingertips in Aged A\/R saves you time when researching outstanding invoices, making collection efforts, or talking with a client about their invoices.<\/p>\n<p>While the default report ages invoices from today, you can use this function to generate Aged A\/R reports for prior time periods too.\u00a0You can export or print out the report if desired.\u00a0You can even resend invoices without leaving the function.<\/p>\n<h2>Viewing aged accounts receivable<\/h2>\n<p>The default report lists clients with unpaid balances in descending order by the ones who have the largest amount outstanding in the oldest time period \u2014 the clients you want to go after first. However you can sort the grid by one or more of the columns \u2014 so you can view the list in ascending or descending order by any time period, grand total owed, firm name or number, assigned collector, and\/or COD status. (When you exit the function RB will revert back to the default order.)<\/p>\n<p>You can also choose how many time periods to review. Amounts due from the past to the present are grouped in 30-day increments with the default view being 6 of these time periods in columns \u2014 plus 1 column for all outstanding amounts beyond 6 months. You can extend the report up to 12 months plus the extra column for older outstanding balances.<\/p>\n<p>A final column in the report lists the grand total outstanding amount for each firm. The last row in the report displays grand totals in each column of outstanding amounts for all clients.<\/p>\n<p>In addition to changing the number of the periods displayed, you can further customize the report to:<\/p>\n<ul>\n<li>Age receivables from an an earlier date.<\/li>\n<li>List firms by who ordered services instead of who was billed for services (if you want to contact the law firms who bought services instead of the insurance companies who will pay the invoices, for example).<\/li>\n<li>Group all of a parent firms\u2019 subsidiaries\u2019 amounts into the parent firm\u2019s total, instead of listing all firms separately.<\/li>\n<li>Show the invoices for a single firm or a parent firm and its subsidiaries.<\/li>\n<li>Show invoices assigned to a single collector in your office.<\/li>\n<li>Display only invoices in one or more categories (such as affiliate invoices).<\/li>\n<li>Display invoices for one or more business units in your company.<\/li>\n<\/ul>\n<h2>Printing Aged A\/R reports<\/h2>\n<p>If you want a static report to work with or for your records, you can export it.\u00a0Aged A\/R reports can be exported as an <em>Excel<\/em> spreadsheet with each client\u2019s overdue amounts broken down by age plus a list of all of their overdue invoices with their basic details. The exported report also includes the grand totals column and row.<\/p>\n<p>If you want an exported Aged A\/R report without invoices, you can export it as an <em>Excel<\/em> spreadsheet or generic file the same way you export other results grids in RB. Once exported with or without invoices, you can print the report.<\/p>\n<h2>Viewing client details<\/h2>\n<p>You can drill down in an Aged A\/R report to see details about a client, their outstanding invoices, and your collection efforts with them to date.<\/p>\n<p>Firm names in RB\u2019s Aged A\/R report are hyperlinked to their profiles in your system so with one click you can pull up all of a client\u2019s contact information \u2014 plus the rest of their details instantly including your collections notes to review.<\/p>\n<p>After accessing a firm from the Aged A\/R report, you can easily:<\/p>\n<ul>\n<li>Contact the firm.<\/li>\n<li>Record your current collections action.<\/li>\n<li>Enter any notes about the situation.<\/li>\n<li>Set a reminder date\/time for follow-up.<\/li>\n<li>Designate a follow-up person to receive the reminder.<\/li>\n<li>Update any other information about the firm such as an address change.<\/li>\n<\/ul>\n<h2>Viewing invoice details<\/h2>\n<p>In addition to the hyperlinked firms, firms\u2019 outstanding balances for each time period are hyperlinked too. Clicking an outstanding balance brings up a list of the client\u2019s unpaid invoices included in that time period\u2019s total \u2014 along with basic contact and invoice information so you can easily refer to specific invoices while on the phone with the client.<\/p>\n<p>Plus the outstanding invoices in this list are all hyperlinked to their details. So you have ALL the facts when talking to the client about getting paid.<\/p>\n<p>When looking at the list of invoices in a client\u2019s Aged A\/R detail window, you can:<\/p>\n<ul>\n<li>See the client\u2019s basic contact information such as the firm\u2019s main phone number.<\/li>\n<li>View basic invoice information at a glance including each invoice\u2019s balance due and how many days old it is.<\/li>\n<li>Drill down to view\/update detailed information about the firm and the collector assigned to the account.<\/li>\n<li>Drill down to view an invoice\u2019s details. In addition to listing the services provided and other invoice details, you can use information from an invoice details window to \u00a0provide clients with details about the specific invoice\u2019s overdue amounts and any payments or other transactions credited to the invoice. You can also update Bill To and Sold To client information.<\/li>\n<li>Resend invoices directly from the client\u2019s Aged A\/R detail window.<\/li>\n<\/ul>\n<h2>Shortcuts to other functions<\/h2>\n<p>Aged A\/R interacts with other RB functions eliminating the need to set search filters to find the relevant client information in those other functions.<\/p>\n<p>You can directly access a Bill To client\u2019s current 90-day payment history from Aged A\/R instead of going into the <a href=\"https:\/\/www.omtiblog.com\/reporterbase101\/modules\/inquiry\/search-payment-histories\/\">Receivable Transaction Inquiry<\/a> function and compiling that history yourself.<\/p>\n<p>You can also directly access all of a Bill To or Sold To client\u2019s financial activity with your company from within Aged A\/R instead of going to the <a href=\"https:\/\/www.omtiblog.com\/reporterbase101\/modules\/inquiry\/focus-on-a-single-clients-invoices\/\">Client Activity<\/a>\u00a0function.<\/p>\n<p>And you can compile and send <a href=\"https:\/\/www.omtiblog.com\/reporterbase101\/modules\/receivables\/collection-letters\/\">collection letters<\/a> for any or all of a client\u2019s outstanding invoices without leaving Aged A\/R.<\/p>\n<p><strong>TL;DR:\u00a0Aged A\/R summarizes each client\u2019s unpaid invoices, grouped by when the invoice was due (aging period). It is interactive so you have your complete set of collection tools and invoice information linked into the report to maximize your collection efforts.<\/strong><\/p>\n<h4>RB concepts in this lesson<\/h4>\n<p><strong>Bill To Firm:<\/strong> The firm responsible for paying the invoice for a job \u2014 usually the firm that scheduled the job \u2014 but also could be a third-party firm such as an insurance agency.<\/p>\n<p><strong>Business Unit (BU):<\/strong>\u00a0One of your company\u2019s revenue centers or any\u00a0entity in your business that you want to track separately.<\/p>\n<p><strong>Firm:<\/strong> Business you provide services to \u2014 usually law firms \u2014 but can also be other court reporting firms, vendors, insurance companies, corporate clients, and courts.<\/p>\n<p><strong>Sold To Firm:<\/strong> Usually the firm that ordered a job.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Set collection priorities by finding the clients who owe you the most for the longest amount of time or by using features in this interactive report to target past due clients. Then use the tools in the report to contact clients with all the facts at your fingertips <a href=\"https:\/\/www.omtiblog.com\/reporterbase101\/modules\/receivables\/aged-a-r\/\">&hellip;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39,226,21],"tags":[184,250,228,236,3,22],"class_list":["post-128","post","type-post","status-publish","format-standard","hentry","category-function","category-lesson","category-receivables","tag-aged-a-r","tag-email-second-round","tag-emailed-lesson","tag-rb9-lite","tag-rb9-standard","tag-receivables"],"_links":{"self":[{"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/posts\/128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/comments?post=128"}],"version-history":[{"count":0,"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/posts\/128\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/media?parent=128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/categories?post=128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.omtiblog.com\/reporterbase101\/wp-json\/wp\/v2\/tags?post=128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}