cancel
Showing results for 
Search instead for 
Did you mean: 
1010907
Level 2

Accurately recording upfront payment and recognizing revenue as shipped

Looking for suggestions on how to accurately account for an ecommerce order using accrual based accounting in the following scenario:

 

  1. We make a sale on 5/1/2020 on our web site and receive payment via a credit card for $100.
  2. We ship part of the order on 5/2/2020 worth $75
  3. We ship the remaining part of the order on 6/10/2020 once the out of stock inventory comes in worth $25.

From an accounting standpoint we want:

  1. Record the merchant account deposit of $100 so we can reconcile that bank account accurately
  2. On the P&L, recognize the revenue as it is shipped, so $75 on 5/2 and $25 on 6/10
  3. Reduce the on hand inventory by the sold quantity on the respective ship dates...i.e. if we ship 6 units on 5/2 and 2 units on 6/10 have the balance sheet reflect the inventory decrements on those days. So if we had a fire in the warehouse on 6/9, we'd know what our inventory asset account was in an accurate way that had the 6 units gone already, but the 2 units still in the warehouse, and hence destroyed.

 

4 Comments 4
Rustler
Level 15

Accurately recording upfront payment and recognizing revenue as shipped

The way it works in accounting is that the sale is made as of the date of the invoice or sales receipt.

That determines when you reduce inventory according to the item used on the invoice, and when income is posted. You received payment in full, as a result you have income as of that date.

Then you ship the items

1010907
Level 2

Accurately recording upfront payment and recognizing revenue as shipped

accidental duplicate post

1010907
Level 2

Accurately recording upfront payment and recognizing revenue as shipped

@Rustler thanks for taking the time to reply, but that doesn't really answer my question. This is a more complex requirement then that. 

 

We need something along the lines of:

 

A sales receipt that just debits a deferred revenue current liability account and credits a revenue account. This will record the cash deposit to the correct payment account to be reconciled.

 

Then an invoice that represents each fulfillment against that order and in turn reduce that inventory as well as credit deferred revenue.

Rustler
Level 15

Accurately recording upfront payment and recognizing revenue as shipped

Create a service item for the deposit which links to the deferred income account and use that to record the deposit.
That will allow for a deposit to the bank

 

Issue each invoice for the parts shipped, as the last item on each invoice use the deposit item, qty is negative one, and the partial amount. That pays for the items using the amount in the deferred income account, posts the sales amount to income from the parts sold, reduces inventory and posts inventory costs

Need to get in touch?

Contact us