---
title: "How to Handle Amazon Canceled Payments in QuickBooks Online and Xero"
description: "Reconcile Amazon canceled payments in QuickBooks Online and Xero."
url: https://docs.taxomate.com/en/articles/11672753-how-to-handle-amazon-canceled-payments-in-quickbooks-online-and-xero
collection: "Amazon Accounting Support"
updated: 2026-10-21
language: en
---

# How to Handle Amazon Canceled Payments in QuickBooks Online and Xero

Reconcile Amazon canceled payments in QuickBooks Online and Xero.

Sometimes, Amazon cancels a scheduled transfer and rolls the funds into a future settlement period. This can result in duplicate revenue being recorded if your accounting software has already imported the original settlement and then imports the next settlement that includes the rolled-over amount.

Here’s how to reconcile this properly in **QuickBooks Online** and **Xero** so your revenue and accounts stay accurate.

* * *

## **When Does This Happen?**

-   Amazon cancels a payout for a settlement period.
    
-   The unpaid balance is rolled into the next settlement.
    
-   Both settlement periods are imported into your accounting software.
    
-   This can cause revenue (and possibly COGS) to be double-counted.
    

Example:

-   Amazon cancels payment for Jan 30 – Feb 13 settlement.
    
-   $1,497.99 is rolled into the next settlement and paid.
    
-   Both settlements appear in QuickBooks Online or Xero.
    
-   Revenue shows up twice unless you adjust for the rolled-over funds.
    

* * *

## **How to Fix This in Xero**

Follow these steps to resolve the issue in Xero.

### **1\. Create a Clearing Account**

-   Go to **Accounting > Advanced > Chart of Accounts**
    
-   Click **Add Account**
    
-   Choose **Current Asset** as the Account Type
    
-   Enter a Code (e.g. 1205)
    
-   Name it **Amazon Clearing Account**
    
-   Check **Enable payments to this account**
    
-   Save
    

This account will temporarily hold the canceled funds.

* * *

### **2\. Record the Canceled Payment**

-   In Xero, create a **Receive Money** transaction for the canceled amount (e.g. $1,497.99).
    
-   Allocate it to the **Amazon Clearing Account**.
    

This records the funds Amazon still owes you but has not yet paid at that point in time.

* * *

### **3\. Adjust the Previous Invoices**

If invoices were created in Xero for the original settlement, adjust them so the revenue is not counted twice:

-   Open the invoices for the earlier settlement period.
    
-   Add new line items that debit the amounts from the Amazon Clearing Account:
    
    -   For the first invoice, add a line:
        
        -   Description: Adjustment to Amazon Clearing Account
            
        -   Account: Amazon Clearing Account
            
        -   Amount: -331.05
            
    -   For the second invoice, add a line:
        
        -   Description: Adjustment to Amazon Clearing Account
            
        -   Account: Amazon Clearing Account
            
        -   Amount: -974.99
            

This ensures the revenue for that canceled payment is removed from the original settlement period in your books.

* * *

## **How to Fix This in QuickBooks Online**

Here’s how to resolve the same issue in QuickBooks Online.

### **1\. Create a Clearing Account**

-   Go to **Accounting > Chart of Accounts**
    
-   Click **New**
    
-   Choose:
    
    -   **Account Type:** Other Current Asset
        
    -   **Detail Type:** Other Current Assets
        
-   Name it **Amazon Clearing Account**
    
-   Click **Save and Close**
    

* * *

### **2\. Record the Canceled Payment**

-   Go to **\+ New > Journal Entry**.
    
-   Create a journal entry:
    
    -   Debit **Amazon Clearing Account** for the amount Amazon held back (e.g. $1,497.99).
        
    -   Credit **Amazon Sales or Settlement Income** (or whichever income account was used in the original settlement import).
        

This recognizes the funds as still due from Amazon rather than immediate revenue.

* * *

### **3\. Adjust Future Settlement Records**

When the rolled-over funds appear in the next settlement, you’ll need to clear out the clearing account to avoid double-counting:

-   Go to **\+ New > Journal Entry**.
    
-   Create a journal entry:
    
    -   Credit the **Amazon Clearing Account** for $1,497.99.
        
    -   Debit **Amazon Sales or Settlement Income** for $1,497.99.
        

This removes the extra revenue and keeps your income totals correct.

* * *

## **Alternatively: Adjust the Imported Settlement**

If you’re using software like Taxomate to import settlements as invoices or journal entries, you can edit the imported settlement data for the second period:

-   Reduce revenue by the rolled-over amount (e.g. $1,497.99).
    
-   Code the reduction to the Amazon Clearing Account.
    

* * *

## **Why Do This?**

Without these adjustments:

✅ Revenue will be overstated.

✅ Your bank deposits won’t match the settlement reports.

✅ Reports for Amazon income won’t reflect the correct period.

By using a clearing account, you keep your records precise and your income statements accurate.

* * *

## **Need Help?**

If you’re unsure how to adjust these entries or work with your clearing accounts, reach out to your accountant or contact us at [Taxomate support](https://docs.taxomate.com) for help!