Skip to content
This repository has been archived by the owner on Jul 26, 2023. It is now read-only.

Gift Wrap is not accounted for #20

Closed
joeunrue opened this issue Jan 7, 2021 · 6 comments · Fixed by #22
Closed

Gift Wrap is not accounted for #20

joeunrue opened this issue Jan 7, 2021 · 6 comments · Fixed by #22
Labels
bug Something isn't working released

Comments

@joeunrue
Copy link

joeunrue commented Jan 7, 2021

I ran the sync for the last 30 days and it got some of my Christmas gifts in the mix but the gift wrap was not added in anywhere. I had to go back and add separate line items to make my accounts reconcile.

I don't know if this is possible to add given that it does not show up in the order export from amazon, but it would be a great to have before next Christmas!

@starsprung
Copy link
Owner

If it's not in the reports it may be a little tricky. I don't have any orders with gift wrapping on my account, would you be able to share any excerpts from your reports so I can take a look? You can send them privately to [email protected] if you're willing (feel free to redact any sensitive information). The Orders and Shipments reports would likely be the one I'd need.

@joeunrue
Copy link
Author

joeunrue commented Jan 7, 2021

I just went ahead and redacted what needed redacted and attached my Christmas Shopping list. I don't see anything that would indicate gift wrap was purchased, as it was on items 2-4, the toy car, the socks, and Animal Crossing.

01-Dec-2020_to_01-Jan-2021.zip

@starsprung
Copy link
Owner

starsprung commented Jan 7, 2021

Thanks! Would it be possible to see the "Orders and shipments" report type for the same time period too? I suspect even if there's no specific mention of a wrapping charge, the wrapping would at least be reflected in the order total and could be reflected as a "miscellaneous adjustment" in YNAB if there is any difference between that number and sum of the items + promotions + shipping.

@joeunrue
Copy link
Author

joeunrue commented Jan 7, 2021

Sorry, my mistake. Here is the orders and shipments form.

There doesn't seem to be a specific column for gift wrap, but the Total Charged column is correct
08-Dec-2020_to_07-Jan-2021.zip

It looks like the Gift Wrap is included in the Total Charged amount and can be approximated by subtracting the other columns from the Total Charged column, though it is a per-shipment amount and not a per-item amount. Still that would be more helpful than nothing

@starsprung
Copy link
Owner

Right, it's harder to get the per-item values correct, but the account total would at least reconcile without adding entries manually. I do plan to look into the possibility of adding an option to attribute discounts and shipping to individual items proportionally (#18) and this would be a another charge that could also be handled that way. There's no 100% accurate way to do it though, so that options would come with the caveat that it's only an estimate.

@starsprung starsprung added the bug Something isn't working label Jan 8, 2021
starsprung added a commit that referenced this issue Jan 9, 2021
…ft wrapping)

Currently certain fees such as gift wrapping are not accounted for, as they aren't listed as an
individual line-item or a separate charge anywhere in the reports. As a workaround, include
unaccounted-for difference in the item totals + shipping + promotions total as a "Misc adjustment"
line item.

fix #20
starsprung added a commit that referenced this issue Jan 9, 2021
…ft wrapping)

Currently certain fees such as gift wrapping are not accounted for, as they aren't listed as an
individual line-item or a separate charge anywhere in the reports. As a workaround, include
unaccounted-for difference in the item totals + shipping + promotions total as a "Misc adjustment"
line item.

fix #20
starsprung added a commit that referenced this issue Jan 9, 2021
…ft wrapping)

Currently certain fees such as gift wrapping are not accounted for, as they aren't listed as an
individual line-item or a separate charge anywhere in the reports. As a workaround, include
unaccounted-for difference in the item totals + shipping + promotions total as a "Misc adjustment"
line item.

fix #20
github-actions bot pushed a commit that referenced this issue Jan 9, 2021
## [1.4.8](v1.4.7...v1.4.8) (2021-01-09)

### Bug Fixes

* **amazon.ts:** account for missing miscellaneous ajustments (e.g. gift wrapping) ([6d7dba4](6d7dba4)), closes [#20](#20)
@github-actions
Copy link

github-actions bot commented Jan 9, 2021

🎉 This issue has been resolved in version 1.4.8 🎉

The release is available on:

Your semantic-release bot 📦🚀

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working released
Projects
None yet
2 participants