...
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
- The Price each in the FX currency is converted to a price ea in AUD - this involves rounding to two decimal places
- The stock is received using the rounded AUD value each x qty
- The invoice line is calculated using the total FX amount (FX each x qty) and then converting this to AUD and then rounding it
- So because the calculations are different a variance in AUD may exist
- Example
- Qty 2080
- price ea 5.84 in British Pounds, FX rate of 0.55 AUD to GBP - results in AUD $10.62 each
- Stock receipt journal creates value in Goods receipt not invoiced GL account using AUD$10.62 each x 2080 = $22,089.60
- 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
- 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
- For many lines this can build up to a more significant value.
- Example