Share this content
0
700

Stock Quantities on Bank Feeds to Online Software

Stock Quantities on Bank Feeds to Online Software

Didn't find your answer?

Search AccountingWEB

PayPal transaction downloads (csv) contain stock item numbers and quantities sold.

But do any of the online accounting software providers accept these stock item numbers and quantities sold for reporting and stock level adjustments?

Replies

Please login or register to join the discussion.

avatar
03rd May 2018 13:10

Unlikely, I would have thought, as bank payment could be well before (proforma) or after (x days credit) the stock movement.

If that doesn't matter to you I would find a way (excel) of turning the csv into a stock journal that you can import into your system

F

Thanks (0)
avatar
03rd May 2018 13:36

Thanks @ WhichTyler

We won't be using the csv, I'm just aware that the stock details are on it (from other clients).

We intend to use the regular PayPal feed direct to the online software, but eg. QuickBooks Online doesn't appear to receive the stock details.

Thanks (0)
avatar
to Gone Sailing
03rd May 2018 13:46

Gone Sailing wrote:

Thanks @ WhichTyler

We won't be using the csv

Your call...

Or you could start at the other end with something like Shopify handling the sales & stock movements, then settling via paypal?

Thanks (0)
avatar
to WhichTyler
03rd May 2018 14:02

Yes, "something like Shopify" is under construction, but there are historic Ebay/PayPal sales which I would like to process fully.

Thanks (0)
avatar
03rd May 2018 14:11

With thanks @WhichTyler

I would like to return to the original question, reworded:

Do any of the online accounting software providers accept stock item numbers and quantities sold [ie. from the bank feeds.] for reporting and stock level adjustments?

As @WhichTyler identifies, such a feed process would need to include the (cost of sales) stock journal.

Thanks (0)
Share this content