Celigo Amazon Settlement Flow – How to change clearing account lines in Journal Entry

Integration Apps
,
1

We have implemented the Amazon - NetSuite integration app..

We are wondering if it’s possible to make this change in the Settlement flow? If so, where would we make this change? Has anyone else encountered this before?

“When looking at the clearing account register, the end result is basically $0 with a small rounding error. We recorded the bank payment against the clearing account in JE### and the invoice payment against the clearing account in PYMT###. However, Celigo's record of Amazon's fees is a bit messy in JE###. Ideally we just see one line for $55.92 recorded against the clearing account rather than $699 less $643.08.

image
image1134×374 80.6 KB

When we look at the settlement summary, we can see why the journal entry was built that way. We were hoping if there's another way to consolidate the clearing account entry in JE###?

image
image1508×201 19.8 KB

Thanks for you guidance/input.

2

Hi Allison,

Thank you for reaching out.

If you’re asking whether it’s possible to consolidate the two clearing account lines in the Journal Entry created by the Settlement flow into a single line, unfortunately, this isn’t available out of the box.

The Settlement flow builds the Journal Entry this way because it reads the Amazon Settlement Report as Amazon provides it. In the report, Amazon separates the gross sales amount and the fees, so the Settlement flow records them as separate lines in the Journal Entry.

From what I’ve seen with other customers, most implementations keep this structure so the entries in NetSuite stay aligned with the Amazon settlement reports and are easier to reconcile.

Please let me know if you have any questions.

1 Like