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
.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 |