{"id":21380,"date":"2021-08-19T16:25:16","date_gmt":"2021-08-19T15:25:16","guid":{"rendered":"https:\/\/bigredcloud.com\/?post_type=docs&#038;p=21380"},"modified":"2022-10-20T11:31:17","modified_gmt":"2022-10-20T10:31:17","password":"","slug":"purchase-ledger-reports","status":"publish","type":"docs","link":"https:\/\/bigredcloud.com\/en\/documents\/purchase-ledger-reports\/","title":{"rendered":"Purchase Ledger Reports"},"content":{"rendered":"<div class=\"fusion-column-wrapper\" style=\"padding: 0px; background-position: left top; background-repeat: no-repeat; background-size: cover; height: auto;\" data-bg-url=\"\">\n<p><iframe loading=\"lazy\" class=\"lazy-loaded\" title=\"vimeo132427438\" src=\"https:\/\/player.vimeo.com\/video\/132427438?autoplay=0&amp;autopause=0\" width=\"600\" height=\"360\" allowfullscreen=\"allowfullscreen\" data-lazy-type=\"iframe\" data-src=\"https:\/\/player.vimeo.com\/video\/132427438?autoplay=0&amp;autopause=0\"><\/iframe><\/p>\n<p>There are a number of reports relating to the Purchase Ledger in the accounting software and the purpose and content of each will be described below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-21381 size-full\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/purch_rpt-300x175-1.jpg\" alt=\"how to use big red cloud software\" width=\"300\" height=\"175\" \/><\/p>\n<p>The Purchase Ledger Reports Menu.<\/p>\n<p><strong>Ledger Accounts.<\/strong><\/p>\n<p>This report displays all transactions for specified Suppliers for a specified period. \u00a0The format of the report is very similar to the\u00a0Lookup \u2013 Suppliers\u00a0option. \u00a0It differs in that the report can be produced for more than one Supplier and it can be produced for a particular period (rather than for the whole Financial Year).<\/p>\n<p>Its most common uses are to verify the correctness of Suppliers\u2019\u00a0statements that you receive and to produce for your accountant full details of Supplier Accounts at year end. \u00a0It is particularly useful for comparing to Suppliers\u2019\u00a0statements because its format is very similar to that used by most Suppliers.<\/p>\n<p><strong>Aged Creditors.<\/strong><\/p>\n<p>This report lists the amount owing to each Supplier as of the end of a specified month and provides an aged analysis of the balance on each account. \u00a0You can choose to exclude Suppliers with a zero balance as of the month specified.<\/p>\n<p>You can select the Period up to which transactions should be included. \u00a0Transactions will be included based on the Period and not the transaction date. \u00a0Negative balances are always applied progressively from the oldest, <em>e.g.<\/em> if a supplier owed you money from 3 months ago and there were no other transactions it would appear as a \u2018Current\u2019 balance.<\/p>\n<p><strong>Calculating Aged Balances With Allocations Off.<\/strong><\/p>\n<p><strong>Invoices.<\/strong><\/p>\n<p>The transaction date determines its age as either Current, 1 Month old, 2 Months or 2 Months+.<\/p>\n<p><strong>Payments.<\/strong><\/p>\n<p>Applied so as to reduce the oldest balance first.<\/p>\n<p><strong>Credit Notes\u00a0And\u00a0Journals.<\/strong><\/p>\n<p>These will be treated as either\u00a0Invoices\u00a0or\u00a0Payments\u00a0depending on which option you chose in\u00a0Setup\/Options.<\/p>\n<p><strong>Calculating Aged Balances With Allocations On.<\/strong><\/p>\n<p>Balances are calculated based on the outstanding balance of invoices only on the date being aged to. \u00a0Unallocated payments are shown separately.<\/p>\n<p><strong>Creditors Listing.<\/strong><\/p>\n<p>This report lists the amount owing to each Supplier as of the end of a specified month. \u00a0It also shows the turnover with each Supplier (<em>i.e.<\/em> the total of all invoices less credit notes received from that Supplier in the Financial Year-to-Date). \u00a0You can choose to exclude Suppliers with a zero balance as of the month specified in the report.<\/p>\n<p><strong>Creditors Control.<\/strong><\/p>\n<p>This report provides a summary, for a specified period, of all the activity between your business and your Suppliers\/Creditors. \u00a0It shows summary totals for all purchase invoices (net of credit notes), payments made, discounts received and adjustments made to accounts through Journal entries. \u00a0It is useful in providing a quick overview of aggregate totals for Purchase Ledger (<em>i.e.<\/em> Creditors) activity. \u00a0The figures displayed on this report are calculated as follows:<\/p>\n<p><strong>Opening Balance<\/strong>\u00a0\u2013 The total of the balances owed to all Suppliers at the beginning of the chosen start month.<\/p>\n<p><strong>Invoices<\/strong>\u00a0\u2013 The total of all Suppliers\u2019\u00a0invoices (less credit notes) entered in the Purchases Book for the specified period.<\/p>\n<p><strong>Cheques,\u00a0Cash\u00a0and\u00a0Discounts<\/strong>\u00a0\u2013 The totals (respectively) of all payments entered to Suppliers\u2019\u00a0Accounts through the Bank Payments and Cash Payments Books, and the total of any Discount Received as entered in both of these books.<\/p>\n<p><strong>Journals<\/strong>\u00a0\u2013 The total of adjustments made to Supplier\u2019s Accounts through Creditors Journal entries.\u00a0 A total in the Debit column would represent adjustments which reduced the amount owed to Suppliers. \u00a0A total in the Credit column would represent adjustments which increased what you owed.<\/p>\n<p><strong>Closing Balance<\/strong>\u00a0\u2013 The total of the balances owed to all Suppliers at the end of the period specified.<\/p>\n<p><strong>Journal Listing.<\/strong><\/p>\n<p>This report lists and totals the Creditor Journal adjustments made to Supplier Accounts. \u00a0The list will only contain those entries made in the range of months which you specify at the start of each report.<\/p>\n<p><strong>Supplier Opening Balances.<\/strong><\/p>\n<p>This report lists Suppliers opening balances at the start of your Financial Year. \u00a0If you first began operating\u00a0Big Red Cloud\u00a0midway through a Financial Year, then the balances shown are those as at the beginning of your First Month of Entry. \u00a0The report will not necessarily include all of the Suppliers who presently have an account in the Purchase Ledger since you may have added some new accounts after you started. \u00a0You can choose to exclude Suppliers with a zero opening balance.<\/p>\n<p><strong>Supplier Listing.<\/strong><\/p>\n<p>This is a list of the Account Codes \/ Names \/ Addresses \/ Contact Names \/ E-mail Addresses \/ Telephone and Fax Numbers of all Suppliers that are presently set up in your Company.<\/p>\n<p><strong>Unpaid\/Unallocated Listing.<\/strong><\/p>\n<p>This report is only available when Allocations is switched on.<\/p>\n<p>On selecting this report the following screen is displayed:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21382\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/sel_unpaid_unalloc-300x176-1.jpg\" alt=\"\" width=\"300\" height=\"176\" \/><br \/>\n<noscript><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2823\" src=\"https:\/\/bigredcloud.co.uk\/wp-content\/uploads\/sel_unpaid_unalloc-300x176.jpg\" alt=\"sel_unpaid_unalloc\" width=\"300\" height=\"176\" srcset=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/sel_unpaid_unalloc-300x176.jpg 300w, http:\/\/bigredcloud.com\/wp-content\/uploads\/sel_unpaid_unalloc.jpg 344w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\"\/><\/noscript><\/p>\n<p>Click on the down arrow to the right of the field to display a list of Suppliers and select the ones to included in the report. \u00a0On the selection screen there are tick boxes to the left of suppliers names. \u00a0To select or deselect all click on the box to the left of the report title.<\/p>\n<p>A listing is display of all the unpaid invoices and unallocated payments for each of the selected suppliers.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>There are a number of reports relating to the Purchase Ledger in the accounting software and the purpose and content&#8230;<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"footnotes":""},"doc_category":[209],"doc_tag":[],"class_list":{"0":"post-21380","1":"docs","2":"type-docs","3":"status-publish","5":"doc_category-purchases"},"year_month":"2026-04","word_count":845,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"apathak","author_nicename":"apathak","author_url":"https:\/\/bigredcloud.com\/en\/author\/apathak\/"},"doc_category_info":[{"term_name":"Purchases","term_url":"https:\/\/bigredcloud.com\/en\/docs-category\/purchases\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Purchase Ledger Reports - Big Red Cloud<\/title>\n<meta name=\"description\" content=\"There are a number of reports relating to the Purchase Ledger in the accounting software and the purpose and content of each will be described below. The\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bigredcloud.com\/documents\/purchase-ledger-reports\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Purchase Ledger Reports\" \/>\n<meta property=\"og:description\" content=\"There are a number of reports relating to the Purchase Ledger in the accounting software and the purpose and content of each will be described below. The\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bigredcloud.com\/documents\/purchase-ledger-reports\/\" \/>\n<meta property=\"og:site_name\" content=\"Big Red Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SimpleOnlineAccounts\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-20T10:31:17+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/purch_rpt-300x175-1.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@BigRedCloud\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Purchase Ledger Reports - Big Red Cloud","description":"There are a number of reports relating to the Purchase Ledger in the accounting software and the purpose and content of each will be described below. The","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:\/\/bigredcloud.com\/documents\/purchase-ledger-reports\/","og_locale":"en_US","og_type":"article","og_title":"Purchase Ledger Reports","og_description":"There are a number of reports relating to the Purchase Ledger in the accounting software and the purpose and content of each will be described below. The","og_url":"https:\/\/bigredcloud.com\/documents\/purchase-ledger-reports\/","og_site_name":"Big Red Cloud","article_publisher":"https:\/\/www.facebook.com\/SimpleOnlineAccounts","article_modified_time":"2022-10-20T10:31:17+00:00","og_image":[{"url":"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/purch_rpt-300x175-1.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@BigRedCloud","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/bigredcloud.com\/documents\/purchase-ledger-reports\/","url":"https:\/\/bigredcloud.com\/documents\/purchase-ledger-reports\/","name":"Purchase Ledger Reports - Big Red Cloud","isPartOf":{"@id":"https:\/\/bigredcloud.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bigredcloud.com\/documents\/purchase-ledger-reports\/#primaryimage"},"image":{"@id":"https:\/\/bigredcloud.com\/documents\/purchase-ledger-reports\/#primaryimage"},"thumbnailUrl":"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/purch_rpt-300x175-1.jpg","datePublished":"2021-08-19T15:25:16+00:00","dateModified":"2022-10-20T10:31:17+00:00","description":"There are a number of reports relating to the Purchase Ledger in the accounting software and the purpose and content of each will be described below. The","breadcrumb":{"@id":"https:\/\/bigredcloud.com\/documents\/purchase-ledger-reports\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bigredcloud.com\/documents\/purchase-ledger-reports\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/bigredcloud.com\/documents\/purchase-ledger-reports\/#primaryimage","url":"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/purch_rpt-300x175-1.jpg","contentUrl":"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/purch_rpt-300x175-1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/bigredcloud.com\/documents\/purchase-ledger-reports\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bigredcloud.com\/en\/"},{"@type":"ListItem","position":2,"name":"Docs","item":"https:\/\/bigredcloud.com\/en\/documents\/"},{"@type":"ListItem","position":3,"name":"Purchase Ledger Reports"}]},{"@type":"WebSite","@id":"https:\/\/bigredcloud.com\/#website","url":"https:\/\/bigredcloud.com\/","name":"Big Red Cloud","description":"Online Accounting Software","publisher":{"@id":"https:\/\/bigredcloud.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bigredcloud.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/bigredcloud.com\/#organization","name":"Big Red Cloud","url":"https:\/\/bigredcloud.com\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/bigredcloud.com\/#\/schema\/logo\/image\/","url":"https:\/\/bigredcloud.com\/wp-content\/uploads\/2025\/07\/unnamed-1.png","contentUrl":"https:\/\/bigredcloud.com\/wp-content\/uploads\/2025\/07\/unnamed-1.png","width":512,"height":512,"caption":"Big Red Cloud"},"image":{"@id":"https:\/\/bigredcloud.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SimpleOnlineAccounts","https:\/\/x.com\/BigRedCloud","https:\/\/www.linkedin.com\/company\/big-red-cloud\/?originalSubdomain=ie"]}]}},"_links":{"self":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/docs\/21380","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/comments?post=21380"}],"version-history":[{"count":0,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/docs\/21380\/revisions"}],"wp:attachment":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/media?parent=21380"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/doc_category?post=21380"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/doc_tag?post=21380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}