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.
Duplicate Data Wizard overview
1040SCAN will automatically mark the organizer pages as 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 don't export to the tax application.

Duplicate Document wizard

Upon loading the
Duplicate Document
wizard, your screen will be segmented into 2 parts: the top half being the
MATCHED
panel and the bottom half being the
UNMATCHED
panel.
Matched and Unmatched panels
Within both the
MATCHED
and
UNMATCHED
panels, the documents listed will be separated into either
Organizer Pages
or
Source Documents
.
Organizer Pages and Source Documents panel
The categories that have triggered the
Duplicate Data
wizard will on your screen. From here, you can select from the forms listed to find and review their content to ensure that any duplicate data is handled appropriately.
Pages to be reviewed for duplication
A summarized version of the instructions will appear in the
Duplicate Data
 panel. You can review these instructions, then select
Instructions
to collapse or expand these instructions and make space for more pages.
Duplicate Wizard instructions

Marking data as duplicate

To mark data as duplicate, the source documents must first be matched to the organizer pages. Once they've been matched and appear in the
MATCHED
panel, you can select the
Dup.
Dup. icon icon for the corresponding data you would like to mark as duplicate.
Matching documents
  1. Once you've selected a category from the
    Category
    panel, the
    MATCHED
    and
    UNMATCHED
    panels will update to display the corresponding data.
  2. You can begin matching documents by scrolling to the
    UNMATCHED
    panel. Select the checkbox of the
    Source Document
    that you would like to match together. You can select multiple checkboxes to group your selections.
    note
    If you'd like to view a document before marking it as duplicate, you can double-click the document title to open it in the
    Review Wizard Image Viewer
    .
    Source Documents
    The
    TOTAL
    will update with each document selected.
    Source documents total
  3. Once your source documents are selected, select the
    Organizer Page
    from either the
    MATCHED
    or
    UNMATCHED
    panel that you would like to group with the selected source documents. This will typically be a single organizer page. However, you can select as many as necessary.
    Organizer pages
  4. Once the organizer page and source documents are selected, the
    MATCH
    feature will be enabled, letting you match your selections and move them to the
    MATCHED
    panel. Select
    MATCH
    to begin matching.
    Select MATCH
  5. Your selected source documents and organizer pages will now be grouped together in the
    MATCHED
    panel, and the subtotal for this group will be displayed beneath the list.
Mark matches as duplicate
Once you've finished matching your source documents with their organizer pages (or if these were automatically matched by the system), you can begin marking the necessary documents as duplicates.
  1. To mark a document as a duplicate, select the
    Dup.
    Dup. icon icon for the corresponding document. The documents you select as duplicates won’t export information to the tax application.
    Select the Dup. icon
    note
    If you select both the organizer page and the source documents as duplicates, none of the data in either will be exported to the tax application.
  2. Documents accidentally marked as duplicates can be unmarked as duplicates by selecting the
    Dup
    icon Dup. icon again.
  3. Once all of the necessary documents in the current category have been marked as duplicate, select
    CATEGORY SIGN OFF
    to acknowledge that all marking has been completed.
    Select CATEGORY SIGN OFF
  4. Proceed to the next category in the
    Category
    panel until all necessary documents have been matched and marked as duplicates.
    Select new form to review

Unmatching data

If documents have been erroneously matched together, users can select the matchings and use the
UNMATCH
feature to move the data back to the
UNMATCHED
panel.
  1. Select the checkbox of the
    Organizer Page
    or
    Source Document
    you would like to unmatch.
    note
    Selecting a source document will only unmatch the selected document, however, selecting an organizer page will unmatch all of the documents within it.
    Select form to unmatch
  2. Select
    UNMATCH
    to unmatch your selections.
    Select UNMATCH
  3. These documents will now appear in the
    UNMATCHED
    section, ready to be rematched, if necessary.
    Unmatched forms in the UNMATCHED panel

Verifying data is automatically marked as a duplicate

Some data may have been automatically marked as duplicate by the system. When this happens, users can verify the data marked as duplicate and make any adjustments necessary.
  1. Select the
    Show Auto-Matched
    checkbox and the items that were automatically marked as duplicates will appear in their respective category. If data was identified as duplicate, the organizer pages and source documents will be matched, and the organizer pages will be checked as duplicate.
    Select the "Show Auto-Matched" checkbox
  2. If you want to change the duplicate from the
    Organizer Page
    to the
    Source Document
    , manually deselect the
    Dup.
    icon in the
    Organizer Pages
    section and instead select it in the
    Source Documents
    section.
    Deselect the Dup. icon
  3. You can clear the
    Show Auto-Match
    checkbox to hide the duplicate data that was identified automatically.
    Deselect the "Show Auto-Matched" checkbox

Filtering data

In cases where there are too many values in a client's binder to efficiently scroll through looking for a specific document or page, users can utilize the
SHOW FILTER
feature to show values of a specific value.
  1. Select
    SHOW FILTER
    .
    Select SHOW FILTER
  2. A field will appear on each column title.
    Filters appearing in the Duplicate Data Wizard
  3. Provide values in the fields to filter the records, only displaying data that contains what you typed in that field.
    Filtered documents
  4. If you no longer need the filter, you can select
    HIDE FILTER
    to remove the filter.
    Select HIDE FILTER

Update field value

If you erroneously made a verification error in the
Step 2 Verication
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, and NFR (New Form Review).
  1. To update the field in post-verification wizards, open the document you'd like to update in the document viewer panel.
    Document appearing in the document viewer
  2. Right-click the field that you want to update, then select
    Edit Value
    .
    Select Edit Value
  3. The
    Edit Value
    window will appear. Here, you can review the
    FORM
    ,
    FORM NAME
    , and
    FIELD
    for further context.
    FORM, FORM NAME, and FIELD fields
  4. Select the correct value from the options listed in the
    VALUE
    dropdown menu. If the correct value is not listed, you can type the correct value instead.
    VALUE dropdown in the Edit Value window
  5. Once the correct value is provided to the
    VALUE
    field, select
    SAVE
    to save your changes and return to the wizard.
    Select SAVE

Mark document as Prior Year

If you erroneously forgot to mark the page as a prior year document in the
Step 2 Verification
wizard then you have the opportunity to mark the documents as a prior year document in post verification wizards like CFA (Child Form Association), and NFR (New Form Review).
  1. Open the document you'd like to mark as a prior year document in the document viewer panel.
    Document in the document viewer
  2. Select
    Mark as Prior Year
    from the
    Mark Document As
    dropdown menu.
    Select Mark as Prior Year
  3. A toast notification will appear indicating that this document has been marked as a
    Prior Year
    document.
    Notification that the document's data will not be captured.

How will duplicates appear in the binder?

  • 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.
  • For In-house verification, select to refer to the matrix that will guide you on handling the documents appearing in this wizard.

What's next?

Once all of the categories have been signed off, this binder is ready for the next step,
New Form
review. Users can select
NEXT STEP
at the bottom of the screen to move this engagement to the next wizard.
note
Once a binder advances to the next step, it can't return to the duplicate data wizard so confirm that you are ready to proceed.
Select NEXT STEP
When the Duplicate Data window appears asking to confirm your decision to proceed, select
CONTINUE
to proceed to the next step or select
CANCEL
to return to the Duplicate Data wizard.
Duplicate Data window

Related Content

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close