Receivables with tax report not balancing to receivables recon. report

Question

Could anyone shed some light on why the receivables with tax report is not balancing to the receivables reconciliation report. I have found a post on the community forum to check the dates invoices and payments have been posted and have ran the report on a forward date. The report is still out of balance the same amount.

Has anyone else had a similar issue?

Doreen_P · Answer

Hi, @LeeshO

Thanks for your post, and we're sorry for the delayed response.

In addition to what @gavin12345 mentioned, the Receivables With Tax report is like looking at your full bill before any payments, while the Receivables Reconciliation report shows your actual outstanding balance after accounting for the early payment. With this, you can use the Receivables Reconciliation report to view the correct amount of balances caused by the prepayments in the file.

Feel free to post again anytime if you require further assistance. 
 
If my response has answered your inquiry, please click "Accept as Solution" to assist other users in finding this information.

Best regards,

Doreen

gavin12345 · Answer

Hi @LeeshO

Use the Receivables Reconciliation Report, it is more accurate than the Receivables with Tax report. Known bugs in the With Tax Report include incorrect treatment of Finance Charges and incorrect treatment of currency gains if you use multi currencies.

Regards

Gavin