Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

An example of the Journals created by discrepancies

FX Purchase Orders and Goods Received Not Invoiced Account Balance from rounding

When the stock arrives - the value of stocking the goods is linked to the "Goods Received Not Invoiced" GL Account

When the invoice is created the same GL account is referenced - and the net result should be zero.

However - an Foreign Exchange purchase order may have a small variance due to rounding

  1. The Price each in the FX currency is converted to a price ea in AUD - this involves rounding to two decimal places
  2. The stock is received using the rounded AUD value each x qty 
  3. The invoice line is calculated using the total FX amount (FX each x qty) and then converting this to AUD and then rounding it
  4. So because the calculations are different a variance in AUD may exist
    1. Example
      1. Qty 2080
      2. price ea 5.84 in British Pounds, FX rate of 0.55 AUD to GBP - results in AUD $10.62 each
      3. Stock receipt journal creates value in Goods receipt not invoiced GL account using AUD$10.62 each x 2080 = $22,089.60
      4. Creditor invoice removes value from Goods Receipt not invoiced GL account converting FX total (2080 x 5.84 = GBP 12,147.20) - converting to AUD $22,085.82
      5. This would leave a small value ($22,089.60 - 22,085.82 = $3.78) in the Goods Received not invoiced GL account for this line
      6. For many lines this can build up to a more significant value.

Image Added