Reckon Accounts | A little issue with ageing

Software: Reckon Accounts

For those who are using multiple currency in Reckon Accounts accounting software, you will discover that the A/R Ageing Detail report doesn’t show the Foreign Open Balance correctly (It shows the base currency value instead).

Accounts Receivable

While waiting for Reckon to fix up the issue, hope not too long, you may try to display the Actual Rate field (select the field from the Modify Report |  Display tab | Columns).

Then, use the Export function to export your report into Microsoft Excel.

From the Microsoft Excel spreadsheet, add a new column and use the PRODUCT () function to calculate the Foreign Open Balance (Open Balance field / Actual Rate field or Open Balance field * Actual Rate; depending on your base currency value).