1 Topic by Alaa (edited by Alaa 11/19/2017 11:25:27 am)

  • Alaa
  • Alaa
  • Senior Member
  • Offline
  • From: Jordan
  • Registered: 03/27/2015
  • Posts: 156

Topic: Bank Account Payment Entry

Hello,,,
i don't know if this is a bug but the problem i am facing is:

When we use Bank Account Payment Entry to send money to a supplier we add the following:
Debit- Accounts Payable: [supplier name] 995$
Debit- Interest & Bank Charges 5$

Credit- Checking Account 1000$
thats great.

now when we print the bank statement and/or the supplier balance, it shows that the supplier balance is 1000$ when it should be 995$ since the 5$ doesn't belong to the supplier but to the bank charges account.

Regards.

  • Alaa
  • Alaa
  • Senior Member
  • Offline
  • From: Jordan
  • Registered: 03/27/2015
  • Posts: 156

Re: Bank Account Payment Entry

https://ibb.co/dPnxSm

in the image attachment above..
shouldn't the supplier balance be 995 instead of 1000?

Post's attachments

Bug_in_Supplier_Balance.jpg 59.4 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.
  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Bank Account Payment Entry

You have merged what should have been 2 separate vouchers. One for the invoice of 995/- and another for expenses of 5/-. Since you issued only 1 cheque for payment of 1000/- you should have got a Pay Instrument (Draft, TT, etc) for 995 and the bank would have debited you 5/- for bank charges. Hence the vouchers should have been:

Purchase Invoice:
=============
Credit AP (Supplier) - 995
Debit COGS: 995

Payment Voucher:
=============
Credit Bank - 1000/-
Debit AP (Supplier) - 995/- (Payment Allocation)
Debit Bank Charges - 5/- (Payment Allocation)

Now the Supplier Payments Report should show 995/- only.

apmuthu's Website

  • Alaa
  • Alaa
  • Senior Member
  • Offline
  • From: Jordan
  • Registered: 03/27/2015
  • Posts: 156

Re: Bank Account Payment Entry

Awesome,
Thanks for your support.