Customer total not yet 1-30 30-60 60-90 over 90
Due
Acc.

Balance forward $793,791 438,933 149,614 106,400 57,442 41,402



I have to complete with these accounts

J.Kras $11,077 due Jan 15
T.Lopez 9,314 due Feb 15(next fiscal year)
L.Zapal 8,664 due Dec.20
R.Caputo 14,710 due Jan 4
S.Smith 6,316 due Nov 15
A.Quinn 4,389 due Mar.1(next fiscal year)
$55,250


Not due yet 2
1-30 5
31-60 15
61-90 25
Over 90 days 50
This is the percentage considered uncollectable

The date is now Jan.31,2011 beginng date Feb,1 ,2010

Please help anyone I need to complete the aging analysis of accounts recievable.

It looks like you posted the same question twice. Have you done the aging schedule yet? If you don't know what that is, you can find it in your textbook or online. It's a schedule that lists the accounts and spreads them by columns (1-30 or "current", 31-60, etc). Once you have that you can apply the percentages that are estimated to be uncollectible. If you'll do that to your best ability and post what you have, we can check to see if you understand. Thanks.

I don't have room to do it like I have it done. I do have these in columns:
Accounts
Balance 849,041
Allowence for uncollectible is 87,002.
This part of the question I did fine the part I don't understand is I'm suppose to compute the end-of-year balances(before adjustments) of accounts recievable and allowances for uncollectible accounts.

On my work it shows Accounts recievable was a debit of $442,341 and the balance for allowance for uncollectible accounts was a credit of $43,700. During the year the store had a sales on account of $3,722,000, a sales return and allowance of $60,000, worthless accounts written off $44,300, and collections from custormers of $3,211,000. What I don't understand is what does compute mean and what do I compute. I also have to prepare an analysis computing the estimated uncollectible accounts.
I can do the rest of my work I just don't understand this part I did the first part which was my original question, any help will be appreciated.

Okay, let's see if we can work through this together. First, it looks like you have a mistake in this question. When I added up the "have to complete with these accounts" part they do not equal $55,250. I looked at your other post and saw that the $780 figure is missing. Did you have that in your work?

I see where the $849,041 comes from, but I'm getting a different answer than $87,002. Can you tell me what you have for a total under each of the columns:
Not due yet 2
1-30 5
31-60 15
61-90 25
Over 90 days 50


Once we are in agreement there, we can figure out the rest. Thanks.

Yes I can and thank you for your help.
In the not yet due I have a total of 9,053
1-30 23,424
31-60 16,907
61-90 16,527
0ver 90 21,091
This is after I did the percentage that's where I came up with 87,002 of course I rounded up on this. I forgot to add the 780 figure to this one it would have been been in my over 90 days that's why I have the figure of 87,002 hope this has helped you and maybe you can help me thank you.

We are in agreement on the not yet due and over 90 columns. Tell me the numbers you have in your 1-30 column.

I have $23,424 in the 1-30 column

All my numbers are
149,614
11,077
14,710

Total I have is 175,401
After the percentages
Then I have the total of 23,424

What I need to know is this: You got $23,424 by applying 5% to the total A/R in the 1-30 day balance. My number is much lower, so we have different totals for that column. I'd like to see what numbers you used to get your total.

Sorry, we were posting at the same time. Okay, the $175,401 is correct, but to get $23,424 you would have to apply over 13%. Can you explain how you did this?

I now have 8770 is this correct I must have miss or hit another number on my caculator.

Yes. We have differences in the 30-60 and 60-90 columns. Why don't you give me the same info and we'll see what's going on?

31-60
106,400
6,316
Total I have is 112,716 then 16,907

61-90
57,442
780
Total I have is 42,182 then 21,091

Take a look at your $6316 and see if it is in the right column. What about L Zappal? You had mentioned earlier that the $780 belongs in the over 90 column, but here you have it in the 61-90 day column, and the $57,442 + 780 = $42,182 doesn't make sense. I think you have your columns mixed up.

Sorry in my 61-90 days the total is suppose to be 66,106 then 16,527 I looked at the wrong column

57,442
8,664

Look at how you spread L Zappal and S Smith.

6,316 due date is nov 15 so from feb 1 I had 31-60 days

Due Nov 15 - 15 days left in Nov + 31 in Dec + 31 in jan = 77

Ok I may need you to help me with the dates .
11,077 is due jan 15
8664 is due dec 20
14,710 due jan 4

You have the 11,077 and 14,710 in the 1-30 day column. You are right with that. If 11077 was due Jan 15 and is outstanding at Jan 31 it is 16 days past due.

You have the 8664 in the 60-90 day column. Can you tell me how many days past due it is?

I did some switching numbers around here are my new totals

31-60
106,400
8664
Total 115,064 then 17,260

61-90

57,442
6316
Total 63,758 then 15,940

I'm trying to help at the same time

Those numbers are right. Good job. So what do you have instead of the 87,002 now?

I have 72,114 now for the total.

I hope I'm getting closer because I need these for this partThis part of the question I did fine the part I don't understand is I'm suppose to compute the end-of-year balances(before adjustments) of accounts recievable and allowances for uncollectible accounts.

On my work it shows Accounts recievable was a debit of $442,341 and the balance for allowance for uncollectible accounts was a credit of $43,700. During the year the store had a sales on account of $3,722,000, a sales return and allowance of $60,000, worthless accounts written off $44,300, and collections from custormers of $3,211,000. What I don't understand is what does compute mean and what do I compute. I also have to prepare an analysis computing the estimated uncollectible accounts.
I can do the rest of my work I just don't understand this part I did the first part which was my original question, any help will be appreciated

$72114 is okay. I took all my numbers to two decimals and got a slightly different answer - like $1 different.

We might need to talk a little about the next part. What do you mean by: On my work it shows Accounts recievable was a debit of $442,341. Was that given to you in the problem? Is that possibly the amount A/R increased during the year or the beginning balance? The balance in the A/R account at 1/31 should equal your detail.

I want to make sure I am getting the right info here. Typically with the allowance for uncollectibe accounts, you will have a credit balance on the books. You will do an analysis like we just did to find out the estimated amount that you need, and then adjust the books to equal that.

I copied it like it was printedthe balance of accounts receivable was a debit of 442,341, and the balance of Allowance for uncollectible accounts was a credit of 43,700. During the year the store had sales on account of 3,722,00,sales returns and allowances of 60,000, worthless accounts written off 44,300, and collections from custormers of 3,211,000

So this is what I'm suppose to do now.
Compute the end-of year balances(before adjustments) of Accounts Recievable and Allowances for Uncollectible Accounts.

Prepare an analysis computing the estimated uncollectible accounts.

Then I figure the estimated uncollectible accounts expense for the year.

We completed the age analysis so I think we use it. So the new balance would be what we just did. I'm not sure

The 43,700 credit was the beginng balance before we did the analysis.

Okay, I see what they are saying. Your beginning balance in A/R was $442,341. I want you to do this work, so take the beginning balance, and adjust it by the transactions. You know your sales and your collections. The difference are accounts that haven't been paid yet. Also adjust by Returns & Allowances. When you write off bad debts, do you know the entry? I don't want to just give you the answers, but tell me what you think it is and we'll work through it. That way I know it will make sense to you when we are done.

When you have done that, we'll work on the Allowance for Doubtful Accts portion.

Also, ask if you don't understand the Returns & Allowances account.

Thanks for not giving me the answers I need to know how to do this. I think the entry would be Accounts recievable write off account,if you are talking about the journal entry. We did not go over any of this in class so I'm really just winging this and using your help.

No, not the journal entry yet. I want you to start with the beginning balance in A/R of $442,341 and then adjust it by the transactions (Sales, Returns, Collections, etc.). I think once you have done this, the whole problem is really going to make sense to you.

I'm guesing here but I think A/R would be 7,375,341
Uncollectible accounts I have 103,700

Then a write off 43,000

Now am I suppose to add the write off with the accounts uncollectible

43,300 is the write off, sorry about that.

It looks like you are basically just adding most of those numbers. You need to think about what effect each would have on A/R. At the time of a sale, a/r is increased. What happens with a collection? Do you understand what they mean by collection?

Let's just work with a/r for a moment. Don't look at uncollectibles until you understand a/r.

I was thinking collections was when someone didn't pay his/her debt.
Thanks for your help this is just my fourth class. Accounts recievable is when a company is going to receive cash.
I'm sorry I don't know much yet.

No, I understand why you said that - like someone "gets sent to collections". Here it means that was the amount of A/R that were collected, meaning the customer paid his bill.

Don't worry about it. You are working at it, and if you keep this up you will understand it soon. It is really important as Accounting builds on all these fundamentals, and if you understand this now it will make all your work easier in the future.

Okay, knowing what collections are, how does that affect your a/r number?

I have so far a total of 883,341,but that's without the write off which I have no clue as how to do. I'm also guessing that store returns are a decrease in A/R

Ingonore last post

If the collections were already collected then that wouldn't mean they are reievable would it?

I'm trying to figure out your 883341 number. Tell me how you got it. I promise we are getting closer. :)

If the collections were already collected then that wouldn't mean they are reievable would it?

When a sale is made, you debit A/R and credit Sales. When a collection is made, you debit cash and credit A/R. In other words, a collection decreases A/R. You have been paid - it is no longer receivable.