Update to settlement report types in Singapore marketplace
On 31 Mar 2024 Amazon added an extra informational row to the GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2 settlement reports for Singapore. The first line now shows the address “1 Raffles Place, Singapore 048619” and GST No. M12345678X, pushing the column header to line 2 and shifting all transaction rows down one line.
Overview
On 31 March 2024 Amazon introduced an additional header line to the flat‑file settlement reports for the Singapore marketplace. The new line contains Amazon Singapore’s corporate address and its GST registration number. Sellers who automatically ingest these reports must revise their parsing logic, otherwise the extra row will be mistaken for data and cause accounting mismatches.
Key Points
- Report endpoints impacted — The change applies to the GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2 API used to pull settlement files for Singapore.
- Content of the new line — The first row now shows Amazon Singapore Pte Ltd’s physical address (e.g., “1 Raffles Place, Singapore 048619”) together with the GST ID (e.g., “GST No. M12345678X”).
- Shift in data rows — Because the header is inserted before the column titles, every transaction record moves down one line, breaking scripts that treat the first line as the header row.
- Tax‑return advantage – Having the GST number embedded directly in the settlement file lets sellers match Amazon‑issued invoices to their GST filings without consulting a separate source.
- Effective from 31 Mar 2024 — All settlement files generated after this date contain the extra line; earlier files remain unchanged.
- Core columns unchanged — Apart from the added row, the column names, data types, and overall file layout stay the same as before.
How the Updated Settlement Reports Work
- Initiate the request — A seller or a third‑party service calls the GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2 endpoint for Singapore, specifying the settlement period they need.
- Example: An accounting team schedules a nightly job that requests the April 2024 settlement file for SG via the API.
- Amazon adds the informational row — The system prefixes the file with a single line that lists the Singapore office address and the GST registration number.
- Example: The first line of the CSV reads: .
Analysis & Recommendations
Why This Matters
Automated ingest pipelines that read the first line as headers will treat the address line as a header, leading to key‑error exceptions and lost transaction data. Because the GST number is now embedded, sellers can reconcile tax filings directly, but only if they adjust their parsers to skip the new row.
Key Takeaways
- Effective 31 Mar 2024, GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2 for Singapore adds a single line with Amazon Singapore Pte Ltd address and GST No...
- The standard column‑header line moves from line 1 to line 2, so the first transaction record starts at line 3.
- Core columns, data types and file layout remain unchanged aside from the added informational row.
- Scripts using csv.DictReader or similar that assume headers on line 1 will mis‑align data and generate accounting mismatches.
Recommended Actions
- →In Seller Central or your code repository, open the parser that consumes GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2 files and add a check: if the f...
- →Extract the GST number from the first line (e.g., split on "GST No.") and store/compare it with your bookkeeping system’s GST ID.
- →Run a test download via the SP‑API console, verify row 1 is the address line, row 2 is the header, and re‑process the file to confirm no errors.
Comments
Join the discussion
Log in or create an account to share your thoughts on this update.
No comments yet. Be the first to share your thoughts!