Amazon Revenue Rollups by Fulfillment Channel, Product, or Order Type

Bookkeep provides flexible Amazon revenue rollup methods that allow sellers to organize revenue activity inside their accounting system in the way that best matches their reporting and operational needs.

Depending on your selected configuration, Bookkeep can summarize Amazon activity by:

• Fulfillment Channel (Amazon fulfilled - AFN or Merchant fulfilled - MFN)

• Product Category

• Item Name

• Order Type (Standard v. Invoiced orders)

These rollup methods determine how Bookkeep groups journal entry activity for sales, refunds, discounts, taxes, fees, shipping, and related Amazon transactions when posting into your accounting platform.

Categories and Subcategories in Journal Entries

Bookkeep uses categories and subcategories to organize Amazon revenue activity into structured journal entry lines.

The primary category represents the transaction type itself, while the subcategory represents the grouping dimension selected in your revenue rollup configuration.

Examples of transaction categories include:

• Gross Sales

• Discounts

• Refunds

• Shipping Income

• Promotional Rebates

• Marketplace Tax Collected

The subcategory depends on the selected rollup method.

Example: Product Category Rollup

Journal Entry Category	Subcategory
Gross Sales	Apparel
Gross Sales	Footwear
Discounts	Apparel
Refunds	Footwear

This structure allows financial reporting to align more closely with operational and product-level business analysis.

Revenue Rollup Methods

Fulfillment Channel

Groups revenue activity based on Amazon fulfillment method.

Examples include:

• Amazon fulfilled - AFN

• Merchant fulfilled - MFN

This method is commonly used by sellers who want visibility into operational performance by fulfillment strategy.

Product Category

Groups revenue activity by Amazon product category.

Examples include:

• Apparel

• Electronics

• Home Goods

• Beauty

This method provides category-level financial visibility while keeping journal entries manageable.

Item Name

Groups revenue activity by individual product or SKU name.

Examples include:

• Running Shoes

• Stainless Steel Water Bottle

• Yoga Mat

This method provides the highest level of product reporting detail and is commonly used by sellers focused on SKU-level profitability analysis.

Order Type

Groups activity by Amazon order classification.

Examples may include:

• Standard Orders

• Invoiced Orders
  
  This method is useful for operational and customer segmentation analysis.

Advanced Product-Level Allocation for Shipping Income and Promotional Rebates

In addition to breaking down Gross Sales, Discounts, and Refunds by subcategory, Bookkeep includes advanced allocation capabilities for the following Amazon revenue rollup methods:

• Product Category

• Item Name

When enabled, Bookkeep can also allocate the following transaction types into the same product-level subcategories used for sales reporting:

• Shipping Income

• Promotional Rebates

This enhancement provides significantly deeper visibility into true product-level profitability directly within your accounting system.

Why This Matters

Many Amazon sellers want to understand more than just top-line revenue by product. Accurate profitability analysis often requires visibility into:

• Which products recover shipping revenue most effectively

• Which products rely heavily on promotional incentives

• Net profitability after discounts and rebates

• True margin performance by product or category

By allocating Shipping Income and Promotional Rebates into the same subcategory structure as product sales, Bookkeep enables more accurate product-level financial reporting directly inside your accounting platform.

This allows accounting and finance teams to analyze profitability using native financial reports without requiring spreadsheets or external BI tooling.

Allocation Logic

Bookkeep allocates Shipping Income and Promotional Rebates to a specific product subcategory only when Amazon provides a clear and reliable linkage between the adjustment and the associated product activity.

Examples include:

• A shipping credit directly tied to a single item sale

• A promotional rebate associated with a specific SKU

• A rebate tied entirely to a single product category

When Amazon does not provide sufficient detail to confidently associate the amount to a single product or category, Bookkeep intentionally falls back to a generic subcategory to preserve accounting accuracy.

This approach maximizes reporting granularity while preventing inaccurate profitability allocations.

Important Notes

• This functionality applies only to the Product Category and Item Name revenue rollup methods.

• Allocation behavior depends entirely on the granularity and quality of data provided by Amazon.

• Generic fallback subcategories are intentionally used to maintain accounting accuracy and prevent misleading profitability reporting.

• This enhancement works alongside Bookkeep’s existing Amazon Seller revenue recognition and COGS automation capabilities.

Benefits of Revenue Rollups

Bookkeep’s Amazon revenue rollup functionality helps sellers:

• Improve product-level profitability analysis

• Simplify financial reporting

• Reduce journal entry complexity

• Align accounting data with operational reporting

• Support more accurate margin analysis

Different businesses may prefer different rollup methods depending on transaction volume, SKU complexity, reporting requirements, and accounting preferences.

Higher-detail rollups such as Item Name provide deeper reporting visibility but may generate larger journal entries depending on transaction volume.

Changing the Default Posting Method

By default, Amazon Seller transactions in Bookkeep are posted using the Fulfillment Channel revenue rollup method.

If you would like to change the revenue rollup method to one of the other available options, you can update the setting directly within your Amazon connection configuration.

To change the posting method:

1. Navigate to the Connections page

2. Open the My Apps tab

3. Locate the appropriate Amazon Seller connection

4. Click the blue Configure button for that connection

This will open the Amazon Seller configuration settings where you can select a different revenue rollup method.

The selected rollup method determines how Bookkeep groups and populates journal entry subcategories, which can then be mapped to your chart of accounts for more detailed financial reporting and profitability analysis.

Additional Amazon Automation Features

Bookkeep’s Amazon integration also supports:

• Automated sales summaries

• Marketplace facilitator tax handling

• Amazon fee posting

• Deferred and released transaction automation

• COGS automation

• Multi-channel accounting support

These capabilities work together to provide a fully automated Amazon accounting workflow across ecommerce and ERP platforms.