Once you complete the Amazon Import, what do you do with the actual credit card transactions?

Google Sheets
,
1

Hi -

So I just did my first Amazon import - YAY! - Merry Christmas to me!

I see all of the new entries, example below:

|12/14/2020|[Amazon Order] 112-6837942-9696201 (2 items)|Transfer|$110.73|||Amazon|
|12/14/2020|[Amazon Item] Thorne Research - B-Complex #12 - Vitamin B Complex with Active B12 and Folate - 60 Capsules||-$18.72|Visa - 8422||Amazon|
|12/14/2020|[Amazon Item] Brooks Women’s Ravenna 11||-$92.01|Visa - 8422||Amazon|

At first, I thought that the importer matched the charge amount and removed the “offset” credit card transaction, but then I looked further and found the 2 entries a few days later:

12/16/2020 Purchase Authorized on 12/14 Amzn Mktp Uso5634 Unknown Amazon Payment Charges - Amazon Customer Service WA Sx4543 Card 8422 -$92.01 PREFERRED CHECKING
12/18/2020 Purchase Authorized on 12/14 Amzn Mktp Us4a3sc Unknown Amazon Payment Charges - Amazon Customer Service WA Sx2549 Card 8422 -$18.72 PREFERRED CHECKING

Leads to my question - what is the best practice here? I want the amazon import workflow bc it tells me all the details but I don’t want duplicate transactions.

I dont need the credit card transaction anymore…or do I?

Do you leave the credit card transaction category or give it a hidden category for reporting and then categorize the Amazon ones?

I assume there is an AUTOCAT process to be ran

Thank you!

2

I believe the ‘recommended’ process is to change the original credit card charge to ‘Transfer’. The ‘Amazon Order’ transaction should also be ‘Transfer’, which allows them to cancel each other out as far as budgeting goes. You can then categorize the individual items with real, useful categories, and your budgets will then be happy.

3 Likes