Automatic Reconciliation

From FloristWiki

Revision as of 12:41, 14 February 2011

Automatic Reconciliation compares the data on your Combined Report disk to the data in FTD Mercury. If you do not receive your Combined Report on disk, call Member Services at 1-800-788-9000 to request a monthly shipment of the disk along with your printed statement. You can also view your statement online at www.ftdi.com.

When loading the Combined Report file from disk, FTD Mercury compares the orders from the disk to the orders on your system and reconciles all orders that match automatically. Orders may not match for several reasons—for example, different order amounts, recipient names, or delivery dates. You can then work from that screen to reconcile or dispute the remaining orders manually.

You cannot automatically reconcile data in your system that is dated more than three months prior to the statement date for that month’s statement. However, you can use Manual Reconciliation to reconcile those orders.

NOTE To reconcile previous batches, use the Auto Reconciliation History command on the Wire Reconciliation menu.

Automatically Reconciling Data

To automatically reconcile data:

1. On the Wire Reconciliation menu, click Load Wire Reconciliation.
2. From the Statement Date list, click the arrow to display a calendar and select the date displayed on the printed Combined Report.
3. From the Wire Service list, select FTD.
4. Insert the Combined Report disk into your floppy disk drive.
5. In the File Name field, click the search button, select the A: drive in the drop-down menu, and navigate to the appropriate Combined Report statement file on the disk.
   File names are in the format: shopcodecb.xxx, where xxx is the 3-letter abbreviation for the month represented in the Combined Report. For example, if your shop code is 90-0034AA, and this is the Combined Report for the month of September, the file you are searching for is named 900034cb.sep.
6. Click Load. The Match Reconciliation window opens and fills in with the orders from your Combined Report displayed in the bottom box, and the Mercury orders in your Message Log in the top box.
   When you click on an order in the bottom box, the matching order in your Message Log is highlighted in the top box so you may compare. Orders with matching information are reconciled automatically and appear in green in the bottom box. If you want to see details about the order, double-click on a line in the top box to view the order in full detail.
   TIP Keep the following in mind:
   • You may double-click on a line in the top box to view the order in full detail.
   • Use the totals sections to help you balance your books with your Combined Report. Note that the dollar amount displayed in the “Disputed” column is the dollar amount of the disputed transactions in the list (not the actual disputed amount created through ADJustment messages).
7. If no match was found, nothing is highlighted in the upper box. Under that circumstance, you may either:
   • Find the order in the top box you believe should match and click Reconcile or Dispute.
   • If you are unable to find anything in the top box that should match, click Reconcile. This creates a synthetic order with a status of Exception in your Message Log. Under that circumstance, the synthetic order remains in your Message Log until it is reconciled during your automatic reconciliation session next month.
8. Click Save when you have finished reconciling orders.
9. Remove the disk from the floppy disk drive.