cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
rkhk276
Level 1

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

 
1 Comment 1
jamespaul
Moderator

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

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: 

 

GL1.PNG

 

GL2.PNG

 

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. 

 

GL4.PNG

 

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

 

GL3.PNG

 

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!