Skip to main content

GORILLA_FINANCESTYPE() - Returns the list of finance types in your account

Returns the list of finance types in your account

Sample Usage

🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for
quicker results and to prevent Google from blocking your account for
24 hrs due to overloading their resources. 
=GORILLA_FINANCESTYPE("TOY STORE")
=GORILLA_FINANCESTYPE("TOY STORE", "US", "SHIP" , "Column", "No")

Syntax Description

Syntax:

=GORILLA_FINANCESTYPE(Seller ID, [marketplace], [filter_finance], [direction],
 [full_list], [transaction_type])

seller ID – REQUIRED:
Enter the seller ID or nickname you entered in your Gorilla account.

marketplace – OPTIONAL:
Marketplace filter. Use Default for the seller default. Other valid values are country codes US, IT, etc.

filter_finance – OPTIONAL:
​​Enter a string to filter for a particular list of finance.

direction – OPTIONAL:
Default is “column” if nothing is entered. It will return the list in a column. Use “row” to get the result in a horizontal row.

full_list – OPTIONAL:
​​Default is “no” so that it only displays the fees associated with your account. To see the FULL list of fees that Amazon takes, enter “yes”. This will list transactions that are also not part of your account.

transaction_type – OPTIONAL
Return data for a specific transaction type. Default is an empty value for any transaction type. Other Valid values are: Shipment, Refund, Removalshipment, Debtrecovery, ServiceFee and Other.

List of Finance types by Amazon

For the latest list, enter =GORILLA_FINANCESTYPE(“TOY STORE”, , , , “yes”).

  • AdhocDisbursement-Expenses

  • AdhocDisbursement-Expenses-MicroDeposit

  • AdhocDisbursement-Sales

  • AdhocDisbursement-Sales-MicroDepositFailed

  • Adjustment-Expenses

  • Adjustment-Expenses-CrossAccountDebtAdjustment

  • Adjustment-Expenses-Other-Other

  • Adjustment-Expenses-Other-PostageBilling_CongestionCharge

  • Adjustment-Expenses-Other-PostageBilling_DeliveryAreaSurcharge

  • Adjustment-Expenses-Other-PostageBilling_FuelSurcharge

  • Adjustment-Expenses-Other-PostageBilling_OversizeSurcharge

  • Adjustment-Expenses-Other-PostageBilling_VAT

  • Adjustment-Expenses-Other-ReturnPostageBilling_DeliveryAreaSurcharge

  • Adjustment-Expenses-Other-ReturnPostageBilling_FuelSurcharge

  • Adjustment-Expenses-Other-ReturnPostageBilling_OversizeSurcharge

  • Adjustment-Expenses-Other-ReturnPostageBilling_Postage

  • Adjustment-Expenses-Other-ReturnPostageBilling_VAT

  • Adjustment-Expenses-RecommerceLiquidation

  • Adjustment-Expenses-ReserveDebit-ReserveDebit

  • Adjustment-Expenses-ShippingServiceChargebacks-PostageBilling_PostageAdjustment

  • Adjustment-Expenses-ShippingServiceChargebacks-PostageBilling_VAT

  • Adjustment-Expenses-ShippingServiceCharges-AmazonShippingCharges

  • Adjustment-Expenses-ShippingServiceCharges-PostageBilling_Insurance

  • Adjustment-Expenses-ShippingServiceCharges-PostageBilling_Postage

  • Adjustment-Expenses-ShippingServiceCharges-PostageBilling_SignatureConfirmation

  • Adjustment-Expenses-Tax

  • Adjustment-Sales

  • Adjustment-Sales-AmazonFees

  • Adjustment-Sales-CrossAccountDebtAdjustment

  • Adjustment-Sales-FailedDisbursement

  • Adjustment-Sales-Other

  • Adjustment-Sales-Reimbursements

  • Adjustment-Sales-ReserveCredit

  • Adjustment-Sales-SAFETReimbursement

  • Adjustment-Sales-SellerReward

  • Adjustment-Sales-ShippingServiceChargebacks

  • Adjustment-Sales-ShippingServiceRefunds

  • ChargebackRefund-Refunded Expenses

  • ChargebackRefund-Refunded Expenses-AmazonFees

  • ChargebackRefund-Refunded Expenses-DigitalServicesFee

  • ChargebackRefund-Refunded Expenses-Other

  • ChargebackRefund-Refunded Expenses-Tax

  • ChargebackRefund-Refunded Sales

  • ChargebackRefund-Refunded Sales-ProductCharges

  • ChargebackRefund-Refunded Sales-Shipping

  • ChargebackRefund-Refunded Sales-Tax

  • DebtRecovery-DebtPayment

  • FBAInventoryReimbursement-Expenses

  • FBAInventoryReimbursement-Expenses-FBAReversedReimbursement-COMPENSATED_CLAWBACK

  • FBAInventoryReimbursement-Expenses-FBAReversedReimbursement-MISSING_FROM_INBOUND_CLAWBACK

  • FBAInventoryReimbursement-Expenses-FBAReversedReimbursement-PAYMENT_RETRACTION_ITEMS

  • FBAInventoryReimbursement-Sales

  • FBAInventoryReimbursement-Sales-AWDInventoryReimbursement

  • FBAInventoryReimbursement-Sales-BwPInventoryReimbursement

  • FBAInventoryReimbursement-Sales-FBAInventoryReimbursement

  • FBAInventoryReimbursement-Sales-MCFInventoryReimbursement

  • FBAInventoryReimbursement-Sales-Other

  • FTBalanceDeduction-Expenses-AmazonShippingDeduction

  • FTBalanceDeduction-Expenses-TransparencyInvoiceDeduction

  • FTBalanceDeduction-Sales

  • GuaranteeClaimRefund-Refunded Expenses

  • GuaranteeClaimRefund-Refunded Expenses-AmazonFees

  • GuaranteeClaimRefund-Refunded Expenses-DigitalServicesFee

  • GuaranteeClaimRefund-Refunded Expenses-Other

  • GuaranteeClaimRefund-Refunded Expenses-PromoRebates

  • GuaranteeClaimRefund-Refunded Sales

  • GuaranteeClaimRefund-Refunded Sales-Other

  • GuaranteeClaimRefund-Refunded Sales-ProductCharges

  • GuaranteeClaimRefund-Refunded Sales-Shipping

  • GuaranteeClaimRefund-Refunded Sales-Tax

  • MiscellaneousLedgerAdjustment-Expenses

  • MiscellaneousLedgerAdjustment-Expenses-Other-BuyerRecharge

  • MiscellaneousLedgerAdjustment-Expenses-Other-ChargeBackRecovery

  • MiscellaneousLedgerAdjustment-Expenses-Other-DisbursementCorrection

  • MiscellaneousLedgerAdjustment-Expenses-Other-MiscAdjustment

  • MiscellaneousLedgerAdjustment-Sales

  • MiscellaneousLedgerAdjustment-Sales-Other

  • PayWithAmazon-Expenses-CrossBorderFees

  • PayWithAmazon-Expenses-FixedFees

  • PayWithAmazon-Expenses-ProductCharges

  • PayWithAmazon-Expenses-VariableFees

  • PayWithAmazon-Sales

  • PayWithAmazon-Sales-CrossBorderFees

  • PayWithAmazon-Sales-ProductCharges

  • PayWithAmazon-Sales-VariableFees

  • ProductAdsPayment-Expenses

  • ProductAdsPayment-Expenses-AdvertisingFee

  • ProductAdsPayment-Sales

  • ProductAdsPayment-Sales-AdvertisingFeeRefund

  • Refund-AmazonFees-AmazonForAllFee-Base

  • Refund-AmazonFees-AmazonForAllFee-Tax

  • Refund-AmazonFees-CODChargeback-Base

  • Refund-AmazonFees-CODChargeback-Tax

  • Refund-AmazonFees-Commission-Base

  • Refund-AmazonFees-Commission-Promo

  • Refund-AmazonFees-Commission-Tax

  • Refund-AmazonFees-FixedClosingFee-Base

  • Refund-AmazonFees-FixedClosingFee-Tax

  • Refund-AmazonFees-GetPaidFasterFee-Base

  • Refund-AmazonFees-GiftwrapChargeback-Base

  • Refund-AmazonFees-GiftwrapChargeback-Tax

  • Refund-AmazonFees-PanAmericasChargebackFee-Base

  • Refund-AmazonFees-PremiumExperienceFee-Base

  • Refund-AmazonFees-RefundCommission-Base

  • Refund-AmazonFees-RefundCommission-Tax

  • Refund-AmazonFees-RemoteFulfillmentCredit-Base

  • Refund-AmazonFees-RemoteFulfillmentCredit-Tax

  • Refund-AmazonFees-ShippingChargeback-Base

  • Refund-AmazonFees-ShippingChargeback-Tax

  • Refund-AmazonFees-ShippingHB-Base

  • Refund-AmazonFees-ShippingHB-Tax

  • Refund-AmazonFees-VariableClosingFee-Base

  • Refund-AmazonFees-VariableClosingFee-Tax

  • Refund-ChemicalTax-ChemicalTaxRegulatoryFee

  • Refund-DigitalServicesFee-DigitalServicesFee-Base

  • Refund-DigitalServicesFee-DigitalServicesFee-Tax

  • Refund-MPFRegulatoryFee-OurPriceRegulatoryFee

  • Refund-Other-GiftwrapPrincipal

  • Refund-Other-GiftwrapPrincipalFBM

  • Refund-Other-GoodwillPrincipal

  • Refund-Other-GoodwillPrincipalFBM

  • Refund-Other-PaymentMethodFeePrincipal

  • Refund-Other-PaymentMethodFeePrincipalFBM

  • Refund-Other-PointsDeductionPrincipal

  • Refund-Other-PointsDeductionPrincipalFBM

  • Refund-Other-RestockingDeductionPrincipal

  • Refund-Other-RestockingDeductionPrincipalFBM

  • Refund-Other-ReturnShippingDeductionPrincipal

  • Refund-Other-ReturnShippingDeductionPrincipalFBM

  • Refund-Other-ReturnShippingPrincipal

  • Refund-Other-ReturnShippingPrincipalFBM

  • Refund-Points-PointsReclaimed

  • Refund-ProductCharges-OurPricePrincipal

  • Refund-ProductCharges-OurPricePrincipalFBM

  • Refund-PromoRebates-OurPriceDiscount

  • Refund-PromoRebates-ShippingDiscount

  • Refund-Shipping-ShippingPrincipal

  • Refund-Shipping-ShippingPrincipalFBM

  • Refund-Tax-GiftwrapTax

  • Refund-Tax-LowValueGoodsTax-Other

  • Refund-Tax-LowValueGoodsTax-Principal

  • Refund-Tax-LowValueGoodsTax-PrincipalFBM

  • Refund-Tax-LowValueGoodsTax-Shipping

  • Refund-Tax-MarketplaceFacilitatorRegulatoryFee-Principal

  • Refund-Tax-MarketplaceFacilitatorRegulatoryFee-PrincipalFBM

  • Refund-Tax-MarketplaceFacilitatorTax-Other

  • Refund-Tax-MarketplaceFacilitatorTax-Principal

  • Refund-Tax-MarketplaceFacilitatorTax-PrincipalFBM

  • Refund-Tax-MarketplaceFacilitatorTax-Shipping

  • Refund-Tax-MarketplaceFacilitatorVAT-Principal

  • Refund-Tax-MarketplaceFacilitatorVAT-PrincipalFBM

  • Refund-Tax-MarketplaceFacilitatorVAT-Shipping

  • Refund-Tax-OurPriceTax

  • Refund-Tax-OurPriceTaxDiscount

  • Refund-Tax-RestockingDeductionTax

  • Refund-Tax-ReturnShippingDeductionTax

  • Refund-Tax-ShippingTax

  • Refund-Tax-ShippingTaxDiscount

  • Refund-TaxCollectedAtSource-TCS-CGST

  • Refund-TaxCollectedAtSource-TCS-IGST

  • Refund-TaxCollectedAtSource-TCS-SGST

  • RemovalShipment-Expenses

  • RemovalShipment-Expenses-AmazonFees-LiquidationProcessingFee

  • RemovalShipment-Expenses-AmazonFees-LiquidationReferralFee

  • RemovalShipment-Expenses-Other

  • RemovalShipment-Sales-RecommerceLiquidation

  • RemovalShipment-Sales-Tax

  • Retrocharge-Retrocharge-BaseTax

  • Retrocharge-Retrocharge-ShippingTax

  • Retrocharge-Tax-LowValueGoodsTax-Principal

  • Retrocharge-Tax-LowValueGoodsTax-Shipping

  • Retrocharge-Tax-MarketplaceFacilitatorTax-Principal

  • Retrocharge-Tax-MarketplaceFacilitatorTax-Shipping

  • Retrocharge-Tax-MarketplaceFacilitatorVAT-Principal

  • Retrocharge-Tax-MarketplaceFacilitatorVAT-Shipping

  • SellerPoweredCoupon-Expenses-CouponFee

  • SellerPoweredCoupon-Sales

  • ServiceCharge-Expenses

  • ServiceCharge-Sales-SupplyChainCreditRollUp

  • ServiceFee - Correction-Expenses-AmazonUpstreamProcessingFee

  • ServiceFee - Correction-Expenses-AmazonUpstreamStorageTransportationFee

  • ServiceFee - Correction-Expenses-AWDMcdTransportationFeeStatementRollUp

  • ServiceFee - Correction-Expenses-CouponPerformanceFeeRollup

  • ServiceFee - Correction-Expenses-FBAFees

  • ServiceFee - Correction-Expenses-InboundConvenienceCharge

  • ServiceFee - Correction-Expenses-InboundTransportationFee

  • ServiceFee - Correction-Expenses-LongTermStorageFee

  • ServiceFee - Correction-Expenses-PaidServicesCharge

  • ServiceFee - Correction-Expenses-StorageBillingFee

  • ServiceFee - Correction-Sales

  • ServiceFee - Reversal-Expenses

  • ServiceFee - Reversal-Sales-AmazonUpstreamProcessingFee

  • ServiceFee - Reversal-Sales-AmazonUpstreamStorageTransportationFee

  • ServiceFee - Reversal-Sales-AWDMcdTransportationFeeStatementRollUp

  • ServiceFee - Reversal-Sales-CouponPerformanceFeeRollup

  • ServiceFee - Reversal-Sales-FBAFees

  • ServiceFee - Reversal-Sales-InboundConvenienceCharge

  • ServiceFee - Reversal-Sales-InboundTransportationFee

  • ServiceFee - Reversal-Sales-LongTermStorageFee

  • ServiceFee - Reversal-Sales-PaidServicesCharge

  • ServiceFee - Reversal-Sales-StorageBillingFee

  • ServiceFee - Reversal-Sales-UnplannedServiceCharge

  • ServiceFee-AmazonFees-BubblewrapFee-Base

  • ServiceFee-AmazonFees-BubblewrapFee-Tax

  • ServiceFee-AmazonFees-CouponParticipationFeeRollup-CouponParticipationFee-Base

  • ServiceFee-AmazonFees-CouponParticipationFeeRollup-CouponParticipationFee-Tax

  • ServiceFee-AmazonFees-CouponPerformanceFeeRollup-CouponPerformanceFee-Base

  • ServiceFee-AmazonFees-CouponPerformanceFeeRollup-CouponPerformanceFee-Promo

  • ServiceFee-AmazonFees-CouponPerformanceFeeRollup-CouponPerformanceFee-Tax

  • ServiceFee-AmazonFees-DealParticipationFeeRollup-DealParticipationFee-Base

  • ServiceFee-AmazonFees-DealParticipationFeeRollup-DealParticipationFee-Promo

  • ServiceFee-AmazonFees-DealParticipationFeeRollup-DealParticipationFee-Tax

  • ServiceFee-AmazonFees-DealPerformanceFeeRollup-DealPerformanceFee-Base

  • ServiceFee-AmazonFees-DealPerformanceFeeRollup-DealPerformanceFee-Tax

  • ServiceFee-AmazonFees-EPRChargebackEcoFee-Base

  • ServiceFee-AmazonFees-EPRChargebackEcoFee-Tax

  • ServiceFee-AmazonFees-EPRChargebackServiceFee-Base

  • ServiceFee-AmazonFees-EPRChargebackServiceFee-Tax

  • ServiceFee-AmazonFees-FBACustomerReturnPerUnitFee-Base

  • ServiceFee-AmazonFees-FBACustomerReturnPerUnitFee-Promo

  • ServiceFee-AmazonFees-FBACustomerReturnPerUnitFee-Tax

  • ServiceFee-AmazonFees-FBADisposalFee-Base

  • ServiceFee-AmazonFees-FBADisposalFee-Promo

  • ServiceFee-AmazonFees-FBADisposalFee-Tax

  • ServiceFee-AmazonFees-FBAInboundConvenienceFee-Base

  • ServiceFee-AmazonFees-FBAInboundConvenienceFee-Promo

  • ServiceFee-AmazonFees-FBAInboundDefectFee-Base

  • ServiceFee-AmazonFees-FBAInboundShipmentCartonLevelInfoFee-Base

  • ServiceFee-AmazonFees-FBAInboundTransportationFee-Base

  • ServiceFee-AmazonFees-FBAInboundTransportationFee-Promo

  • ServiceFee-AmazonFees-FBAInboundTransportationFee-Tax

  • ServiceFee-AmazonFees-FBAInboundTransportationProgramFee-Base

  • ServiceFee-AmazonFees-FBAInboundTransportationProgramFee-Promo

  • ServiceFee-AmazonFees-FBAInboundTransportationProgramFee-Tax

  • ServiceFee-AmazonFees-FBAInternationalInboundFreightFee-Base

  • ServiceFee-AmazonFees-FBAInternationalInboundFreightTaxAndDuty-Base

  • ServiceFee-AmazonFees-FBALongTermStorageFee-Base

  • ServiceFee-AmazonFees-FBALongTermStorageFee-Tax

  • ServiceFee-AmazonFees-FBAPerUnitFulfillmentFee-Base

  • ServiceFee-AmazonFees-FBAPerUnitFulfillmentFee-Tax

  • ServiceFee-AmazonFees-FBARemovalFee-Base

  • ServiceFee-AmazonFees-FBARemovalFee-Promo

  • ServiceFee-AmazonFees-FBARemovalFee-Tax

  • ServiceFee-AmazonFees-FBAStorageFee-Base

  • ServiceFee-AmazonFees-FBAStorageFee-Tax

  • ServiceFee-AmazonFees-FBAWeightBasedFee-Base

  • ServiceFee-AmazonFees-FBAWeightBasedFee-Tax

  • ServiceFee-AmazonFees-GlobalInboundTransportationDuty-Base

  • ServiceFee-AmazonFees-GlobalInboundTransportationFreight-Base

  • ServiceFee-AmazonFees-LabelingFee-Base

  • ServiceFee-AmazonFees-LabelingFee-Tax

  • ServiceFee-AmazonFees-MFNPostageFee-Base

  • ServiceFee-AmazonFees-MFNPostageFee-Promo

  • ServiceFee-AmazonFees-MFNPostageFee-Tax

  • ServiceFee-AmazonFees-MFNShippingChargeback-Base

  • ServiceFee-AmazonFees-MFNShippingChargeback-Tax

  • ServiceFee-AmazonFees-OpaqueBaggingFee-Base

  • ServiceFee-AmazonFees-OpaqueBaggingFee-Tax

  • ServiceFee-AmazonFees-OrderCancellationCharge-Base

  • ServiceFee-AmazonFees-OrderCancellationCharge-Tax

  • ServiceFee-AmazonFees-PaidServicesCharge-PaidServicesFee-Base

  • ServiceFee-AmazonFees-PaidServicesCharge-PaidServicesFee-Tax

  • ServiceFee-AmazonFees-PaidServicesFee-Base

  • ServiceFee-AmazonFees-PaidServicesFee-Tax

  • ServiceFee-AmazonFees-PolybaggingFee-Base

  • ServiceFee-AmazonFees-PolybaggingFee-Tax

  • ServiceFee-AmazonFees-Subscription-Base

  • ServiceFee-AmazonFees-Subscription-Tax

  • ServiceFee-AmazonFees-VineEnrollmentFee-VineFee-Base

  • ServiceFee-AmazonFees-VineEnrollmentFee-VineFee-Promo

  • ServiceFee-AmazonFees-VineEnrollmentFee-VineFee-Tax

  • ServiceFee-DigitalServicesFee-DigitalServicesFee-Base

  • ServiceFee-DigitalServicesFee-DigitalServicesFee-Tax

  • ServiceFee-FBAFees-AmazonUpstreamProcessingFee-Base

  • ServiceFee-FBAFees-AmazonUpstreamProcessingFee-Promo

  • ServiceFee-FBAFees-AmazonUpstreamStorageTransportationFee-Base

  • ServiceFee-FBAFees-AmazonUpstreamStorageTransportationFee-Promo

  • ServiceFee-FBAFees-AWDMcdTransportationFeeStatementRollUp-AWDMcdTransportationFee-Base

  • ServiceFee-FBAFees-AWDStorageFees-STARStorageFee-Base

  • ServiceFee-FBAFees-AWDStorageFees-STARStorageFee-Promo

  • ServiceFee-FBAFees-FBACustomerReturnPerUnitFee-Base

  • ServiceFee-FBAFees-FBACustomerReturnPerUnitFee-Promo

  • ServiceFee-FBAFees-FBACustomerReturnPerUnitFee-Tax

  • ServiceFee-FBAFees-FBADisposalFee-Base

  • ServiceFee-FBAFees-FBADisposalFee-Promo

  • ServiceFee-FBAFees-FBADisposalFee-Tax

  • ServiceFee-FBAFees-FBAInboundConvenienceFee-Base

  • ServiceFee-FBAFees-FBAInboundConvenienceFee-Promo

  • ServiceFee-FBAFees-FBAInboundDefectFee-Base

  • ServiceFee-FBAFees-FBAInboundShipmentCartonLevelInfoFee-Base

  • ServiceFee-FBAFees-FBARemovalFee-Base

  • ServiceFee-FBAFees-FBARemovalFee-Promo

  • ServiceFee-FBAFees-FBARemovalFee-Tax

  • ServiceFee-FBAFees-HRRNonApparelRollup-CustomerReturnHRRUnitFee-Base

  • ServiceFee-FBAFees-HRRNonApparelRollup-CustomerReturnHRRUnitFee-Tax

  • ServiceFee-FBAFees-InboundConvenienceCharge-FBAInboundConvenienceFee-Base

  • ServiceFee-FBAFees-InboundConvenienceCharge-FBAInboundConvenienceFee-Promo

  • ServiceFee-FBAFees-InboundTransportationFee-FBAInboundTransportationFee-Base

  • ServiceFee-FBAFees-InboundTransportationFee-FBAInboundTransportationFee-Promo

  • ServiceFee-FBAFees-InboundTransportationFee-FBAInboundTransportationFee-Tax

  • ServiceFee-FBAFees-InboundTransportationFee-FBAInboundTransportationProgramFee-Base

  • ServiceFee-FBAFees-InboundTransportationFee-FBAInboundTransportationProgramFee-Promo

  • ServiceFee-FBAFees-InboundTransportationFee-FBAInboundTransportationProgramFee-Tax

  • ServiceFee-FBAFees-LabelingFee-Base

  • ServiceFee-FBAFees-LabelingFee-Tax

  • ServiceFee-FBAFees-LongTermStorageFee-FBALongTermStorageFee-Base

  • ServiceFee-FBAFees-LongTermStorageFee-FBALongTermStorageFee-Tax

  • ServiceFee-FBAFees-MCCFReturnFeeStatementRollUp-MCCFReturnFee-Base

  • ServiceFee-FBAFees-OpaqueBaggingFee-Base

  • ServiceFee-FBAFees-OpaqueBaggingFee-Tax

  • ServiceFee-FBAFees-PolybaggingFee-Base

  • ServiceFee-FBAFees-PolybaggingFee-Tax

  • ServiceFee-FBAFees-ReCommerceGradingAndListingFee-Base

  • ServiceFee-FBAFees-StorageBillingFee-FBAStorageFee-Base

  • ServiceFee-FBAFees-StorageBillingFee-FBAStorageFee-Tax

  • ServiceFee-FBAFees-StorageReservationBillingFee-StorageReservationFee-Base

  • ServiceFee-FBAFees-StorageReservationBillingFee-StorageReservationFee-Promo

  • ServiceFee-FBAFees-StorageReservationBillingFee-StorageReservationFee-Tax

  • ServiceFee-FBAFees-UnplannedServiceCharge-FBAInboundDefectFee-Base

  • Shipment - Correction-Expenses-AmazonFees-FBAPerUnitFulfillmentFee-Base

  • Shipment - Correction-Sales

  • Shipment - Reversal-Expenses

  • Shipment - Reversal-Sales-AmazonFees

  • Shipment-AmazonFees-AmazonForAllFee-Base

  • Shipment-AmazonFees-AmazonForAllFee-BaseFBM

  • Shipment-AmazonFees-AmazonForAllFee-Tax

  • Shipment-AmazonFees-AmazonForAllFee-TaxFBM

  • Shipment-AmazonFees-CODChargeback-Base

  • Shipment-AmazonFees-CODChargeback-Tax

  • Shipment-AmazonFees-Commission-Base

  • Shipment-AmazonFees-Commission-BaseFBM

  • Shipment-AmazonFees-Commission-Promo

  • Shipment-AmazonFees-Commission-PromoFBM

  • Shipment-AmazonFees-Commission-Tax

  • Shipment-AmazonFees-Commission-TaxFBM

  • Shipment-AmazonFees-CSBAFee-Base

  • Shipment-AmazonFees-FBAPerUnitFulfillmentFee-Base

  • Shipment-AmazonFees-FBAPerUnitFulfillmentFee-Promo

  • Shipment-AmazonFees-FBAPerUnitFulfillmentFee-Tax

  • Shipment-AmazonFees-FBATransportationFee-Base

  • Shipment-AmazonFees-FBATransportationFee-Tax

  • Shipment-AmazonFees-FBAWeightBasedFee-Base

  • Shipment-AmazonFees-FBAWeightBasedFee-Promo

  • Shipment-AmazonFees-FBAWeightBasedFee-Tax

  • Shipment-AmazonFees-FixedClosingFee-Base

  • Shipment-AmazonFees-FixedClosingFee-BaseFBM

  • Shipment-AmazonFees-FixedClosingFee-Tax

  • Shipment-AmazonFees-FixedClosingFee-TaxFBM

  • Shipment-AmazonFees-GetPaidFasterFee-Base

  • Shipment-AmazonFees-GetPaidFasterFee-Tax

  • Shipment-AmazonFees-GiftwrapChargeback-Base

  • Shipment-AmazonFees-GiftwrapChargeback-Tax

  • Shipment-AmazonFees-GiftwrapCommission-Base

  • Shipment-AmazonFees-GiftwrapCommission-BaseFBM

  • Shipment-AmazonFees-PanAmericasChargebackFee-Base

  • Shipment-AmazonFees-PoAPerUnitFulfillmentFee-Base

  • Shipment-AmazonFees-PoAPerUnitFulfillmentFee-Promo

  • Shipment-AmazonFees-PremiumExperienceFee-Base

  • Shipment-AmazonFees-PremiumExperienceFee-BaseFBM

  • Shipment-AmazonFees-SalesTaxCollectionFee-Base

  • Shipment-AmazonFees-SalesTaxCollectionFee-Tax

  • Shipment-AmazonFees-ShippingChargeback-Base

  • Shipment-AmazonFees-ShippingChargeback-Tax

  • Shipment-AmazonFees-ShippingHB-Base

  • Shipment-AmazonFees-ShippingHB-Promo

  • Shipment-AmazonFees-ShippingHB-Tax

  • Shipment-AmazonFees-TechnologyFee-Base

  • Shipment-AmazonFees-TechnologyFee-Tax

  • Shipment-AmazonFees-VariableClosingFee-Base

  • Shipment-AmazonFees-VariableClosingFee-BaseFBM

  • Shipment-AmazonFees-VariableClosingFee-Tax

  • Shipment-AmazonFees-VariableClosingFee-TaxFBM

  • Shipment-ChemicalTax-ChemicalTaxRegulatoryFee

  • Shipment-DigitalServicesFee-DigitalServicesFee-Base

  • Shipment-DigitalServicesFee-DigitalServicesFee-Tax

  • Shipment-DigitalServicesFee-DigitalServicesFeeFBA-Base

  • Shipment-DigitalServicesFee-DigitalServicesFeeFBA-Tax

  • Shipment-MPFRegulatoryFee-OurPriceRegulatoryFee

  • Shipment-Other-GiftwrapPrincipal

  • Shipment-Other-GiftwrapPrincipalFBM

  • Shipment-Other-PaymentMethodFeePrincipal

  • Shipment-Other-PaymentMethodFeePrincipalFBM

  • Shipment-POAServiceFee-POAServiceFee-Base

  • Shipment-POAServiceFee-POAServiceFee-Promo

  • Shipment-POAServiceFee-POAServiceFee-Tax

  • Shipment-Points-PointsGranted

  • Shipment-ProductCharges-OurPricePrincipal

  • Shipment-ProductCharges-OurPricePrincipalFBM

  • Shipment-PromoRebates-OurPriceDiscount

  • Shipment-PromoRebates-ShippingDiscount

  • Shipment-Shipping-ShippingPrincipal

  • Shipment-Shipping-ShippingPrincipalFBM

  • Shipment-Tax-GiftwrapTax

  • Shipment-Tax-LowValueGoodsTax-Other

  • Shipment-Tax-LowValueGoodsTax-Principal

  • Shipment-Tax-LowValueGoodsTax-PrincipalFBM

  • Shipment-Tax-LowValueGoodsTax-Shipping

  • Shipment-Tax-MarketplaceFacilitatorRegulatoryFee-Principal

  • Shipment-Tax-MarketplaceFacilitatorRegulatoryFee-PrincipalFBM

  • Shipment-Tax-MarketplaceFacilitatorTax-Other

  • Shipment-Tax-MarketplaceFacilitatorTax-Principal

  • Shipment-Tax-MarketplaceFacilitatorTax-PrincipalFBM

  • Shipment-Tax-MarketplaceFacilitatorTax-Shipping

  • Shipment-Tax-MarketplaceFacilitatorVAT-Principal

  • Shipment-Tax-MarketplaceFacilitatorVAT-PrincipalFBM

  • Shipment-Tax-MarketplaceFacilitatorVAT-Shipping

  • Shipment-Tax-OurPriceTax

  • Shipment-Tax-OurPriceTaxDiscount

  • Shipment-Tax-PaymentMethodFeeTax

  • Shipment-Tax-ShippingTax

  • Shipment-Tax-ShippingTaxDiscount

  • Shipment-TaxCollectedAtSource-TCS-CGST

  • Shipment-TaxCollectedAtSource-TCS-IGST

  • Shipment-TaxCollectedAtSource-TCS-SGST

  • Shipment-TaxWithholding-ItemTDS

  • TaxWithholding-Expenses

  • TaxWithholding-Expenses-TaxWithholding

  • TaxWithholding-Sales

  • TaxWithholding-Sales-TDSReimbursement

Examples:

=GORILLA_FINANCESTYPE("TOY STORE")

If no attributes are entered, it will list all the line items categorized as finances related to the Amazon account.

=GORILLA_FINANCESTYPE("TOY STORE", "US", "SHIP", "Column", "No")

Lists all finance types for the US marketplace, searching for any fees that start with “SHIP” and is associated with Shipping/Shipment, displayed in a column, and only displaying the finances associated with the Amazon account. If “YES” is used, it will return all Amazon fee names, whether it is charged to the account or not.

Related Articles
Did this answer your question?