{"id":378,"date":"2014-07-16T12:47:45","date_gmt":"2014-07-16T12:47:45","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=378"},"modified":"2024-12-02T10:17:24","modified_gmt":"2024-12-02T10:17:24","slug":"sage-100-accounts-receivables-ar-aging-report","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2014\/07\/16\/sage-100-accounts-receivables-ar-aging-report\/","title":{"rendered":"Sage 100 Accounts Receivables (A\/R) Aging Report"},"content":{"rendered":"

The general ledger account \u201cAccounts Receivable\u201d in Sage 100 ERP<\/a> usually contains only summary amounts and is referred to as a control account. The details for the control account – each credit sale for every customer – is found in the subsidiary ledger for Accounts Receivable. The total amount of all the details in the subsidiary ledger must be equal to the total amount reported in the control account. The detailed information in the accounts receivable subsidiary ledger is used to prepare a report known as the Aging of Accounts Receivable.<\/p>\n

New Stuff<\/em>:<\/strong> <\/span>Sage 100 Open sales order report \u2013 by Item<\/em><\/a><\/p>\n

An A\/R Aging report lists each customer, their due balance, and the time periods for which that balance has been outstanding. The report usually categorizes the sections as: “Current, 30 days, 60 days, 90 days, 120 days, over 120 days” It can also be a\u00a0 user-defined parameter. If the customer has several bills that were incurred at different times, the report will show how much is due and at what time.<\/p>\n

The Aging of accounts receivable report is typically generated by sorting the unpaid sales invoices in the subsidiary ledger\u2014first by a customer and then by the date of the sales invoices. If a company sells merchandises (or provides services) and allows the customers to pay 30 days later, this report will indicate how much<\/em> of its accounts receivable are past due. It also reports when are the accounts past due.<\/p>\n

Key features of the AR Aging report<\/span><\/strong><\/p>\n

    \n
  1. Shows how much money your customer owes<\/li>\n
  2. Shows how old the balance is (30-60-90-120+days).<\/li>\n
  3. Shows the claimed source for each balance.<\/li>\n
  4. The starting point to identify abnormal payment trends based on payers, practice history, and standards.<\/li>\n
  5. Holds data for the Payer Mix Summary which projects potential expected income revenue.<\/li>\n<\/ol>\n

    A\/R aging Report works on a basic rule which is as follows:<\/p>\n

    In debt collection, it is said that “The longer a debt is owed, the less likely you will to be able to collect It.” i.e. the longer a bill is outstanding, the less likely you will be able to collect the same. Here are some guidelines to consider when reading an A\/R aging report:<\/p>\n