1. Home
  2. QuickBooks Discussions
  3. Is there an easy way to find duplicate transactions?

Is there an easy way to find duplicate transactions?

I'm running QBPro 2005 (waiting for 2006 this week) and I've used some proprietary software to import transactions. Unfortunately, there are a

*lot* of duplicates surfacing - for example, all the credit card transactions for software bought appear twice. Is there any way to write a report so that it shows duplicate transactions? I suppose I could create reports which cover income, expense and balance sheet transactions details, export these to Excel and export them to Access to use the "Find duplicate" report there, but Christmas is getting close, so - all help gratefully received!
Reply to
Paul Danaher
Loading thread data ...

Why not export all transactions to Excel and sort on various combinations of columns?

Reply to
Peter Saxton

Do a pivot table on the data and select COUNT on the amount field. This will quickly show you which ones are duplicated.

Reply to
Laura

Nice idea in principle - unfortunately, invoices, payments etc are occasionally identical in amount although separate transactions! But it is a useful trick - thanks.

Reply to
Paul Danaher

You do the pivot table on date-transaction number-etc (other unique identifiers) and "count" on amount. This will give you the number of unique date-transaction-etc transactions. Then you can go back and check any date-transaction-etc entries where the count is not equal to 1. These will be your duplicate entries.

Reply to
Laura

Laura wrote: ...

Sorry, I should have worked through it first before commenting. Thanks.

Reply to
Paul Danaher

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.