I'm wondering how others record their Amazon FBA transactions.
Do you record one invoice per month?
For example,
Should the "unavailable balance" line in the Settlement Report the equivalent of net A/R from Amazon?
Or do you use 1 cash sale per settlement report and then debit it to an cash holding account?
p
Pete Kastner
05/15/2023, 12:22 PM
We use Celigo and post 300-400 invoices per day.
l
Luis
05/15/2023, 12:25 PM
How do you deal with refunds, fees and settled cash?
Do you record refunds as CMs or cash refunds? Do you use the actual inventory items for these?
Where do you record the fees? As CMs? Or as part of customer payments?
p
Pete Kastner
05/15/2023, 12:30 PM
Refunds we record as cash refunds. we do use the actual inventory items.
When we do the Settlement, Celigo has a custom record for the Settlement, and posts the payments and fee's. for the fee's there is a Journal entry as part of the settlement.
l
Luis
05/15/2023, 12:33 PM
So if I understand it correctly, invoices and cash refunds are recorded at GROSS amounts. The fees or refunds of fees are recorded collectively via a JE. So the customer payments are recorded at gross as well and are applied to invoices. Does this sound right?
Luis
05/15/2023, 12:34 PM
When you record the cash refunds, you use the inventory items. Is that because your customers always return the SKUs? Or was it just an assumption? And then you just create an inventory adjustment to correct the inventory stock at some point?
p
Pete Kastner
05/15/2023, 1:30 PM
The Amazon returns include if the item is being restock. "detailed-disposition": "SELLABLE",