Ebay/Paypal purchases

[Eaglesrjh]

Hi

I purchase a good amount of my stock for sale from Ebay and pay direct from my paypal balance.

The paypal feed pulls these purchases through but leaves them untagged.

Is there any way of logging these purchase automatically against a supplier? The problem I guess is that every single one has a totally different reference name.

It correctly logs sales and fees but not purchases.

any help greatly appreciated.

[QFMathew]

Hi @Eaglesrjh

Unfortunately, there’s no way to automatically tag them against a purchase using the feed settings.

I’m not able to test it, but perhaps the bank tagging rules could work? If there’s a common word for each supplier (for example, their name), you may be able to set up the bank tagging rule to create a purchase and tag it automatically.

What I’m unsure about is whether this actually applies to the PayPal feed or whether it’s just statement upload/manual input. I’ll ask my colleague about this and will confirm whether this would work or not.

[Glenn]

Bank tagging rules should work fine for PayPal as it’s treated like any other bank account in QuickFile. The PayPal feed only supports auto-tagging of sales, not purchases so bank tagging rules would be the way to go here.

[Eaglesrjh]

thanks, how would i create the bank tag though, every purchase is different, nothing in common.

i.e one reference name would be like

Paul Hope ((0BB324195K633421T)

the next one would be

Craig Woods ((5YF42905ER494025S))

so nothing in common to tag.

[QFMathew]

Hi @Eaglesrjh

If they are regular suppliers, then the names would be the common thing, e.g. money out to ‘Craig Woods’ would create a purchase for Craig Woods.

If there isn’t anything in common, then unfortunately it’s not possible. The system wouldn’t know who they are for, or what they are for to do anything with them.

[Eaglesrjh]

ok thanks, sadly they are most often one off suppliers so will just have to keep doing it manually

[Glenn]

You can still bulk tag all these entries (Max 50 at a time) to a single supplier from the bank screen. That should save a bit of time.

[Eaglesrjh]

ooh how do i do that!

[Glenn]

First you can isolate all the debits using the “Advanced Search” box:

Select all items:

Then click the bulk tag option:

Then choose the option “Payments to the same supplier”:

Then just follow the options to select a supplier and set any VAT (if applicable).

[Eaglesrjh]

perfect, that will help a lot.

Thanks.