Duplicate Transactions | FAQ | Zoho Books (2024)

FAQs

What does it mean when it says possible duplicate transaction? ›

This soft warning indicates that this transaction is identical to a transaction that has already been posted to the same account.

When making a payment, the card issuer may authorise the card when contact is made, and again when funds are withdrawn. This will be reflected next to the actual charge on the statement and appear as a duplicate transaction.

Remove duplicate transactions in Side-by-Side mode

In the Items Reviewed section, select the account with the transactions you want to remove. Select Items to Delete. Select the transactions you want to delete. Select Delete Selected.

Certain Merchants, such as internet companies, may authorise a charge when you place an order. The Merchant may then authorise your Card again when the amount is due. In these instances, the charge may appear twice in Pending Transactions but will be billed to your account only once.

Duplicate payments are a huge headache for accounts payable departments and their vendors. For AP teams, they lead to wasted time and money and strained supplier relationships. But in order to eliminate the potential of duplicate payments, your organization must understand where they come from and how they occur.

Why do multiple charges happen? Businesses might authorise multiple charges in error, or because of a technical problem. In most cases, the money for duplicate transactions is sent back to your balance within a week.

A duplicate payment occurs when an entity makes an extra payment in the same amount as the original. This is usually caused by an accounting error or processing glitch. Some duplicate payments may result in more than just a second identical payment.

If you're seeing duplicate transactions from your recurring template, it may be that you have two or more templates created for the same customer. These templates could be named differently. Note: Recurring templates are only available in QuickBooks Online Essentials and Plus.

What causes duplicate transactions in QuickBooks? ›

When you connect your bank and credit card accounts to online banking, QuickBooks Self-Employed automatically downloads your latest transactions. Since each bank connects to QuickBooks differently, sometimes there are crossed wires. QuickBooks may occasionally download duplicate transactions.

Duplicates can occur when you import lists and transactions from an external program into your company data file. Supported programs that can import into QuickBooks include Microsoft Excel, other spreadsheet programs and applications added to the default QuickBooks installation.

Remove duplicate values

Select the range of cells that has duplicate values you want to remove. Tip: Remove any outlines or subtotals from your data before trying to remove duplicates. Select Data > Remove Duplicates, and then under Columns, check or uncheck the columns where you want to remove the duplicates.

Here's how to remove duplicate data in Google Sheets. Click any cell that contains data. Then, select the Data tab > Data cleanup > Remove duplicates. From the Remove duplicates window that appears, select which columns you'd like to include in your search for duplicate data.

A duplicate transaction is when a customer is charged twice for a single purchase. For example, if a customer gets their hair cut for £75 and they later receive two transactions of £75 from the same merchants taken from their bank account.