How to Cross Age Accounts Receivable

Open up a spreadsheet program and create columns entitled "Vendor Name," "30-Day," 60-Day," "90-Day" and "Total." Include a column for comments or notes and this will effectively be your aged accounts receivable listing. Input the data into each of the columns appropriately. Proceed to add the totals of the amount of money owed by each debtor in the "Total" column.

  • Proceed to the 90-days column and summarize the outstanding debts appearing in this column and add the total of each debtor's outstanding amount of money.

  • ‘Anupam Kher is gunning for the pest actor award’: Actor’s pest control remark bugs Twitter
    The showdown resumed on Sunday evening, as Sardesai tweeted one final response, albeit without tagging Kher this time. Meanwhile, a parody account, @surdesairajdeep, stepped into the fight on Sunday morning to get in a word.

    Divide each debtor's total outstanding debt in the 90 days column by the total debts owed by each of the debtors and multiply the result by 100 to determine the percentage of each debtor's 90 days outstanding debts to the total debt owed by each of the debtors to the business.

  • List the debtors whose 90-days outstanding debts are 50 percent and above. Compute the total amount of the outstanding debts owed to the business by these particular debtors and in so doing, you will have cross-aged your accounts receivable.

  • Asia-Pacific conference on aligning corporate sustainability with sustainable development goals It also proposed tools and strategies to improve corporate sustainability and better align business sustainability strategies with the SDGs.
    More... Sheet music+CD - Annie Ledout - 99 Tests d'Ecoute An unequalled solidity and life expectancy! Reeds, ligatures, cords, harnesses and cleaning products from Rico. Cases, covers and accessories 100 % Made In France: Bam arrives to di-arezzo! Discover our dedicated page.
    More... Dublin Airport Parking Located just five minutes from the airport, the hotel will provide you with just the break you need before your flight. We’ll show you all of our auto parking deals with a summary of price , transfer times and security details .
    More... Clever & Funny Puns Art By Nabhan Abdullatif [PICS] Wanted to have more pun-tastic fun in your head? Just head over to Nathan’s DeviantArt gallery for more! Just in case you don’t know, this is "just in case"… now how should I explain this? Mood Swings .
    More... Ameren Cos. Providing Power Outage Data Over Handheld Devices Ameren Cos.. in Illinois and Missouri are among the first electric utility companies in the nation to offer power outage information on mobile devices.
    More...

    More news