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 &amp; Debits' tab. Also when I go to 'Pay Bills' it doesn't ask to apply a credit.&nbsp; I also ran the Supplier Ledger Report dated from 01/01/1900 to 31/12/9999 and the balance is -$165.&nbsp; Can you please advise how I find the transaction?

lrbooks61 · Answer

Hihave you run the supplier ledger report in detail so you can see the transactions as the credit is there in the report you did run&nbsp;the detail report should show all transactions , keep the dates as you have before&nbsp;lisa

bronwenw · Answer

Thanks for the suggestion Lisa but the Supplier Ledger report didn't reveal anything. Any other suggestions?

mike_james · Answer

Hi&nbsp;bronwenw&nbsp;, 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.&nbsp;&nbsp;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.&nbsp;&nbsp;Let me know the result. If there is an entry for this supplier and amount, I can advise further.

bronwenw · Answer

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

lrbooks61 · Answer

HiI have been thinking so sorry for the delay in response&nbsp;The&nbsp; only other thing I can suggest is to do a find transaction and see if the 165 comes up there&nbsp;So go into a find transactiongo to the account tabgo to advanced filters&nbsp;select all accountsset date range from 2000 - 2999set amount to 165in payee put the customer name ( if nothing comes up then delete and leave blank and run again)&nbsp;Hope that helps&nbsp;The finance charge&nbsp; - if that is what it is may show in a differnt gl code&nbsp;Lisa&nbsp;

Forum Discussion

Supplier card shows negative current balance but no transactions found

Looking for something else?

Related content

Negative Payroll

Supplier Card - Last transaction date

Negative inventory account balances

Warning Duplicate Supplier Invoice

GST error caused by supplier deposit transaction

Matching a supplier refund bank transaction

Export Suppliers

Categorising a transaction