Skip to main content
August 26, 2020
Question

The banking book is showing one entry only; but the concerned ledger account is showing two entries i.e., the transaction got duplicated..

  • August 26, 2020
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

August 26, 2020

Hello, rkhk276.

 

I'll be taking a look at the issue and help you fix the duplicate transaction. 

 

Are you referring to the General Ledger report? If so, then it's actually a normal behavior. The report shows the debit and credit activities for each account. A transaction might look like it was duplicated but it's actually not. A split transaction (multiple accounts affected) will show on the bank account and where the amounts are allocated to. Here's an example: 

 

 

 

This article explains more about debits and credits: How accounts are affected by debits and credits.

 

However, if you're referring to a different report or view, then we might need to dig a little deeper. To confirm if the transaction was duplicated, let's run a Profit and Loss report. Here's how: 

 

  1. Go to Reports, then select Profit and Loss from the Business overview or Favourites list. 
  2. Set the dates under Report period. 
  3. Check both accounting methods by ticking either Accrual or Cash
  4. Check the total amounts for each account. 

 

 

If your income or expenses are overstated, then we can check the transactions by clicking the amounts under an account. This will show a list of recorded transactions. Simply select the duplicate record and delete it:

 

  1. Open the transaction.
  2. Click the More menu.
  3. Choose Delete

 

 

It's also important to check other bank accounts in your Chart of Accounts. Simply click the Chart of Accounts menu, then click Account history on each bank. 

 

The transaction might've been recorded under a different bank account (which shows up as duplicate in your reports). In this case, simply delete it to fix this. 

 

After dealing with the duplicate transaction, do you need further assistance with any other tasks? Our articles can help you out. Browse them here to get started. 

 

Mention my username (@jamespaul) if you have further concerns with your transactions, reports or QuickBooks Online in general. I'm always here to help out. Have a solid day ahead!