Accounting Finance:TD Bank Merchant Statements

Log on

• Go to: TD Merchant Services
• Enter username (email address)
• Enter password

Summary Reports

• To download summary reports:

1. Click Monthly Statement
2. Click Summary from the drop down menu
3. Click the month you are working on, click open, print report, click X to close report, put aside
4. On the left side click Monthly Statement to bring you back to statement type
5. This time pick 200-22378885 (UNIPHARM WHOLESALE DRUGS)
6. Click the month you are working on, click open, print report, click X to close report, put aside

• To download UWD summary report:

1. On the left side click Reports
2. Click Settled Transaction Details
3. Double click the plus (+) sign on the uniPHARM Chain Account. A list of uniPHARM stores will appear.
4. Choose the uniPHARM account 200-022378885 (UNIPHARM WHOLESALE DRUGS)
5. Click the double right arrow
6. Change the start and end date
7. Click CSV
8. Click Submit
9. Click open

Worksheets

• Preparing a UWD worksheet:

1. The file will open in Excel Format
2. Go to \common\A2013-2014 (current)\Bank Discount Charges and click to open the Merchant Statement you are working on
3. Click UWD tab
4. Check to make sure the column headings on A-Q match the downloaded data
5. Paste downloaded data onto columns A-Q and check row numbers.
6. Change the column headings for B and C to store number and store owner.
7. Populate both columns using the formulas below:

-Store Number: =IF(+F2="V",VLOOKUP(+E2,'V Table'!$A$5:$G$135,2,0),VLOOKUP(+E2,'M Table'!$A$5:$G$200,2,0))
-Store Owner: =IF(+F2="V",VLOOKUP(+E2,'V Table'!$A$5:$G$135,3,0),VLOOKUP(+E2,'M Table'!$A$5:$G$200,3,0))

Tips

• If one of the fields show up as N/A note the credit card number, settlement date and go to Online Mart to check who the owner of the card is. Add the information on the V table (Visa) or M table (MC). Once the tables are updated the fields will populate.
• Note: If you do not have access to Online Mart you may also check the credit card details on Y:\uniPHARM-TD Batches\2013-2014 by finding the worksheet that matches your transaction date.
• Data sort the copied columns by Merchant ID and check all the gray columns against the uniPHARM statement #22378885 that you previously printed. Make sure all the totals match.
• Check and fix the reconciliation box if necessary.

Invoicing Stores

• Invoice the stores with fees greater than $1 and enter the invoice number on the worksheet beside Customer Billing.
• Note: Michael Fish (10567 and 11900) and Geoffrey Wong (10146 and 10334).
• See FIN-AR-005 to do the manual invoicing for the stores. Item number to be used is 02003812.
• Email or fax all the invoices to the respective stores.

Data Worksheets

• Click on the Data tab and compare the column totals (E-CA) against the Summary statement that you previously printed.
• Update column CB by doing a vlookup on the Maxwell Paper spreadsheet on K:\common\AR\2013-2014 (current)\Bank Discount Charges.
• Check the TD statements of stores that have recently returned their terminals or had adjustments done to their account and compare it with the UWD statement we have for them, correct if necessary
• Do random checks by opening different store statements on https://www.mistgateway.com:33808/tdreport/stmt and checking them against the UWD statements under the Portfolio tab worksheet.
• Under the Data tab check that the store charges total + UWD terminal charges total = total amount charged to your bank. Maxwell paper will be paid by UWD and will be on their UWD statement.
• Do internal adjustments to invoice the stores (no paper document) using the amounts on column CM (Store charges total).

Work with Manual Adjustments

• Select ASW FastPath→Cash Management→AR Cash Management Tasks→AR Invoicing Tasks→Enter Financial Transactions

• Enter voucher type 10
• Enter Batch amount
• Click User Template
• Change template to CVM
• Click enter

• Enter next customer OR
• Click F12 when all adjustments are entered

1. Enter Doc # (MMDDYY of TD charges)
2. Enter Customer number
3. Enter Transaction amount (total of both Visa & MC charges)
4. Enter text (enter the month & year of the charges)
5. Press enter twice

• Enter Amount
• Click enter

• Click F3 to complete adjustment entry
• Click F3
• Mark close batch
• Change Printer queue lp05
• Click enter

• Click enter
• Make sure there is no difference in total debit and credit

Print Merchant Statements

• Check your printer set-up before printing statements.
• Click Print ALL statements (under the Portfolio tab).
• Slot all printed statements and mail the customer statements with the exception of Macdonalds.
  • Email Macdonalds (10478, 10479, 12004) email to Emilo Dente (office@macdonaldsrx.com) and then discard copy.
• Stores now have access to TD merchant online report to get a copy of the TD statement. When a store requests for a copy offer to set them up online.