Worksheet

Foreign invoice rate worksheet

Lay this worksheet out on a single sheet, giving each foreign invoice its own line. Columns: invoice number, currency, foreign amount, invoice date, invoice rate, rate source, book value, receipt date, receipt rate, realised difference and revaluation rate at period end. A second block lists each currency with its rate rule, its rate owner and the ledger codes for realised and unrealised differences.

Name: ______________________   Business: ______________________   Date: ______________

Scroll the table sideways to see every column.

Cross out or rewrite any heading that does not fit your business. From the guide “Exchange rate gain and loss on invoices: how software records them”, www.gullysystem.com/blog/exchange-rate-gain-and-loss-on-invoices-how-software-records-them