Forum Discussion

WMack's avatar
WMack
Experienced User
3 years ago

Receivables Reconciliation Exception out of balance

I have an out of balance on the above report.  I've traced it back and found the 2 Invoices that are causing this but don't really understand what I need to do to fix it.  If I run the report forwarding to a future date the out of balance amount is still the same, not zero.  

 

Inv 1:  dated 22/10/21 for 3,960. Paid out by a credit on the 15/09/21 

 
Inv 2:  dated 27/04/22 for $297. Paid out by a credit on the 16/02/22
 
Please help.

1 Reply

Replies have been turned off for this discussion
  • SamaraM's avatar
    SamaraM
    Former Staff
    3 years ago

    Hi WMack 

     

    Sorry to see that no one has replied to you yet. It looks like the there may be a false out of balance due to a timing issue. This is when a customer payment or credit is dated earlier than the invoice it has been applied to.

     

    To check if you have a false out of balance run the report at a future date. For example "31/12/9998". If the report balances on this date, you may need to delete and re-enter the transaction mentioned using the correct date.

     

    See our Help Article: Receivables, payables or inventory out of balance for more information on that topic.

     

    If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.