Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers

Spot Rate Revaluation

Datafile Software

Spot Rate Revaluation

Where a spot rate revaluation is required the following steps would normally be taken.

Alter the spot rates via the Currency Maintenance options.

Run a spot rate revaluation without updating the file, so that the effect of the change can be viewed.

When satisfied with the effect, re-run the revaluation selecting the option to update the files.

Run the remainder of the period end processes.

For each account the transactions are analysed and a spot-rate revaluation analysis record (type ‘8’) is written for each change account with the base currency exchange difference value.

The spot rate revaluation routine does not update the sales ledger or purchase ledger values. Its sole purpose is to generate transactions that will be updated into the nominal ledger.The effect of these transactions will be to revalue the nominal ledger control account to reflect the spot rate revaluations. Once these transactions are reversed in the nominal ledger (via standard journal entry) then the nominal ledger control account reverts to the true value of the ledger concerned.

It follows that you should never run a spot rate revaluation more that once at the end of the month. You will generate additional sets of revaluation transaction which update into the nominal ledger, multiplying up the effect of the spot rate revaluation.

Procedurally the spot rate revaluation operates as discussed above for the holding rate revaluation.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
List All Transactions
Viewed 1750 times since Mon, Jul 2, 2012
Recalculate Debtor/Creditor Control
Viewed 1906 times since Mon, Jul 2, 2012
System Profiles Screen 6 (Sub-Contractors Accessory)
Viewed 1814 times since Mon, Jul 2, 2012
Transaction / Detail Enquiries
Viewed 13507 times since Mon, Jul 2, 2012
VAT Adjustments - Post-Dated Purchase Invoices
Viewed 3805 times since Thu, Oct 11, 2018
Credit Restocking Fee (SOP Only)
Viewed 116 times since Thu, Jan 2, 2025
Period / Year End Facilities - Application User Facilities
Viewed 1875 times since Mon, Jul 2, 2012
Credit Control Manager (S/L Only) - Utilities
Viewed 2139 times since Mon, Jul 2, 2012
Allocations (Purchase Ledger)
Viewed 2258 times since Mon, Jul 2, 2012
VAT Form 100 - Group VAT Registration
Viewed 3742 times since Tue, Oct 9, 2018