Customer Card showing as payment owed

[tlwebb]

Can anyone help with a customer showing a balance owing but no records exist.  The invoice shows 0 the statement shows 0 but there is amount showing under balance when you click on the customer how do i get rid of this.

[LRBooks61]

is the invoice post dated?

Can you do a find transaction on the amount that is showing?

If you do a accounts receivable report does it show? Can you drill down from there to see the invoice?

A screenshot of it would be helpful if these suggestions don't help

Lisa

[tlwebb]

Hi Lisa

The invoice it refers to has a 0 blance owing and it doesnt show up in any report and I have attached screen shot as you can see the balances are all 0

[LRBooks61]

Try going into recieve payments

select the customer there may be a credit that needs to be allocated perhaps 

you may need to select include closed sales

Lisa

[tlwebb]

Hi Lisa

Nothing there at all, I have done a general ledger report and for some reason its there as far back as I can go which is 2014 but its never been an issue and I have no idea why, we have now closed the business and i dont know how to get rid of it.  If I did a credit there is nothing to put it against. 

[LRBooks61]

Did you say that you found the invoice it refers to?

if so go into it and then select history ( bottom left corner)

have a look at the payment 

is there something there that stands out. It could be a date issue with a post dated receipt perhaps. Although it is paid it is paid in the future so it doesn't look paid

screenshot of the pay could be useful if you can't see anything 

lisa

[LRBooks61]

The other thing to check is trade debtors - is it showing there?

Can you reconcile trade debtors to accounts receivable? 

you said you have sold the business - has an accountant done any work on your myob file?

 
Lisa

[tlwebb]

Hi Lisa

I cant see the invoice as it looks like it was before 2014 so would have been purged as that is as far back as the general ledger goes.  I just want to know how to get rid of it now as I cant just do a credit as there is nothing to put it against even though by doing that it takes the balance to 0 but I will have an outstanding credit showing.  What I dont understand is if that amount is outstanding why is the statment at 0.

[LRBooks61]

There is glitch somewhere 

can you confirm whether your trade debtors include that amount? Your accounts receivable should equal your trade debtors 

you could run a report against the customer card reports cards card transactions (accrual) select all dates

check that all entries are allocated to trade debtors account - usually 1-1200

there has to be a reason for it

Lisa

[tlwebb]

Hi Lisa

Can you please advise how to do that as I am not sure. went into the reports as I have attached then put in the customer and it brought up nothing