Accounting Voucher

make journal entry

I also faced the same problem but didin't get any full proof solution. So what I do is: After the bill is raised I open advance receipt entry and then instead of advance I select the bill number.

Hi guys

I have a solution but i dont know wheather it is correct, if wrong plz let me know wat will b the problem if we pass the entri like this. 

On advance

Bank/Cash A/c                    5000

     To Party A/c (On Acc)                  5000

On raising the bill

Party A/c (On Acc)                             5000

    To Sales/Service income A/c                   5000

Thank & Regards

R Shriram

Yes Shriram is correct

Bank/Cash A/c Dr    5000/-

       To Ramlal A/c           5000/-

Ramlal A/c    Dr         5000/-

          To Sales A/c      5000

Thanks Sreenivaas

Regards

R Shriram

Generally the bill number or on account options are enabled only when we need to track bill-wise but if we do as Shriram suggested the very purpose of enabling the option will be lost. So, instead we can also disable that option in tally and work.

We can treat it as on account payment also to get rid off this problem

sorry sir i have wrongly posted actually it has to be Advance payment

Sorry Regards

R Shriram

Originally posted by : usha gautam
	In Tally ERP 9, when any advance amount received from debtor then we can adjust it in receipt voucher (F6) as advance. but how to adjust this advance receipts in further raised bill. for example: I received Rs. 5000 from Ram Lal on 25.02.2011 as advance. - 1) cash /bank dr to ram lal ( instance 1st) this will auto adjust when u post sales entry as  ram lal dr to sales  -2) a)cash bank dr to advance b) Ram Lal dr to sales c) advance dr to ram lal  (journal)   on 03.03.2011 a bill raised of Rs. 5000, Now how to adjust this bill against the amount recievd in advance. I would be thankful a lot, if anyone is able to slove this Problem.

select any of these two methods 

as the payment is entered betore the bill , bill wise details will not come, 

1)pass the payment to advnace from customers ( ram lal is nowhere)

2) enter bill details and credit the party 

3) make journal entry after entry of bill , bring back the amount from "advance from customers" to ram lal account, 

now the bill wise details will appear. 

Thanks Sharma...

So we have to create a ledger like “Advance from Customers” and make a journal entry to solve this issue....

 Is this a bug? May be Tally will solve this in the future...

 Thanks & Regards

no, its not a bug

when we ask for bill wise details, and any payment is received before the issue of invoice, then software considers that payment related to any previous transaction as there was no reference available for the invoice, 

to solve the issue, making a pool fund" advance from customers" will regularize the accounting. 

Mr. Sharma

you have provided a very good solution but there is still a problem. lets suppose i have around 50 customers and i credited all advances received from these customers in Advances from customers a/c. now  how i would be able to know that from a specific customer how much amount is received in advance because there is only aggregate amount in Advance fr customer a/c. in case i create customer a/cs under the group Advance fr customers then it will results in doubling of accounts means for 50 customers i have to create 100 a/cs (50 under Debtors + 50 under Advances).