{"id":32723,"date":"2021-01-27T18:17:53","date_gmt":"2021-01-27T18:17:53","guid":{"rendered":"https:\/\/support.ospreyapproach.com\/?post_type=pracctice_guide&#038;p=32723"},"modified":"2024-08-06T15:52:45","modified_gmt":"2024-08-06T14:52:45","slug":"aged-debtors","status":"publish","type":"pracctice_guide","link":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/","title":{"rendered":"Reports: Aged Debtors"},"content":{"rendered":"<div class=\"card\">\n\n    <p class=\"mb-2\"><strong>Who is this guide for?<\/strong><\/p>\n    <p class=\"mb-0\"><i class=\"far fa-user fa-fw mr-2\"><\/i> <strong>Accounts Users<\/strong> and <strong>Accounts Supervisors<\/strong><\/p>    \n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">This guide will go through the Aged Debtors report<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This report lists clients\/matters with a Debit balance, ageing the balance according to the period in which the bill was posted.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"409\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/06\/image-47-1024x409.png\" alt=\"\" class=\"wp-image-34408\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2021\/06\/image-47-1024x409.png 1024w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2021\/06\/image-47-300x120.png 300w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2021\/06\/image-47-768x307.png 768w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2021\/06\/image-47.png 1242w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"h2 wp-block-paragraph\"><strong>Filter options<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"435\" height=\"391\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/06\/image-45.png\" alt=\"\" class=\"wp-image-34404\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2021\/06\/image-45.png 435w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2021\/06\/image-45-300x270.png 300w\" sizes=\"auto, (max-width: 435px) 100vw, 435px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Fee Earner<\/strong> &#8211;&nbsp; Select one or more Fee Earner<\/li>\n\n\n\n<li><strong>Worktype<\/strong> &#8211;&nbsp; Select one or more Worktype<\/li>\n\n\n\n<li><strong>Branch<\/strong> &#8211;&nbsp; Report on All branches or a particular branch<\/li>\n\n\n\n<li><strong>Department<\/strong> &#8211;&nbsp; Report on All departments or a particular department<\/li>\n\n\n\n<li><strong>Currency<\/strong> &#8211;&nbsp; Select the Currency type you wish to report on<\/li>\n\n\n\n<li><strong>Include Credit Balances<\/strong> &#8211;&nbsp; This option enables you to report on all non-zero balances, including credit balances.&nbsp; When you select this option the total on the Aged Debtors report should equal the Debtors figure for Year to Date on the Trial Balance for the current period<\/li>\n\n\n\n<li><strong>As At<\/strong> &#8211; Select this option and enter the date you wish to run the report at, you can select a retrospective date<\/li>\n\n\n\n<li><strong>Ordering<\/strong> &#8211; Select either Client Name or Client Number<\/li>\n\n\n\n<li><strong>Grouping<\/strong> &#8211; Options of No Grouping, Fee Earner or Work type.&nbsp; A new page is started for each Fee Earner or Work type and subtotals are given per grouping<\/li>\n<\/ul>\n\n\n\n<p class=\"h2 wp-block-paragraph\"><strong>List of Columns produced<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Client\/matter number<\/li>\n\n\n\n<li>Client name<\/li>\n\n\n\n<li>Matter Description<\/li>\n\n\n\n<li>Fee Earner<\/li>\n\n\n\n<li>Work type<\/li>\n\n\n\n<li>Balance (this is the overall balance on the matter)<\/li>\n\n\n\n<li>Bill Date (this is the date of the most recent outstanding bill on the matter)<\/li>\n\n\n\n<li>The following columns give the aged analysis of the debt\n<ul class=\"wp-block-list\">\n<li>0-30 days<\/li>\n\n\n\n<li>31-60 days<\/li>\n\n\n\n<li>61-90 days<\/li>\n\n\n\n<li>91+ days<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Credit balance. &nbsp;&nbsp;This displays any credit balances when this filter option is selected<\/li>\n\n\n\n<li>MisAl.&nbsp; This column displays \u2018Yes\u2019 when there is a problem with the allocations on the matter, meaning that the sum of the ageing columns does not match the Balance on the ledger. The ledger should be <a data-type=\"URL\" data-id=\"https:\/\/support.ospreyapproach.com\/guides\/clear-and-reallocate-a-client-ledger\/\" href=\"https:\/\/support.ospreyapproach.com\/guides\/clear-and-reallocate-a-client-ledger\/\" target=\"_blank\" rel=\"noreferrer noopener\">cleared and reallocated <\/a>to rectify this.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This report lists clients\/matters with a Debit balance, ageing the balance according to the period in which the bill was posted. <\/p>\n","protected":false},"author":22,"featured_media":0,"template":"","categories":[109],"tags":[],"class_list":["post-32723","pracctice_guide","type-pracctice_guide","status-publish","hentry","category-using-reports-client-financial"],"acf":{"display_as_dashboard_announcement":false,"announcement_title":"","announcement_type":"New feature","announcement_link_text":"Learn more","announcement_image":null},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Reports: Aged Debtors - Osprey Approach Customer Support &amp; Training | Osprey Academy<\/title>\n<meta name=\"description\" content=\"This guide will go through the Aged Debtors report\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reports: Aged Debtors - Osprey Approach Customer Support &amp; Training | Osprey Academy\" \/>\n<meta property=\"og:description\" content=\"This guide will go through the Aged Debtors report\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/\" \/>\n<meta property=\"og:site_name\" content=\"Osprey Approach Customer Support &amp; Training | Osprey Academy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/OspreyApproachUK\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-06T14:52:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/06\/image-47-1024x409.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@OspreyApproach\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/\",\"name\":\"Reports: Aged Debtors - Osprey Approach Customer Support &amp; Training | Osprey Academy\",\"isPartOf\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/06\/image-47-1024x409.png\",\"datePublished\":\"2021-01-27T18:17:53+00:00\",\"dateModified\":\"2024-08-06T14:52:45+00:00\",\"description\":\"This guide will go through the Aged Debtors report\",\"breadcrumb\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/#primaryimage\",\"url\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/06\/image-47-1024x409.png\",\"contentUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/06\/image-47-1024x409.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/support.ospreyapproach.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Guides\",\"item\":\"https:\/\/support.ospreyapproach.com\/guides\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Reports: Aged Debtors\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/\",\"name\":\"Osprey Approach Customer Support &amp; Training | Osprey Academy\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization\",\"name\":\"Osprey Approach Customer Support &amp; Training | Osprey Academy\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png\",\"contentUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png\",\"width\":201,\"height\":61,\"caption\":\"Osprey Approach Customer Support &amp; Training | Osprey Academy\"},\"image\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/OspreyApproachUK\/\",\"https:\/\/x.com\/OspreyApproach\",\"https:\/\/www.linkedin.com\/company\/ospreyapproach\",\"https:\/\/www.youtube.com\/channel\/UClARKUq_3YvaK01GPvI6_qA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Reports: Aged Debtors - Osprey Approach Customer Support &amp; Training | Osprey Academy","description":"This guide will go through the Aged Debtors report","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/","og_locale":"en_GB","og_type":"article","og_title":"Reports: Aged Debtors - Osprey Approach Customer Support &amp; Training | Osprey Academy","og_description":"This guide will go through the Aged Debtors report","og_url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/","og_site_name":"Osprey Approach Customer Support &amp; Training | Osprey Academy","article_publisher":"https:\/\/www.facebook.com\/OspreyApproachUK\/","article_modified_time":"2024-08-06T14:52:45+00:00","og_image":[{"url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/06\/image-47-1024x409.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@OspreyApproach","twitter_misc":{"Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/","name":"Reports: Aged Debtors - Osprey Approach Customer Support &amp; Training | Osprey Academy","isPartOf":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/#primaryimage"},"image":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/#primaryimage"},"thumbnailUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/06\/image-47-1024x409.png","datePublished":"2021-01-27T18:17:53+00:00","dateModified":"2024-08-06T14:52:45+00:00","description":"This guide will go through the Aged Debtors report","breadcrumb":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/#primaryimage","url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/06\/image-47-1024x409.png","contentUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/06\/image-47-1024x409.png"},{"@type":"BreadcrumbList","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/aged-debtors\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.ospreyapproach.com\/"},{"@type":"ListItem","position":2,"name":"Guides","item":"https:\/\/support.ospreyapproach.com\/guides\/"},{"@type":"ListItem","position":3,"name":"Reports: Aged Debtors"}]},{"@type":"WebSite","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/","name":"Osprey Approach Customer Support &amp; Training | Osprey Academy","description":"","publisher":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization","name":"Osprey Approach Customer Support &amp; Training | Osprey Academy","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/","url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png","contentUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png","width":201,"height":61,"caption":"Osprey Approach Customer Support &amp; Training | Osprey Academy"},"image":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/OspreyApproachUK\/","https:\/\/x.com\/OspreyApproach","https:\/\/www.linkedin.com\/company\/ospreyapproach","https:\/\/www.youtube.com\/channel\/UClARKUq_3YvaK01GPvI6_qA"]}]}},"_links":{"self":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/32723","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide"}],"about":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/types\/pracctice_guide"}],"author":[{"embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/users\/22"}],"version-history":[{"count":3,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/32723\/revisions"}],"predecessor-version":[{"id":69078,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/32723\/revisions\/69078"}],"wp:attachment":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/media?parent=32723"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/categories?post=32723"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/tags?post=32723"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}