WILREP - Specialist Accounting Report

What is

S&P (Sales and Purchases) and S&D (Sales and Distribution cost) Reporting

Purpose

· Link accounting entries with TRADE Sales and Purchases

· Manually entered accounting entries which have not been assigned to a Sale or Purchase contract will be included

· Totals for different cost and proceed categories should correlate with the totals for P&L in the ITAS accounting ledger for the same fiscal period

Operation

· Selections are

. TRADE (Freeze) database

. Layout choice of Detail or Summary

.Detail; lists a row of data per accounting entry. The report content is described later in this help.
.Summary: a row of data per sale contract. The layout follows the detail report, but all the values are summarised.
. Account period range

· General Ledger accounts are nominated by category for inclusion of the respective value in the report

· The report drives from the accounting transactions

· The data is processed by Sale (with allocated purchase if present), unallocated purchase and the last section lists where no sale nor purchase TRADE are associated/linked by the transaction contract number.

· Categories for accounting values are Proceeds, Cost of Materials, Material Price differences, Freight, Insurance, Commissions, Demurrage, Survey Costs, Port Charges, Storage.

· The postings in the selected accounting period range for the nominal ledger accounts entered for each category will be included

Report

· Sales details are presented followed by allocated purchase details and costs

· Differences between Actuals and Accruals for the cost categories are listed

· Paper trades are highlighted (physical circles, strings, washouts, Docs bypasses)

· AIT trades are those where the buyer and seller are part of the GTP (global Trader Program as flagged in CLI) or reside outside Operating Company Country Of Residence e.g. Singapore

· Manually entered accounting entries are those posted to P&L accounts which are nominated as GTP P&L accounts in EXP (other P&L account column)

· Cost accruals are recognised as being the postings with a TA reference

Report Content

Document Date	Document Date of posting
Document Ref.	Reference of Posting
Trader	Sale Trader
Sale	Sale ID
Customer Code	Buyer Code
Cust. Name	Buyer Name
SO	Client Reference
Sales (USD)	Proceeds in USD
Doc. Ccy	Accounting Document Currency
Sales Doc. Ccy	Proceeds in Document Currency
Inco Terms	Sale Contract Terms
Dest. Port	Sale Port of Destination
Dest. Country	Country of Sale Port of Destination
Dest. Region	Region (PHYSCODES/Ports) of Destination
Product	Sale Commodity
Purchase Trader	Trader on Purchase
Purchase Date	Purchase Contract Date
Purchase	Purchase ID
Vend. Code	Seller Code
Vend. Name	Seller Name
Vend. Country	Country of Seller
PO	Purchase Invoice Reference
Qty	Purchase Quantity
Cost - Mat	Purchase Cost (transactions)
Purchase Terms	Contract Terms on Purchase
Load Port	Purchase Load Port
Load Country	Purchase Load Country
Load Region	Region of Purchase Load Port
Vessel	Sale Vessel
User Inits	Initials of User who entered the Sale
Costs	Costs dictated by General Ledger selections
Costs Accrual	Value of TA documents
Cost Actual	Value of non-Ta documents
Cost Diff.	Difference between Actual and Accrual
Net Profit	Sum of preceding column values
Sales Region	Region from country code of buyer
Accs. Month	Accounting Posting Month
Cust. Inter C	Intercompany flag for Buyer
Vend Inter C	Intercompany flag for Seller
AIT	GTP/Non GTP trading
Sale TT Month	Month of TT Date on Sale
Sale TT Year	Year of TT Date on Sale
Purch TT Month	Month of TT Date on Purchase
Purch Year	Year of TT Date on Purchase
Accs Year	Year of accounting period