Supplier card shows negative current balance but no transactions found

Question

One of our Supplier Cards has a current balance of -$165 however when I go into the Purchases Register there is nothing listed in the 'Returns & Debits' tab. Also when I go to 'Pay Bills' it doesn't ask to apply a credit.  I also ran the Supplier Ledger Report dated from 01/01/1900 to 31/12/9999 and the balance is -$165.  Can you please advise how I find the transaction?

LRBooks61 · Answer

Hi

I have been thinking so sorry for the delay in response

The  only other thing I can suggest is to do a find transaction and see if the 165 comes up there

So go into a find transaction

go to the account tab

go to advanced filters

select all accounts

set date range from 2000 - 2999

set amount to 165

in payee put the customer name ( if nothing comes up then delete and leave blank and run again)

Hope that helps

The finance charge  - if that is what it is may show in a differnt gl code

Lisa

bronwenw · Answer

I've checked the GL account with expanded dates for a 'Finance Charge' but still nothing.

Mike_James · Answer

Hi @bronwenw , something worth checking is reviewing for any entries in GL account which is linked to the Purchases account for "I pay charges for late payment". If none in the current year, go back to previous years if you can.

Sometimes when pay bill entries are made, the amount gets put into the finance charge field at the bottom of that window. A review of the expense account will tell you if that has happened.

Let me know the result. If there is an entry for this supplier and amount, I can advise further.