|
Posted by Laura on September 8, 2006, 8:00 pm
Please log in for more thread options
> Laura wrote:
>>> On Thu, 7 Sep 2006 03:29:53 -0400, "Paul Danaher"
>>>
>>>> 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!
>>>>
>>> Why not export all transactions to Excel and sort on various
>>> combinations of columns?
>>
>> Do a pivot table on the data and select COUNT on the amount field.
>> This will quickly show you which ones are duplicated.
>
> Nice idea in principle - unfortunately, invoices, payments etc are
> occasionally identical in amount although separate transactions! But it is
> a useful trick - thanks.
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.
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap