Step 5 - Duplicate Data

The
Duplicate Data
step displays potentially duplicate data between organizer pages and source documents, letting you confirm duplicate data identified by the system or mark data that you identify as duplicate. The amount marked as a duplicate won’t be exported to the tax application.
1040SCAN will automatically mark the organizer pages as auto duplicates in the following 2 cases:
  • If the payer and ownership codes match, the organizer items are marked as duplicates regardless of whether the amounts match or not.
  • If the amounts match exactly (with a difference of $1 being allowed), the organizer items are marked as duplicate even if the payer and ownership codes don’t match.
You can manually mark data as duplicate by grouping organizer pages and source documents together and then selecting documents to be excluded from export. For instance, consider an example in which the organizer page of Schedule C has gross receipts of $19,700 and 1099-Misc forms have a total of $19,660. If you want to consider the higher amount of $19,700 from the organizer, you group the documents and then mark the amounts on the 1099-Misc forms as duplicates. This ensures the data from the 1099-Misc documents doesn’t export to the tax application.

Marking data as duplicate

  1. If you need to select multiple source documents, hold 
    Ctrl
    and select each source document (to select documents one at a time). You can also hold
    Shift
    and select the 1st and last source documents (to select a range of source documents in between).
  2. Follow the same procedure to select the organizer pages you want to group with the source documents you selected. This will usually be a single organizer page.
  3. With your organizer pages and source documents selected, select 
    Match
    .
  4. Now you'll see the organizer pages and source documents grouped together with subtotals at the bottom of the group.
  5. Mark the documents you want to consider as duplicates, select the checkboxes under the
    Dup
    column. The documents you select as duplicates (that is,
    Dup
    ) won’t export information to the tax application.
    If you erroneously select both the organizer page and the source documents as duplicates, none of the data will be exported to your tax application.
  6. If you erroneously select the
    Dup
    checkbox without first matching that document, you will receive an error. Select
    OK
    and ensure it's matched before you select the
    Dup
    checkbox.
  7. Be sure to select each category under the
    Category
    section on the left so you don't miss any potential duplicates.
  8. Once you are done matching the duplicate data, select
    Next
    to close the
    Duplicate Data
    step. On the confirmation window, select
    Yes

Unmarking data as duplicate

  1. Clear the checkbox in the
    Dup
    column to unmark that organizer page or source document as a duplicate. Now select the organizer page or source document and select
    UnMatch
    to unmatch it from its current group.
  2. The document will now be unmatched and the checkbox will be cleared.
Bulk unmatch
Instead of individually unmatching every document, you can bulk unmatch everything inside a selected category.
Follow these steps to bulk unmatch all matched documents:
  1. Go to the
    Category
    panel.
  2. Right-click the category name, then select
    Unmatch
    .

Verifying data automatically marked as a duplicate

  1. Select the
    Show Auto Duplicate
    checkbox on the lower left to see items marked as duplicates automatically. If data was identified as duplicate, the organizer pages and source documents will be matched, and the organizer pages will be checked as duplicate.
  2. If you want to change the duplicate from organizer to source document, manually clear the
    Dup
    checkbox in the
    Organizer Pages
    section and select it in the
    Source Documents
    section.
  3. Be sure to select each category under the
    Category
    section on the left to see everything marked as a duplicate automatically.
  4. If you want any of the data that was automatically marked as a duplicate to be considered for export instead, you should select it, select 
    UnMatch
    , and clear the
    Dup
    checkbox.
  5. Clear the
    Show Auto Duplicate
    checkbox to hide the duplicate data identified automatically.

Filtering data

  1. Select 
    Show Filter
    .
  2. Each column will now show an empty field at the top. Type in the fields to filter the data, showing only data that contain what you typed in that field. When you're done, select
    Clear Filter
    to remove the filter.

Tips to remember

  • Select
    Cancel
     or press
    Alt
    +
    C
     to close the Review Wizard without saving any of the work performed.
  • Select
    Finish Later
     or press
    Alt
    +
    F
     to close the Review Wizard after saving all of the work performed.
  • Select
    Next
     or press
    Alt
    +
    N
     to continue.
  • Duplicate data won’t be exported to the tax return.
  • Documents marked as a duplicate will have a 
    Duplicate
    stamp next to the amount in the SPbinder.
  • The items are displayed in the following sequence: 1. Automatically marked as Duplicates & manually match as duplicates:- Anything that was automatically marked as duplicate by SurePrep will appear on top, then amounts that a user manually marked as Duplicates.2. Remaining organizer/source documents that weren't matched. 

Update field value

If you erroneously made a verification error in the
Step 2 Verification
wizard then you now have the ability to correct the field or value in post-verification wizards like Superseded Documents, CFA (Child Form Association), Duplicate Data, NFR (New Form Review), and Tax Exempt Income.
To update the field in post-verification wizards, double-click the document to view the source document in the Document Viewer window.
Right-click the field that you want to update, then select
Edit
on the shortcut menu.
On the
Edit
window, select or enter the correct value then select
Save
.
Example 1:
Example 2:

Mark document as Prior Year

If you erroneously forgot to mark the page a prior year document in Step 2 Verication Wizard then you have the opportunity to mark the documents as a prior year document in post verification wizards like CFA (Child Form Association), NFR (New Form Review), and Tax Exempt Interest.
Double-click the document to view the source document in the Document Viewer window.
On the new window, select
Mark as PY
to correct the document as a prior year document. 
On the confirmation window, select
Yes
to mark the page as a prior year document.
Prior Year Information in SPbinder
In SPbinder, documents marked as a prior year document will appear in
INDEX TREE > Prior Year Information
.
Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close