cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
For everything you need to know at EOFY, view our EOFY FAQs.
Highlighted
Level 2

Missing and duplicate transactions

I have a number of transactions on my pay pal statement that are not in my chart of accounts for reconciliation. How can I add these in? can you add them the same way you would a bank statement? Plus I've found some duplicate transactions (attached) how can I remove these? I also have transactions in my chart of accounts (reconciliation) that are not on my statement - How do I remove these?

Solved
Best answer July 24, 2019

Best Answers
Highlighted
Moderator

Missing and duplicate transactions

Yes, it's the same way when you add your bank transactions, kcoromandel.

 

In the Select the transactions to import page, you'll have to choose the transactions that are not in your Chart of accounts. Then, continue with the on-screen instruction to successfully add those transactions.

 

On the other hand, you can delete duplicate transactions and those that are not in your Chart of Accounts. Here's how to do it:

 

In the Banking page, select the transactions you wish to delete. Next, in the Batch actions drop-down, select Exclude Selected. Then, go to the Excluded tab and then select the transactions you excluded earlier. Lastly, in the Batch actions drop-down, click Delete.

 

I have screenshots as your visual guide.

 

 

Upon reconciling you can check the article I've provided.

 

If you need my help when reconciling, I'm always around to help you out.

View solution in original post

3 Comments 3
Highlighted
Moderator

Missing and duplicate transactions

Yes, it's the same way when you add your bank transactions, kcoromandel.

 

In the Select the transactions to import page, you'll have to choose the transactions that are not in your Chart of accounts. Then, continue with the on-screen instruction to successfully add those transactions.

 

On the other hand, you can delete duplicate transactions and those that are not in your Chart of Accounts. Here's how to do it:

 

In the Banking page, select the transactions you wish to delete. Next, in the Batch actions drop-down, select Exclude Selected. Then, go to the Excluded tab and then select the transactions you excluded earlier. Lastly, in the Batch actions drop-down, click Delete.

 

I have screenshots as your visual guide.

 

 

Upon reconciling you can check the article I've provided.

 

If you need my help when reconciling, I'm always around to help you out.

View solution in original post

Highlighted
Level 1

Missing and duplicate transactions

So I get how to fix the duplicates but as soon as I hit update again, I get a whole new batch of duplicates  I cant work this way  It seems to only be transfer transactions.  Almosty like 2 different acounts import their own version of the transaction.  After I reconcile, duplicates come back and get me out of balance again.  The only thing I can do is to disconnect my accounts from the banks

 

Highlighted
Content Creator

Missing and duplicate transactions

Hi Yasgur, 

 

Transfers work in a bit of a different way when it comes to matching the bank feeds - if you have transfers between two accounts, and bank feeds set up for both of those accounts, you will have both a transaction downloaded for the money leaving one account as well as entering the other account. In the event that this happens, there is a process for recording the transaction correctly within the system - first you need to add the transfer from one account, however in the other account that is the other half of the transfer, rather than adding that bank feed transaction you would match to the transfer in the system. 

 

It can be bit of a tricky process, so if you'd rather reach out you can give us a call on 1800 046 038, or follow the steps below if you'd rather receive a callback or start a chat:

  1. While signed in to QuickBooks Online, click the Help menu in the upper-right corner.
  2. Select Contact us and enter the details of your concern.
  3. Click Let's talk and choose Chat or Get a callback.
  4. Enter the required information.

-Lucas